Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMedOrderSuppInfoH This table stores historical data for medication order supplimentary information
Column Name Column Datatype Column Null Option Column Comment
ObjectIDINTNOT NULL Object ID for the medication order supplimentary information
InstanceHFCIDSMALLINTNOT NULL The HFC(Healthcare Foundation Class) ID of the object(1140). 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 valued
IsDeletedSMALLINTNOT NULL Indicates whether the record is soft deleted. Allowable Values: 0 - Active, 1 - Marked as Deleted
IsVersionedBITNOT 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 HMedOrderSuppInfoH_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
CreationTimeDATETIMENULL The date and time when the object is created
TitrateInstruction1VARCHAR(64)NULL First instruction of the five titrate instructions
TitrateInstruction2VARCHAR(64)NULL Second instruction of the five titrate instructions
TitrateInstruction3VARCHAR(64)NULL Third instruction of the five titrate instructions
TitrateInstruction4VARCHAR(64)NULL Fourth instruction of the five titrate instructions
TitrateInstruction5VARCHAR(64)NULL Last(fifth) instruction of the five instructions
IncreaseDoseVARCHAR(20)NULL Part of Increase by titrate instructions that stores the dose part
IncreaseDoseUnitVARCHAR(20)NULL Part of Increase by titrate instructions that stores the dose unit part
IncreaseEveryVARCHAR(10)NULL Indicates the "Every" duration part(repeat pattern)
IncreaseEveryUnitCodeVARCHAR(10)NULL Indicates the "Every" duration unit part
IncreaseForVARCHAR(10)NULL Part of Increase by titrate instructions, stores the 'For' part
IncreaseForUnitVARCHAR(10)NULL Part of Increase by titrate instructions, stores the 'For Unit' part
OtherTitrateInstructionsVARCHAR(64)NULL Free text titrate instructions representing 'Other'
MaxDoseVARCHAR(10)NULL Maximum dose of the titrate
MaxDoseUnitVARCHAR(20)NULL Part of Increase by titrate instructions, stores the 'For Unit' part
MaxDosePerDurationVARCHAR(10)NULL Maximum dose per duration
MedOrderOIDINTNOT NULL Object ID of the medication order(HMedOrder)
TargetCosigner1StaffNameVARCHAR(188)NULL Primary target cosigner for an order. The field will store the staffname with the title. Hence the length is 188
TargetCosigner2StaffNameVARCHAR(188)NULL Secondary target cosigner for an order. The field will store the staffname with title.Hence the length is 188
TargetCosigner3StaffNameVARCHAR(188)NULL Tertiary target cosigner for an order. The field will store the staffname with title.Hence the length is 188
TargetCosigner1StaffOIDINTNULL Object ID of the primary target cosigner staff(HStaff)
TargetCosigner2StaffOIDINTNULL Object ID of the secondary primary target cosigner staff(HStaff)
TargetCosigner3StaffOIDINTNULL Object ID of the tertiary target cosigner staff(HStaff)
OrderSourceModifierNameVARCHAR(64)NULL Name of the order source modifier
OrderSourceModifierOIDINTNULL Object ID of the object(such as patient, order, etc.). This field is always a primary key for the associated table
OrderSourceAbbrCHAR(4),System defined order source abbreviation to which the selected order source modifier is mapped to
Allowable values:
NULL - not valued
VERB - verbal
WRTN - written
PRTL - per-protocol
ValidFromDATETIMENULL Date and time from when current record is valid
ValidToDATETIMENULL Date and time till when current record is valid
PharmacyInstrVARCHAR(256)NULL Instructions given to pharmacy
OAWTypeCHAR(1)NOT NULL OAW(Order as Written) type. Allowable values: 'S' - Standard, 'A' - Advanced, 'C' - Complex. Default - 'S'
HasVaccineCHAR(1)NULL Indicates if Order has a vaccine component. Allowable Values: Y - Order has a Vaccine component, N - Order does NOT have a vaccine component, NULL or empty string - NOT Known
ChangeNoSMALLINTNULL Number of times the order has changed. Used to properly sequence the history information
IndicationCodeVARCHAR(18)NULL Medication indication code
IndicationDescriptionVARCHAR(80)NULL Medication Indication description
CodeSystemVARCHAR(8)NULL Code system that defines the indication
IndicationRequiredCodeTINYINTNULL Mandatory-ness setting for Indication. Allowable value: 0/NULL - NOT Available, 1 - Optional, 2 - Mandatory

Return to Table-Index

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