| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 4 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 5 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 6 |
NAME_DESCR |
Character(50) |
VARCHAR2(50) NOT NULL |
Description
|
| 7 |
GPMX_NID_RFC |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID: RFC
|
| 8 |
GPMX_NID_CURP |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID: CURP
|
| 9 |
GPMX_NID_IMSS |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID: IMSS
|
| 10 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 11 |
GPMX_CD_REGIME |
Character(2) |
VARCHAR2(2) NOT NULL |
Labor regimen code
1=Similar to Salary
10=Income Stock or Bond
11=Similar Others
12=Retired
13=Severance
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
99=Other
|
| 12 |
PYMT_DT |
Date(10) |
DATE |
Payment Date
|
| 13 |
PRC_BGN_DT |
Date(10) |
DATE |
The Processing Begin Date is the Beginning Date of the Period when Processing is taking place. It usually is the same as the Period Begin Date (PRD_BGN_DT), except in cases of Advance Payment.
|
| 14 |
PRC_END_DT |
Date(10) |
DATE |
The Processing End Date is the End Date of the Period when Processing is taking place. It usually is the same as the Period End Date (PRD_END_DT), except in cases of Advance Payment.
|
| 15 |
GPMX_PAID_DAYS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Paid Days
|
| 16 |
DESCR_DEPT |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 17 |
GPMX_CLABE |
Character(18) |
VARCHAR2(18) NOT NULL |
CLABE Inter-bank Payment Scheme
|
| 18 |
GPMX_CFDI_BANK |
Character(3) |
VARCHAR2(3) NOT NULL |
CFDI bank MEX
001=BANAMEX
012=BBVA BANCOMER
014=SANTANDER
021=HSBC
044=SCOTIABANK
072=BANORTE
|
| 19 |
SENIORITY_PAY_DT |
Date(10) |
DATE |
Seniority Pay Calc Date
|
| 20 |
GPMX_SENPAY_WKS |
Number(4,0) |
SMALLINT NOT NULL |
Seniority Pay Weeks
|
| 21 |
DESCR_JOBCODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 22 |
TP_CONTRACT_FROM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Num From
|
| 23 |
GPMX_JOURNAL_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Journal Type Description MEX
|
| 24 |
PERIOD_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Period Name
|
| 25 |
GPMX_SDI_TOT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
SDI Total GP Mexico
|
| 26 |
GPMX_COMP_ACTIVITY |
Character(2) |
VARCHAR2(2) NOT NULL |
Company Settings
1=Class I
2=Class II
3=Class III
4=Class IV
5=Class V
99=Not Applicable
|
| 27 |
GPMX_TOTAL_TAXABLE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Total Taxable
|
| 28 |
PIN_NET_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Net Pay Value
|
| 29 |
GPMX_TOT_ERN_TAX |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Total Earning Taxable
|
| 30 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 31 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 32 |
DAILY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Daily Rate
|
| 33 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 34 |
METHODNAME |
Character(32) |
VARCHAR2(32) NOT NULL |
Method Name
|
| 35 |
TERMINATIONS |
Number(3,0) |
SMALLINT NOT NULL |
TERMINATIONS
|
| 36 |
GPMX_TOT_DED_TAX |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Total Deductions Taxable
|
| 37 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 38 |
GPMX_PAYROLL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Type
B=Bonus
E=Extraordinary Payroll
F=Saving Funds
L=Layoff
M=Retirement
O=Ordinary Payroll
P=Profit Sharing
R=Regular Payroll
S=Special
T=Termination
V=Vacation Premium
X=Christmas Bonus
|
| 39 |
GPMX_CFDI_RES_ORI |
Character(2) |
VARCHAR2(2) NOT NULL |
CFDI Report - Resource Origin
IF=Federal Incomes
IM=Mixed Incomes
IP=Own Incomes
|
| 40 |
GPMX_CFDI_OWRE_AMT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
CFDI Report - Own Resources Amount
|
| 41 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code
|
| 42 |
STATE_LOCATION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
State Location Code
|
| 43 |
GPMX_MAR_VAL_SHARE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Share Market Value
|
| 44 |
GPMX_OPT_PRICE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Share Option Price
|
| 45 |
GPMX_OTH_PAY_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Total Earnings Amount
|
| 46 |
GPMX_EMPL_SUBSIDY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Employment Subsidy
|
| 47 |
YEARS |
Number(3,0) |
SMALLINT NOT NULL |
for app engine fghr002b
|
| 48 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 49 |
GPMX_ERROR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Status
E=Error
N=No Errors
Default Value: N
|
| 50 |
GPMX_TERM_VERSION |
Character(10) |
VARCHAR2(10) NOT NULL |
Termination Version
|
| 51 |
GPMX_TER_LOF |
Character(4) |
VARCHAR2(4) NOT NULL |
Termination Layoff
Use this field to identify the termination reason as (Termination or Layoff)
0010=Termination
0020=Layoff
|
| 52 |
GPMX_EMP_TAX_TREAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Tax Treatment MEX
605=Wages & Salaries & Assimilated
|
| 53 |
POSTAL2 |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal Code
|
| 54 |
PENSION_TP_WRK_MEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Pensioned worker
0=Not Applicable
1=Disability
2=Unemployment and Old Age
|
| 55 |
GPMX_DAY_FACTOR |
Number(14,7) |
DECIMAL(13,7) NOT NULL |
Daily Factor
|
| 56 |
GPMX_NAME_254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Name 254
|