dbo.SXAAMBScriptFavorite 
Default Table Name  SXAAMBScriptFavorite 
Definition  Lists all of the favorite prescriptions. 

dbo.SXAAMBScriptFavorite 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. 
ScriptFavoriteID(PK)    int  NO  Auto generated unique primary key value. 
GenericItemID(FK)    int  YES  A foreign key to the GenericItemID column in the SXARxGenericItem table. 
GenericNameID(FK)    int  YES  A foreign key to the GenericNameID column in the SXARxGenericName table. 
DrugName    varchar(255)  YES  The name of the medication being prescribed. Used for printing of the prescription. 
DoseAmount    float  YES  The amount of the dose 
DoseUOMID(FK)    int  YES  A foreign key to the RxUOMID column in the SXARxUnitOfMeasure table. 
ScriptFrequencyID(FK)    int  YES  A foreign key to the ScriptFrequencyID column in the SXAAMBScriptFrequency table. 
Route    varchar(255)  YES  The route used in this prescription. 
DurationAmount    float  YES  The length of this prescription in days 
IsContinuous    bit  YES  A flag indicating whether or not this is a continuous prescription. 
Quantity    float  YES  The quantity of the medication being prescribed. 
Refills    int  YES  The number of refills allowed for this prescription. 
Instructions    varchar(4000)  YES  The instructions to include with this prescription. 
Comments    varchar(1000)  YES  Any comments to include with this prescription. 
Memo    varchar(4000)  YES  The physician-only comments for this prescription. 
IsDaw    bit  YES  A flag indicating whether or not this prescription is to be dispensed as written. 
CSASchedule    smallint  NO  The national standard schedule of the drug used for auditing and classification purposes. 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
DispensedUnits    varchar(50)  YES  Number of units dispensed 
FormularyDrugKey    varchar(30)  YES  The drug ID from the 3rd party drug database vendor that maps to a drug ID in the formulary. 
FormularyBrandKey    varchar(30)  YES  The brand ID from the 3rd party drug database vendor that maps to a brand ID in the formulary 
InnerPackageSize    numeric(15, 3)  YES  The size of the package used to fill this prescription if applicable. 
InnerPackageSizeUOMID(FK)    int  YES  A foreign key to the RxUOMID column in the SXARxUnitOfMeasure table. 
IsEnterprise    bit  NO  Flag to indicate whether or not this favorite is available to the enterprise 
IsPrn    bit  NO  Indicates whether a medication should be taken as needed for a specified complaint. 
IsSIG    bit  NO  To store the Show sig day state for favorite medication 
IsTaperDose    bit  NO  To store the Taper dose state for medication 
IndicationForUse    varchar(1000)  YES  User can store the Indication for use while adding prescription for favorites from Add Rx 
ProductRouteID    int  YES  This column holds the Route ID used to display route in RxWriter 
ClinicalRouteID    int  YES  This column holds the ClinicalRoute ID used to display clinical route in RxWriter 
MDD    varchar(500)  YES  MDD colomn is to store data for maximum daily dose for particular prescription. 
DispensedDetailID    bigint  YES  DispensedDetailID will store despense detail id for particular prescrption 
PrnReason    varchar(500)  YES  PrnReason is to save common and PRN instructions for prescriptions 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
DrugCoverageStatusCodeType    int  YES  Capture if Compound Drugs (CP) and Supplies (SP) 
eRxStructuredSigID(FK)    int  YES  A foreign key to the eRxStructuredSigID column in the SXAAMBeRxStructuredSig table. 
QuantityUOMID    int  YES  Contains Quantity Unit of measure ID selected from the RxWriter 
PharmacyMemo    varchar(4000)  YES  Pharmacy notes. 
IsAutoCalculate    bit  NO  Indicates if Auto Calculate is turned on for this prescription. 
FreeTextSIG    varchar(4000)  YES  Free text SIG. 
IsFreeTextSIG    bit  NO  Free text SIG only toggle. 
DoseCalcAmount    float  YES  Dose Amount from the Dose Calculator. 
DoseCalcUOMID(FK)    int  YES  A foreign key to the RxUOMID column in the SXARxUnitOfMeasure table. 
DoseCalcWtBSA    varchar(30)  YES  Patient weight units from the Dose Calculator. 
DoseCalcInterval    varchar(30)  YES  Dose interval unit for how often dose should be taken from the Dose Calculator 
DoseCalcFrequencyID(FK)    int  YES  A foreign key to the ScriptFrequencyID column in the SXAAMBScriptFrequency table. 
DoseCalcRounding    float  YES  Increment used for rounding dose from the dose calculator. 
IsPackageSelected    bit  NO  Package selected radio button state 
NumberOfPackages    int  YES  Number of packages for the prescription. 
IsAutoComplete    bit  NO  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.  

dbo.SXAAMBScriptFavorite Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAAMBScriptFavoritePK  PrimaryKey  ScriptFavoriteID