EMPLIDPrompt Table: PERSONAL_DATA
AUTHORIZED_OPRIDPrompt Table: OPRID_VW2
E=Edit
F=Edit & Submit
V=View
Default Value: F
EX_EE_AUTH_TBL(SQL Table) |
Index Back |
|---|---|
Employee Authority |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | AUTHORIZED_OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
Authorized User ID
Prompt Table: OPRID_VW2 |
| 3 | EE_AUTH_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Authorization level
E=Edit F=Edit & Submit V=View Default Value: F |