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. 

PrescriptionID 
Definition  Auto generated unique primary key value. 

ClientGUID 
Definition  A foreign key to the GUID column in the CV3Client table. 

ChartGUID 
Definition  A foreign key to the GUID column in the CV3Chart table. 

ClientVisitGUID 
Definition  Link to the CV3ClientVisit table 

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. 

DrugName 
Definition  The name of the medication being prescribed. Used for free text entries. 

DoseAmount 
Definition  An enumerated type with the following list of possible values: 0 = [DoseAmount], 

DoseUOMID 
Definition  A foreign key to the RxUOMID column in the SXARxUnitOfMeasure table. 

ScriptFrequencyID 
Definition  A foreign key to the ScriptFrequencyID column in the SXAAMBScriptFrequency table. 

Route 
Definition  An enumerated type with the following list of possible values: 0 = [Route], 

DurationAmount 
Definition  The length of this prescription 

IsContinuous 
Definition  A flag indicating whether or not this is a continuous prescription. 

QuantityAmount 
Definition  The quantity of the medication being prescribed. 

Refills 
Definition  The number of refills allowed for this prescription. 

Instructions 
Definition  An enumerated type with the following list of possible values: 0 = [Instructions], 

Comments 
Definition  PHI: Any comments to include with this prescription. 

Memo 
Definition  PHI: The physician-only comments for this prescription. 

IsDaw 
Definition  A flag indicating whether or not this prescription is to be dispensed as written. 

UserGUID 
Definition  A foreign key to the GUID column in the CV3User table. 

CareproviderGUID 
Definition  A foreign key to the GUID column in the CV3User table. 

StartDate 
Definition  Visit TimeZone - The date this prescription was entered. 

EndDate 
Definition  Visit TimeZone - The date this prescription should become inactive 

RenewalDate 
Definition  Visit TimeZone - The date this prescription was renewed. 

StatusType 
Definition  An enumerated type with the following list of possible values: 1 = [Active],2 = [Inactive],3 = [Discontinued],4 = [Cancelled],5 = [Unapproved],6 = [NoLongerTaking],7 = [Completed],8 = [EnteredInError],11 = [Deleted], 

PrescriptionType 
Definition  An enumerated type with the following list of possible values: 1 = [Rx],2 = [DRx],3 = [Hx],4 = [eHx],5 = [cHx], 

CSASchedule 
Definition  The national standard schedule of the drug used for auditing and classification purposes. 

DispensedUnits 
Definition  Number of units dispensed 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

FormularyOrgName 
Definition  The name of the patient's insurance organization used to check pharmacy benefits 

FormularyDrugKey 
Definition  The drug ID from the 3rd party drug database vendor that maps to a drug ID in the formulary. 

FormularyBrandKey 
Definition  The brand ID from the 3rd party drug database vendor that maps to a brand ID in the formulary 

FormularyStatus 
Definition  The status of the prescribed drug in the patient's insurance plan - Approved, Not Reimbursed, etc. 

InnerPackageSize 
Definition  The size of the package used to fill this prescription if applicable. 

InnerPackageSizeUOMID 
Definition  A foreign key to the RxUOMID column in the SXARxUnitOfMeasure table. 

CDSUniqueIDGUID 
Definition  A unique Identifier in the form of an HVCIDdt. Used by CDS to uniquely identify a row. 

