EP_ALERT_TYP_VW

(SQL View)
 Index Back

ePerformance Notifications

Notification Details used in the HR notify framework

SELECT DISTINCT A.EP_ALERT_TYPE , X.XLATLONGNAME FROM PS_EP_ALERT_DTLS A , PSXLATITEM X WHERE A.EP_ALERT_DAYS > 0 AND (X.FIELDNAME = 'EP_ALERT_TYPE' AND X.FIELDVALUE = A.EP_ALERT_TYPE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description