GPMX_CF_EMP_TMP(SQL Table) |
Index Back |
|---|---|
CFDI Employees MEXCFDI Employees MEX |
| # | 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 Rcd Nbr |
| 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 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 |
| 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(1) | VARCHAR2(1) NOT NULL |
Company Settings
1=Class I 2=Class II 3=Class III 4=Class IV 5=Class V |
| 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 |