EP_LAST_NOTIFY (SQL Table)	Index Back
DUE DATE NOTIFICATIONS Table for ePerformance documents due-date email data

EP_LAST_NOTIFY

(SQL Table)

DUE DATE NOTIFICATIONS

Table for ePerformance documents due-date email data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_NOTIF_TRNS_ID Number(10,0) DECIMAL(10) NOT NULL Notification ID for Due Date Notifications.

2 EP_DATE_PROCESSED Date(10) DATE Last Date this ID was processed. Used for Due Date notifications

3 EP_LAST_RUN_DATE DateTime(26) TIMESTAMP Last Date this ID was run. Used for Due Date notifications

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_NOTIF_TRNS_ID	Number(10,0)	DECIMAL(10) NOT NULL	Notification ID for Due Date Notifications.
2	EP_DATE_PROCESSED	Date(10)	DATE	Last Date this ID was processed. Used for Due Date notifications
3	EP_LAST_RUN_DATE	DateTime(26)	TIMESTAMP	Last Date this ID was run. Used for Due Date notifications