COUNTRYDefault Value: MEX
EFFDTDefault Value: %date
WAGE_ZONE_MEX10=A Economic Zone
20=B Economic Zone
30=C Economic Zone
GPMX_MIN_WAGE(SQL Table) |
Index Back |
|---|---|
Minimum Wage RecordMinimum Wage 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 |