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

The Class Data report describes a class, including the learning items, curricula, and offerings associated with the class, the users in the class, and other attributes of the class.

 

Report NameClass Data
REPORT_NAME_IDClassData
REPORT_ID212
CATEGORY_IDLearning
GROUP_IDClassData
WORKFLOW_IDRun Class Data Report
TYPEBIRT /PRD
USER_TYPEAdmin
PUBLISHEDYes
SHOW_IN_MENUYes
DMN_IDPUBLIC

 

SQL Query used

customFields
SELECT To_char(c.col_num) AS col_num, 
       label, 
       user_value, 
       user_desc 
FROM   pa_usrcl_class c, 
       (SELECT a.col_num, 
               user_value, 
               user_desc 
        FROM   pa_class_user a, 
               pa_usrrf_class b, 
               pa_usrcl_class c 
        WHERE  class_id = ? 
               AND a.col_num = c.col_num 
               AND a.col_num = b.col_num(+) 
               AND a.user_value = b.user_id(+)) d 
WHERE  c.col_num = d.col_num(+) 
/** and not(0) = [IncludeCustomFields]*/ 
ORDER  BY col_num 
master
SELECT class_id, 
       class_desc, 
       c.dmn_id, 
       dmn_desc, 
       c.qual_id, 
       qual_title, 
       start_dte, 
       end_dte, 
       max_size 
FROM   pa_class c, 
       pa_domain d, 
       pa_qual q 
WHERE  c.dmn_id = d.dmn_id(+) 
       AND c.qual_id = q.qual_id(+) 
/** AND CLASS_ID IN [ClassIDSearch]       and [security:pa_class c]*/ 
ORDER  BY class_id 
schedules
SELECT To_char(cs.schd_id) AS schd_id, 
       s.cpnt_typ_id, 
       s.act_cpnt_id, 
       s.rev_dte, 
       cp.rev_num, 
       sr.start_dte, 
       sr.end_dte, 
       auto_enroll, 
       s.timezone_id, 
       s.display_in_schd_tz 
FROM   pa_class_sched cs, 
       ps_schd_resources sr, 
       pa_sched s, 
       pv_course cp 
WHERE  cs.schd_id = s.schd_id 
       AND cs.schd_id = sr.schd_id 
       AND s.cpnt_typ_id = cp.cpnt_typ_id 
       AND s.act_cpnt_id = cp.cpnt_id 
       AND s.rev_dte = cp.rev_dte 
       AND class_id = ? 
ORDER  BY start_dte, 
          schd_id 
students
SELECT cs.stud_id, 
       lname, 
       fname, 
       mi, 
       cs.class_stat_id, 
       class_stat_desc, 
       cs.comments 
FROM   pa_class_student cs, 
       pa_student s, 
       pa_class_stat stat 
WHERE  cs.stud_id = s.stud_id 
       AND cs.class_stat_id = stat.class_stat_id(+) 
       AND class_id = ? 
ORDER  BY lname, 
          fname, 
          mi 

 

 

 

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