| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
GP_PYGRP
Set Control Field: GP_PAYGROUP
|
| 2 |
BGN_DT |
Date(10) |
DATE NOT NULL |
Begin Date
Default Value: %date
|
| 3 |
END_DT |
Date(10) |
DATE |
end date
|
| 4 |
GPMX_ADJ_FACTOR |
Character(1) |
VARCHAR2(1) NOT NULL |
App;y Adjustment Factor GP Mexico
Y/N Table Edit
Default Value: N
|
| 5 |
GPMX_DAY_FACTOR |
Number(14,7) |
DECIMAL(13,7) NOT NULL |
Daily Factor
|
| 6 |
GPMX_TAX_METHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax Method GP Mexico
0010=Annual Projection Method
0020=Without Adjustment
0030=Adjustment During the Month
0040=Adjustment at end of the Month
0050=Semi-monthly Projected
|
| 7 |
GPMX_TAX_CRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Salary Credit only in Adjustment Period
Y/N Table Edit
Default Value: N
|
| 8 |
GPMX_IMS_ER_PAID |
Character(1) |
VARCHAR2(1) NOT NULL |
IMSS Quotas Pay for Employer GP Mexico
Y/N Table Edit
Default Value: N
|
| 9 |
GPMX_BASE_DAYS |
Character(4) |
VARCHAR2(4) NOT NULL |
Days Base for Variable SDI - GP Mexico
0010=Bimonth Days
0020=Paid Days
0030=60 days
0040=Hourly Payee
|
| 10 |
GPMX_BAS_SAL_IMS |
Character(4) |
VARCHAR2(4) NOT NULL |
Base Salary for IMSS Quotas - GP Mexico
0010=Salary
0020=SDI
|
| 11 |
GPMX_PYGRP_CALC |
Character(4) |
VARCHAR2(4) NOT NULL |
Payee Salary calculation Type
0010=Hourly
0020=Calendar Days
0030=Frequency Days
Default Value: 0010
|
| 12 |
GPMX_7TH_DAY_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N pay 7th day
Y/N Table Edit
Default Value: N
|
| 13 |
GPMX_CRE_SAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to pay Salary Credit at Paygroup Parameters
Default Value: Y
|
| 14 |
GPMX_XMAS_AVG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Xmas Bonus Using Average Salary
Y/N Table Edit
Default Value: N
|
| 15 |
GPMX_PYGRP_ABSM |
Character(1) |
VARCHAR2(1) NOT NULL |
Absence Application Method
C=Calendar Days
F=Frequency Days
|
| 16 |
GPMX_SUB_METHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
Subsidy Method
AEOM=Adjustment at end of the Month
PLPR=Payment in the Last Period
WADJ=Adjustment During the Month
WOAD=Without Adjustment
Default Value: WOAD
|
| 17 |
GPMX_CD_REGIME |
Character(2) |
VARCHAR2(2) NOT NULL |
Labor regimen code
1=Similar to Salary
10=Income Stock or Bond
2=Salaries and Wages
3=Retirees
4=Pensioners
5=Similar to Salary Cooperative
6=Similar to Salary Civil Associ
7=Members of Council Directors
8=Similar to Salary Business Act
9=Salary and Serv Fees Assim
Default Value: 2
|