GP_CS_PACUM_PVW

(SQL View)
 Index Back

Accumulator View

Accumulator View used in Pivot Grids for Processing Monitor

SELECT A.DEPTID , A.EMPLID , A.EMPL_RCD , B.GP_PAYGROUP , B.PIN_NUM , B.CAL_RUN_ID , B.CAL_ID , SUM( B.CALC_RSLT_VAL) FROM PS_JOB A , PS_GP_RSLT_ACUM B WHERE ( A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_JOB A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.EMPL_RCD = A_ED.EMPL_RCD AND A_ED.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A_ES.EFFSEQ) FROM PS_JOB A_ES WHERE A.EMPLID = A_ES.EMPLID AND A.EMPL_RCD = A_ES.EMPL_RCD AND A.EFFDT = A_ES.EFFDT) AND A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.GP_PAYGROUP = B.GP_PAYGROUP AND B.RSLT_SEG_NUM = ( SELECT MAX(SUB.RSLT_SEG_NUM) FROM PS_GP_RSLT_ACUM SUB WHERE B.EMPLID = SUB.EMPLID AND B.CAL_RUN_ID = SUB.CAL_RUN_ID AND B.EMPL_RCD = SUB.EMPL_RCD AND B.GP_PAYGROUP = SUB.GP_PAYGROUP AND B.CAL_ID = SUB.CAL_ID AND B.ORIG_CAL_RUN_ID = SUB.ORIG_CAL_RUN_ID) ) GROUP BY A.DEPTID , A.EMPLID , A.EMPL_RCD , B.CAL_RUN_ID, B.GP_PAYGROUP , B.CAL_ID , B.PIN_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee 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 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
6 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
8 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result