SAP SuccessFactors
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 their learning history.

This is a user side report since it has (User) at the end of the report name.

  

  

Report NameCertificate Of Completion Learning Event
REPORT_NAME_IDCertificateOfCompletionLearningHistoryUser
REPORT_ID191
CATEGORY_ID 
GROUP_ID
WORKFLOW_IDView User Certificate of Completion Learning Event Report
TYPEBIRT /PRD
PUBLISHEDYes
SHOW_IN_MENUNo

 

SQL Query used

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

 

 

 

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