Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOrderSuppInfo This table stores supplementary(Additional) information about an Order.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object Identifier of this record. This field is a primary key for the associated table.
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1509. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application.
RecordIdintNULL Not valued in this table.
Descriptionvarchar(1)NULL Not valued in this table.
IsVersionedbitNOT NULL When set to True, the object was modified. Once this field is set to True, you cannot reset it to False. Allowable Values: 0 - False, 1 - True. Note: The presence of this field in tables depends on the configuration at the time of table design.
CreatedUserIdintNULL Object ID of the logged in user who created this record.
This field is linked to HSUser table to get details about the user. For more information see description of HSUser table.
CreationTimesmalldatetimeNULL Date and time when the record was created.
CopiesTovarchar(256)NULL This field captures a ";" separated list of StaffNames & HCU's as entered by the user in Order Detail Form. Reports print this to specify where(person or unit) the order information was copied to.
OrderingDevicevarchar(20)NULL The device/workstation from where the order was placed.
ResearchProgramvarchar(64)NULL Clients can tag the orders with some Research programs and use it to fetch these orders for their research.
Conditionvarchar(64)NULL Client-defined value for recording a medical condition with the order. Eg. Peripherally Inserted Central Catheter, Blood Glucose greater than 200 less than 60, etc.
CommentingLevelvarchar(32)NULL Client-defined value for comments.
SpecificViewvarchar(32)NULL Client-defined value for radiology views.
TransportMethodsvarchar(32)NULL The client-defined transport method. Ex. Walk, wheelchair.
VerbalOrderIndicatorbitNULL DEPRICATED : Boolean flag indicating whether the order is verbal. One should use field OrderSourceAbbr=='VERB' to evaluate if order is verbal or not.
GuideLinesvarchar(255)NULL Descriptive text specifying guidelines to execute the order.
ClinicalInformationvarchar(64)NULL Free text value specifying some clinical information.
ReasonForRequestvarchar(64)NULL The reason for requesting the order.
Instructionvarchar(255)NULL Special instructions to be followed before, after or during execution of the placed order.
IsolationFlagbitNULL Flag indicating whether isolation precautions should be taken or not. Allowable Values: 0 - No, 1 - Yes
TransArrRespvarchar(64)NULL Client-defined value for describing the entity/person responsible for arranging the transport for the service ordered.
ProblemNamevarchar(200)NULL Free text name of the problem for which the order got placed.
ConsultNoOfVisitsValuestinyintNULL Client-defined value for recording number of consult visits.
ConsultRequestValuesvarchar(32)NULL Client-defined value for recording the consult request. Eg. Evaluate Patient , Routine Check, etc.
ConsultHistoryvarchar(120)NULL Free text value which documents the history of consultations.
ReasonForDiscontinuevarchar(120)NULL The reason the order was discontinued.
ReasonForDupOverridevarchar(64)NULL Free text value which documents the reason to override a duplicate order alert.
PerformedLocationvarchar(10)NULL Free text value which documents the location where the order was performed.
TransportMethodCodetinyintNULL User defined code for Transport method.
DietModifier1varchar(1000)NULL Client-defined value for recording the diet modifiers on a diet order. These can contain multiple values which are separated by the unicode character 0X01E
Eg. Low Sodium, No Hot Beverages, No Breakfast Eggs, etc.(instead of a comma ',' it will be the Unicode character).
DietModifier2varchar(1000)NULL Client-defined value for recording the diet modifiers on a diet order. These can contain multiple values which are separated by the unicode character 0X01E
Eg. Low Sodium, No Hot Beverages, No Breakfast Eggs, etc.(instead of a comma ',' it will be the Unicode character).
DietModifier3varchar(1000)NULL Client-defined value for recording the diet modifiers on a diet order. These can contain multiple values which are separated by the unicode character 0X01E
Eg. Low Sodium, No Hot Beverages, No Breakfast Eggs, etc.(instead of a comma ',' it will be the Unicode character).
RespiratoryRatevarchar(8)NULL Documents respiratory rate on a respiratory order.
PercentageOfOxygenvarchar(8)NULL Documents percentage of oxygen required for a respiratory order.
PEEPvarchar(8)NULL Positive End-Expiratory Pressure(PEEP) is mechanical ventilator parameter set for a respiratory order.
VolumeTotalvarchar(8)NULL Client-defined value indicating lung capacity setting for respiratory equipment.
Medicationvarchar(64)NULL The supplemental medication information on a non-med order.
Dosevarchar(30)NULL The dose for the supplemental medication.
Diluentvarchar(64)NULL Any Diluent or solution used for the supplemental medication.
Modevarchar(32)NULL The Mode/Route for the supplemental medication.
PIPvarchar(8)NULL Peak inspiratory pressure(PIP) is mechanical ventilator parameter set for a respiratory order.
InspiratoryTimevarchar(15)NULL Inspiratory Time is the mechanical ventilator parameter set for a respiratory order.
Devicevarchar(32)NULL Device used for the respiratory order.
PrimaryCDMvarchar(32)NULL Primary Charge Description Master Code(CDM).
SecondaryCDMvarchar(32)NULL Secondary Charge Description Master Code(CDM).
LPMvarchar(8)NULL Liters of air per minute(LPM). It is a measurement of the velocity at which air flows into the sample probe. Valued for respiratory orders.
PressureSupportvarchar(15)NULL When the patient takes a breath and the ventilator then adds pressure to that breath to make it easier for the patient to achieve a good tidal volume. This added pressure is captured in this field.
AttendingPhysicianvarchar(188)NULL Name of the Staff(HStaff) who is the attending physician for the visit on which the order was placed.
AdmittingPhysicianvarchar(188)NULL Name of the Staff(HStaff) who is the admitting physician for the visit on which the order was placed.
ReasonForRevisionvarchar(120)NULL Free text reason for the revision of the order.
DoseUOMvarchar(16)NULL Unit of Measure for the Dose value.
OrderSourceModifierNamevarchar(64)NULL Name of the Order Source Modifier with which the order was placed.
SampleToBeCollByStaffOIDintNULL Object ID of the Staff(HStaff) planned to collect the sample.
SampleToBeCollByStaffvarchar(188)NULL Name of the Staff(HStaff) planned to collect the sample.
TargetCosigner1StaffNamevarchar(188)NULL Name of the Staff(HStaff) planned to cosign the order.
TargetCosigner2StaffNamevarchar(188)NULL Name of the Staff(HStaff) planned to cosign the order.
TargetCosigner3StaffNamevarchar(188)NULL Name of the Staff(HStaff) planned to cosign the order.
TargetCosigner1StaffOIDIntNULL Object ID of the Staff(HStaff) planned to cosign the order.
TargetCosigner2StaffOIDIntNULL Object ID of the Staff(HStaff) planned to cosign the order.
TargetCosigner3StaffOIDIntNULL Object ID of the Staff(HStaff) planned to cosign the order.
OrderSourceModifierOIDIntNULL Object ID for the Order Source Modifier(HOrderSourceModifier)
OrderSourceAbbrchar(4)NULL Abbreviation of the base order source.
Allowable Values:
VERB - Verbal
WRTN - Written
PRTL - Per Protocol
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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