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