SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 

RepFlags 
Definition  Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. 

Build 
Definition  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 

TouchedBy 
Definition  Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

TouchedWhen 
Definition  The date and time that the row was last updated and will be based on the Enterprise time zone. 

CreatedBy 
Definition  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

CreatedWhen 
Definition  The date and time that the row was created and will be based on the Enterprise time zone. 

Active 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

GUID 
Definition  Unique primary key value. 

OrderGUID 
Definition  Primary key 

IsTemplate 
Definition  Indicate whether the order is an order template. 

ComplexOrderType 
Definition  Indicates the order type for the child order 2 – Sequential Complex Dose Child Order;4 – Concurrent Complex Dose Child Order;6 – Multiple Frequencies Child Order 

SequenceNumber 
Definition  Indicate the sequence that the orders will be created. 

DosageLow 
Definition  Store the dosage low 

DosageHigh 
Definition  Store the dosage high 

Uom 
Definition  Store the uom. 

OrderRouteCode 
Definition  Store the order route code 

OrderRouteModifierCode 
Definition  Store the order route modifier code 

FrequencyCode 
Definition  Store the frequency code 

FreqFromTime 
Definition  Store the frequency from time value if frequency is selected. 

FreqToTime 
Definition  Store the frequency to time value if frequency is selected. 

FreqUom 
Definition  Store the frequency uom if frequency is selected. 

FreqEventModifierType 
Definition  Store the event modifier for event based frequency code 

FreqEventCode 
Definition  Store the event code for event based frequency code 

StopAfterValue 
Definition  Store the duration value 

StopAfterOptionType 
Definition  Store the duration uom 1 – Days;2 – Hours; 3 – Minutes; 4 – Times 

RequestedDate 
Definition  Store the requested date of the child order 

RequestedTime 
Definition  Store the requested time for time critical child order 

ReqCodedTime 
Definition  Store the coded requested time for time critical order 

ReqTimeValue 
Definition  Store the time value for requested time of event based type 

ReqTimeUom 
Definition  Store the uom of the time value for requested time of event based type. 

ReqTimeEventModifierType 
Definition  Store the event modifier for requested time of event based type 

ReqTimeEventCode 
Definition  Store the event time code for requested time of event based type 

StopDate 
Definition  Store the stop date of the child order 

StopTime 
Definition  Store the stop time of the child order 

EstimatedStopDtm 
Definition  Estimate stop date/time of the child order. This should be calculated and updated when the estimated stop date/time is calculated for the master order. This field is mainly used by CDS. 

CalcDoseMethod 
Definition  Indicate the method used for calculated dose 0 – Per dose; 1 – Daily Dose 

CalcRequestedDose 
Definition  Store the requested calculated dose 

CalcUOMPer 
Definition  Store the uom per requested dose. 

CalcActualDose 
Definition  Store the actual dose used for the calculated dose 

CalcOverrideReason 
Definition  Store the override dose reason 

CalcTotalDailyDose 
Definition  Store the total daily dose 

CalcInfo 
Definition  Store the calculated dose information 

IsPRN 
Definition  Indicate whether the order instance should be a PRN order 

PRNReasonText 
Definition  For PRN order instance, store the PRN reason. 

ChildOrderGUID 
Definition  Store the Order GUID for child order created from this component. 

EstimatedRequestedDtm 
Definition  Estimate requested date/time of the child order. This should be calculated and updated when the estimated stop date/time is calculated for the master order. This field is mainly used by CDS. 

DataItemCode1 
Definition  Stores the first data item code returned from call MLM 

DataItemValue1 
Definition  Stores the value returned for DataItemCode1 from call MLM 

DataItemCode2 
Definition  Stores the second data item code returned from call MLM 

DataItemValue2 
Definition  Stores the value returned for DataItemCode2 from call MLM 

DataItemCode3 
Definition  Stores the third data item code returned from call MLM 

DataItemValue3 
Definition  Stores the value returned for DataItemCode3 from call MLM 

DataItemCode4 
Definition  Stores the fourth data item code returned from call MLM 

DataItemValue4 
Definition  Stores the value returned for DataItemCode4 from call MLM 

DataItemCode5 
Definition  Stores the fifth data item code returned from call MLM 

DataItemValue5 
Definition  Stores the value returned for DataItemCode5 from call MLM 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.