UX_ALERTS_PRS

(SQL Table)
Index Back

Alert Personalization

Record holds users' perference for 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 UX_CRITICAL_ALERT Character(1) VARCHAR2(1) NOT NULL Checkbox for including the critical alerts on Admin setup page.

Y/N Table Edit

3 UX_STANDARD_ALER Character(1) VARCHAR2(1) NOT NULL Checkbox for including the high level alerts on Admin setup page.

Y/N Table Edit

4 UX_INFO_ALER Character(1) VARCHAR2(1) NOT NULL Checkbox for including the informational alerts on Admin setup page.

Y/N Table Edit

5 UX_ALERT_NUM Number(2,0) SMALLINT NOT NULL Used on the Alerts pagelet to determine the number of alert messages to display on the pagelet.

Default Value: 0