Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMedOrderComponentDosageH This table stores historical data representing component dosage for a medication
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(1134). 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 HMedOrderComponentDosageH_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 when the current record became valid
ValidToDATETIMENULL The Date/Time until the current record is valid
DosageDateTimeDATETIMENULL The date and time of administering the medication to the patient.
DosageTypeTINYINTNOT NULL The type of dosage. Different order types have different kinds and numbers of dosages for every administration
Allowable Values:
0 - medodtSliding
1 - medodtDiffer
2 - medodtExtra
3 - medodtSimple
DoseVARCHAR(47)NULL The dose of medication. For example 250 mg of erythromycin.
DoseUnitStringVARCHAR(30)NULL Tthe unit of the dose of medication. An example is "mg" in 250 mg of erythromycin.
MedOrderComponent_oidINTNOT NULL Object ID of the medication order component(HMedOrderComponent)
Patient_oidINTNOT NULL Object ID for the Patient(HPatient)
RangeFromVARCHAR(9)NULL Minimum value in the sliding scale
RangeToVARCHAR(9)NULL Maximum value in the sliding scale
DispensingDoseVARCHAR(20)NULL The dose of medication to be dispensed.
DispensingDoseUnitStringVARCHAR(30)NULL The unit of the dose of medication to be dispensed
DoseUnitCodeVARCHAR(20)NULL The code associated with the unit of the dose
DispensingDoseUnitCodeVARCHAR(20)NULL The code associated with the unit of the dose of medication to be dispensed
SequenceNoINTNOT NULL Unique sequence number assigned to the complex medical dosage
DoseConcentrationVARCHAR(60)NULL The dose concentration.
ChangeNoSMALLINTNULL The number of times the order has changed. Used to properly sequence the history information
OriginalDoseVARCHAR(47)NULL The original dose
OriginalDoseUnitCodeVARCHAR(20)NULL The original dose unit code
OriginalDoseUnitStringVARCHAR(30)NULL The original dose unit string
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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