EP_PE_OPR_A_STP

(SQL Table)
Index Back

EE Review Alerts - Opr Prefs

Stores personalizations relating to the Employee Review Alerts pagelet.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type

Prompt Table: EP_REVW_TYP_VW

3 EP_ALERT_COMP_DT Date(10) DATE Used on the Employee Review Alerts pagelet to determine the Period End Dates to display.
4 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.
5 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

6 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

7 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

8 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

9 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