GP_CS_PNET_VW

(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 , C.NAME_DISPLAY , A.CAL_RUN_ID , B.CAL_RUN_ID , A.GP_PAYGROUP , A.CAL_ID , B.CAL_ID , D.MESSAGE_TEXT , A.PIN_NET_VAL , B.PIN_NET_VAL , A.PIN_NET_VAL- B.PIN_NET_VAL , CASE WHEN A.PIN_NET_VAL = 0 AND B.PIN_NET_VAL = 0 THEN 0 WHEN A.PIN_NET_VAL <> 0 AND B.PIN_NET_VAL = 0 THEN 100 ELSE %Abs(%DecDiv(%DecMult(A.PIN_NET_VAL- B.PIN_NET_VAL, 100), B.PIN_NET_VAL)) END FROM PS_GP_CS_PNET_PVW A , PS_GP_CS_PNET_PVW B , PS_PERSON_NAME C , PSMSGCATDEFN D WHERE A.DEPTID = B.DEPTID AND A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.EMPLID = C.EMPLID AND D.MESSAGE_SET_NBR = 17000 AND D.MESSAGE_NBR = 4881

  • Related Language Record: GP_CS_PNET_VL

    • # 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 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    5 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    6 GP_PREV_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Previous Calendar Group ID
    7 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    8 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
    9 GP_PREV_CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value
    12 GP_PREV_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value
    13 GP_CS_AMT_DIFF Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value
    14 GP_CS_PCT_DIFF Signed Number(22,6) DECIMAL(20,6) NOT NULL Percentage Difference