Skip to main content

Downloading Health Records

Open ACU allows you to download a CSV file of all found records in blocks or searches. 

Coming: Health records download for each patient by date range.

To download a block of records to CSV

Go to EHR > EHR By Block (if you are an owner you can choose the practitioner first to load their blocks)

Select a block from the column on the left
oneblock.png

If there are any appointments you will see a button at the top right of the records loaded in the right column. 
dl_ehr.png

This button will download a CSV file.

The information columns in the downloaded file

These are the fields in the CSV file downloaded from the EHR.

    id -- a unique id for the appointment
    start_time -- appointment start time
    checked -- Has been checked in
    patient_name
    patientid -- unique id for the patient
    birth_date -- if not entered it will be 0000-00-00
    prac_name
    pracid -- unique id for the practitioner
    locationid -- unique id for the 
    made_from -- 1 if made by the patient
    first_appt -- this patient's first appointment date
    flag -- 1 if true
    new -- 1 if true
    credit -- current credit balance
    tokens -- current tokens balance
    caution -- 1 if true
    privatenote -- an old POCA Point private note holder
    zhr_approved -- 1 if this appointment record has been approved and locked
    ehrid -- a reference number to the health record
    typeid -- placeholder, not applicable
    rating -- star rating value
    text0 & text0ta (two exact columns) -- Note or "S" text (two columns)
    text1 & text1ta (two exact columns) -- "O" text
    text2 & text2ta (two exact columns) -- "A" text
    text3 & text3ta (two exact columns)-- Plan or "P" text
    points0 -- head or symmetrical points
    points1 -- TR points
    points2 -- TL points
    points3 -- BR points
    points4 -- BL points
    datemodified
    datecreated