HRS_XP_RCM_VW

(SQL View)
 Index Back

Batch Letter View

Recruitment Letter template view

SELECT DISTINCT A.HRS_REPORT_DEFN_ID , A.HRS_REPORT_TMPL_ID FROM PS_HRS_RCMNT_LTR A WHERE A.LETTER_PRINTED_DT IS NULL AND A.HRS_REPORT_DEFN_ID <> ' ' AND A.HRS_REPORT_TMPL_ID <> ' ' AND EXISTS ( SELECT 'X' FROM PSXPRPTTMPL_VW B WHERE B.REPORT_DEFN_ID = A.HRS_REPORT_DEFN_ID AND B.TMPLDEFN_ID = A.HRS_REPORT_TMPL_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL The Fusion Publisher Report Definition ID used by Recruiting
2 HRS_REPORT_TMPL_ID Character(30) VARCHAR2(30) NOT NULL The Fusion publisher Report template ID used by RS.