SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. 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. 

OrderOptionComponentID 
Definition  Auto generated unique primary key value. 

OrderOptionID 
Definition  A foreign key to the OrderOptionID column in the SXAMMOrderOption table. 

GenericItemID 
Definition  A foreign key to the GenericItemID column in the SXAMMGenericItem table. 

MaxDoseNum 
Definition  Identifies the Maximum Dose that is to be administered (only used for PRN Orders). 

DoseNum 
Definition  Identifies the Dose that is to be administered for this Component. 

DoseUOMCode 
Definition  Identifies the Unit of Measure associated with the Dose. Links to the CV3 Unit of Measure table. 

IsDAW 
Definition  Identifies if the Order Component should be dispensed as written. 

DAWProductID 
Definition  A foreign key to the ProductID column in the SXAMMProduct table. 

IsPrimary 
Definition  Identifies if the Component is the Primary Component. 

IsSolution 
Definition  Identifies if the Component is a Solution. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

DispenseInCartDaily 
Definition  Identifies if this order should be dispensed in the cart daily. 

EnteredDoseNum 
Definition  Dose entered (before conversion from /kg etc) 

EnteredDoseUOMCode 
Definition  Unit of measure for entered dose 

WeightSurfaceAreaDoseType 
Definition  An enumerated type with the following list of possible values: 0 = [kg],1 = [kg (ideal)],2 = [kg (adjusted)],3 = [m2],4 = [m2 (ideal)],5 = [m2 (adjusted)],6 = [Flat Dose],7 = [AUC (Cockcroft-Gault adjusted)],8 = [AUC (Cockcroft-Gault ideal)],9 = [AUC (Cockcroft-Gault)],10 = [AUC (Jelliffe adjusted)],11 = [AUC (Jelliffe ideal)],12 = [AUC (Jelliffe no BSA)],13 = [AUC (Jelliffe)],14 = [AUC (measured CrCl)],15 = [AUC (St. Jude's modified-Peds)], 

TimeDoseType 
Definition  An enumerated type with the following list of possible values: 0 = [hr],1 = [min], 

EnteredMaxDoseNum 
Definition  Entered maximum dose (before converting from /kg etc) 

FreeTextDrugName 
Definition  If Order.isFreeText = TRUE contains drug name 

DoseSummary 
Definition  Calculated dose summary field 

OrderComponentGUID 
Definition  Identifies the CV3 Order Component GUID. This is used to 'link' a CV3 order component to an mm order option component. This attribute will only be filled in for CV3 orders that are considered IV orders. 

OrderCatalogMasterItemGUID 
Definition  Identifies the OCMI that this Order Option Component maps to. 

IsNonFormulary 
Definition  This field will be used to indicate if the order component placed was non-formulary 

IsFreeText 
Definition  This field will be used to indicate if the order component placed was free-text 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

DoseSummaryForLabels 
Definition  Dose summary text to be used for labels