GPMX_NRP_FIX_AD(SQL Table) |
Index Back |
|---|---|
Fix SDI ParametersFix SDI Earnings Parameters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | GPMX_PIN_ERN_NUM |
Number(8,0) | INTEGER NOT NULL | Earning Pin Num |
| 5 | GPMX_FIXSDI_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Fix SDI Type MEX
0010=General 0020=By Payee |
| 6 | 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 |
| 7 | GPMX_BASE_AMOUNT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Fix SDI Base Amount MEX |
| 8 | GPMX_BASE_DAY | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Fix SDI Base Day MEX |
| 9 | GPMX_BASE_PCTG | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Fix SDI Base Pctg MEX |
| 10 | 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 |
| 11 | GPMX_INT_BASE | Character(4) | VARCHAR2(4) NOT NULL |
Fix SDI Int Base MEX
0010=Daily Rate 0020=SDI 0030=Minimun Wage 0040=All |
| 12 | GPMX_INT_PCTG_LOW | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Fix SDI Int Pctg Low MEX |
| 13 | 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 |
| 14 | GPMX_INT_PCTG_TOP | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Fix SDI Int Pctg Top MEX |
| 15 | 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 |