EP_USER_ROLE_VW(SQL View) |
Index Back |
---|---|
ePerformance UsrRole XLAT viewView of EP_USER_ROLE from the translate table. |
SELECT %Substring(FIELDVALUE,1,1) , EFFDT , XLATLONGNAME , XLATSHORTNAME FROM PSXLATITEM WHERE FIELDNAME = 'EP_USER_ROLE' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EP_USER_ROLE | Character(1) | VARCHAR2(1) NOT NULL |
This field is used internally to record the current user's "role context" - that is, whether they are accessing a component as a Manager, and Employee, an HR Administrator or a 360 Reviewer.
A=Approver E=Employee H=HR Administrator M=Manager O=Other/360 V=View-Only |
2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |