GPGB_RTIRSLT_VW

(SQL View)
 Index Back

GPGB_NIABLE_PTD values


SELECT ACUM.EMPLID ,ACUM.CAL_RUN_ID ,ACUM.EMPL_RCD ,ACUM.GP_PAYGROUP ,ACUM.RSLT_SEG_NUM ,ACUM.USER_KEY1 ,ACUM.USER_KEY2 C ,C.PIN_NM ,SUM(ACUM.CALC_VAL-ACUM.CALC_RSLT_VAL) FROM PS_GP_RSLT_ACUM ACUM , PS_GP_PIN C WHERE ACUM.PIN_NUM = C.PIN_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 ACUM.EMPLID, ACUM.CAL_RUN_ID, ACUM.EMPL_RCD, ACUM.GP_PAYGROUP, ACUM.RSLT_SEG_NUM, ACUM.USER_KEY1 ,ACUM.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 Rcd Nbr
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