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=Shared with Employee
CA=Canceled
CO=Completed
EC=Define Criteria
IP=Evaluation in Progress
NS=Not Started
PA=Approval
RH=Pending Acknowledgement
TP=Track Progress

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=Shared with Employee CA=Canceled CO=Completed EC=Define Criteria IP=Evaluation in Progress NS=Not Started PA=Approval RH=Pending Acknowledgement TP=Track Progress
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.