OPRIDUX_ALERT_TYPEAV=Anniversary Alerts
BD=Birthday Alerts
EC=Compensation
EP=Performance
LI=Expiring Licenses/Certificates
ME=Expiring Memberships
TR=Scheduled Training
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
UX_ALTDEF_USER(SQL Table) |
Index Back |
|---|---|
User Perference SettingUsers' Personalization Settings 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_ALERT_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
The definitions of alert types showed as a dropdown list on the Admin setup page.
AV=Anniversary Alerts BD=Birthday Alerts EC=Compensation EP=Performance LI=Expiring Licenses/Certificates ME=Expiring Memberships TR=Scheduled Training |
| 3 | UX_TYPE_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Checkbox for including the alerts types on alert definetion grid on Admin setup page.
Y/N Table Edit |
| 4 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | UX_ALERT_INLCUDED | Character(1) | VARCHAR2(1) NOT NULL |
Admin setup field to determine if current alert type will be included in the pagelet.
Y/N Table Edit |
| 6 | UX_ALLOWED_DEL | Character(1) | VARCHAR2(1) NOT NULL |
Allow to Delete
Y/N Table Edit |