| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 2 |
BGN_DT |
Date(10) |
DATE NOT NULL |
Begin Date
Default Value: %date
|
| 3 |
END_DT |
Date(10) |
DATE |
end date
|
| 4 |
GPMX_NOT_SUB_DAYS |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Days without Subsidy Mexico
|
| 5 |
GPMX_SUBS_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
Subsidy type Absences Mexico
0010=Daily Salary
0020=SDI Complement
0030=Without Subsidy
0040=SDI
|
| 6 |
GPMX_IMS_AGRMT |
Character(4) |
VARCHAR2(4) NOT NULL |
Agreement With IMSS
Y/N Table Edit
Default Value: N
|
| 7 |
GPMX_7TH_D_FAC_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
7th Day Factor Mexico
0010=Without Factor
0020=6th & 7th Day Factor
0030=7th Day Factor
0040=Other
|
| 8 |
GPMX_7TH_DAY_FACTO |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
7th Day Factor Code Mexico
|
| 9 |
GPMX_VAC_PREM_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Vacation Premium Type Value Mexico
ANIV=Anniversary
ANNL=Annual
PROP=Proportional
Default Value: ANIV
|
| 10 |
NEG_BAL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Negative Balance Option
A=Allow Negative Balance
O=Take with Other Absence
U=Take as Unpaid Time
Y/N Table Edit
Default Value: N
|
| 11 |
GPMX_VAC_PREM_MNTH |
Number(2,0) |
SMALLINT NOT NULL |
GPMX_VAC_PREM_MNTH
Vacation Premium Month
|
| 12 |
GPMX_VAC_PREM_DAY |
Number(2,0) |
SMALLINT NOT NULL |
GPMX_VAC_PREM_DAY
Vacation Premium Day
|
| 13 |
GPMX_VAC_ANNL_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
GPMX_VAC_ANNL_OPT
Vacation Premium Annual Application Options
DAYS=Vacation Days and Premium
PREM=Vacation Premium
Default Value: DAYS
|
| 14 |
GPMX_VAC_TAKE_DISC |
Character(1) |
VARCHAR2(1) NOT NULL |
GPMX_VAC_TAKE_DISC
Vacation Takes Discount
Y/N Table Edit
Default Value: N
|
| 15 |
GPMX_SALARY_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
GPMX_VAC_TAKE_DISC
Vacation Takes Discount
Y/N Table Edit
Default Value: Y
|
| 16 |
GPMX_XMAS_BONUS_DA |
Character(1) |
VARCHAR2(1) NOT NULL |
Xmas Bonus Deduct Absenses
Y/N Table Edit
Default Value: N
|
| 17 |
GPMX_INFONAVIT_ABS |
Character(4) |
VARCHAR2(4) NOT NULL |
INFONAVIT Loans Absences
0010=Absences
0020=Absences and Disabilities
Default Value: 0010
|
| 18 |
GPMX_MISSING_LEAVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Termination in Missing Leave
Y/N Table Edit
Default Value: N
|