EP_ALERT_DAYS (SQL Table)	Index Back
EE Review Alerts Days This record determines when alerts appear for each Review Type on the Employee Review Alerts pagelet.

EP_ALERT_DAYS

(SQL Table)

EE Review Alerts Days

This record determines when alerts appear for each Review Type on the Employee Review Alerts pagelet.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_REVIEW_STATUS Character(4) VARCHAR2(4) NOT NULL This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately.
AK=Acknowledged
AR=Available for Review
CA=Cancelled
CO=Completed
IP=In Progress
NS=Not Started
RH=Review Held

2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

3 EP_ALERT_DAYS_CRT Number(3,0) SMALLINT NOT NULL Used on the Employee Review Alerts pagelet to determine when corresponding alerts should appear.

4 EP_ALERT_DAYS_STD Number(3,0) SMALLINT NOT NULL Used on the Employee Review Alerts pagelet to determine when corresponding alerts should appear.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_REVIEW_STATUS	Character(4)	VARCHAR2(4) NOT NULL	This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately. AK=Acknowledged AR=Available for Review CA=Cancelled CO=Completed IP=In Progress NS=Not Started RH=Review Held
2	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
3	EP_ALERT_DAYS_CRT	Number(3,0)	SMALLINT NOT NULL	Used on the Employee Review Alerts pagelet to determine when corresponding alerts should appear.
4	EP_ALERT_DAYS_STD	Number(3,0)	SMALLINT NOT NULL	Used on the Employee Review Alerts pagelet to determine when corresponding alerts should appear.