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. 

ScriptFavoriteID 
Definition  Auto generated unique primary key value. 

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 printing of the prescription. 

DoseAmount 
Definition  The amount of the dose 

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  The route used in this prescription. 

DurationAmount 
Definition  The length of this prescription in days 

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

Quantity 
Definition  The quantity of the medication being prescribed. 

Refills 
Definition  The number of refills allowed for this prescription. 

Instructions 
Definition  The instructions to include with this prescription. 

Comments 
Definition  Any comments to include with this prescription. 

Memo 
Definition  The physician-only comments for this prescription. 

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

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

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

DispensedUnits 
Definition  Number of units dispensed 

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 

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. 

IsEnterprise 
Definition  Flag to indicate whether or not this favorite is available to the enterprise 

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

IsSIG 
Definition  To store the Show sig day state for favorite 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 

ProductRouteID 
Definition  This column holds the Route ID used to display route in RxWriter 

ClinicalRouteID 
Definition  This column holds the ClinicalRoute ID used to display clinical route in RxWriter 

MDD 
Definition  MDD colomn is to store data for maximum daily dose for particular prescription. 

DispensedDetailID 
Definition  DispensedDetailID will store despense detail id for particular prescrption 

PrnReason 
Definition  PrnReason is to save common and PRN instructions for prescriptions 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

DrugCoverageStatusCodeType 
Definition  Capture if Compound Drugs (CP) and Supplies (SP) 

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

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

PharmacyMemo 
Definition  Pharmacy notes. 

IsAutoCalculate 
Definition  Indicates if Auto Calculate is turned on for this prescription. 

FreeTextSIG 
Definition  Free text SIG. 

IsFreeTextSIG 
Definition  Free text SIG only toggle. 

DoseCalcAmount 
Definition  Dose Amount from the Dose Calculator. 

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

DoseCalcWtBSA 
Definition  Patient weight units from the Dose Calculator. 

DoseCalcInterval 
Definition  Dose interval unit for how often dose should be taken from the Dose Calculator 

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

DoseCalcRounding 
Definition  Increment used for rounding dose from the dose calculator. 

IsPackageSelected 
Definition  Package selected radio button state 

NumberOfPackages 
Definition  Number of packages for the prescription. 

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.