ManufacturerName 
Definition  The name of the manufacturer of the sample given to a patient (applies only to prescriptions marked as "samples" 

TransmissionStatus 
Definition  An enumerated type with the following list of possible values: 0 = [None],1 = [Printed],2 = [Faxed],3 = [eTransmitted],4 = [Failed],5 = [Received],11 = [SentToQueue],12 = [SentToQueueFailed],13 = [ReceivedByHandler], 

DiscontinueDate 
Definition  Visit TimeZone - Date a prescription was discontinued 

DenialDate 
Definition  Visit TimeZone - Date a prescription was denied 

DenialReason 
Definition  PHI: Reason for the denial of a prescription 

RxReferenceNumber 
Definition  Pharmacy Rx Reference Number 

Pharmacist 
Definition  PHI: Pharmacist Name (last | first | mid | suffix | prefix) 

PharmacyID 
Definition  Related ID from SXAAMBPharmacy table 

NDC 
Definition  National Drug Code 

LastRenewDate 
Definition  visit TimeZone - The date of the last renewal of the prescription 

PharmacyMemo 
Definition  PHI: A note to the pharmacist. 

SourceCode 
Definition  Indicates the source of the formulary information saved with the prescription. 

SourceCodeType 
Definition  Indicates the type of source of the formulary information saved with the prescription. 0=MediMedia; 1=RxHub 

FormularySourceType 
Definition  Indicates the source of the formulary information saved with the prescription. 

SupervisorGUID 
Definition  The User who was supervising the Prescriber at the time of Prescription creation. 

SourceApplicationType 
Definition  An enumerated type with the following list of possible values: 0 = [PrescriptionWriter],1 = [ORMAdmission],2 = [ORMDischarge],3 = [OrderEntryDischarge],4 = [StructuredNotes],5 = [ClinicalSummary],6 = [Inbox],7 = [MyView],8 = [PhoneNote],9 = [Workbench],10 = [External],11 = [TakeHomeMedRequest],12 = [PharmacyOutPatient],13 = [ORMTransfer],14 = [ORMOutPatient],15 = [Community], 

IsPrn 
Definition  Indicates whether a medication should be taken as needed for a specified complaint. 

PrnReason 
Definition  An enumerated type with the following list of possible values: 0 = [PrnReason], 

SelectedSubmitMethodType 
Definition  An enumerated type with the following list of possible values: 1 = [Print],2 = [Fax],3 = [eSubmit],4 = [SaveOnly],5 = [None],6 = [eCancel], 

IsStartDateApprox 
Definition  Indicates if the start date entered is a fuzzy date (ex. 12/1/2011 would display as Dec 2011). 

IsEndDateApprox 
Definition  Indicates if the end date entered is a fuzzy date (ex. 12/1/2011 would display as Dec 2011). 

SelectedProviderAddressGUID 
Definition  Link to the address table CV3Address 

ProductRouteID 
Definition  Multum RouteID for the Product Route 

ClinicalRouteID 
Definition  Multum RouteID for the Clinical Route 

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

IsSIG 
Definition  To store the Show sig day state for medication 

IsTaperDose 
Definition  To store the Taper dose state for medication 

IndicationForUse 
Definition  User can store the Indication for use while adding prescription for favorites from Add Rx 

SignedMessageID 
Definition  Unique identifier of the signed prescription stored in Rx Archive database on shield 

DEANumber 
Definition  DEA Number associated with the provider address selected while submitting the prescription 

MDD 
Definition  Maximum Daily Dosage 

DispensedDetailID 
Definition  A foreign key to the DispensedDetailID column in the SXAAMBeRXDispensedDetail table. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

FormularyQueryGeneratedType 
Definition  An enumerated type with the following list of possible values: 0 = [Not Recorded],1 = [No Formulary Query Generated],2 = [Formulary Query Generated], 

DrugCoverageStatusCodeType 
Definition  An enumerated type with the following list of possible values: 0 = [n/a],1 = [Compound Drugs (CP)],2 = [Supplies (SP)], 

CommunitySourceDocumentGUID 
Definition  Saves CXD Document link 

OriginatingSource 
Definition  PHI: Source from where Medicaiton was Initiated 

PriorAuthorizationNumber 
Definition  Store Rx Prior Authorization Number 

PriorAuthorizationStatusCode 
Definition  Store Rx Prior Authorization Status Code: A|D|R|N|F 

eRxStructuredSigID 
Definition  A foreign key to the eRxStructuredSigID column in the SXAAMBeRxStructuredSig table. 

RepresentativeNDC 
Definition  Contains representative NDC of a drug 

QuantityUOMID 
Definition  Contains Quantity Unit of measure ID selected from the RxWriter 

PrintReason 
Definition  Stores the reason for printing a prescription 

TransmissionDateUTC 
Definition  The date and time that the prescription was eTransmitted and will be based on the Visit time zone. 

EffectiveDateUTC 
Definition  SXAAMBClientPrescription 

FreeTextSig 
Definition  An enumerated type with the following list of possible values: 0 = [FreeTextSig], 

IsAutoCalc 
Definition  AutoCalc selected. 

IsFreeTextSig 
Definition  Freetext SIG selected 

eRXTransDetailID 
Definition  Transaction Detail ID number to save a selected benefit plan with the prescription. 

Response271DTM 
Definition  271 response time stamp of Transaction Detail ID. 

DoseCalcHeightCm 
Definition  store height in cm 

DoseCalcWeightKg 
Definition  store weight in kg 

RxNormCUI 
Definition  RxNormCUI is stand for RxNorm Concept Unique Identifier and it is a normalized naming system for generic and branded drugs. It is produced by the National Library of Medicine for purposes of interoperable electronic data exchange in the United States. 

RxNormQualifier 
Definition  RxNorm Qualifier is a term type of RxNorm i.e. SCD, SBD, BPCK, GPCK. 

IsAutoComplete 
Definition  this is a toogle flag. If it is off, a prescription status would not be reevaluated. Otherwise, it would be by checking if the current date pass the end of refill date.