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. 

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. 

DispensedDetailID 
Definition  Auto generated unique primary key value. 

DispensedHeaderID 
Definition  A foreign key to the DispensedHeaderID column in the SXAAMBeRXDispensedHeader table. 

DrugName 
Definition  Drug Name information for the relevant Drug listed in the DRU segment 

DrugNumber 
Definition  Drug Number for the relevant Drug listed in the DRU segment (NDC11 code if it exists) 

LastFillDate 
Definition  visit TimeZone - Last Fill Date for the relevant Drug listed in the DRU segment 

DrugDispensedXml 
Definition  XML Representation of Dispense History DRU Segment 

Msrepl_tran_version 
Definition  Optimistic lock identifier. 

MedicationStartDtmUTC 
Definition  Visit TimeZone -
Stores Start Date of medicaton 

MedicationEndDtmUTC 
Definition  Visit TimeZone -
Stores End Date of medicaton 

Instruction 
Definition 
Medication instructions 

Duration 
Definition 
Medication Duration 

Quantity 
Definition 
holds amount of dose needs to be given 

Refills 
Definition 
Medication Refills 

OriginatingSource 
Definition 
Medication Originating source from where it has come 

OriginatingProvider 
Definition 
Medication Originating Provider who has given medication 

CommunityMedStatus 
Definition 
Medication status as active, inactive, etc coming from the med source 

Dose 
Definition 
Dose of medication 

DosageUnit 
Definition 
unit of measure for drug 

Route 
Definition 
medication route 

Frequency 
Definition 
frequency of the drug 

IsPRN 
Definition 
indicates if the drug is PRN 

IsStartDateApprox 
Definition 
indicates if the startdate is approximate 

IsEndDateApprox 
Definition 
indicates if the enddate is approximate 

StartDateApproxType 
Definition  An enumerated type with the following list of possible values: 0 = [CompleteDate],1 = [MonthYear],2 = [Year], 

EndDateApproxType 
Definition  An enumerated type with the following list of possible values: 0 = [CompleteDate],1 = [MonthYear],2 = [Year], 

RxNormCode 
Definition 
Rxnorm code of drug 

StatusType 
Definition  An enumerated type with the following list of possible values: 0 = [Pending],1 = [Accepted],2 = [EditedAndAccepted],3 = [Rejected],4 = [Deleted], 

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. 

TouchedWhenUTC 
Definition  The date and time that the row was last updated including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 

GenericItemID 
Definition  A foreign key to the GenericItemID column in the SXARxGenericItem table. 

GenericNameID 
Definition  A foreign key to the GenericNameID column in the SXARxGenericName table. 

Comments 
Definition  Comments entered by the provider 

FormularyDrugKey 
Definition  MMDC(Main Multum Drug Code) 

FormularyBrandKey 
Definition  DrugSynonymID from the table SXAMTmultum_drug_nameSYN 

ProductRouteID 
Definition 
This column stores the Multum Product Route ID, corrospends to ProductRouteID in SXAAMBClientPrescription 

CommunityMedID 
Definition  This column is to uniquely identify a Community Mediaction 

RejectReason 
Definition  Reason provided while rejecting the med 

CDSUniqueIDGUID 
Definition  Stores CDS unique Id for imported medication 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

RxNormQual 
Definition  The Sure Scripts provided drug database source. 

IsDAW 
Definition  PHI: Flag to indicate whether the community med is DAW 

AutoReconciliationStatusType 
Definition  An enumerated type with the following list of possible values: 0 = [NotAutoReconciled],1 = [NeedAutoReconcile],2 = [ReconcileDone],