GPAU_ACR_DTL_VW

(SQL View)
 Index Back

Accrual Detail View

HRMS APAC Absence Accrual Inquiry Pages: Fetches all entitlements and associated values from result Acum Table based on Employee Id, record, Absence Take and Accumulator from and through dates.

SELECT DISTINCT A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , C.PIN_NUM , A.ACM_FROM_DT , A.ACM_THRU_DT , A.PIN_PARENT_NUM , E.DESCR , A.CALC_RSLT_VAL FROM PS_GP_RSLT_ACUM A , PS_GP_PYE_PRC_STAT B , PS_GP_ABS_TK_FCST C , PS_GP_PIN D , PS_GP_PIN E WHERE A. EMPLID = B.EMPLID AND A.CAL_RUN_ID = B.CAL_RUN_ID AND A.EMPL_RCD = B.EMPL_RCD AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID AND A.ORIG_CAL_RUN_ID = B.ORIG_CAL_RUN_ID AND A.ORIG_CAL_RUN_ID = A.CAL_RUN_ID AND B.CALC_TYPE = 'A' AND A.EMPL_RCD_ACUM = A.EMPL_RCD AND A.PIN_NUM = C.PIN_FCST_RSLT_NUM AND C.PIN_FCST_RSLT_NUM = D.PIN_NUM AND D.PIN_TYPE = 'AC' AND B.PRC_ORD_TS = ( SELECT MAX(PRC_ORD_TS) FROM PS_GP_PYE_PRC_STAT ST WHERE A. EMPLID = ST.EMPLID AND A.CAL_RUN_ID = ST.CAL_RUN_ID AND A.EMPL_RCD = ST.EMPL_RCD AND A.GP_PAYGROUP = ST.GP_PAYGROUP AND A.ORIG_CAL_RUN_ID = ST.ORIG_CAL_RUN_ID AND ST.CALC_TYPE = 'A') AND E.PIN_NUM = A.PIN_PARENT_NUM AND A.RSLT_SEG_NUM = ( SELECT MAX(A1.RSLT_SEG_NUM) FROM PS_GP_RSLT_ACUM A1 WHERE A.EMPLID = A1.EMPLID AND A.EMPL_RCD = A1.EMPL_RCD AND A.CAL_ID = A1.CAL_ID AND A.CAL_RUN_ID = A1.CAL_RUN_ID AND A.ORIG_CAL_RUN_ID = A1.ORIG_CAL_RUN_ID AND A.PIN_NUM = A1.PIN_NUM)

# 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 Record
4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
5 ACM_FROM_DT Date(10) DATE From Date
6 ACM_THRU_DT Date(10) DATE Through Date
7 PIN_ENT_NUM Number(8,0) INTEGER NOT NULL Element number field
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 GPAU_ACUM_VAL4 Signed Number(20,6) DECIMAL(18,6) NOT NULL This field will be used to store the value of accumulator 4 used for on-line and hard-copy payslips