Appointment

The <Appointment> element contains all the information relative to the scheduled appointment. All <Appointment> elements are nested within a single <Appointments> tag.

Element	Description	Type	Notes
appt_no	appointment number	int
serv_no	service number	int
pro_no	provider number	int
LocationID	location number	int
ins_no	insurance number	int
appt_name	patient name	nvarchar
appt_phone	patient phone	nvarchar
appt_address	patient address number	nvarchar
appt_notes	free-form notes	ntext
appt_date	appointment date	datetime
appt_start_time	appointment start time	datetime
appt_end_time	appointment end time	datetime
appt_dayofweek	appoint day	int	May be blank
appt_color	appointment color code	int
appt_cancel_ind	canceled indicator	bit
appt_confirmed_ind	confirmed indicator	bit
appt_left_msg_ind	message left indicator	bit
appt_no_answer_ind	no-answer indicator	bit
appt_show_ind	show/no-show indicator	bit
appt_new_pat_ind	new patient indicator	bit
appt_pre_appointment	preappointment indicator	bit
appt_conf_inits	number of confirmations	int	May be blank
appt_resched_count	number of rescheduled appointments	int	May be blank
appt_Om_no	patient number	int	key data
appt_Other_Ins_Name	Secondary insurance name	nvarchar	May be blank
appt_Workphone	patient's work phone	nvarchar
recorded_by	last edited by	int	staff member's ID
recorded_date	edit date	datetime
created_by	created by	int	Sstaff member's ID
created_date	created date	datetime
EligibilityFileName	eligibility filename	nvarchar
AuthFileName	authorization filename	nvarchar
appt_CellNumber	patient's cell phone number	nvarchar
app_icon_1	service icon	int	May be blank
app_icon_2	service icon	int	May be blank
app_icon_3	service icon	int	May be blank
app_recur_pattern	recurrance pattern ID	smallint
app_recur_enddate	recurrance end date	datetime
appt_deleted_ind	deleted indicator	bit
appt_recur_range	recurrance range	smallint
appt_recur_end_Occurence	recurrance end date	datetime
appt_recur_daily_pattern	recurrance daily pattern	smallint
appt_recur_weekly_pattern	recurrance weekly pattern	smallint
appt_recur_monthly_pattern	recurrance monthly pattern	smallint
appt_recurs_every	recurrance frequency	smallint
appt_recur_month_day	recurrance day of month	smallint
appt_recur_day_type	recurrance day type	smallint
appt_recur_day_month_type	recurrance day of month type	smallint
appt_recur_weekly_day	recurrance day of week	smallint
app_icon_4	service icon	int
recurringAppointmentID	recurring appointment ID	int
isRecurrenceVariance	recurrance indicator	bit