| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
GPMX_PIN_ERN_NUM |
Number(8,0) |
INTEGER NOT NULL |
Earning Pin Num
Prompt Table:
GPMX_PIN_ER_VW
|
| 4 |
GPMX_FIXSDI_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Fix SDI Type MEX
0010=General
0020=By Payee
Default Value: 0010
|
| 5 |
GPMX_CALC_BASE |
Character(4) |
VARCHAR2(4) NOT NULL |
Fix SDI Calc Base MEX
0010=Daily Rate
0020=SDI
0030=Minimun Wage
0040=Amount
0050=# of Days
Default Value: 0040
|
| 6 |
GPMX_BASE_AMOUNT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Fix SDI Base Amount MEX
|
| 7 |
GPMX_BASE_DAY |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Fix SDI Base Day MEX
|
| 8 |
GPMX_BASE_PCTG |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Fix SDI Base Pctg MEX
|
| 9 |
GPMX_BASE_WG_ZONE |
Character(4) |
VARCHAR2(4) NOT NULL |
Fix SDI Base Wg Zone MEX
0010=A Economic Zone
0020=B Econimic Zone
0030=C Economic Zone
0040=Payee's Economic Zone
Default Value: 0010
|
| 10 |
GPMX_INT_BASE |
Character(4) |
VARCHAR2(4) NOT NULL |
Fix SDI Int Base MEX
0010=Daily Rate
0020=SDI
0030=Minimun Wage
0040=All
Default Value: 0040
|
| 11 |
GPMX_INT_PCTG_LOW |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Fix SDI Int Pctg Low MEX
|
| 12 |
GPMX_INT_WGZN_LOW |
Character(4) |
VARCHAR2(4) NOT NULL |
Fix SDI Int Wg Zone Low MEX
0010=A Economic Zone
0020=B Economic Zone
0030=C Economic Zone
0040=Payee's Economic Zone
Default Value: 0010
|
| 13 |
GPMX_INT_PCTG_TOP |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Fix SDI Int Pctg Top MEX
|
| 14 |
GPMX_INT_WGZN_TOP |
Character(4) |
VARCHAR2(4) NOT NULL |
Fix SDI Int Wgzn Top MEX
0010=A Economic Zone
0020=B Economic Zone
0030=C Economic Zone
0040=Payee's Economic Zone
Default Value: 0010
|