EG_ADMIN_POSTS(SQL Table) |
Index Back |
|---|---|
Administrative PostsAdministrative Posts |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ADMIN_POST |
Character(15) | VARCHAR2(15) NOT NULL |
Administrative Post
AD=Assciate Dean CH=Chair DE=Dean DI=Director VC=Vice Chair Prompt Table:
EG_ADM_POST_TBL
|
| 3 | FROMDATE |
Date(10) | DATE NOT NULL | From Date |
| 4 | END_DATE | Date(10) | DATE | End Date |
| 5 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 6 | APPOINTMENT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Appointment Type
APP=ReAppointed INT=Initial Appointment Default Value: INT |
| 7 | REVISION_DT | Date(10) | DATE | Revision Date |
| 8 | REASON | Character(30) | VARCHAR2(30) NOT NULL | Reason |
| 9 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL |
| 10 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 11 | DESCR50 |
Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 12 | DESCRLONG | Long Character | CLOB | Long Description |