Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOrderSuppInfoExt This table stores extended 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 1534. 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. Column exists as part of persistence framework implementation.
Descriptionvarchar(1)NULL Not Valued in this table. Column exists as part of persistence framework implementation.
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 is created.
FollowUpDurationintNULL Duration for which the order should be followed up to completion.
FollowUpDurationUOMvarchar(64)NULL Unit of measure of the duration for which the order should be followed up to completion.
FollowUpDurationCondnvarchar(255)NULL Valued from Dictionary Item of Type OaR.FollowUpCondition.Conditions for following up the order to completion.
FollowUpDatevarchar(64)NULL Date and time from when the order must be followed up.
RespDoseVarchar(12)NULL Respiratory dose associated with a Respiratory order.
CaloricRestrictionvarchar(64)NULL Mumber of calories patient can have each day(e.g., 1800 calories, 2000 calories). This is commonly used in ADA(diabetic diet) type diets.
CollectionMethodvarchar(64)NULL Method to collect samples. This is used across laboratory order detail forms, e.g., induced sputum, clean catch, and catheterized.
ConditionalInformationvarchar(64)NULL Valued from Dictionary Item of Type Ord.ConditionalInformation.This is used for additional information about the entire order. For example, "As Tolerated", "When patient out of bed", etc.
DietaryAmountVarchar(12)NULL Amount of tube feed ordered.
DietaryRoutevarchar(64)NULL Valued from Dictionary Item of Type Ord.DietRoute.Dietary route used for supplements and tube feeding. These types of nutrition can be delivered orally, via a nasogastric tube or a jejunostomy tube.
DietaryUnitvarchar(64)NULL Valued from Dictionary Item of Type Ord.DietaryUnit. Units in relation to the dietary amount, e.g., cans or mL.
EnteralFeedGoalRatevarchar(64)NULL Valued from Dictionary Item of Type Ord.EnteralFeedGoalRate.Rate at which the enteral feed is optimal for the patient. Patient may start at 10 mL/hour, but the ideal intake of the enteral feed is 50 mL/hour(goal rate).
EnteralFeedRunOverRatevarchar(64)NULL Valued from Dictionary Item of Type Ord.EnteralFeedRunOverRate.Runover rate of each enteral feed. This is used for bolus type feeding, at the rate of mL/hour.
EnteralFeedStartTimesmalldatetimeNULL Start feed time. This is used in conjunction with the stop feed time element when a patient receives tube feeding every day, but only for certain designated hours of the day. You could have a tube feeding order at 10mL/hour from 6am to 6pm. It is a continuous order, but only to be given during those designated hours. Note: Currently, there is no system functionality to support this processing. It is purely informational.
EnteralFeedStopTimesmalldatetimeNULL End of feed time. This is used in conjunction with the stop feed time element when a patient receives tube feeding every day, but only for certain designated hours of the day. You could have a tube feeding order at 10mL/hour from 6am to 6pm. It is a continuous order, but only to be given during those designated hours. Note: Currently, there is no system functionality to support this processing. It is purely informational.
EnteralFeedTypevarchar(64)NULL Valued from Dictionary Item of Type Ord.EnteralFeedType.Type of enteral feed being administered.
FluidRestrictionvarchar(64)NULL Valued from Dictionary Item of Type Ord.FluidRestriction.Amount of fluid a patient can consume each day(e.g., 1 liter fluid restriction).
FoodConsistencyvarchar(64)NULL Valued from Dictionary Item of Type Ord.FoodConsistency. Represents Thickness of food. This is because some patients have difficulty in chewing food as it needs to be more granular to facilitate mastication. Examples of consistency are Mechanical Soft, Pureed, etc.
LiquidConsistencyvarchar(64)NULL Valued from Dictionary Item of Type Ord.FoodConsistencyOrd.LiquidConsistency .Consistency of the fluids that a patient may drink. Some patients have swallowing difficulties, requiring that the fluids they drink need to be thickened. Examples include nectar or honeythickened liquids.
NPOExceptForvarchar(64)NULL Valued from Dictionary Item of Type Ord.NPOExceptFor. Exceptions for NPO(nothing by mouth). NPOExcept- For refers to ice chips, medications, and sips of water. For example, patient can be NPO except for sips of water.
ProteinRestrictionvarchar(64)NULL Valued from Dictionary Item of Type Ord.ProteinRestriction.Number of grams of protein a patient can have each day(e.g., 40 gram protein restriction).
SodiumRestrictionvarchar(64)NULL Valued from Dictionary Item of Type Ord.SodiumRestriction.Number of grams of sodium a patient can have each day(e.g., 2 gram sodium restriction).
StartOnEventvarchar(64)NULL Event that identifies when the order should begin. For example, Preop, Upon arrival to floor, etc. Note: Currently, there is no system functionality to support this processing. This is purely informational.
StopOnEventvarchar(64)NULL Event that identifies when the order should stop. For example, Stop upon arrival to floor, etc. Note: Currently, there is no system functionality to support this processing. This is purely informational.
TitrateOxygenvarchar(64)NULL Oxygen orders that include a titration parameter. For example, maintain SpO2 greater than 92% or maintain SpO2 greater than 89% and less than 94%.
ToBeSeenByDTimeMinssmalldatetimeNULL For referral orders, indicates by when patient should see referred-to provider.
ToBeSeenByOIDintNULL For referral orders, contains ObjectID of staff(HStaff) of referred-to provider.
ToBeSeenByNamevarchar(188)NULL For referral orders, contains name of Staff(HStaff) of referred-to provider.
ToBeSeenByContactInfovarchar(1024)NULL For referral orders, contains address and phone of referred-to provider.
OrderData01varchar(64)NULL Valued from Dictionary Item of Type Ord.Data01. User defined field which clients can use for capturing custom data of the order
OrderData02varchar(64)NULL Valued from Dictionary Item of Type Ord.Data02. User defined field which clients can use for capturing custom data of the order
OrderData03varchar(64)NULL Valued from Dictionary Item of Type Ord.Data03. User defined field which clients can use for capturing custom data of the order
OrderData04varchar(64)NULL Valued from Dictionary Item of Type Ord.Data04. User defined field which clients can use for capturing custom data of the order
OrderData05varchar(64)NULL Valued from Dictionary Item of Type Ord.Data05. User defined field which clients can use for capturing custom data of the order
OrderData06varchar(64)NULL Valued from Dictionary Item of Type Ord.Data06. User defined field which clients can use for capturing custom data of the order
OrderData07varchar(64)NULL Valued from Dictionary Item of Type Ord.Data07. User defined field which clients can use for capturing custom data of the order
OrderData08varchar(64)NULL Valued from Dictionary Item of Type Ord.Data08. User defined field which clients can use for capturing custom data of the order
OrderData09varchar(64)NULL Valued from Dictionary Item of Type Ord.Data09. User defined field which clients can use for capturing custom data of the order
OrderData10varchar(64)NULL Valued from Dictionary Item of Type Ord.Data10. User defined field which clients can use for capturing custom data of the order
CDSMNumbervarchar(255)NULL CDSM is abbreviation for Clinical Decision Support Mechanism. This is decision support number
CDSMScorevarchar(255)NULL Appropriateness score
CDSMIndicationvarchar(512)NULL The reason for exam
CDSMAcknowledgeReasonvarchar(512)NULL Reason why the recommendation not used
CDSMAcknowledgeCommentvarchar(512)NULL Users supplied comment
CDSMNamevarchar(255)NULL Name of qualified Clinical Decision Support Mechanism
CDSMCodevarchar(32)NULL Code for the Qualified Clinical Decision Support Mechanism
CDSMExceptionReasonNamevarchar(64)NULL Valued from Dictionary Item of Type Ord.ExceptionReason. Name for the Reason as to why Appropriate Use Criteria was not supplied
CDSMExceptionReasonCodevarchar(64)NULL Valued from Dictionary Item of Type Ord.ExceptionReason.HCPCS Code for the Reason as to why Appropriate Use Criteria was not supplied, Stored DDI value
CDSMAdherenceIndicationNamevarchar(64)NULL Valued from Dictionary Item of Type Ord.AdherenceIndication.Name for the appropriate user criteria adherence . Allowable Values : Yes, No, or Not Applicable for CDSMScore Interpretation
CDSMAdherenceIndicationCodevarchar(64)NULL Valued from Dictionary Item of Type Ord.AdherenceIndication.Code for Yes, No, or Not Applicable for CDSMScore interpretation
CDSMTypevarchar(64)NULL Represents how the CDSM info was added to the order: e.g manually on the ODF, by CareSelect, or Exception
CDSMOidvarchar(255)NULL Identifier of the Clinical Decision Support Mechanism
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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