GVT_LOCALITY_AREALANGUAGE_CDEFFDTGVT_LOCAREA_LNG(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. Related Language record for GVT_LOCAREA_TBL. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_LOCALITY_AREA |
Character(2) | VARCHAR2(2) NOT NULL | Locality Pay Area |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |