_81.appointments

Field Type Null Default Key Extra Comment
apt_id int(11) NO PRI auto_increment
apt_cus_id int(11) NO MUL
apt_cli_id int(11) NO MUL
apt_loc_id int(11) NO MUL
apt_pat_id int(11) NO MUL
apt_phy_id int(11) NO MUL
apt_rsc_id int(11) NO MUL
apt_are_id int(11) NO MUL
apt_type_id tinyint(1) NO 0
apt_ast_id int(11) NO MUL
apt_asr_id int(11) NO
apt_acs_id int(11) NO
apt_datestamp varchar(8) NO MUL
apt_datestamp_start bigint(12) unsigned NO MUL
apt_datestamp_end bigint(12) unsigned NO MUL
apt_duration char(4) NO 0
apt_rescheduled_date bigint(12) unsigned NO MUL
apt_original_apt_id int(11) NO 0 MUL Points to the original apt ID for a rescheduled apt
apt_arrival_time varchar(4) NO
apt_exit_waiting_time varchar(4) NO
apt_checkout_time varchar(4) NO
apt_complete_time varchar(4) NO
apt_rms_id int(11) NO MUL
apt_grp_id int(11) NO MUL
apt_enc_id int(11) NO MUL
apt_usr_id_created int(11) NO MUL
apt_usr_modified timestamp YES Timestamp for direct user modification
apt_usr_id_modified int(11) NO MUL
apt_note varchar(120) NO
apt_note2 varchar(120) NO
apt_incomplete char(1) NO 1 MUL
apt_ins1_id int(11) NO
apt_ins_verified char(1) NO
apt_ins_reject_reason varchar(255) NO
apt_ins_approved char(1) NO
apt_id_ext varchar(30) NO 0 MUL
apt_telehealth_session varchar(80) NO
apt_ths_id int(11) NO 0
apt_rec_apt_id int(11) YES 0 MUL The original appointment for a group of recurring appointments
apt_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
apt_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
apt_id
TableColumn
_1.appointment_recurrencearec_origin_apt_id
_1.appointments_remindersaptrem_apt_id
_1.appointments_requestsaptreq_linked_apt_id
_1.auditsaud_apt_id
_1.audits_archiveaud_apt_id
_1.patients_referralspref_apt_id
_1.recall_listrcl_apt_id
_1188.appointment_recurrencearec_origin_apt_id
_1188.appointments_remindersaptrem_apt_id
_1188.appointments_requestsaptreq_linked_apt_id
_1188.auditsaud_apt_id
_1188.audits_archiveaud_apt_id
_1188.patients_referralspref_apt_id
_1188.recall_listrcl_apt_id
_1218.appointment_recurrencearec_origin_apt_id
_1218.appointments_remindersaptrem_apt_id
_1218.appointments_requestsaptreq_linked_apt_id
_1218.auditsaud_apt_id
_1218.audits_archiveaud_apt_id
_1218.patients_referralspref_apt_id
_1218.recall_listrcl_apt_id
_1548.appointment_recurrencearec_origin_apt_id
_1548.appointments_remindersaptrem_apt_id
_1548.appointments_requestsaptreq_linked_apt_id
_1548.auditsaud_apt_id
_1548.audits_archiveaud_apt_id
_1548.patients_referralspref_apt_id
_1548.recall_listrcl_apt_id
_435.appointment_recurrencearec_origin_apt_id
_435.appointments_remindersaptrem_apt_id
_435.appointments_requestsaptreq_linked_apt_id
_435.auditsaud_apt_id
_435.audits_archiveaud_apt_id
_435.patients_referralspref_apt_id
_435.recall_listrcl_apt_id
_436.appointment_recurrencearec_origin_apt_id
_436.appointments_remindersaptrem_apt_id
_436.appointments_requestsaptreq_linked_apt_id
_436.auditsaud_apt_id
_436.audits_archiveaud_apt_id
_436.patients_referralspref_apt_id
_436.recall_listrcl_apt_id
_436_archive_testing.appointment_recurrencearec_origin_apt_id
_436_archive_testing.appointments_remindersaptrem_apt_id
_436_archive_testing.appointments_requestsaptreq_linked_apt_id
_436_archive_testing.auditsaud_apt_id
_436_archive_testing.audits_archiveaud_apt_id
_436_archive_testing.patients_referralspref_apt_id
_436_archive_testing.recall_listrcl_apt_id
_437.appointment_recurrencearec_origin_apt_id
_437.appointments_remindersaptrem_apt_id
_437.appointments_requestsaptreq_linked_apt_id
_437.auditsaud_apt_id
_437.audits_archiveaud_apt_id
_437.patients_referralspref_apt_id
_437.recall_listrcl_apt_id
_8.appointment_recurrencearec_origin_apt_id
_8.appointments_remindersaptrem_apt_id
_8.appointments_requestsaptreq_linked_apt_id
_8.auditsaud_apt_id
_8.audits_archiveaud_apt_id
_8.patients_referralspref_apt_id
_8.recall_listrcl_apt_id
_81.appointment_recurrencearec_origin_apt_id
_81.appointments_remindersaptrem_apt_id
_81.appointments_requestsaptreq_linked_apt_id
_81.auditsaud_apt_id
_81.audits_archiveaud_apt_id
_81.patients_referralspref_apt_id
_81.recall_listrcl_apt_id
_999.appointment_recurrencearec_origin_apt_id
_999.appointments_remindersaptrem_apt_id
_999.appointments_requestsaptreq_linked_apt_id
_999.auditsaud_apt_id
_999.audits_archiveaud_apt_id
_999.patients_referralspref_apt_id
_999.recall_listrcl_apt_id
common.ahi_auditsaud_apt_id
common.telehealth_codesthc_apt_id
common.telehealth_otpts_apt_id
apt_are_id
TableColumn
_1.appointment_recurrencearec_apt_are_id
_1188.appointment_recurrencearec_apt_are_id
_1218.appointment_recurrencearec_apt_are_id
_1548.appointment_recurrencearec_apt_are_id
_435.appointment_recurrencearec_apt_are_id
_436.appointment_recurrencearec_apt_are_id
_436_archive_testing.appointment_recurrencearec_apt_are_id
_437.appointment_recurrencearec_apt_are_id
_8.appointment_recurrencearec_apt_are_id
_81.appointment_recurrencearec_apt_are_id
_999.appointment_recurrencearec_apt_are_id
apt_type_id
TableColumn
_1.appointment_recurrencearec_apt_type_id
_1188.appointment_recurrencearec_apt_type_id
_1218.appointment_recurrencearec_apt_type_id
_1548.appointment_recurrencearec_apt_type_id
_435.appointment_recurrencearec_apt_type_id
_436.appointment_recurrencearec_apt_type_id
_436_archive_testing.appointment_recurrencearec_apt_type_id
_437.appointment_recurrencearec_apt_type_id
_8.appointment_recurrencearec_apt_type_id
_81.appointment_recurrencearec_apt_type_id
_999.appointment_recurrencearec_apt_type_id
apt_datestamp
TableColumn
_1.appointment_recurrencearec_apt_datestamp
_1.appointment_recurrencearec_apt_datestamp_start
_1.appointment_recurrencearec_apt_datestamp_end
_1188.appointment_recurrencearec_apt_datestamp
_1188.appointment_recurrencearec_apt_datestamp_start
_1188.appointment_recurrencearec_apt_datestamp_end
_1218.appointment_recurrencearec_apt_datestamp
_1218.appointment_recurrencearec_apt_datestamp_start
_1218.appointment_recurrencearec_apt_datestamp_end
_1548.appointment_recurrencearec_apt_datestamp
_1548.appointment_recurrencearec_apt_datestamp_start
_1548.appointment_recurrencearec_apt_datestamp_end
_435.appointment_recurrencearec_apt_datestamp
_435.appointment_recurrencearec_apt_datestamp_start
_435.appointment_recurrencearec_apt_datestamp_end
_436.appointment_recurrencearec_apt_datestamp
_436.appointment_recurrencearec_apt_datestamp_start
_436.appointment_recurrencearec_apt_datestamp_end
_436_archive_testing.appointment_recurrencearec_apt_datestamp
_436_archive_testing.appointment_recurrencearec_apt_datestamp_start
_436_archive_testing.appointment_recurrencearec_apt_datestamp_end
_437.appointment_recurrencearec_apt_datestamp
_437.appointment_recurrencearec_apt_datestamp_start
_437.appointment_recurrencearec_apt_datestamp_end
_8.appointment_recurrencearec_apt_datestamp
_8.appointment_recurrencearec_apt_datestamp_start
_8.appointment_recurrencearec_apt_datestamp_end
_81.appointment_recurrencearec_apt_datestamp
_81.appointment_recurrencearec_apt_datestamp_start
_81.appointment_recurrencearec_apt_datestamp_end
_999.appointment_recurrencearec_apt_datestamp
_999.appointment_recurrencearec_apt_datestamp_start
_999.appointment_recurrencearec_apt_datestamp_end
apt_duration
TableColumn
_1.appointment_recurrencearec_apt_duration
_1188.appointment_recurrencearec_apt_duration
_1218.appointment_recurrencearec_apt_duration
_1548.appointment_recurrencearec_apt_duration
_435.appointment_recurrencearec_apt_duration
_436.appointment_recurrencearec_apt_duration
_436_archive_testing.appointment_recurrencearec_apt_duration
_437.appointment_recurrencearec_apt_duration
_8.appointment_recurrencearec_apt_duration
_81.appointment_recurrencearec_apt_duration
_999.appointment_recurrencearec_apt_duration