User Alerts: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
Keystone supports User Alerts which are used to communicate important information to Keystone users. | Keystone supports User Alerts which are used to communicate important information to Keystone users. | ||
CCTALERT table | ==CCTALERT table== | ||
The key to this feature is the CCTALERT table in the CCWSYS database. | <p>The key to this feature is the CCTALERT table in the CCWSYS database.</p> | ||
<p><i>NOTE: This table is re-downloaded daily (1:00 AM) from the cloud.</i></p> | |||
{| border="3" cellspacing="0" cellpadding="3" class="wikitable" | {| border="3" cellspacing="0" cellpadding="3" class="wikitable" | ||
! Column | ! Column | ||
! Description | ! Description | ||
! Data Type | ! Data Type | ||
! Default | ! 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) | |||
|} | |} | ||
Latest revision as of 23:32, 25 August 2026
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) |