GP_CS_PNET_PVW

(SQL View)
 Index Back

Net Pay View

Net Pay View used in Pivot Grids for Processing Monitor

SELECT A.DEPTID , A.EMPLID , A.EMPL_RCD , B.GP_PAYGROUP , B.CAL_RUN_ID , B.CAL_ID , SUM( B.PIN_NET_VAL) FROM PS_JOB A , PS_GP_PYE_SEG_STAT 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_VER_NUM = 1 AND B.RSLT_REV_NUM = 1 AND B.RSLT_SEG_NUM = ( SELECT MAX(SUB.RSLT_SEG_NUM) FROM PS_GP_PYE_SEG_STAT 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.GP_PAYGROUP , B.CAL_RUN_ID , B.CAL_ID

# 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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
7 PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value