Letters Export

The Letters Export extracts data related to letters saved for a patient.  Below you will find a detailed definition of possible inputs and outputs.  

Data Location:  EMR > Letters


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


  • chart_number: Unique ID for patient (foreign key for patient)
  • sys_id:  Unique ID for the letter record (primary key)
  • encounter_date: Encounter date for the letter.
  • letter_name:  Name of the letter
  • letter_data:  HTML representation of the letter
  • letter_status:  Status of the letter (Printed, Ready, Mailed, Faxed)