EP_ALERT_SETUP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type Prompt Table: EP_REVW_TYP_VW
2	EP_ALERT_COMP_DT	Date(10)	DATE NOT NULL	Used on the Employee Review Alerts pagelet to determine the Period End Dates to display.
3	EP_ALERT_NUM_EMPS	Number(2,0)	SMALLINT NOT NULL	Used on the Employee Review Alerts pagelet to determine the number of employees to display on the short pagelet. Default Value: 5
4	EP_ALERT_CHG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Used on the Employee Review Alerts pagelet to determine if the manager can change Review Type. Y/N Table Edit Default Value: N
5	EP_ALERT_CHG_RANGE	Character(1)	VARCHAR2(1) NOT NULL	Used on the Employee Review Alerts pagelet to determine if the manager can change End Date Range. Y/N Table Edit Default Value: N
6	EP_ALERT_CHG_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Used on the Employee Review Alerts pagelet to determine if the manager can change Display Alert Levels. Y/N Table Edit Default Value: N
7	EP_ALERT_CHG_DAYS	Character(1)	VARCHAR2(1) NOT NULL	Used on the Employee Review Alerts pagelet to determine if the manager can change Alert Days. Y/N Table Edit Default Value: N
8	EP_ALERT_CHG_EMPS	Character(1)	VARCHAR2(1) NOT NULL	Used on the Employee Review Alerts pagelet to determine if the manager can change Number of Employees. Y/N Table Edit Default Value: N
9	EP_ALERT_DISP_COM	Character(1)	VARCHAR2(1) NOT NULL	Used on the Employee Review Alerts pagelet to determine if reviews with Alert Level of "Complete" are displayed. Y/N Table Edit Default Value: N
10	EP_ALERT_DISP_ONS	Character(1)	VARCHAR2(1) NOT NULL	Used on the Employee Review Alerts pagelet to determine if reviews with Alert Level of "On Schedule" are displayed. Y/N Table Edit Default Value: N
11	EP_ALERT_DISP_STD	Character(1)	VARCHAR2(1) NOT NULL	Used on the Employee Review Alerts pagelet to determine if reviews with Alert Level of "Standard Alert" are displayed. Y/N Table Edit Default Value: N
12	EP_ALERT_DISP_CRT	Character(1)	VARCHAR2(1) NOT NULL	Used on the Employee Review Alerts pagelet to determine if reviews with Alert Level of "Critical Alert" are displayed. Y/N Table Edit Default Value: N
13	EP_ALERT_DISP_CAN	Character(1)	VARCHAR2(1) NOT NULL	Used on the Employee Review Alerts pagelet to determine if reviews with Alert Level of "Cancelled" are displayed. Y/N Table Edit Default Value: N