EP_PG_DFLT_VW

(SQL View)
 Index Back

EP_PG_DFLT_VW

Used in Document status pivot chart published in Manager Dash Board as a pagelet. This record displays user settings selected in Document Status Pivot chart.

SELECT OPRID , EP_REVIEW_TYPE , FROM_DATE , TO_DATE , EP_MANAGER_ID , CASE WHEN ( SELECT CFG.ACCESS_TYPE FROM PS_HR_DR_UI_CFG CFG WHERE CFG.PNLGRPNAME='EP_APPR_SELECT' ) > 3 THEN SUPERVISOR_ERN ELSE 0 END FROM PS_EP_PG_USER_DFLT UNION ALL SELECT OPR.OPRID , DFLT.EP_REVIEW_TYPE , DFLT.FROM_DATE , DFLT.TO_DATE , OPR.EMPLID , CASE WHEN ( SELECT CFG.ACCESS_TYPE FROM PS_HR_DR_UI_CFG CFG WHERE CFG.PNLGRPNAME='EP_APPR_SELECT' ) > 3 THEN JOB.EMPL_RCD ELSE 0 END FROM PS_EP_DEFAULT DFLT ,PSOPRDEFN OPR , PS_HR_DR_PR_JOB_VW JOB WHERE OPR.EMPLID=JOB.EMPLID AND NOT EXISTS( SELECT 'X' FROM PS_EP_PG_USER_DFLT DFL WHERE DFL.OPRID=OPR.OPRID) AND DFLT.EP_TRANSACTION_NM='P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type
3 FROM_DATE Date(10) DATE From Date
4 TO_DATE Date(10) DATE Latest Date to be sent to PYR
5 EP_MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager/Mentor ID.
6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record