HRS_XP_APP_VW (SQL View)	Index Back
Batch Letter View Applicant Letter temaplte view

HRS_XP_APP_VW

(SQL View)

Batch Letter View

Applicant Letter temaplte view

SELECT DISTINCT A.HRS_REPORT_DEFN_ID , A.HRS_REPORT_TMPL_ID , A.LANG_CD FROM PS_HRS_APP_PROFILE 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.

3 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese

#	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.
3	LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese