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