The Demographics Export extracts data related to the patient primary demographics. Below you will find a detailed definition of possible inputs and outputs.
Data Location: Setup > Patients > Demographics
Inputs
- Employer: For practices that utilize the Employer Module product, demographics can be exported based on this. This is rare.
Outputs
- last_name: Patient last name
- first_name: Patient first name
- middle_name: Patient middle name
- nick_name: Patient nick name
- suffix: Patient suffix
- chart_number: Unique ID for patient (primary key)
- active: Active indicator (yes or no)
- user_defined: User defined field
- sig_file: Signature on File flag (yes or no)
- sig_file_date: Signature on File Date
- address_1: Patient street address
- address_2: Patient secondary address (i.e. Suite or Apartment)
- city: Patient City
- state: Patient State
- zip: Patient Zip Code
- home_phone: Patient Home Phone
- work_phone: Patient Work Phone
- other_phone: Patient Other Phone
- email: Patient email address
- primary_id: Patient primary ID type (i.e. SSN)
- primary_id_value: Patient primary ID value
- secondary_id: Patient secondary ID type
- secondary_id_value: Patient secondary ID value
- gender: Patient Gender
- marital_st: Patient Marital Status
- birth_date: Patient Date of Birth
- rhc: Patient Date of Death
- employed: Patient Employment Status
- employer: Patient Employer
- student: Patient Student Status
- pcp: Patient Primary Care Provider Name
- ethnicity: Patient Ethnicity
- race: Patient Race
- referring: Patient Referring Provider Name
- doctor: Patient Primary Doctor at the Practice
- old_patient_id: Imported Old Patient ID #1 (usually from a data conversion)
- old_patient_id_1: Imported Old Patient ID #2 (usually from a data conversion)
- old_patient_id_2: Imported Old Patient ID #3 (usually from a data conversion)
