User Alerts
Keystone supports User Alerts which are used to communicate important information to Keystone users.
CCTALERT table
The key to this feature is the CCTALERT table in the CCWSYS database.
NOTE: This table is re-downloaded daily (1:00 AM) from the cloud.
| Column | Description | Data Type | Default | Required | Comment |
|---|---|---|---|---|---|
| ID | Record Id | integer | * | Must be sequential starting from 1 | |
| ONCE_FLAG | Auto-Dismiss | Y/N | N | * | Y=auto-dismiss after display |
| CRITICAL_FLAG | Critical Alert | Y/N | N | * | Y=critical alert (displays in bold at top of list) |
| OCCUR_FLAG | Display Frequency | Y/D/W/M/A | Y | * | alwa(Y)s, (D)aily, (W)eekly, (M)onthly, (A)nnually |
| BEG_DATE | Start Date | date | Start Date for the alert | ||
| END_DATE | End Date | date | End Date for the alert | ||
| BEG_VER | Start Version | varchar(20) | Version Start (version >= Start Version) | ||
| VER_CUTOFF | Version Cutoff | varchar(20) | Version Cutoff (version < Version Cutoff) | ||
| MODULE_LIST | Module List | varchar(20) | Module List (comma-separated) | ||
| PROGRAM_LIST | Program List | varchar(100) | Program List (comma-separated) | ||
| USER_ROLE_LIST | User Role List | varchar(100) | User Role List (comma-separated) | ||
| MSG | Alert Message | varchar(250) | * | Alert Message text | |
| URL | Link URL | varchar(200) | Clickable Link URL | ||
| URL_DESC | Link Description | varchar(100) | Clickable Link text (what the user sees) |