Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
Patient_oid | int | NOT NULL | The object ID of the alert raised for the patient. |
AlertID | int | NOT NULL | The object ID of the alert. |
AlertTitle | varchar(128) | NOT NULL | The title of the alert as displayed on the Worklist. |
AlertDescription | varchar(255) | NOT NULL | The complete description of the alert. |
CreatedDateTime | smalldatetime | NOT NULL | The date and time when the alert was created. |
AlertPriority | smallint | NOT NULL | The priority of the alert. Allowable Values: 1 - Critical, 2 - High, 3 - Medium, 4 - Low. |
AlertStatus | smallint | NOT NULL | The status of the alert. Allowable Values: 1 - AlertInActive, 2 - AlertActive, 3 - AlertCompleted, 4 - AlertRemoved, 5 - AlertInProgress. |
CompletedDateTime | smalldatetime | NULL | The date and time when the alert was completed or deleted from the application. |
DeclineComments | varchar(255)NULL, | | The comments from the user if the user declines an alert without performing the mandatory suggested actions. |
DeclinedBy | int | NULL | The object id of the user who performed the decline action. |
BusObjectID | bigint | NULL | The business object ID of the owner or the source of the alert. |
BusObjectType | varchar(20) | NOT NULL | The source or the owner's code, which resulted in creating the alert. Examples: ADT, COS, WFE. |
Visit_oid | int | NULL | The object ID of the patient visit during which the alert is created. |
UseCensus | smallint | NOT NULL | When set to 0, indicates that the alert should be displayed on the Worklist of the user if the user has a role associated with the alert. For this category, the patient need not be on the user's Patient Census. This field will be set to 0 for alerts that can be seen by all staff members of a particular role irrespective of whether or not they are responsible for that patient. For example, alerts that need to be displayed on a Pharmacist's alert Worklist. When set to 1, indicates that the alert should be displayed on the Worklist of those users who have the patient on their worklist census and have at least one of the roles associated with the alert. This category is more restricted and will ensure that sensitive alerts are displayed only on those users' Worklist who have access to the patient. |
LastViewedBy | int | NULL | The object ID of the user who last viewed the alert. |
LastViewedDateTime | smalldatetime | NULL | The last date and time when the alert was viewed. |
AutoRemove | smallint | NOT NULL | When set to 1, indicates that the alert can be automatically removed from the user's Worklist. |
DisplayLocation | char(3) | NOT NULL | The location where the alert displays. |
CreatedBy | int | NOT NULL | The user ID of the user whose session created the instance of the alert. |
AuditComment | varchar(500) | NULL | The description about the alert as entered by the user. |
DupCheckSum | int | NULL | The "checkSUM" associated with the alert. For duplicate alerts, logic is defined to identify the alert in the HREAlert table. The duplicate check is defined as a second alert for the same patient with the same text in the name and description fields and the same suggested actions and the same fields for the suggested actions. Since this is a complex combination to determine at runtime, the combination of the mentioned information is converted into a "checkSUM" literal that is saved with every alert. On creation of every new alert, the checkSUM value for the new alert is evaluated and compared in the database for any duplicates. |
HasMandatories | smallint | NOT NULL | When set to 1, indicates the alert contains mandatory suggested actions. |
AlertCategory_oid | int | NULL | The link to the Alert Category table |
AcceptedByOID | int | NULL | The ObjectID of the user who accepts the alert. |
AcceptComments | varchar(255) | NULL | The comments from the user if the user accepts an alert. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|
|