Prescriptions Export

The Prescriptions Export extracts data related to the patient's prescription records.  Below you will find a detailed definition of possible inputs and outputs.  

Data Location:  EMR > Prescriptions

Inputs

•  Employer: For practices that utilize the Employer Module product, demographics can be exported based on this.  This is rare.

Outputs

• PrescriptionID:  Unique ID for the prescription record (primary key).
• PatientID:  Unique ID for the patient (foreign key). Maps to Chart Number in other files.
• NDC:  National Drug Code - standardized identifier for the medication.
• RxNorm:  RxNorm - standardized identifier for the medication.
• Status: Prescription status (i.e. New or Stopped).
• Method: Method of the prescription (Updated/Print/Historical/etc...).
• PrescribingProviderID: Unique ID for the prescribing provider (foreign key).
• DrugName:  Name of the medication.
• Strength: Strength of the medication.
• StrengthUOM:  Strength units of measure .
• EncounterDate: Encounter date.
• WrittenDate: Date medication was written.
• StartDate:  Date medication should be started .
• StopDate:  Date medication was stopped.
• VoidDate: Date medication is void after.
• SigQuantity:  Sig value - represents how the medication should be taken.  Quantity is the number to take at a time.
• SigDosage: Sig value - represents how the medication should be taken.  Represents dosage value (i.e. Tablet or Capsule) 
• SigRoute:  Sig value - represents how the medication should be taken.  Route represents how the medication is delivered (i.e. Oral)
• SigFrequency: Sig value - represents how the medication should be taken.  Frequency represents how often the medication should be taken.
• SigFreeForm: Sig value - represents how the medication should be taken.  The Sig Free Form field allows a user to type in details. 
• DispenseQuantity: Dispense value - represents how the medication should be bottled.  The Quantity is how many should be provided overall.
• Dispense: Dispense value - represents how the medication should be bottled.  This field represents the type of item to be provided (i.e. Tablet/ Capsule). 
• DispenseNCIt: Unique ID for the Dispense Type (used for e Prescribing).
• DaysSupply: Total Day Supply provided.
• Refills: Total number of refills provided.
• DAW: Dispense as written flag (Yes or No).
• Alerts:  Alert text.
• Comments: Comment text .
• PharmacyNCPDP:  Associated pharmacy NCPDP (foreign key).
• RefillPrescriptionID: If the medication was generated from a refill, the original prescription ID (foreign key).