| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 5 |
GPMX_FORMAT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Format ID
|
| 6 |
GPMX_SORTID |
Character(10) |
VARCHAR2(10) NOT NULL |
SORT ID
|
| 7 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
|
| 8 |
GPMX_MESSAGE |
Character(254) |
VARCHAR2(254) NOT NULL |
Message
|
| 9 |
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
|
| 10 |
PRD_BGN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 11 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 12 |
CAL_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID
|
| 13 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 14 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 15 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 16 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 17 |
JOB_EFFDT |
Date(10) |
DATE |
Job Effective Date
|
| 18 |
JOB_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Job Effective Sequence
|
| 19 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 20 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
|
| 21 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 22 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 23 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 24 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 25 |
DAILY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Daily Rate
|
| 26 |
SUPERVISOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Supervisor ID
|
| 27 |
GPMX_PREV_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Inter-company Previous Pay Group
|
| 28 |
WORKER_TYPE_MEX |
Character(4) |
VARCHAR2(4) NOT NULL |
Worker Type Mexico
0010=Permanent Worker
0020=Eventual Worker
0030=Construction Eventual
|
| 29 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 30 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
|
| 31 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location Set ID
|
| 32 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 33 |
SEG_BGN_DT |
Date(10) |
DATE |
Payee Process Segment's Begin Date
|
| 34 |
SEG_END_DT |
Date(10) |
DATE |
Payee Process Segment's End Date
|
| 35 |
EFFDT_WRK |
Date(10) |
DATE |
Effective Date
|
| 36 |
COMP_TAX_SUBS_MEX |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Paid Subsidy
|
| 37 |
COMP_TAX_ACR_MEX |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Paid Subsidy
|
| 38 |
RFC_ER_ID_MEX |
Character(16) |
VARCHAR2(16) NOT NULL |
RFC ID Number
|
| 39 |
INF_ER_ID_MEX |
Character(12) |
VARCHAR2(12) NOT NULL |
INFONAVIT ID Number
|
| 40 |
COMP_ACTIVITY_MEX |
Character(30) |
VARCHAR2(30) NOT NULL |
Company Activity Settings
|
| 41 |
REP_CURP_MEX |
Character(18) |
VARCHAR2(18) NOT NULL |
Legal Representative CURP.
|
| 42 |
REP_NAME_MEX |
Character(50) |
VARCHAR2(50) NOT NULL |
Legal Representative Name.
|
| 43 |
REP_RFC_MEX |
Character(16) |
VARCHAR2(16) NOT NULL |
Legal Representative RFC
|
| 44 |
PIN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Element Type
|
| 45 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 46 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 47 |
PAID_DAYS |
Number(2,0) |
SMALLINT NOT NULL |
Number of Days
|
| 48 |
SENIORITY_PAY_DT |
Date(10) |
DATE |
Seniority Pay Calc Date
|
| 49 |
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.
|
| 50 |
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.
|
| 51 |
FILEREFPATH |
Character(128) |
VARCHAR2(128) NOT NULL |
File Reference Path
|
| 52 |
GPMX_DIGITAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Upload digital certificate
N=No
Y=Yes
Default Value: N
|
| 53 |
PYMT_DT |
Date(10) |
DATE |
Payment Date
|
| 54 |
GPMX_FILE_TP_CFDI |
Character(1) |
VARCHAR2(1) NOT NULL |
File Type CFDI Mexico
E=By Employee
M=Massive
|
| 55 |
TOTAL_EMPLID |
Number(9,0) |
DECIMAL(9) NOT NULL |
Total EmplID
|
| 56 |
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
|
| 57 |
RUN_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Run Type Name
|
| 58 |
GPMX_FILE_PATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Input/Output file path
|
| 59 |
GPMX_PAID_DAYS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Paid Days
|
| 60 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 61 |
TERMINATIONS |
Number(3,0) |
SMALLINT NOT NULL |
TERMINATIONS
|
| 62 |
PT_RECFIELDVALUE |
Character(100) |
VARCHAR2(100) NOT NULL |
Parameter Value
|
| 63 |
GPMX_LBL_HEADER1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Label Header Mexico.
|
| 64 |
GPMX_OUTPUT_DIR |
Character(127) |
VARCHAR2(127) NOT NULL |
Input/Output file path
|
| 65 |
GPMX_PAYMENT_MTHD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Method
01=Cash
02=Check
03=Electronic Funds Transfer
04=Credit Card
05=Electronic Wallet
06=Electronic Money
08=Food Coupons
28=Debit Card
29=Service Card
99=To be defined
A=Cash
C=Check
|
| 66 |
GPMX_TRM_PAY_MTHD |
Character(2) |
VARCHAR2(2) NOT NULL |
Terminations Payment Method
01=Cash
02=Check
A=Cash
C=Check
|
| 67 |
GPMX_QR_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
QR Code Field for GP Mex
|
| 68 |
GPMX_CAPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Ceiling - GP Mexico
|
| 69 |
GPMX_EMP_RUN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Option
A=All
E=In Error
|
| 70 |
GPMX_CAL_FINAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow process CFDI only for Calendar Finalized
|
| 71 |
GPMX_OVR_CD_REGIME |
Character(2) |
VARCHAR2(2) NOT NULL |
Override Labor Regimen Code for Severance
13=Severance
|
| 72 |
GPMX_SUB_EMP_PAID |
Character(1) |
VARCHAR2(1) NOT NULL |
Employment Subsidy Effective Paid
|
| 73 |
GPMX_SUBS_NODE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to print the Subsidy Node
|
| 74 |
GPMX_ESTABID_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Establishment option
J=Job Data
L=Location
Default Value: L
|
| 75 |
GPMX_NAME_254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Name 254
|