Page tree
Skip to end of metadata
Go to start of metadata

 The Item Status report returns learning item completion in CSV format.

 

Report NameItems Status CSV
REPORT_NAME_IDUserItemStatusCSV
REPORT_ID232
CATEGORY_IDUserManagement
GROUP_IDUserItemStatus
WORKFLOW_IDRun Item Status Report
TYPEBIRT /PRD
USER_TYPEAdmin
SHOW_IN_MENU

Yes

SQL Query used 

ItemStatus
SELECT c.stud_id, 
       c.lname, 
       c.fname, 
       c.mi, 
       a.cpnt_id, 
       a.cpnt_typ_id, 
       a.rev_dte, 
       a.rev_num, 
       cp.cpnt_title AS cpnt_desc, 
       a.compl_dte, 
       a.cmpl_stat_id, 
       b.cmpl_stat_desc, 
       b.provide_crdt, 
       b.initiate_level1_survey, 
       b.initiate_level3_survey, 
       a.schd_id, 
       a.total_hrs, 
       a.credit_hrs, 
       a.cpe_hrs, 
       a.contact_hrs, 
       a.tuition, 
       a.inst_name, 
       a.comments, 
       a.base_stud_id, 
       a.base_cpnt_typ_id, 
       a.base_cpnt_id, 
       a.base_rev_dte, 
       a.base_cmpl_stat_id, 
       a.base_compl_dte, 
       a.es_user_name, 
       a.internal, 
       a.grade_opt, 
       a.grade, 
       a.pmt_order_ticket_no, 
       a.ticket_sequence, 
       a.order_item_id, 
       a.esig_message, 
       a.esig_meaning_code_id, 
       a.esig_meaning_code_desc, 
       a.cpnt_key, 
       a.currency_code, 
       c.emp_stat_id, 
       c.emp_typ_id, 
       c.jl_id, 
       c.jp_id, 
       c.target_jp_id, 
       c.job_title, 
       c.dmn_id, 
       c.org_id, 
       c.region_id, 
       c.co_id, 
       c.notactive, 
       c.addr, 
       c.city, 
       c.state, 
       c.postal, 
       c.cntry, 
       c.super, 
       c.coach_stud_id, 
       c.hire_dte, 
       c.term_dte, 
       c.email_addr, 
       c.resume_locn, 
       c.comments, 
       c.shipping_name, 
       c.shipping_contact_name, 
       c.shipping_addr, 
       c.shipping_addr1, 
       c.shipping_city, 
       c.shipping_state, 
       c.shipping_postal, 
       c.shipping_cntry, 
       c.shipping_phon_num, 
       c.shipping_fax_num, 
       c.shipping_email_addr, 
       c.stud_pswd, 
       c.pin, 
       c.pin_date, 
       c.encrypted, 
       c.has_access, 
       c.billing_name, 
       c.billing_contact_name, 
       c.billing_addr, 
       c.billing_addr1, 
       c.billing_city, 
       c.billing_state, 
       c.billing_postal, 
       c.billing_cntry, 
       c.billing_phon_num, 
       c.billing_fax_num, 
       c.billing_email_addr, 
       c.self_registration, 
       c.self_registration_date, 
       c.access_to_org_fin_act, 
       c.notify_dev_plan_item_add, 
       c.notify_dev_plan_item_mod, 
       c.notify_dev_plan_item_remove, 
       c.notify_when_sub_item_complete, 
       c.notify_when_sub_item_failure, 
       c.LOCKED, 
       c.password_exp_date, 
       c.security_question, 
       c.security_answer, 
       c.role_id, 
       c.image_id, 
       c.gender, 
       c.past_service, 
       c.lst_unlock_tstmp, 
       c.manage_sub_sp, 
       c.manage_own_sp 
FROM   pa_cpnt_evthst a, 
       pa_cmpl_stat b, 
       pa_student c, 
       pv_course cp 
WHERE  a.cmpl_stat_id = b.cmpl_stat_id 
       AND a.stud_id = c.stud_id 
       AND cp.cpnt_typ_id(+) = a.cpnt_typ_id 
       AND cp.cpnt_id(+) = a.cpnt_id 
       AND cp.rev_dte(+) = a.rev_dte 
/** and (a.cpnt_typ_id, a.cpnt_id, a.rev_dte) in [ItemSearch]    and c.stud_id in [UserSearch]    and b.cmpl_stat_id in [CompletionStatusSearch]    and a.compl_dte >= [FromDate]     and a.compl_dte < [ToDate]    and [security:type=union pa_student c] */ 

 

Link:http://wiki.scn.sap.com/wiki/x/uwAIG