EP_PE_OPR_A_STP(SQL Table) |
Index Back |
---|---|
EE Review Alerts - Opr PrefsStores personalizations relating to the Employee Review Alerts pagelet. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |