HGA_MGR_PND_VW

(SQL View)
 Index Back

Pending absence requests

Pending absence requests view used in MSS pivot grids.

SELECT E.EMPLID , E.EMPL_RCD , E.TRANSACTION_NBR , E.OPRID , E.EMPLID_CURR_APPR , CASE WHEN E.EMPLID_CURR_APPR = DEL.PROXY_ID THEN 'C' ELSE 'P' END FROM PS_HGA_APPR_DTL_VW E LEFT OUTER JOIN PS_HCDL_DELEGATION DEL ON E.EOAWORIG_OPRID = DEL.DELEGATOR_OPRID AND E.EMPLID_CURR_APPR = DEL.PROXY_ID AND DEL.TRANSACTION_NAME = 'GP_SS_ABS_APPR_L' AND (DEL.FROM_DATE <= %CurrentDateIn AND (DEL.TO_DATE >= %CurrentDateIn OR DEL.TO_DATE IS NULL )) AND DEL.DLGT_STATUS = 'A' WHERE E.EOAWUSTEP_STATUS = 'P' AND E.EMPLID_CURR_APPR <> ' ' AND NOT EXISTS ( SELECT 'Y' FROM PS_HGA_MGR_SEC_VW DR WHERE DR.EMPLID = E.EMPLID AND DR.EMPL_RCD = E.EMPL_RCD AND DR.SUPERVISOR_ID = E.EMPLID_CURR_APPR)

# 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 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
6 REPORTSTO_TYPE Character(1) VARCHAR2(1) NOT NULL Reports to type: D - Direct I - Indirect C - Delegated P - Other (Pending Approval)
A=All
C=Delegated
D=Direct
I=Indirect
P=Other