UX_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
Default Value: 5
Default Value: 15
Default Value: 30
Y/N Table Edit
UX_ALERT_DEF(SQL Table) |
Index Back |
|---|---|
Alert Type DefinitionHost all the alert types and it's defintion regarding to sequence, urgency levels, included in the pagelet, and allow to delete. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 2 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 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 | ALERT_DAYS_CRT | Number(3,0) | SMALLINT NOT NULL |
Number of days for critical alerts.
Default Value: 5 |
| 5 | ALERT_DAYS_STD | Number(3,0) | SMALLINT NOT NULL |
Number of days for high level alerts
Default Value: 15 |
| 6 | ALERT_DAYS_INFO | Number(3,0) | SMALLINT NOT NULL |
Number of days for informational alerts
Default Value: 30 |
| 7 | UX_MAX_BACK | Number(3,0) | SMALLINT NOT NULL | Define overdue days for critical alerts on Admin setup page. |
| 8 | UX_ALLOWED_DEL | Character(1) | VARCHAR2(1) NOT NULL |
Allow to Delete
Y/N Table Edit |