| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 3 |
GPMX_SRTY |
Number(8,3) |
DECIMAL(7,3) NOT NULL |
Seniority GP Mexico
|
| 4 |
GPMX_MINWG_EZN |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Minimum Wage Employee Zone GP Mexico
|
| 5 |
GPMX_CEIL_DAY_EM |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Ceiling Days Maternity & Illness GP Mexico
|
| 6 |
GPMX_CEIL_DAY_IV |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Ceiling Days Disability and Life GP Mexico
|
| 7 |
GPMX_MAX_EM |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Max Ceiling Maternity & Illness GP Mexico
|
| 8 |
GPMX_MAX_IV |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Max Ceiling Disability and Life GP Mexico
|
| 9 |
GPMX_SDI_FACTOR |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
SDI Factor GP Mexico
|
| 10 |
GPMX_MIN_SAL_DIF |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Difference SMG and Daily Rate GP Mexico
|
| 11 |
GPMX_MINWG_AZN |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Minimum Wage A Zone GP Mexico
|
| 12 |
GPMX_SDI_FIX |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Fixed SDI GP Mexico
|
| 13 |
GPMX_SDI_VAR |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Variable SDI GP Mexico
|
| 14 |
GPMX_SDI_TOT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
SDI Total GP Mexico
|
| 15 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|