Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMedAlerts This table stores data related to medical alerts raised due to medication interactions
Column Name Column Datatype Column Null Option Column Comment
ObjectIDINTNOT NULL The object ID for the med alert
InstanceHFCIDSMALLINTNOT 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
RecordIdINTNULL The record ID. Not valued in this table. Column exists as part of persistence framework implementation
DescriptionVARCHAR(1)NULL User-defined information provided by the modules in the application. Note: The length of this field varies with tables. Not valued
IsDeletedTINYINTNOT NULL Indicates whether the record is soft deleted. Allowable Values: 0 - Active, 1 - Marked as Deleted
IsVersionedTINYINTNOT 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
CreatedUserIdINTNULL The Object ID of the user who created the object. This field is linked to HSUser table to get details about the user.
CreationTimeSMALLDATETIMENULL The date and time when the object was created
ValidFromDATETIMENOT NULL The Date/Time from when the current record became valid
ValidToDATETIMENULL The Date/Time until the current record is invalid
AlertTitleVARCHAR(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.
AlertDescriptionVARCHAR(1024)NOT NULL The complete alert message describing the check conflict
AlertTypeTINYINTNULL 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
AlertStatusTINYINTNULL The alert status
Allowable values:
0 - Undefined
1 - ResolutionPresented
2 - ResolutionInProgress
3 - Complete
Patient_oidINTNOT NULL Object ID for the Patient(HPatient)
AlertCreatedTimeSMALLDATETIMENOT NULL The date and time when the conflict was generated by the application
PatientVisit_oidINTNULL Object ID for the Patient's Visit(HPatientVisit)
SourceInternalIDINTNULL Source internal ID(HOrder.ObjectID) for the primary order that resulted in the error
OverrideCommentsVARCHAR(255)NULL Comments entered by a user when he tries to override existing comments
AlertCreatedBy_oidINTNOT NULL Object ID of the user who created the alert(HSUser)
LastCngDtimeDATETIMENULL The current Universal Time Coordinate or Greenwich Mean Time
AlertContextVARCHAR(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"
ChangeNoSMALLINTNULL The number of times the order has changed. Used to properly sequence the history information

Return to Table-Index

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