WCS_ECM_EXCLUDEDLANGUAGE_CDWCS_EXCLUDED_LV(SQL View) |
Index Back |
|---|---|
Yes No Prompt Language ViewYes No prompt language view. |
| SELECT %Substring(XLAT.FIELDVALUE, 1, 1) , XLAT.LANGUAGE_CD , XLAT.XLATLONGNAME FROM PSXLATITEMLANG XLAT WHERE XLAT.FIELDNAME = 'WCS_YESNO' AND XLAT.EFFDT = ( SELECT MAX(ED.EFFDT) FROM PSXLATITEMLANG ED WHERE XLAT.FIELDNAME = ED.FIELDNAME AND XLAT.FIELDVALUE = ED.FIELDVALUE AND XLAT.LANGUAGE_CD = ED.LANGUAGE_CD) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WCS_ECM_EXCLUDED |
Character(1) | VARCHAR2(1) NOT NULL | Employee Exclusion Flag |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |