GPAU_PSLP_SM_VW

(SQL View)
 Index Back

GP AUS - Payslip ED Vw

GP AUS - Payslip earnings and deductions view - The view will summarize earnings and deduction amounts by rslt_seg_num

SELECT E.EMPLID , E.EMPL_RCD , E.CAL_RUN_ID , E.GP_PAYGROUP , E.CAL_ID , B.PIN_NUM , B.BASE_RSLT_VAL , B.PCT_RSLT_VAL , B.RATE_RSLT_VAL , B.RSLT_PAYBK , B.RSLT_ADD_ARR , SUM(B.CALC_RSLT_VAL) , SUM(B.UNIT_RSLT_VAL) , SUM(B.CALC_ADJ_VAL) , SUM(B.BASE_ADJ_VAL) , SUM(B.UNIT_ADJ_VAL) FROM PS_GP_RSLT_ERN_DED B , PS_GP_PYE_PRC_STAT E WHERE B.EMPLID = E.EMPLID AND B.EMPL_RCD = E.EMPL_RCD AND B.CAL_RUN_ID = E.CAL_RUN_ID AND B.ORIG_CAL_RUN_ID = E.ORIG_CAL_RUN_ID AND B.GP_PAYGROUP = E.GP_PAYGROUP AND B.CAL_ID = E.CAL_ID GROUP BY E.EMPLID, E.EMPL_RCD, E.CAL_RUN_ID, E.GP_PAYGROUP, E.CAL_ID, B.PIN_NUM, B.BASE_RSLT_VAL, B.PCT_RSLT_VAL, B.RATE_RSLT_VAL, B.RSLT_PAYBK, B.RSLT_ADD_ARR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
7 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value
8 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value
9 RATE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
10 RSLT_PAYBK Signed Number(20,6) DECIMAL(18,6) NOT NULL Payback Amount Result
11 RSLT_ADD_ARR Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Added To Arrears
12 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
13 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation
14 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value
15 BASE_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Adjustment
16 UNIT_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit Adjustment