SETIDDefault Value: OPR_DEF_TBL_HR.SETID
GPS_POST_IDDefault Value: P
GPS_POST_TBL(SQL Table) |
Index Back |
|---|---|
GPS Post TableBase information on posts as available in the system |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID |
| 2 | GPS_POST_ID |
Character(8) | VARCHAR2(8) NOT NULL | GPS post id |
| 3 | GPS_POST_ID_OLD | Character(50) | VARCHAR2(50) NOT NULL | GPS legacy post id |
| 4 | GPS_POST_STAT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | GPS Identify a post id to be taken into consideration for certain statistical reports |
| 5 | GPS_POOL_ID | Character(8) | VARCHAR2(8) NOT NULL | GPS Pool ID |
| 6 | GPS_ORIG_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Created in Administration
Default Value: P |