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