User Alerts: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
{| 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) | |||
|} | |} | ||
Revision as of 23:30, 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.
| 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) |