Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object Identifier of this record. This field is a primary key for the associated table. |
InstanceHFCID | smallint | NOT 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. |
RecordId | int | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
Description | varchar(1) | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
IsVersioned | bit | NOT 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. |
CreatedUserId | int | NULL | 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 |
CreationTime | smalldatetime | NULL | Date and time when the record is created. |
FollowUpDuration | int | NULL | Duration for which the order should be followed up to completion. |
FollowUpDurationUOM | varchar(64) | NULL | Unit of measure of the duration for which the order should be followed up to completion. |
FollowUpDurationCondn | varchar(255) | NULL | Valued from Dictionary Item of Type OaR.FollowUpCondition.Conditions for following up the order to completion. |
FollowUpDate | varchar(64) | NULL | Date and time from when the order must be followed up. |
RespDose | Varchar(12) | NULL | Respiratory dose associated with a Respiratory order. |
CaloricRestriction | varchar(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. |
CollectionMethod | varchar(64) | NULL | Method to collect samples. This is used across laboratory order detail forms, e.g., induced sputum, clean catch, and catheterized. |
ConditionalInformation | varchar(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. |
DietaryAmount | Varchar(12) | NULL | Amount of tube feed ordered. |
DietaryRoute | varchar(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. |
DietaryUnit | varchar(64) | NULL | Valued from Dictionary Item of Type Ord.DietaryUnit. Units in relation to the dietary amount, e.g., cans or mL. |
EnteralFeedGoalRate | varchar(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). |
EnteralFeedRunOverRate | varchar(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. |
EnteralFeedStartTime | smalldatetime | NULL | 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. |
EnteralFeedStopTime | smalldatetime | NULL | 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. |
EnteralFeedType | varchar(64) | NULL | Valued from Dictionary Item of Type Ord.EnteralFeedType.Type of enteral feed being administered. |
FluidRestriction | varchar(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). |
FoodConsistency | varchar(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. |
LiquidConsistency | varchar(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. |
NPOExceptFor | varchar(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. |
ProteinRestriction | varchar(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). |
SodiumRestriction | varchar(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). |
StartOnEvent | varchar(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. |
StopOnEvent | varchar(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. |
TitrateOxygen | varchar(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%. |
ToBeSeenByDTimeMins | smalldatetime | NULL | For referral orders, indicates by when patient should see referred-to provider. |
ToBeSeenByOID | int | NULL | For referral orders, contains ObjectID of staff(HStaff) of referred-to provider. |
ToBeSeenByName | varchar(188) | NULL | For referral orders, contains name of Staff(HStaff) of referred-to provider. |
ToBeSeenByContactInfo | varchar(1024) | NULL | For referral orders, contains address and phone of referred-to provider. |
OrderData01 | varchar(64) | NULL | Valued from Dictionary Item of Type Ord.Data01. User defined field which clients can use for capturing custom data of the order |
OrderData02 | varchar(64) | NULL | Valued from Dictionary Item of Type Ord.Data02. User defined field which clients can use for capturing custom data of the order |
OrderData03 | varchar(64) | NULL | Valued from Dictionary Item of Type Ord.Data03. User defined field which clients can use for capturing custom data of the order |
OrderData04 | varchar(64) | NULL | Valued from Dictionary Item of Type Ord.Data04. User defined field which clients can use for capturing custom data of the order |
OrderData05 | varchar(64) | NULL | Valued from Dictionary Item of Type Ord.Data05. User defined field which clients can use for capturing custom data of the order |
OrderData06 | varchar(64) | NULL | Valued from Dictionary Item of Type Ord.Data06. User defined field which clients can use for capturing custom data of the order |
OrderData07 | varchar(64) | NULL | Valued from Dictionary Item of Type Ord.Data07. User defined field which clients can use for capturing custom data of the order |
OrderData08 | varchar(64) | NULL | Valued from Dictionary Item of Type Ord.Data08. User defined field which clients can use for capturing custom data of the order |
OrderData09 | varchar(64) | NULL | Valued from Dictionary Item of Type Ord.Data09. User defined field which clients can use for capturing custom data of the order |
OrderData10 | varchar(64) | NULL | Valued from Dictionary Item of Type Ord.Data10. User defined field which clients can use for capturing custom data of the order |
CDSMNumber | varchar(255) | NULL | CDSM is abbreviation for Clinical Decision Support Mechanism. This is decision support number |
CDSMScore | varchar(255) | NULL | Appropriateness score |
CDSMIndication | varchar(512) | NULL | The reason for exam |
CDSMAcknowledgeReason | varchar(512) | NULL | Reason why the recommendation not used |
CDSMAcknowledgeComment | varchar(512) | NULL | Users supplied comment |
CDSMName | varchar(255) | NULL | Name of qualified Clinical Decision Support Mechanism |
CDSMCode | varchar(32) | NULL | Code for the Qualified Clinical Decision Support Mechanism |
CDSMExceptionReasonName | varchar(64) | NULL | Valued from Dictionary Item of Type Ord.ExceptionReason. Name for the Reason as to why Appropriate Use Criteria was not supplied |
CDSMExceptionReasonCode | varchar(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 |
CDSMAdherenceIndicationName | varchar(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 |
CDSMAdherenceIndicationCode | varchar(64) | NULL | Valued from Dictionary Item of Type Ord.AdherenceIndication.Code for Yes, No, or Not Applicable for CDSMScore interpretation |
CDSMType | varchar(64) | NULL | Represents how the CDSM info was added to the order: e.g manually on the ODF, by CareSelect, or Exception |
CDSMOid | varchar(255) | NULL | Identifier of the Clinical Decision Support Mechanism |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|