Appointments Import

This wiki page is to document how appointment data needs to be constructed in order to import using WebChart’s Schedule Import Tool.

  • File format: Data file shall be formated in Comma Separated Values (CSV).
  • The first row of the file shall contain column header information.
  • Each subsequent row shall represent an appointment.

Column Definition

The appointment column definition shall contain all columns listed below regardless if there is a value or not.

  • R = Required
  • R* = Only one of these is required
  • O = Optional
NameTypeRequiredComments
patient.partitionchar 15OMRN group partition
patient.MRNchar 50Ochart identifier, a Medical Record Number
sched.Resourceint 10 unsignedRId of resource patient will see (the import tool limits the appointment to one resource)
sched.Start DatedatetimeRDate and time the appointment starts (YYYYMMDD HHMMSS)
sched.End DatedatetimeR*Date and time the appointment ends (YYYYMMDD HHMMSS)
sched.Due DatedatetimeODate and time the appointment must be completed by (YYYYMMDD HHMMSS)
sched.Durationint 10 unsignedR*Duration of the appointment in seconds
sched.ReasonmediumtextOThe reason for the appointment (EG: patient's cheif complaint)
sched.Locationchar 10OWhere the location takes place; can be a code (EG: OFFICE) or the description (EG: Office)
sched.Type1char 15OType of appointment; EG: Office Visit Established, Procedure, Well Child Exam
sched.Type2char 75OType of appointment
sched.Type3int 5OType of appointment
sched.Type4int 10OType of appointment
sched.CommentmediumtextOGeneral appointment comments/notes
sched.Canceledint 10 unsignedOFlags appointment as cancelled; 0=not cancelled; 1=cancelled; 2=patient did not show
sched.Cancel Codechar 10OReason why the appointment was cancelled; EG: No Show, Patient Cancelled
sched.Cancel DatedatetimeODate that the appointment was canceled. (YYYYMMDD HHMMSS)
sched.Confirmedint 10 unsignedO0 (no) or 1 (yes) to indicate whether or not the appointment has been confirmed with the patient
sched.Confirm Userint 11 unsignedOID of the user who confirmed the appointment
sched.Confirm DatedatetimeODate that the appointment was confirmed. (YYYYMMDD HHMMSS)
sched.Contactchar 30OField for the name of the provider who called in the appointment
sched.Contact Numberchar 30OField for the phone number of contact who called in the appointment

Sample CSV files

Here are sample CSV files to download and view in a text editor or a spreadsheet program.

1 Basic appointment - File:Schedulesample1.csv

1 Mulitple appointments - File:Schedulesample2.csv


WebChart Documentation

Last Updated:

Last Build: Tue, 18 Jun 2024 18:57:35 EDT
WikiGDrive Version: dd69069d725fca5f553df7ded62e130a49d49ca6