Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMedOrderComponent This table stores the medication order component data
Column Name Column Datatype Column Null Option Column Comment
ObjectIDINTNOT NULL The object ID for the medication order component
InstanceHFCIDSMALLINTNOT NULL The HFC(Healthcare Foundation Class) ID of the object(1133). 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 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 HMedOrderComponent_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. For more information on HSUser table
CreationTimeSMALLDATETIMENULL The date and time when the object is created
ValidFromDATETIMENOT NULL The Date/Time from which the medication prescribed to the patient is valid
ValidToDATETIMENULL The Date/Time when the medication prescribed to the patient is no longer valid
StartDateTimeDATETIMENOT NULL The date and time from when the order component is valid
ResultToCollectVARCHAR(64)NULL Result that should be measured. It indicates a name that describes the vital sign on which the medication strength should be based. For example, BloodSugar
CalculatedStopDateTimeDATETIMENOT NULL The date and time when the order component is no longer valid. Calculated based on system preferences
DurationINTNULL Duration for which the drug component is valid.
NotifyPhysicianVARCHAR(75)NULL Actions required to be taken by the physician if a measured value of medication exceeds the specified value. For example: Contact MD if BloodSugar <70 or >350
PrimaryComponentTINYINTNOT NULL When set to 1, indicates that the medication is a primary component. A single primary component is allowed per medication. Allowable Values: 0/1
GenericDrugNameVARCHAR(95)NOT NULL Indicates the alternate name assigned to the drug
OfficialDrugCodeVARCHAR(32)NULL The nationally(or regionally) recognized drug identifier for a dispensable packaged drug
DrugCodeVARCHAR(32)NOT NULL Code assigned to the medication
DrugLevelTINYINTNOT NULL Level of description for the medication
Allowable Values:
0 - medDrugBrand
1 - medDrugRoute
2 - medDrugForm
3 - medDrugStrength
4 - medDrugPackage
5 - medDrugNDC
RouteCodeVARCHAR(15)NULL Code associated with the route, the method of taking or administering the medication
FrequencyStringVARCHAR(40)NOT NULL Frequency of taking or administering the medication. This is populated from the Name field in HRecurrenceTemplate
DrugCatalogIDINTNOT NULL Object ID of the catalog that contains information about the medication
MedOrder_oidINTNOT NULL Object ID of HMedOrder stored as a result of many-to-one relationship between HMedOrderComponent and HMedOrder
Frequency_oidINTNOT NULL Object ID of HRecurrenceInstance stored as a result of a one-to-one relationship between HMedDispOrderComponent and HRecurrenceInstance
Patient_oidINTNOT NULL Object ID for the Patient(HPatient)
DrugService_oidINTNOT NULL Object ID of HMedDrugService stored as a result of one-to-one relationship between HMedOrderComponent and HMedDrugService
DurationUnitStringVARCHAR(20)NULL Unit of the duration for which the component is valid. For example, days, doses
DrugStrengthVARCHAR(15)NULL Strength of the drug. If the strength of a drug is high, it indicates that the drug has higher capability. As an example, Bob takes 250 mg erythromycin four times a day to cure his throat infection. If Bob's doctor increases the drug strength to 500 mg, he will then take it only twice a day
DrugStrengthUnitStringVARCHAR(20)NULL Unit of the strength of the drug. For example, mg(milligrams)
DoseFormVARCHAR(32)NULL Administration form of the medication. For example, Tabl(tablet), syrup, etc
DrugTypeTINYINTNOT NULL Type of medication
Allowable Values:
0 - meddtMed
1 - meddtSolution
2 - meddtAdditive
3 - meddtMedAdditive
4 - MeddtPremix
5 - meddtundef
DurationUnitCodeINTNULL Code associated with the unit of the duration for which the component is valid
DrugStrengthUnitCodeVARCHAR(20)NULL Code associated with the unit of the strength of the drug
RouteStringVARCHAR(32)NULL The manner in which the medication should be taken. For example, oral. This string can be a user-defined value if the user has different names than first databank.
TheraputicCodeVARCHAR(8)NULL Classification system of how the medication is used. ATC codes used in a European environment. May contain FDB's Hierarchical Specific Therapeutic Class Code(HIC3) defined in HATCMaster
DrugClassVARCHAR(2)NULL Classification that determines how narcotic the medication is
BrandDrugNameVARCHAR(95)NULL Brand name of the medication as displayed to the user. For example, Aspirin Oral Tab 325 mg
SequenceNoINTNOT NULL Unique sequence number assigned to the drug component used to prescribe medication. When a medication order which has multiple components, this field is used to sequence them during display
OrderSubTypeAbbrVARCHAR(30)NULL Abbreviation of order sub type
SubRouteStringVARCHAR(32)NULL Sub route string
SubRouteCodeVARCHAR(15)NULL Sub route code
DrugVolumeVARCHAR(6)NULL Drug volume
DrugVolumeUnitVARCHAR(12)NULL Unit of the drug volume
DrugVolumeUnitCodeVARCHAR(16)NULL Code of the drug volume unit
DefaultUnitCHAR(1)NULL Default unit for medication
ChangeNoSMALLINTNULL Indicates the number of times the order has changed. Used to properly sequence the history information
UserEnteredDoseVARCHAR(47)NULL Stores user entered dose value in case of short notation differ dose
UserEnteredDoseUnitStringVARCHAR(30)NULL User entered dose unit string value in case of short notation differ dose
UserEnteredDoseUnitCodeVARCHAR(20)NULL Dose unit code for user entered dose unit value in case of short notation differ dose
GenericOrBrandNameTINYINTNULL Primary drug name indicator, 1 or null for generic, 0 for brand
IndicationRequiredCodeTINYINTNULL Mandatory-ness setting for Indication. Allowable values: 0/NULL - Not Available, 1 - Optional, 2 - Mandatory
ATCCodeUSVARCHAR(8)NULL Indicate drug's Anatomical Therapeutic Chemical(ATC) Classification code, as developed by the World Health Organization(WHO). This column is only used in a US environment
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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