GPS_PRECLN_AET(SQL Table) |
Index Back |
|---|---|
Prepared Clean Up AETGPS Prepared Clean Up AET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | YEAR | Character(4) | VARCHAR2(4) NOT NULL | Character field to represent a year |
| 4 | 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 |
| 5 | GPS_ROWID | Character(45) | VARCHAR2(45) NOT NULL | RowID, a condensed version of the key fields of a budgeting system |
| 6 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 8 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 9 | GPS_GRADE | Character(8) | VARCHAR2(8) NOT NULL |
Salary Grade.
Prompt Table: GPS_POST_GRD_VW |
| 10 | GPS_RANK | Character(15) | VARCHAR2(15) NOT NULL | Rank for GPS |
| 11 | GPS_POST_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Post Type
AND=Other (Civil Service) ANE=Other (Employee) ANG=Public Sector Employee ANW=Civil Servant on Recall AZU=Apprentice BEA=Civil Servant ERE=Replacement Post (Employee) ERS=Replacement Post (Civil Serv.) LEB=Empty Post (Civil Service) LEE=Empty Post (Employee) |
| 12 | GPS_2YR_PLAN | Character(1) | VARCHAR2(1) NOT NULL | Double Houshold |
| 13 | GPS_YEAR_SRC | Number(4,0) | SMALLINT NOT NULL | Source Year |
| 14 | GPS_BDG_YEAR | Number(1,0) | SMALLINT NOT NULL |
budget Year
1=1st Budgeting Year 2=2nd Budgeting Year Default Value: 1 |
| 15 | GPS_PLN_TYPE_SRC | Character(1) | VARCHAR2(1) NOT NULL | Post Plan Type |
| 16 | EFFDT | Date(10) | DATE | Effective Date |
| 17 | GPS_COMMENT | Character(254) | VARCHAR2(254) NOT NULL | GPS comments |
| 18 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 19 | GPS_FRACTION | Number(9,2) | DECIMAL(8,2) NOT NULL | GPS Fraction |
| 20 | GPS_NUMBER | Number(6,0) | INTEGER NOT NULL | GPS Amount of Posts to create |
| 21 | GPS_NBR_DONE | Number(6,0) | INTEGER NOT NULL | GPS number of planning instructions done in clean-up phase |
| 22 | GPS_DEPT_TGT | Character(10) | VARCHAR2(10) NOT NULL | Target department |
| 23 | GPS_CUT_OFF | Date(10) | DATE | cut-off date |
| 24 | GPS_POST_ID | Character(8) | VARCHAR2(8) NOT NULL | GPS post id |
| 25 | GPS_DESCR1 | Character(50) | VARCHAR2(50) NOT NULL | Description 1 |
| 26 | GPS_DESCR2 | Character(50) | VARCHAR2(50) NOT NULL | Description 2 |