| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 2 |
GVT_MPA_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
GVT Mass Pay Adjustment Type
FWA=Annual Federal Wage Service
FWS=FWS Special Rate Increase
GSA=GS Annual Pay Adjustment
GSS=GS Special Rate Increase
LEO=LEO Special Pay Adjustment
LPA=Locality Pay Adjustment
|
| 3 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table:
GB_GROUP_TBL
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
GVT_MPA_PCT |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
GVT Mass Pay Adjustment Pct
Default Value: 0
|
| 6 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
Prompt Table:
GVT_PAY_PLAN
|
| 7 |
GVT_LEG_AUTH_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (1)
Prompt Table:
GVT_AUTH_VAL_VW
|
| 8 |
GVT_PAR_AUTH_D1 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 1 Descr - Part 1
|
| 9 |
GVT_PAR_AUTH_D1_2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 1 Descr - Part 2
|
| 10 |
GVT_LEG_AUTH_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (2)
Prompt Table:
GVT_AUTH_VAL_VW
|
| 11 |
GVT_PAR_AUTH_D2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 2 Descr - Part 1
|
| 12 |
GVT_PAR_AUTH_D2_2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 2 Descr - Part 2
|
| 13 |
GVT_MPA_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Mass Pay Adj Calc Type
P=Percentage
S=Special Calculation Routine
T=Pay Tables
Default Value: T
|
| 14 |
GVT_MPA_SPEC_CALC |
Character(3) |
VARCHAR2(3) NOT NULL |
GVT Mass Pay Adjustment Spec
GM=GH/GM Special Calucation
|
| 15 |
GVT_MPA_TABLE_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Mass Pay Adj Pay Tables
A=Include All for Pay Plan
E=Exclude Tables Listed
I=Include Tables Listed
Default Value: A
|