SCC_PREF_LANGVW(SQL View) |
Index Back |
|---|---|
Language code viewLanguage code view for preferences |
| SELECT s.lang_cd , A.XLATLONGNAME FROM PS_SCC_COMM_LANG s , PSXLATITEM A WHERE a.FIELDNAME = 'LANG_CD' AND A.FIELDVALUE = s.lang_cd |
| # | 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 Prompt Table: SCC_PREF_LANGVW |
| 2 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |