EP_DUEDT_TYP_VW

(SQL View)
 Index Back

ePerformance Notifications

Notification Details used in the HR notify framework

SELECT DISTINCT N.EP_DUEDATE_TYPE , X.XLATLONGNAME FROM PS_EP_NOTIFY_DTLS N , PSXLATITEM X , PS_EP_ALERT_DTLS A WHERE X.FIELDNAME = 'EP_DUEDATE_TYPE' AND X.FIELDVALUE = N.EP_DUEDATE_TYPE AND 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')

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description