dbo.SXAMMOrderOption 
Default Table Name  SXAMMOrderOption 
Definition  This entity contains each administration option available for the Order. For example; an order written with a route of IM/IV would have two order options, one for the IM and another for the IV route. Each Order Option would then have it's own components. 

dbo.SXAMMOrderOption Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SiteID    smallint  NO  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 
Build    int  NO  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    varchar(50)  NO  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    datetime  NO  The date and time that the row was last updated and will be based on the Enterprise time zone. 
CreatedBy    varchar(50)  NO  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    datetime  NO  The date and time that the row was created and will be based on the Enterprise time zone. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
OrderOptionID(PK)    bigint  NO  Auto generated unique primary key value. 
OrderID(FK)    bigint  NO  A foreign key to the OrderID column in the SXAMMOrder table. 
TotalDoseNum    numeric(14, 4)  NO  Identifies the total dose that is to be administered for the Order Option (Route). 
TotalDoseUOMCode    varchar(30)  NO  Identifies the Unit of Measure associated with the Total Dose. Links to the CV3 Unit of Measure table. 
RouteCode    varchar(30)  YES  Identifies the Route of the order. ie Oral. Links to the CV3 Route table. 
RouteModifierCode    varchar(30)  YES  Identifies the Route Modifier. ie Chewed Crushed etc. Links to the CV3 Order Route Modifier table. 
MedicationFormCode    varchar(30)  YES  Identifies the Dose Form for the Order Option ie. Tablet Capsule etc.. Links to the CV3 Med Form table. 
BodySiteCode    varchar(30)  YES  Identifies the Body Site for the Order Option. ie. Left Arm, Right Foot etc.. Links to the CV3BodySite table. 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
FillingLabelDataID    bigint  YES  Identifies the Filling Label records that were generated by the Cart Fill process 
DispensingContainerID(FK)    int  YES  A foreign key to the DispensingContainerID column in the SXAMMDispensingContainer table. 
LineTypeID    int  YES  Identifies the Preferred Line Type for this Order 
UseFloorstock    bit  NO  Identifies if Floor Stock should be used for Filling the order. 
HangTimeNum    numeric(6, 2)  YES  Identifies the Default Hang Time. 
HangTimeUOMCode    varchar(30)  YES  Identifies the Unit of measure associated with the hang time.Links to CV3UnitOfmeasure 
CostAmt    numeric(11, 3)  YES  Total Cost of all components 
KeepVeinOpen    bit  NO  Keep Vein Open 
LabelExpiryPeriodNum    smallint  YES  Expiry Period to print on labels 
LabelExpiryPeriodType    int  YES  An enumerated type with the following list of possible values: 0 = [Hours],1 = [Days], 
PriceAmt    numeric(11, 3)  YES  Total Price of all components 
StorageConditionID(FK)    int  YES  A foreign key to the StorageConditionID column in the SXAMMStorageCondition table. 
OrderVariableComponentGUID    HVCIDdt  YES  Identifies the Order Variable Component GUID for complex orders 
CalculationDetails    varchar(max)  YES  This attribute contains a detailed explanation of how the Charge Calculation was determined. It will contain the exact steps that were done to calculate the charge being processed to the patient - will include markup, dispensing fees etc... applied to the base price of the drug.This entity contains the formatted text displayed within the Price Popup window. The data stored in this attribute will most likely be in XLM format 
TotalVolumeNum    numeric(14, 4)  YES  Identifies the total volume for the Order Option (Route). 
TotalVolumeUOMCode    varchar(30)  YES  Identifies the Unit of Measure associated with the Total Volume. Links to the CV3 Unit of Measure table via 'Code'. 
IsManualFillQuantitySet    bit  YES  Tells if fill Quantity is set by the user on the order. If so use manually set value else calculate based on frequency. 
ManualFillQuantity    int  YES  Manually set fill quantity for the order. 
UseRobot    bit  YES  true if the order will be dispatched to the robot 
FlowRateNum    numeric(14, 4)  YES 
SMM Order Flow Rate Value 
FlowRateUOMCode    varchar(30)  YES 
SMM Order Flow Rate UOM 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXAMMOrderOption Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAMMOrderOptionPK  PrimaryKey  OrderOptionID