GPGB_FPS_R2_VW

(SQL View)
 Index Back

GPGB_ER_NIC_VALUE values

GPGB_ER_NIC_VALUE values

SELECT RSLT.EMPLID ,RSLT.CAL_RUN_ID ,RSLT.EMPL_RCD ,RSLT.GP_PAYGROUP ,RSLT.RSLT_SEG_NUM ,RSLT.USER_KEY1 ,RSLT.USER_KEY2 C ,C.PIN_NM ,SUM(ACUM.CALC_VAL-RSLT.GPGB_ER_NIC_VALUE) FROM PS_GPGB_RTI_RSLT RSLT , PS_GP_RSLT_ACUM ACUM , PS_GP_PIN C WHERE RSLT.GPGB_ER_NIC_VALUE <> 0 AND RSLT.EMPLID = ACUM.EMPLID AND RSLT.EMPL_RCD = ACUM.EMPL_RCD AND RSLT.GP_PAYGROUP = ACUM.GP_PAYGROUP AND RSLT.CAL_ID = ACUM.CAL_ID AND ACUM.PIN_NUM = C.PIN_NUM AND RSLT.CAL_RUN_ID = ACUM.CAL_RUN_ID AND RSLT.EMPL_RCD = ACUM.EMPL_RCD AND RSLT.GP_PAYGROUP = ACUM.GP_PAYGROUP AND RSLT.CAL_ID = ACUM.CAL_ID AND RSLT.ORIG_CAL_RUN_ID = ACUM.ORIG_CAL_RUN_ID AND RSLT.RSLT_SEG_NUM = ACUM.RSLT_SEG_NUM AND ACUM.SEQ_NUM8 = ( SELECT MAX(ACUM1.SEQ_NUM8) FROM PS_GP_RSLT_ACUM ACUM1 WHERE ACUM1.EMPLID = ACUM.EMPLID AND ACUM1.CAL_RUN_ID = ACUM.CAL_RUN_ID AND ACUM1.EMPL_RCD = ACUM.EMPL_RCD AND ACUM1.GP_PAYGROUP = ACUM.GP_PAYGROUP AND ACUM1.CAL_ID = ACUM.CAL_ID AND ACUM1.ORIG_CAL_RUN_ID = ACUM.ORIG_CAL_RUN_ID AND ACUM1.RSLT_SEG_NUM = ACUM.RSLT_SEG_NUM AND ACUM1.PIN_NUM = ACUM.PIN_NUM) GROUP BY RSLT.EMPLID, RSLT.CAL_RUN_ID, RSLT.EMPL_RCD, RSLT.GP_PAYGROUP, RSLT.RSLT_SEG_NUM, RSLT.USER_KEY1 ,RSLT.USER_KEY2, C.PIN_NM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
6 USER_KEY1 Character(25) VARCHAR2(25) NOT NULL User Key 1
7 USER_KEY2 Character(25) VARCHAR2(25) NOT NULL User Key 2
8 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
9 CALC_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Value