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. 

OrderID 
Definition  Auto generated unique primary key value. 

OrderGUID 
Definition  A foreign key to the GUID column in the CV3Order table. 

OrderDesc 
Definition  Identifies the description of the order. 

OrderNum 
Definition  Identifies the Order Number. May be used for linking the RxOrder to an Order in an external Pharmacy Module 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

DispenseSubTypeID 
Definition  A foreign key to the DispenseSubTypeID column in the SXAMMDispenseSubType table. 

OrderSetID 
Definition  A foreign key to the OrderSetID column in the SXAMMOrderSet table. 

PrintOnMAR 
Definition  Identifies if the Order should be printed on the MAR. 

IsTitrate 
Definition  Titrating deals with creating solutions – as in some powder dissolved in some liquid. 

IsPatientOwned 
Definition  Patient owns the medication - no dispensing will be performed 

PerfectedByGUID 
Definition  User who perfected the order (will be NULL if smart selected) 

IsPerfected 
Definition  Smart Selection or Pharmacist have defined required order option components. 

VerifiedByGUID 
Definition  User who MM verified the order 

VerifiedDtm 
Definition  Visit TimeZone - Identifies the date/time the Order Version was Pharmacy Verified. 

IsFreeText 
Definition  Drug does not exist in drug catalog 

TherapeuticClassID 
Definition  A foreign key to the TherapeuticClassID column in the SXAMMTherapeuticClass table. 

SmartSelectionProcessingNotes 
Definition  Identifies notes that are processed and put together by Smart Selection. These notes are to be used when attempting to identify the business processing/rules that occurred when Smart Selection processed Order. 

HasBeenVerified 
Definition  Flag indicating that the order has been verified 

IsTPN 
Definition  Identifies if the order is a TPN. 

IsQuickCharge 
Definition  Flag to indicate that the order is for a quick charge 

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

IsOnDemand 
Definition  Indicator that the order is On Demand 

FillQtyOriginType 
Definition  An enumerated type with the following list of possible values: 0 = [Calculated],1 = [Manual],2 = [PolicyOnDemand],3 = [PolicyOverride], 

FillQty 
Definition  Fill Quantity either manually entered or the result of a Dispensing Policy Detail 

DispensingPolicyDetailID 
Definition  A foreign key to the DispensingPolicyDetailID column in the SXAMMDispensingPolicyDetail table. 

CanPrintPrepLabel 
Definition  This column indicates if Prep Label will be printed for the order 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

IsNonPharmacyOrder 
Definition  Indicates whether an order is/was fulfilled/serviced by a hospital pharmacy