GP_PAYGROUPEFFDTDefault Value: %DATE
GPMX_SRTYGPMX_SDI_FACTOR(SQL Table) |
Index Back |
|---|---|
Christmas, Vac, Prem, FactorsChristmas Bonus, Vacations, Vacations Premium and SDI Factor |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %DATE |
| 3 | GPMX_SRTY |
Number(8,3) | DECIMAL(7,3) NOT NULL | Seniority GP Mexico |
| 4 | GPMX_VAC_DAYS | Number(13,6) | DECIMAL(12,6) NOT NULL | Vacation Days GP Mexico |
| 5 | GPMX_VAC_PREMIUM | Number(19,6) | DECIMAL(18,6) NOT NULL | Vacation Premium % GP Mexico |
| 6 | GPMX_XMAS_DAYS | Number(13,6) | DECIMAL(12,6) NOT NULL | Christmas Bonus Days GP Mexico |
| 7 | GPMX_SDI_FACTOR | Number(19,6) | DECIMAL(18,6) NOT NULL | SDI Factor GP Mexico |