Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HREAlert This table stores Clinical Alerts for the Patient. Typically populated by Workflow Engine and Rules Engine.
Column Name Column Datatype Column Null Option Column Comment
Patient_oidintNOT NULL The object ID of the alert raised for the patient.
AlertIDintNOT NULL The object ID of the alert.
AlertTitlevarchar(128)NOT NULL The title of the alert as displayed on the Worklist.
AlertDescriptionvarchar(255)NOT NULL The complete description of the alert.
CreatedDateTimesmalldatetimeNOT NULL The date and time when the alert was created.
AlertPrioritysmallintNOT NULL The priority of the alert. Allowable Values: 1 - Critical, 2 - High, 3 - Medium, 4 - Low.
AlertStatussmallintNOT NULL The status of the alert. Allowable Values: 1 - AlertInActive, 2 - AlertActive, 3 - AlertCompleted, 4 - AlertRemoved, 5 - AlertInProgress.
CompletedDateTimesmalldatetimeNULL The date and time when the alert was completed or deleted from the application.
DeclineCommentsvarchar(255)NULL, The comments from the user if the user declines an alert without performing the mandatory suggested actions.
DeclinedByintNULL The object id of the user who performed the decline action.
BusObjectIDbigintNULL The business object ID of the owner or the source of the alert.
BusObjectTypevarchar(20)NOT NULL The source or the owner's code, which resulted in creating the alert. Examples: ADT, COS, WFE.
Visit_oidintNULL The object ID of the patient visit during which the alert is created.
UseCensussmallintNOT 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.
LastViewedByintNULL The object ID of the user who last viewed the alert.
LastViewedDateTimesmalldatetimeNULL The last date and time when the alert was viewed.
AutoRemovesmallintNOT NULL When set to 1, indicates that the alert can be automatically removed from the user's Worklist.
DisplayLocationchar(3)NOT NULL The location where the alert displays.
CreatedByintNOT NULL The user ID of the user whose session created the instance of the alert.
AuditCommentvarchar(500)NULL The description about the alert as entered by the user.
DupCheckSumintNULL 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.
HasMandatoriessmallintNOT NULL When set to 1, indicates the alert contains mandatory suggested actions.
AlertCategory_oidintNULL The link to the Alert Category table
AcceptedByOIDintNULL The ObjectID of the user who accepts the alert.
AcceptCommentsvarchar(255)NULL The comments from the user if the user accepts an alert.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates