SETIDDefault Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SET_VLD_HR_05
YEARGPS_POST_PLN_TYPE0=Base Plan
1=1. Amendment Plan
2=2. Amendment Plan
3=3. Amendment Plan
4=4. Amendment Plan
Default Value: 0
GPS_PRECLN_RCTL(SQL Table) |
Index Back |
|---|---|
Prepared Clean Up Run CtrlGPS Prepared Clean Up AE Run Control Table |
| # | 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 Prompt Table: SET_VLD_HR_05 |
| 2 | YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Character field to represent a year |
| 3 | 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 Default Value: 0 |
| 4 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |