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], |