Table for recording alarms for generating notifications
Data model
Fields
| Field | Type | Description |
|---|---|---|
| chalarm_action* | INT | Alarm type identifier (Start = 1, Stop = 2, Alert = 3, Warning = 4) |
| chalarm_docid* | INT | Field for configured alarm document ID. |
| chalarm_docstatusid | INT | Field for identification of open or closed alarm status. |
| chalarm_expirationdate* | DATETIME | Alarm expiration date |
| chalarm_id* | INT | Primary Table Key |
| chalarm_itemtime_id | INT | Identifier for association of configured attention times. |
| chalarm_provider_id | INT | Identification for Provider Association |
| chalarm_status* | INT | Alarm status identification |
| chalarm_type* | INT | Field for configured alarm type identification. |
Primary Key
| PK_AFLS_CHRONOS_ALARMS |
|---|
| chalarm_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| chalarm_itemtime_id | Bod. AFW_ITEM_TIMES | id | FK01_AFLS_CHRONOS_ALARMS |