GPMX_NRP_FIX_VW(SQL View) |
Index Back |
|---|---|
WA for FIX ReportUsed for SDI fix report process |
| SELECT GP_PAYGROUP ,EFFDT ,GPMX_PIN_ERN_NUM + 50000000 ,GPMX_FIXSDI_TYPE ,GPMX_CALC_BASE ,GPMX_BASE_AMOUNT ,GPMX_BASE_DAY ,GPMX_BASE_PCTG ,GPMX_BASE_WG_ZONE ,GPMX_INT_BASE ,GPMX_INT_PCTG_LOW ,GPMX_INT_WGZN_LOW ,GPMX_INT_PCTG_TOP ,GPMX_INT_WGZN_TOP FROM PS_GPMX_FIXSDI_PRM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP_OPR_VW |
|
| 2 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
| 3 | Number(8,0) | INTEGER NOT NULL | Earning Pin Num | |
| 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 |
| 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 |