SETIDDefault Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SET_VLD_HR_02
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_ROWIDLANGUAGE_CDGPS_POSTPLNTBLL(SQL Table) |
Index Back |
|---|---|
GPS Post Plan Tablebase definitions of a post plan |
| # | 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_02 |
| 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 | GPS_ROWID |
Character(45) | VARCHAR2(45) NOT NULL | RowID, a condensed version of the key fields of a budgeting system |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | GPS_DESCR1 | Character(50) | VARCHAR2(50) NOT NULL | Description 1 |
| 7 | GPS_DESCR2 | Character(50) | VARCHAR2(50) NOT NULL | Description 2 |