dbo.SXAMMOutpatientOrder 
Default Table Name  SXAMMOutpatientOrder 
Definition  This entity contains details for the outpatient order such as the Generic Item Dose quantities, number of refills, etc. Information in this entity cannot be changed after the outpatient order has been saved (except the active and reason code). 

dbo.SXAMMOutpatientOrder 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. 
OutpatientOrderID(PK)    int  NO  Auto generated unique primary key value. 
ClientVisitGUID(FK)    HVCIDdt  NO  Identifies the Client/Visit that the outpatient order is associated with. ,Links to the CV3 Client Visit table (an outpatient order is associated with an encounter/visit) 
GenericItemID    int  NO  Link to SXAMMGenericItem 
ProductID(FK)    int  YES  A foreign key to the ProductID column in the SXAMMProduct table. 
IsDAW    bit  NO  Identifies if the outpatient order should be dispensed as written, if so, then the product must be specified 
OriginalSIGDesc    varchar(1000)  YES  Identifies the SIG as typed by the user.

,The SIGs will be separated by commas and will be translated as the user types. The user may type additional information that is not translated and will appear on the label as is. 
TranslatedSIGDesc    varchar(1000)  YES  Identifies the translated SIG as it will appear on the label (it may include text that was written directly by the user and not translated). 
DoseNum    numeric(14, 4)  NO  Identifies the Dose of the Order. 
DoseUOMCode    varchar(30)  NO  Identifies the Unit Of Measure associated with the Dose Number.

,Links to the CV3UnitOfMeasure table via the code. 
DaysSupplyNum    numeric(3, 0)  YES  Identifies the total Days Supply of the outpatient order. 
TotalRefillNum    numeric(3, 1)  NO  Identifies the total number of refills available for the outpatient order. 
RemainingRefillNum    numeric(3, 1)  NO  Identifies the Number of refills remaining for the outpatient order. 
PrescribedByUserGUID    HVCIDdt  NO  Identifies the Physician who Prescribed the Outpatient Order. 
PrescribedDtm    datetime  NO  Visit TimeZone - Identifies the Date the Outpatient Order was Prescribed. 
ReasonCode    varchar(30)  YES  Reason for making the outpatient order inactive. Links to the CV3CodedReason table via the code. 
Note    varchar(2000)  YES  Notes that may be required for the order 
ExpiryDtm    datetime  YES  Visit TimeZone - Identifies the Date that the outpatient order is to expire. 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
OrderGUID    HVCIDdt  YES  link to cv3order table 
StatusType    int  YES  An enumerated type with the following list of possible values: 0 = [Pending],1 = [Processed],2 = [Canceled],3 = [Inactivated], 
OrderType    int  YES  An enumerated type with the following list of possible values: 0 = [Outpatient],1 = [Take Home Meds], 
DrugName    varchar(250)  YES  Stores free text drug name for discharge orders 
Route    varchar(30)  YES  Stores Route code for discharge orders 
IsPRN    bit  NO  Flag indicating whether an order is PRN 
PRNReason    varchar(30)  YES  Stores PRN reason text when provided for PRN orders 
Duration    int  YES  Stores length of the order (can be in # of doses or days) 
DurationUOM    varchar(30)  YES  Unite of measurement for the duration column 
SummaryLine    varchar(2000)  YES  Stores order's summary information 
BillForRxType    int  YES  An enumerated type with the following list of possible values: 0 = [Not Billed],1 = [IP Charge Algorithm],2 = [OP Charge Algorithm],3 = [Manual Entry], 
CancelRxReason    varchar(140)  YES  Stores free text reason for canceling an outpatient order 
IsPharmacyEntered    bit  YES  This column stores a boolean value indicating whether an Rx was created in Pharmacy Outpatient (true) OR it was requested from SCM (false). 
IsControlled    bit  YES  This column stores a value indicating whether a drug being dispensed is a controlled med.Note: Changing datatype from numeric(2,0) to numeric(3,1) 
IsNarcotic    bit  YES  This column stores a value indicating whether a drug being dispensed is a narcotic med. 
IsDispensingPolicyApplied    bit  YES  This column stores true for LOA orders when the dispensing policy is applied. False when it is overridden. 
IsPartialLOA    bit  YES  This boolean flag indicates whether the LOA request is a partial LOA. 
OrderCatalogMasterItemGUID    HVCIDdt  YES  This column stores the order catalog master item guid needed to process clinical alerts 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXAMMOutpatientOrder Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAMMOutpatientOrderPK  PrimaryKey  OutpatientOrderID