COUNTRYDefault Value: MEX
EFFDTDefault Value: %date
10=A Economic Zone
20=B Economic Zone
30=C Economic Zone
GPMX_MININF_DTL(SQL Table) |
Index Back |
|---|---|
Minimum Wage INFONAVIT recordMinimum Wage INFONAVIT record GP Mexico |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: MEX |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | WAGE_ZONE_MEX | Character(4) | VARCHAR2(4) NOT NULL |
Wage Zone for Mexico
10=A Economic Zone 20=B Economic Zone 30=C Economic Zone |
| 4 | GPMX_MINIMUM_WAGE | Number(19,6) | DECIMAL(18,6) NOT NULL | Minimum Wage GP Mexico |
| 5 | GPMX_UMI_DAILY_VAL | Number(15,2) | DECIMAL(14,2) NOT NULL | Unit of Measure and Updates Daily Value to INFONAVIT |
| 6 | GPMX_UMI_MTHLY_VAL | Number(15,2) | DECIMAL(14,2) NOT NULL | Unit of Measure and Updates Monthly Value to INFONAVIT |
| 7 | GPMX_UMI_ANNL_VAL | Number(15,2) | DECIMAL(14,2) NOT NULL | Unit of Measure and Updates Annual Value to INFONAVIT |