Skip to main content

Flat File Integrations - Appointments

File Name​

When sending the file to the server it should be named using the following format: "appointments_{timestamp}.csv"

Which Data​

We support sending all future appointments up to 14 days in advance and all appointments that occurred in the previous 7 days

Data Fields​

NOTE: Please follow all field name and note formats, including case sensitivity.

ItemField nameFormatReq’dNotes
identifiersidentifiersIdentityYSee id format
mrnmrnstringYMRN of the patient this appointment belongs to
start timestartFHIR dateTimeYE.g. 2022-05-03T14:35:50 See https://www.hl7.org/fhir/datatypes.html#dateTime
durationminutesDurationintegerYDuration of the appointment in minutes.
statusstatusproposed | pendingbookedarrivedfulfilledcancellednoshowYSee https://www.hl7.org/fhir/valueset-appointmentstatus.html
Primary providerproviderIdstringY
OrganizationorganizationIdstringYThis will be used to tie the appointment to a care episode in the event careEpisode Id is not provided.
Episode of CarecareEpisodeIdstringnIf care episode integration is enabled
Service TypeserviceTypestringnSee https://www.hl7.org/fhir/valueset-service-type.html for default codeset, we can also handle other/custom codesets
42 CFR Part II statuscoveredBy42CfrPart2yes/noNValid “yes” values are “1”, “y”, “yes” and “true”. Valid “no” values are “0”, “n”,”no” and “false”.