GVT_MPA_PAY_TBL(SQL Table) |
Index Back |
|---|---|
GVT Mass Pay Adjust Pay Tables |
| # | 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 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | GVT_MPA_PCT |
Number(5,2) | DECIMAL(4,2) NOT NULL |
GVT Mass Pay Adjustment Pct
Default Value: 0 |
| 5 | GVT_PAY_PLAN |
Character(2) | VARCHAR2(2) NOT NULL |
Pay Plan
Prompt Table: GVT_PAY_PLAN |
| 6 | SAL_ADMIN_PLAN |
Character(4) | VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table: GVT_SAL_PLN_VW |