EP_DDTYP_ROL_VW

(SQL View)
 Index Back

ePerformance Notifications

Notification Details used in the HR notify framework

SELECT DISTINCT N.EP_DUEDATE_TYPE , R.EP_ROLE , R.EP_DESCR , A.EP_ALERT_TYPE FROM PS_EP_NOTIFY_DTLS N , PS_EP_ROLE_VW1 R , PS_EP_ALERT_DTLS A WHERE A.EP_ALERT_DAYS > 0 AND (A.EP_ALERT_TYPE = '1' AND N.EP_ALERT_DISP_ONS = 'Y' OR A.EP_ALERT_TYPE = '2' AND N.EP_ALERT_DISP_STD = 'Y' OR A.EP_ALERT_TYPE = '3' AND N.EP_ALERT_DISP_CRT = 'Y') UNION SELECT EP_DUEDATE_TYPE , EP_ROLE , R.EP_DESCR , EP_ALERT_TYPE FROM PS_EP_NOTIFY_DTLS N , PS_EP_ROLE_VW4 R , PS_EP_ALERT_DTLS A WHERE N.EP_DUEDATE_TYPE = '5' AND R.EP_ROLE = 'OTHER' AND (A.EP_ALERT_TYPE = '1' AND N.EP_ALERT_DISP_ONS = 'Y' OR A.EP_ALERT_TYPE = '2' AND N.EP_ALERT_DISP_STD = 'Y' OR A.EP_ALERT_TYPE = '3' AND N.EP_ALERT_DISP_CRT = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EP_DUEDATE_TYPE Character(1) VARCHAR2(1) NOT NULL This field stores the various phases of a document for which due dates can be stored in a Performance Calendar.
1=Approve Criteria
2=Checkpoint Due
3=Finalize Criteria
4=Nomination Due
5=Evaluation Due
2 EP_ROLE Character(8) VARCHAR2(8) NOT NULL Role unique identifier
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 EP_ALERT_TYPE Character(1) VARCHAR2(1) NOT NULL Field used to identify alert/threshold types for ePerformance Notifications.
1=Courtesy Reminder
2=Warning Reminder
3=Critical Reminder