Schedule export fields explained: the columns that matter
An appointment report can have forty columns or six. For recovering lost visits, only a handful really matter. Here is what each one does, what can go wrong with it, and how to check your own export before you rely on it.
- Seven fields carry almost all the value: date, time, provider, status, appointment type, phone and value.
- Status is the most important column. If cancelled and no-show rows are filtered out of your report, most of the revenue signal disappears.
- A stable patient identifier, such as an account or chart number, lets separate exports be matched up without relying on names.
- Leave out what the task does not need: diagnoses, clinical notes and full billing detail have no place in a schedule export.
Date and start time
Every row needs the appointment's date and start time. Together they place the visit on the calendar and show where open time sits between booked visits. A duration or end-time column is a bonus: it shows how big each gap is, so a 15-minute hole isn't treated like a 60-minute one.
Watch for: dates exported as text in an unusual format, times with no AM/PM, and reports that print the date once as a group header instead of on every row. That last one looks fine to a person but breaks when the file is read as data. If your report groups by day, look for a "detail" or "list" version instead.
Provider or resource
The provider column says who the visit was with: a doctor, dentist, hygienist, therapist or a room or chair. It matters because open time is always open time for someone. A cancellation with a hygienist can only be filled by a patient who needs a hygienist.
Watch for: providers listed by initials or internal codes. That is fine as long as it is consistent. Keep a one-line key handy ("DR1 = the owner dentist, HYG2 = Tuesday hygienist") so the codes can be mapped once.
Status: the column that does the most work
Status tells you what happened to each visit. Typical values include scheduled, confirmed, arrived or checked in, completed, cancelled, no-show, and in dental systems often "broken." Almost every revenue leak is visible here:
- Cancelled rows are open slots and patients who still need care.
- No-show or broken rows are patients who did not come, many of whom never rebook unless someone reaches out.
- Checked in but not completed can signal a patient who waited and left unseen.
- Scheduled or unconfirmed rows in the next 48 hours are the ones most at risk.
Appointment type or reason
The appointment type says what kind of visit it was: new patient, recall or hygiene, follow-up, treatment, evaluation, re-evaluation. It is how you match an open slot to the right waiting patient and how you estimate value when the export has no dollar column.
Keep it general. A category is useful; a clinical reason is not needed. "Follow-up" is enough. Many systems have a free-text reason or note column next to the type. That column can contain sensitive details typed in by staff, so it is usually best left out of the export entirely.
Patient identifier and phone
To follow up on a cancelled or overdue visit, you need to know who the patient is and how to reach them. Two columns do that job:
A patient identifier, such as an account, chart or patient ID number. It matches rows across exports reliably, even when two patients share a name or a name is spelled two ways.
A contact phone, ideally the mobile number. Many systems store home, work and cell separately. If you can choose, export the cell column, since that is the one that can receive a text.
Watch for: phone numbers stored with extensions or notes in the same field ("555-0100 ask for mom"), and blank phone columns caused by the report pulling the wrong phone type.
Value: production, fee or estimate
Some systems include a dollar figure on each appointment: scheduled production in many dental systems, or an expected charge elsewhere. When it is there, every lost visit can be priced exactly.
When it isn't, an estimate works. Here is illustrative math: say new-patient visits average $250, follow-ups $120 and hygiene visits $180 at your practice. Tag each appointment type with its average, and every cancellation in the file gets a reasonable dollar value. Ten cancelled follow-ups and three cancelled new-patient visits in a week would be about $1,950 of care at risk. That is enough to prioritize which slots to fill first.
A five-minute check of your own export
- Open the file in a spreadsheet. Confirm there is exactly one header row and one appointment per row.
- Filter the status column. Make sure cancelled and no-show values actually appear. If not, change the report settings to include them.
- Sort by date. Confirm the range covers what you asked for, past and future.
- Spot-check five rows against the live schedule. Same provider, same time, same status?
- Delete any column you would not want a stranger to see and that the task does not need, such as clinical notes.
DocsMD maps your columns once
DocsMD reads the standard schedule export your system already produces, maps its column names once, and uses date, time, provider, status, type, phone and value to detect cancellations, no-shows, open time and overdue patients. Patient texts carry only your practice name, times and numbered choices, never the patient's name or the reason for the visit. Every recovered visit lands in your weekly itemized report.
Questions
What if my export has no status column?
Look for a different version of the report, often called a detail or list report, or an option to include cancelled and missed appointments. Without status, cancellations and no-shows are invisible.
Should I include patient names?
A stable patient ID usually does the matching more reliably. Whether names are included depends on what your vendor needs to work with your front desk; whatever is shared should go only to a vendor under a Business Associate Agreement.
Do I need insurance or billing columns?
Not for finding and filling empty time. Coverage checks are a separate job and should use only what that job requires.
Why does my file show the date only once per day?
The report is formatted for printing, with dates as group headers. Look for a list or detail layout that repeats the date on every row, or a direct export to CSV option.