PROCESS_INSTANCE05=Title 5, Other
38=Title 38, United States Code
GE=Equivalent to GS Class System
GS=Title 5, GS Class System
WE=Equivalent to Title 5 FWS
WG=Title 5, Prevailing Rate Sys
AE_FGPY005P_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GVT_PAY_PLAN | Character(2) | VARCHAR2(2) NOT NULL | Pay Plan |
| 3 | GVT_CLASS_AUTH | Character(2) | VARCHAR2(2) NOT NULL |
Classification Authority
05=Title 5, Other 38=Title 38, United States Code GE=Equivalent to GS Class System GS=Title 5, GS Class System WE=Equivalent to Title 5 FWS WG=Title 5, Prevailing Rate Sys |
| 4 | GVT_IGA_PAY | Character(1) | VARCHAR2(1) NOT NULL | Interim Geographic Adjustment |
| 5 | GVT_LEO_PAY | Character(1) | VARCHAR2(1) NOT NULL | Law Enforcement Officer Pay |
| 6 | GVT_LOCALITY_PAY | Character(1) | VARCHAR2(1) NOT NULL | Locality Adjusted Pay |
| 7 | GVT_PREMIUM_PAY | Character(1) | VARCHAR2(1) NOT NULL | Premium Pay |
| 8 | GVT_SAL_STEP_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Non-Numeric Steps |
| 9 | MAX_RT_ANNUAL | Number(19,3) | DECIMAL(18,3) NOT NULL | Maximum Pay Rate-Annual |
| 10 | MIN_RT_ANNUAL | Number(19,3) | DECIMAL(18,3) NOT NULL | Minimum Pay Rate-Annual |
| 11 | GVT_LM_ERN_PROGRAM | Character(3) | VARCHAR2(3) NOT NULL | Pay Plan |
| 12 | GRADE | Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
| 13 | STEP | Number(2,0) | SMALLINT NOT NULL | Step |
| 14 | GVT_MULT_FACTOR | Number(3,0) | SMALLINT NOT NULL | Mult. Factor |
| 15 | GVT_LEO_RULE | Character(1) | VARCHAR2(1) NOT NULL | LEO Rule |
| 16 | GVT_LOC_RULE | Character(1) | VARCHAR2(1) NOT NULL | Location Rule |
| 17 | PAY_TABLE_WHERE | Character(200) | VARCHAR2(200) NOT NULL | PAY TABLE WHERE |
| 18 | GVT_REMARK_1 | Character(70) | VARCHAR2(70) NOT NULL | Remark Line 1 |
| 19 | GVT_REMARK_2 | Character(70) | VARCHAR2(70) NOT NULL | Remark Line 2 |
| 20 | GVT_REMARK_3 | Character(70) | VARCHAR2(70) NOT NULL | Remark Line 3 |
| 21 | GVT_REMARK_4 | Character(70) | VARCHAR2(70) NOT NULL | Remark Line 4 |
| 22 | GVT_REMARK_5 | Character(70) | VARCHAR2(70) NOT NULL | Remark Line 5 |
| 23 | GVT_REMARK_6 | Character(70) | VARCHAR2(70) NOT NULL | Remark Line 6 |
| 24 | GVT_REMARK_CD1 | Character(3) | VARCHAR2(3) NOT NULL | Remark Code 1 |
| 25 | GVT_REMARK_LINE1 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 1 |
| 26 | GVT_REMARK_LINE2 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 2 |
| 27 | GVT_REMARK_LINE3 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 3 |
| 28 | GVT_REMARK_LINE4 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 4 |
| 29 | GVT_REMARK_LINE5 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 5 |
| 30 | GVT_REMARK_LINE6 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 6 |
| 31 | GVT_REMARK_LINE7 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 7 |
| 32 | GVT_REMARK_LINE8 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 8 |
| 33 | GVT_REMARK_LINE9 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 9 |
| 34 | OVERRIDE_CUR_RT | Character(1) | VARCHAR2(1) NOT NULL | Override Existing Rates |