GVT_LOCALITY_AREAEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Default Value: 0
Default Value: 0
GVT_LOCAREA_TBL(SQL Table) |
Index Back |
|---|---|
GVT: Locality Pay AreasGVT: This table is used in conjunction with the Location Table and the LEO Locality Area Table to set the appropriate Locality Percentage. This Locality Percentage is multiplied by the employee's basic salary rate to determine their Locality Adjustment. The Locality Adjustment is then added to the basic salary rate to compute the locality-adjusted salary rate. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_LOCALITY_AREA |
Character(2) | VARCHAR2(2) NOT NULL | Locality Pay Area |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | GVT_LOCALITY_PCT | Number(5,2) | DECIMAL(4,2) NOT NULL |
Locality percentage
Default Value: 0 |
| 6 | GVT_IGA_PCT | Number(5,2) | DECIMAL(4,2) NOT NULL |
IGA Percentage
Default Value: 0 |