...
AlertConfigurationRoleRecipient Table
This table is an extension of AlertConfiguration table that allows to register specific roles as recipients for a specific alert.
The structure of this table is:
| Id | AlertConfigurationId | RoleId |
|---|
Where:
- Id: unique id of this entry.
- AlertConfigurationId: the id of the Alert Configuration where this recipient belongs.
- RoleId:the id of the targeted Role.
| Note |
|---|
| Roles with 'read_alerts_only_from_associated_patients' permission shouldn't have any entry in this table. These roles are going to omit this table and read straight from AlertPatient table. Entries for these roles in this table are thus redundant. |
TimeBasedAlertConfiguration
This table is an extension of AlertConfiguration that allows the configuration of alerts that are generated by a cron job instead of by the submission of a form. When the system starts-up, a Quartz job is created for each of the entries in this table. The job will be configured using the cron expression provided by this table and using the timezone of the facility where the associated Alert Configuration belongs to (given by the RoomId column of AlertConfiguration).
The structure of this table is:
| Id | AlertConfigurationId | CronExpression | FactName | JobKey |
|---|
Where:
- Id: unique id of this configuration.
- AlertConfigurationId: the id of the Alert Configuration where this recipient belongs.
- CronExpression: the cron expression used to register a job in Quartz.
- FactName: This string is used by the time-based rules to know when they should be fired.
- JobKey: The Quartz job key associated with this entry. If this entry doesn't have a Quartz job associated, this value is null.
Entity Model
