GP_CS_PACUM_VW

(SQL View)
 Index Back

Accumulator View

Accumulator View used in Pivot Grids for Processing Monitor

SELECT A.DEPTID , A.EMPLID , A.EMPL_RCD , A.GP_PAYGROUP , A.PIN_NUM , C.NAME_DISPLAY , A.CAL_RUN_ID , B.CAL_RUN_ID , A.CAL_ID , B.CAL_ID , D.DESCR , A.CALC_RSLT_VAL , B.CALC_RSLT_VAL , A.CALC_RSLT_VAL- B.CALC_RSLT_VAL , CASE WHEN A.CALC_RSLT_VAL = 0 AND B.CALC_RSLT_VAL = 0 THEN 0 WHEN A.CALC_RSLT_VAL <> 0 AND B.CALC_RSLT_VAL = 0 THEN 100 ELSE %Abs(%DecDiv(%DecMult(A.CALC_RSLT_VAL- B.CALC_RSLT_VAL, 100), B.CALC_RSLT_VAL)) END FROM PS_GP_CS_PACUM_PVW A , PS_GP_CS_PACUM_PVW B , PS_PERSON_NAME C , PS_GP_PIN 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.PIN_NUM = B.PIN_NUM AND A.EMPLID = C.EMPLID AND A.PIN_NUM = D.PIN_NUM

  • Related Language Record: GP_CS_PACUM_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 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    6 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    7 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    8 GP_PREV_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Previous Calendar Group ID
    9 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
    10 GP_PREV_CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    12 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
    13 GP_PREV_ACUM_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value
    14 GP_CS_AMT_DIFF Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value
    15 GP_CS_PCT_DIFF Signed Number(22,6) DECIMAL(20,6) NOT NULL Percentage Difference