Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMedScreenInfo This table stores displayed information in relation with alert and resolution action. Stores the interaction between drugs.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDINTNOT NULL The object ID of the object(such as patient, order, etc.). This field is always a primary key for the associated table.
InstanceHFCIDSMALLINTNOT NULL The HFC(Healthcare Foundation Class) ID of the object(1139). 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. Modules in the application can use this field to group all objects having something in common and then assign the same RecordId to all the objects. For example, all related information for a patient, such as patient address, patient visits, patient name, etc., can be assigned the same RecordId. The modules can then query on this RecordId to retrieve the related information for that patient.
DescriptionVARCHAR(1)NULL User-defined information provided by the modules in the application. Note: The length of this field varies with tables. Not used.
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 it's 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 HMedScreenInfo_Ver is created
CreatedUserIdINTNULL The Object ID of the user who created the object. This field is linked to HSUser table to get details about the user. For more information on HSUser table
CreationTimeSMALLDATETIMENULL The date and time when the object is created
ValidFromDATETIMENULL The Date/Time from when the medication is valid
ValidToDATETIMENULL The Date/Time till when the medication is valid
SourceInternalIDINTNOT NULL The source order identifier that triggered the alert
SourceComponentIDINTNOT NULL The source component identifier that triggered the alert
RelatedInternalIDINTNOT NULL The affected order identifier
RelatedComponentIDINTNOT NULL The identifier of the affected component
RelatedComponentTypeINTNOT NULL Affected component type. Allowable Values: 0 - HMedDispOrderComponent 1 - HmedOrderComponent
SourceDrugCodeVARCHAR(32)NULL The identifier for the source drug
RelatedDrugCodeVARCHAR(32)NULL The identifier for the affected/related drug
SourceDrugNameVARCHAR(95)NULL Name of the source drug
RelatedDrugNameVARCHAR(95)NULL Name of the affected drug
SourceDrugLevelINTNULL Level of classification of the source Drug or DrugCode
RelatedDrugLevelINTNULL Level of classification of the affected Drug or DrugCode
ScreenDescriptionVARCHAR(512)NULL Message describing the interaction between drugs in Source and Related order.
MedResolutionAction_oidINTNOT NULL Object ID of the stored resolution action(HMedResolutionAction)
MedAlert_oidINTNOT NULL Object ID of the stored medication alert(HMedAlerts)
ChangeNoSMALLINTNULL The number of times the order has changed. Used to properly sequence the history information
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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