SETIDPrompt 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
GPS_ROWIDGPS_PPLN_SRCHVW(SQL View) |
Index Back |
|---|---|
GPS Post Plan Tablebase definitions of a post plan |
| SELECT SETID , YEAR , GPS_POST_PLN_TYPE , GPS_ROWID FROM PS_GPS_POSTPLN_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
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 |
| 4 | GPS_ROWID |
Character(45) | VARCHAR2(45) NOT NULL | RowID, a condensed version of the key fields of a budgeting system |