dbo.SXAMMOrder 
Default Table Name  SXAMMOrder 
Definition  This Entity contains Pharmacy Orders and links directly to the CV3Order table.
Table to hold pharmacy order details 

dbo.SXAMMOrder 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. 
OrderID(PK)    bigint  NO  Auto generated unique primary key value. 
OrderGUID(FK)    HVCIDdt  NO  A foreign key to the GUID column in the CV3Order table. 
OrderDesc    varchar(2000)  NO  Identifies the description of the order. 
OrderNum    varchar(40)  NO  Identifies the Order Number. May be used for linking the RxOrder to an Order in an external Pharmacy Module 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
DispenseSubTypeID(FK)    int  YES  A foreign key to the DispenseSubTypeID column in the SXAMMDispenseSubType table. 
OrderSetID(FK)    int  YES  A foreign key to the OrderSetID column in the SXAMMOrderSet table. 
PrintOnMAR    bit  NO  Identifies if the Order should be printed on the MAR. 
IsTitrate    bit  NO  Titrating deals with creating solutions – as in some powder dissolved in some liquid. 
IsPatientOwned    bit  NO  Patient owns the medication - no dispensing will be performed 
PerfectedByGUID    HVCIDdt  YES  User who perfected the order (will be NULL if smart selected) 
IsPerfected    bit  NO  Smart Selection or Pharmacist have defined required order option components. 
VerifiedByGUID    HVCIDdt  YES  User who MM verified the order 
VerifiedDtm    datetime  YES  Visit TimeZone - Identifies the date/time the Order Version was Pharmacy Verified. 
IsFreeText    bit  NO  Drug does not exist in drug catalog 
TherapeuticClassID(FK)    int  YES  A foreign key to the TherapeuticClassID column in the SXAMMTherapeuticClass table. 
SmartSelectionProcessingNotes    varchar(4000)  YES  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    bit  NO  Flag indicating that the order has been verified 
IsTPN    bit  NO  Identifies if the order is a TPN. 
IsQuickCharge    bit  YES  Flag to indicate that the order is for a quick charge 
IsNonFormulary    bit  YES  This field will be used to indicate if the order placed was a non-formulary order 
IsOnDemand    bit  YES  Indicator that the order is On Demand 
FillQtyOriginType    int  YES  An enumerated type with the following list of possible values: 0 = [Calculated],1 = [Manual],2 = [PolicyOnDemand],3 = [PolicyOverride], 
FillQty    numeric(14, 4)  YES  Fill Quantity either manually entered or the result of a Dispensing Policy Detail 
DispensingPolicyDetailID(FK)    int  YES  A foreign key to the DispensingPolicyDetailID column in the SXAMMDispensingPolicyDetail table. 
CanPrintPrepLabel    bit  NO  This column indicates if Prep Label will be printed for the order 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
IsNonPharmacyOrder    bit  NO  Indicates whether an order is/was fulfilled/serviced by a hospital pharmacy  

dbo.SXAMMOrder Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAMMOrderPK  PrimaryKey  OrderID