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 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP_OPR_VW |
2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
3 | GPMX_PIN_ERN_NUM | 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 |