EP_ROLEEFFDTDefault Value: %date
LANGUAGE_CDEP_ROLE_LNG_VW2(SQL View) |
Index Back |
|---|---|
Roles non MGR/EE: Setup - RelRelated Language View used to prompt for non - Employee and Manager roles. |
| SELECT EP_ROLE , EFFDT , LANGUAGE_CD , EP_DESCR FROM PS_EP_ROLE_LANG WHERE EP_ROLE <> 'E' AND EP_ROLE <> 'M' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_ROLE |
Character(8) | VARCHAR2(8) NOT NULL | Role unique identifier |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description field used in ePerformance. |