Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | INT | NOT NULL | The object ID for the med alert |
InstanceHFCID | SMALLINT | NOT NULL | The HFC(Healthcare Foundation Class) ID of the object(1137). Note: The value specified in the ObjectID field and in this field enables unique indentification of an object across the application |
RecordId | INT | NULL | The record ID. Not valued in this table. Column exists as part of persistence framework implementation |
Description | VARCHAR(1) | NULL | User-defined information provided by the modules in the application. Note: The length of this field varies with tables. Not valued |
IsDeleted | TINYINT | NOT NULL | Indicates whether the record is soft deleted. Allowable Values: 0 - Active, 1 - Marked as Deleted |
IsVersioned | TINYINT | NOT NULL | Indicates whether the record was modified through persistent layer after its initial creation. Once this field is set to True, you cannot reset it to False. If this field is set to True in a table, another table with the name HMedAlerts_Ver is created. Allowable Values: 0 - False, 1 - True |
CreatedUserId | INT | NULL | The Object ID of the user who created the object. This field is linked to HSUser table to get details about the user. |
CreationTime | SMALLDATETIME | NULL | The date and time when the object was created |
ValidFrom | DATETIME | NOT NULL | The Date/Time from when the current record became valid |
ValidTo | DATETIME | NULL | The Date/Time until the current record is invalid |
AlertTitle | VARCHAR(32) | NOT NULL | The alert title. The alert title is a short message displayed to the user on Current Order Session(COS) describing the check conflict. |
AlertDescription | VARCHAR(1024) | NOT NULL | The complete alert message describing the check conflict |
AlertType | TINYINT | NULL | The alert type |
| | | Allowable values: |
| | | 0 - medAlertDrugAllergy |
| | | 1 - medAlertDrugDrugInteraction |
| | | 2 - medAlertDrugDose |
| | | 3 - medAlertDuplicateTherapy |
| | | 4 - medAlertGenericDuplicate |
| | | 5 - medAlertMustReview |
| | | 6 - medAlertMissingMandatoryFields |
| | | 7 - medAlertMissingTargetCosigner |
| | | 8 - medAlertUnscreenedDrugs |
| | | 9 - medAlertUnscreenedAllergies |
| | | 19 to 23 - Precautions and Drug Food Allergies |
| | | 26 - Auto Profile alerts |
AlertStatus | TINYINT | NULL | The alert status |
| | | Allowable values: |
| | | 0 - Undefined |
| | | 1 - ResolutionPresented |
| | | 2 - ResolutionInProgress |
| | | 3 - Complete |
Patient_oid | INT | NOT NULL | Object ID for the Patient(HPatient) |
AlertCreatedTime | SMALLDATETIME | NOT NULL | The date and time when the conflict was generated by the application |
PatientVisit_oid | INT | NULL | Object ID for the Patient's Visit(HPatientVisit) |
SourceInternalID | INT | NULL | Source internal ID(HOrder.ObjectID) for the primary order that resulted in the error |
OverrideComments | VARCHAR(255) | NULL | Comments entered by a user when he tries to override existing comments |
AlertCreatedBy_oid | INT | NOT NULL | Object ID of the user who created the alert(HSUser) |
LastCngDtime | DATETIME | NULL | The current Universal Time Coordinate or Greenwich Mean Time |
AlertContext | VARCHAR(16) | NULL | Indicates where the alert came from |
| | | In case of Retrospective Allergy Checking the allowable values in this field are: |
| | | "ClinDoc-AlgAdd", "ClinDoc-AlgRec", "ClinDoc-AlgAdd-P" and "ClinDoc-AlgRec-P" |
ChangeNo | SMALLINT | NULL | The number of times the order has changed. Used to properly sequence the history information |
|