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

The Certificate of Completion report prints the certificates of   completion for users from the recorded learning event.

The Certificate of Completion Learning Event should be printed from Record Learning – Financial.

This report is an Admin side report. It’s not shown as hyperlink only because it can’t be printed from the Reports Panel.

 

Report NameCertificate Of Completion Learning Event
REPORT_NAME_IDCertificateOfCompletionLearningEvent
REPORT_ID188
CATEGORY_IDUserManagement
GROUP_ID
WORKFLOW_IDRun Certificate of Completion Report
TYPEBIRT /PRD
SHOW_IN_MENUYes

 

 

 

SQL Query used

master
SELECT s.lname, 
       s.fname, 
       s.mi, 
       c.cpnt_title 
FROM   pa_student s, 
       pv_course c 
WHERE  1 = 1 
/** and s.stud_id IN [UserSearch]      and (c.cpnt_typ_id,c.cpnt_id,c.rev_dte) IN [ItemSearch]        and [security:pa_student s] */ 
ORDER  BY lname, 
          fname, 
          mi, 
          c.cpnt_typ_id, 
          c.cpnt_id, 
          c.rev_dte 

 

 

  • No labels