GPMX_NRP_FIX_VW

(SQL View)
Index Back

WA for FIX Report

Used 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