EMPLOYEE_IDHR_DR_DELEGATOR(SQL View) |
Index Back |
|---|---|
Delegator NameDelegator Name view for prompt record. |
| SELECT EMPLID , NAME_DISPLAY FROM PS_PERSON_NAME WHERE EMPLID > ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLOYEE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Employee ID |
| 2 | NAME_DISPLAY_TXT | Character(100) | VARCHAR2(100) NOT NULL | used to show the rules for NAME_DISPLAY format |