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. |
OrderOptionID |
Definition | Auto generated unique primary key value. |
OrderID |
Definition | A foreign key to the OrderID column in the SXAMMOrder table. |
TotalDoseNum |
Definition | Identifies the total dose that is to be administered for the Order Option (Route). |
TotalDoseUOMCode |
Definition | Identifies the Unit of Measure associated with the Total Dose. Links to the CV3 Unit of Measure table. |
RouteCode |
Definition | Identifies the Route of the order. ie Oral. Links to the CV3 Route table. |
RouteModifierCode |
Definition | Identifies the Route Modifier. ie Chewed Crushed etc. Links to the CV3 Order Route Modifier table. |
MedicationFormCode |
Definition | Identifies the Dose Form for the Order Option ie. Tablet Capsule etc.. Links to the CV3 Med Form table. |
BodySiteCode |
Definition | Identifies the Body Site for the Order Option. ie. Left Arm, Right Foot etc.. Links to the CV3BodySite table. |
MSrepl_tran_version |
Definition | Optimistic lock identifier. |
FillingLabelDataID |
Definition | Identifies the Filling Label records that were generated by the Cart Fill process |
DispensingContainerID |
Definition | A foreign key to the DispensingContainerID column in the SXAMMDispensingContainer table. |
LineTypeID |
Definition | Identifies the Preferred Line Type for this Order |
UseFloorstock |
Definition | Identifies if Floor Stock should be used for Filling the order. |
HangTimeNum |
Definition | Identifies the Default Hang Time. |
HangTimeUOMCode |
Definition | Identifies the Unit of measure associated with the hang time.Links to CV3UnitOfmeasure |
CostAmt |
Definition | Total Cost of all components |
KeepVeinOpen |
Definition | Keep Vein Open |
LabelExpiryPeriodNum |
Definition | Expiry Period to print on labels |
LabelExpiryPeriodType |
Definition | An enumerated type with the following list of possible values: 0 = [Hours],1 = [Days], |
PriceAmt |
Definition | Total Price of all components |
StorageConditionID |
Definition | A foreign key to the StorageConditionID column in the SXAMMStorageCondition table. |
OrderVariableComponentGUID |
Definition | Identifies the Order Variable Component GUID for complex orders |
CalculationDetails |
Definition | 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 |
Definition | Identifies the total volume for the Order Option (Route). |
TotalVolumeUOMCode |
Definition | Identifies the Unit of Measure associated with the Total Volume. Links to the CV3 Unit of Measure table via 'Code'. |
IsManualFillQuantitySet |
Definition | Tells if fill Quantity is set by the user on the order. If so use manually set value else calculate based on frequency. |
ManualFillQuantity |
Definition | Manually set fill quantity for the order. |
UseRobot |
Definition | true if the order will be dispatched to the robot |
FlowRateNum |
Definition |
SMM Order Flow Rate Value |
FlowRateUOMCode |
Definition |
SMM Order Flow Rate UOM |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |