HGA_BAL_TAKE_VW

(SQL View)
 Index Back

Pending Requests Duration

09/16/13 EGS: Created

SELECT A.EMPLID , A.EMPL_RCD , A.PIN_ENTL_BAL_NUM , SUM(DURATION_ABS) FROM PS_GP_ABS_BALSS_VW A , PS_GP_PIN_CMPNT B , PS_GP_ABS_TAKE_ENT C , PS_GP_ABSHISTSS_VW D WHERE B.PIN_ENTL_BAL_NUM = A.PIN_ENTL_BAL_NUM AND C.PIN_ENT_NUM = B.PIN_NUM AND C.PRIORITY = ( SELECT MIN(PRIORITY) FROM PS_GP_ABS_TAKE_ENT WHERE PIN_ENT_NUM = C.PIN_ENT_NUM) AND D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.PIN_TAKE_NUM = C.PIN_NUM AND D.PROCESS_DT IS NULL AND D.WF_STATUS NOT IN ('C', 'N') GROUP BY A.EMPLID, A.EMPL_RCD, A.PIN_ENTL_BAL_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 PIN_ENTL_BAL_NUM Number(8,0) INTEGER NOT NULL Element number field
4 DURATION_ABS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements