LANG_CDCFR=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
HRS_XP_RCPLG_VW(SQL View) |
Index Back |
|---|---|
Batch Letter ViewApplicant Letters Recipient Language view |
| SELECT DISTINCT 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 | 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 |