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. |