We currently offer the following CSV report formats of your reminder results files.

These files can be attached to the Job Completed email messages or sent securely and automatically via SFTP or FTPS to your FTP server ( learn how to set this up in this related article).

The CSV File Name

The CSV file is named with the unique Job ID assigned to the reminder job and will be a series of numbers inside square brackets like this:

[1386537590-286977-163759939].csv

Default Format

This is the default format and contains the job results data separated by commas but without any quotes around each field.

Field Order:

id,id_job,name,phone,appt_time,appt_date,appt_tov,appt_status,appt_labs,balance,provider,location,user1,user2,user3,time,date,message,info,patient_mobile,client_code,patient_code,case_code,medical_code,facility_code,facility_address,facility_phone,reminder_type,action_type

Sample Data:

[1373804927-226175-1100709036],[1373804927-225898-1326635953],Joe Burke,386-555-1111,10:30AM,9/30/2013,,,,,Mary Parker,,N,39139,,,,,Appointment confirmed (Y),386-334-6434,ABC001,1,MOR001,,EAST,333 W Lake , Ave,305-394-6197,P,SMS

Quoted Format

Field Order:

id,id_job,name,phone,appt_time,appt_date,appt_tov,appt_status,appt_labs,balance,provider,location,user1,user2,user3,time,date,message,info,patient_mobile,client_code,patient_code,case_code,medical_code,facility_code,facility_address,facility_phone,reminder_type,action_type

Sample Data:

"[1386537590-287544-596698929]","[1386537590-286977-163759939]","Arnie Ferguson","(386) 555-1111","07:45AM","03/28/2022","AA Follow Up","","follow up and schedule endoscopy combine","","","","","","","04:20PM","12/08/13","","Appointment confirmed","","","","","","","","","","NPC"

Quoted Duration Format

This has one additional field at the end of the fields called 'duration' which contains the duration of a connected phone call in seconds.  This could be when a live person answered the phone, or when a message was left on an answering machine or voice mail, or even the total duration of a phone call including the live transfer to another number (such as your office, front desk or call center).

Field Order:

id,id_job,name,phone,appt_time,appt_date,appt_tov,appt_status,appt_labs,balance,provider,location,user1,user2,user3,time,date,message,info,patient_mobile,client_code,patient_code,case_code,medical_code,facility_code,facility_address,facility_phone,reminder_type,action_type,duration

Sample Data:

"[1386537590-287544-596698929]","[1386537590-286977-163759939]","Arnie Ferguson","(386) 555-1111","07:45AM","03/28/2022","AA Follow Up","","follow up and schedule endoscopy combine","","","","","","","04:20PM","12/08/13","","Appointment confirmed","","","","","","","","","","NPC","28"

SAMPLE QUOTED DURATION file attached.