GPS_ATSTF_TBL(SQL Table) |
Index Back |
|---|---|
auto-staffing run informationauto-staffing history table. store each run information of auto-staffing. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPS_ATSTF_SEQ |
Number(10,0) | DECIMAL(10) NOT NULL | Auto-Staffing Sequence |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID |
| 3 | GPS_ATSTF_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Process Type
C=Perform Custom Process E=Automatic Staffing for All Default Value: C |
| 4 | RUNDATE | Date(10) | DATE |
Process Scheduler Run Date
Default Value: %date |
| 5 | GPS_ATSTF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Current Status
F=Closed I=Initiated P=Assignments in Progress Default Value: I |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 7 | YEAR | Character(4) | VARCHAR2(4) NOT NULL | Character field to represent a year |
| 8 | GPS_POST_PLN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Post Plan TYpe
0=Base Plan 1=1. Amendment Plan 2=2. Amendment Plan 3=3. Amendment Plan 4=4. Amendment Plan |