GVT_LEOPAY_AREALANGUAGE_CDEFFDTGVT_LEOAREA_LNG(SQL Table) |
Index Back |
|---|---|
GVT: LEO Special Pay Area TblGVT: This table is used in conjunction with the GVT_LOCPAY_AREA and LOCATION tables to determine the appropriate Locality Pay Percentage to use for salary computations. The appropriate percentage for Law Enforcement Officers (LEOs) differs from regular Locality Pay. Related Language record for GVT_LEOAREA_TBL. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_LEOPAY_AREA |
Character(1) | VARCHAR2(1) NOT NULL | LEO Special 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 |