aurora_standard.schmultior

Field	Type	Null
appt_time	time	YES
visit_no	int(11)	YES
level_care_id	int(11)	YES
number	int(11)	YES
procedure	varchar(50)	YES
notes	varchar(255)	YES
ane_id	int(11)	YES
surgery_room	int(11)	YES

References

Local Column

References

number

Table	Column
API.partner_accounts	phone_number
AzaleaStats.error_reports	err_source_line_number
EFaxes.efaxes_recipients	efr_number
HSPI_Bastrop.coverages	group_number
HSPI_Bastrop.coverages	policy_number
HSPI_Bastrop.locations	clia_number
HSPI_Bastrop.phone_numbers	phone_number
HSPI_CURES2015_B1.cbos_inventory_log	document_number
HSPI_CURES2015_B1.coverages	group_number
HSPI_CURES2015_B1.coverages	policy_number
HSPI_CURES2015_B1.locations	clia_number
HSPI_CURES2015_B1.phone_numbers	phone_number
HSPI_Central_Hospital.cbos_inventory_log	document_number
HSPI_Central_Hospital.coverages	group_number
HSPI_Central_Hospital.coverages	policy_number
HSPI_Central_Hospital.locations	clia_number
HSPI_Central_Hospital.phone_numbers	phone_number
HSPI_Dewitt.cbos_inventory_log	document_number
HSPI_Dewitt.coverages	group_number
HSPI_Dewitt.coverages	policy_number
HSPI_Dewitt.locations	clia_number
HSPI_Dewitt.phone_numbers	phone_number
HSPI_Fulton.cbos_inventory_log	document_number
HSPI_Fulton.coverages	group_number
HSPI_Fulton.coverages	policy_number
HSPI_Fulton.locations	clia_number
HSPI_Fulton.phone_numbers	phone_number
HSPI_Inferno.cbos_inventory_log	document_number
HSPI_Inferno.coverages	group_number
HSPI_Inferno.coverages	policy_number
HSPI_Inferno.locations	clia_number
HSPI_Inferno.phone_numbers	phone_number
HSPI_MU2015_E1.cbos_inventory_log	document_number
HSPI_MU2015_E1.coverages	group_number
HSPI_MU2015_E1.coverages	policy_number
HSPI_MU2015_E1.locations	clia_number
HSPI_MU2015_E1.phone_numbers	phone_number
HSPI_MU2015_G2.cbos_inventory_log	document_number
HSPI_MU2015_G2.coverages	group_number
HSPI_MU2015_G2.coverages	policy_number
HSPI_MU2015_G2.locations	clia_number
HSPI_MU2015_G2.phone_numbers	phone_number
HSPI_MU2015_G9.cbos_inventory_log	document_number
HSPI_MU2015_G9.coverages	group_number
HSPI_MU2015_G9.coverages	policy_number
HSPI_MU2015_G9.locations	clia_number
HSPI_MU2015_G9.phone_numbers	phone_number
HSPI_Ness.coverages	group_number
HSPI_Ness.coverages	policy_number
HSPI_Ness.phone_numbers	phone_number
HSPI_Sandbox.cbos_inventory_log	document_number
HSPI_Sandbox.coverages	group_number
HSPI_Sandbox.coverages	policy_number
HSPI_Sandbox.locations	clia_number
HSPI_Sandbox.phone_numbers	phone_number
HSPI_Summit_General.cbos_inventory_log	document_number
HSPI_Summit_General.coverages	group_number
HSPI_Summit_General.coverages	policy_number
HSPI_Summit_General.locations	clia_number
HSPI_Summit_General.phone_numbers	phone_number
HSPI_System.phone_numbers	phone_number
HSPI_United_Physicians.cbos_inventory_log	document_number
HSPI_United_Physicians.coverages	group_number
HSPI_United_Physicians.coverages	policy_number
HSPI_United_Physicians.locations	clia_number
HSPI_United_Physicians.phone_numbers	phone_number
MPI.cbos_inventory_log	document_number
MPI.coverages	group_number
MPI.coverages	policy_number
MPI.locations	clia_number
MPI.phone_numbers	phone_number
SSO.developer_profiles	phone_number
_1.client_contacts	clicon_fax_number
_1.encounters_claims_supplemental_informations	ecsi_control_number
_1.encounters_cpt_codes	ecp_prescription_number
_1.encounters_ub04	enc_ub04_81_a_number
_1.encounters_ub04	enc_ub04_81_b_number
_1.encounters_ub04	enc_ub04_81_c_number
_1.encounters_ub04	enc_ub04_81_d_number
_1.hl7_orders	ord_group_number
_1.inventory	inv_lot_number
_1.inventory	inv_product_number
_1.patients	pat_emergency_number
_1.patients_demographics_snapshots	pds_emergency_number
_1.patients_histories	ph_enc_version_number
_1.patients_inventory	pinv_lot_number
_1.patients_inventory	pinv_product_number
_1.patients_prescriptions	prx_order_number
_1188.client_contacts	clicon_fax_number
_1188.encounters_claims_supplemental_informations	ecsi_control_number
_1188.encounters_cpt_codes	ecp_prescription_number
_1188.encounters_ub04	enc_ub04_81_a_number
_1188.encounters_ub04	enc_ub04_81_b_number
_1188.encounters_ub04	enc_ub04_81_c_number
_1188.encounters_ub04	enc_ub04_81_d_number
_1188.hl7_orders	ord_group_number
_1188.inventory	inv_lot_number
_1188.inventory	inv_product_number
_1188.patients	pat_emergency_number
_1188.patients_demographics_snapshots	pds_emergency_number
_1188.patients_histories	ph_enc_version_number
_1188.patients_inventory	pinv_lot_number
_1188.patients_inventory	pinv_product_number
_1188.patients_prescriptions	prx_order_number
_1218.client_contacts	clicon_fax_number
_1218.encounters_claims_supplemental_informations	ecsi_control_number
_1218.encounters_cpt_codes	ecp_prescription_number
_1218.encounters_ub04	enc_ub04_81_a_number
_1218.encounters_ub04	enc_ub04_81_b_number
_1218.encounters_ub04	enc_ub04_81_c_number
_1218.encounters_ub04	enc_ub04_81_d_number
_1218.hl7_orders	ord_group_number
_1218.inventory	inv_lot_number
_1218.inventory	inv_product_number
_1218.patients	pat_emergency_number
_1218.patients_demographics_snapshots	pds_emergency_number
_1218.patients_histories	ph_enc_version_number
_1218.patients_inventory	pinv_lot_number
_1218.patients_inventory	pinv_product_number
_1218.patients_prescriptions	prx_order_number
_1548.client_contacts	clicon_fax_number
_1548.encounters_claims_supplemental_informations	ecsi_control_number
_1548.encounters_cpt_codes	ecp_prescription_number
_1548.encounters_ub04	enc_ub04_81_a_number
_1548.encounters_ub04	enc_ub04_81_b_number
_1548.encounters_ub04	enc_ub04_81_c_number
_1548.encounters_ub04	enc_ub04_81_d_number
_1548.hl7_orders	ord_group_number
_1548.inventory	inv_lot_number
_1548.inventory	inv_product_number
_1548.patients	pat_emergency_number
_1548.patients_demographics_snapshots	pds_emergency_number
_1548.patients_histories	ph_enc_version_number
_1548.patients_inventory	pinv_lot_number
_1548.patients_inventory	pinv_product_number
_1548.patients_prescriptions	prx_order_number
_435.client_contacts	clicon_fax_number
_435.encounters_claims_supplemental_informations	ecsi_control_number
_435.encounters_cpt_codes	ecp_prescription_number
_435.encounters_ub04	enc_ub04_81_a_number
_435.encounters_ub04	enc_ub04_81_b_number
_435.encounters_ub04	enc_ub04_81_c_number
_435.encounters_ub04	enc_ub04_81_d_number
_435.hl7_orders	ord_group_number
_435.inventory	inv_lot_number
_435.inventory	inv_product_number
_435.patients	pat_emergency_number
_435.patients_demographics_snapshots	pds_emergency_number
_435.patients_histories	ph_enc_version_number
_435.patients_inventory	pinv_lot_number
_435.patients_inventory	pinv_product_number
_435.patients_prescriptions	prx_order_number
_436.client_contacts	clicon_fax_number
_436.encounters_claims_supplemental_informations	ecsi_control_number
_436.encounters_cpt_codes	ecp_prescription_number
_436.encounters_ub04	enc_ub04_81_a_number
_436.encounters_ub04	enc_ub04_81_b_number
_436.encounters_ub04	enc_ub04_81_c_number
_436.encounters_ub04	enc_ub04_81_d_number
_436.hl7_orders	ord_group_number
_436.inventory	inv_lot_number
_436.inventory	inv_product_number
_436.patients	pat_emergency_number
_436.patients_demographics_snapshots	pds_emergency_number
_436.patients_histories	ph_enc_version_number
_436.patients_inventory	pinv_lot_number
_436.patients_inventory	pinv_product_number
_436.patients_prescriptions	prx_order_number
_436_archive_testing.client_contacts	clicon_fax_number
_436_archive_testing.encounters_claims_supplemental_informations	ecsi_control_number
_436_archive_testing.encounters_cpt_codes	ecp_prescription_number
_436_archive_testing.encounters_ub04	enc_ub04_81_a_number
_436_archive_testing.encounters_ub04	enc_ub04_81_b_number
_436_archive_testing.encounters_ub04	enc_ub04_81_c_number
_436_archive_testing.encounters_ub04	enc_ub04_81_d_number
_436_archive_testing.hl7_orders	ord_group_number
_436_archive_testing.inventory	inv_lot_number
_436_archive_testing.inventory	inv_product_number
_436_archive_testing.patients	pat_emergency_number
_436_archive_testing.patients_demographics_snapshots	pds_emergency_number
_436_archive_testing.patients_histories	ph_enc_version_number
_436_archive_testing.patients_inventory	pinv_lot_number
_436_archive_testing.patients_inventory	pinv_product_number
_436_archive_testing.patients_prescriptions	prx_order_number
_437.client_contacts	clicon_fax_number
_437.encounters_claims_supplemental_informations	ecsi_control_number
_437.encounters_cpt_codes	ecp_prescription_number
_437.encounters_ub04	enc_ub04_81_a_number
_437.encounters_ub04	enc_ub04_81_b_number
_437.encounters_ub04	enc_ub04_81_c_number
_437.encounters_ub04	enc_ub04_81_d_number
_437.hl7_orders	ord_group_number
_437.inventory	inv_lot_number
_437.inventory	inv_product_number
_437.patients	pat_emergency_number
_437.patients_demographics_snapshots	pds_emergency_number
_437.patients_histories	ph_enc_version_number
_437.patients_inventory	pinv_lot_number
_437.patients_inventory	pinv_product_number
_437.patients_prescriptions	prx_order_number
_8.client_contacts	clicon_fax_number
_8.encounters_claims_supplemental_informations	ecsi_control_number
_8.encounters_cpt_codes	ecp_prescription_number
_8.encounters_ub04	enc_ub04_81_a_number
_8.encounters_ub04	enc_ub04_81_b_number
_8.encounters_ub04	enc_ub04_81_c_number
_8.encounters_ub04	enc_ub04_81_d_number
_8.hl7_orders	ord_group_number
_8.inventory	inv_lot_number
_8.inventory	inv_product_number
_8.patients	pat_emergency_number
_8.patients_demographics_snapshots	pds_emergency_number
_8.patients_histories	ph_enc_version_number
_8.patients_inventory	pinv_lot_number
_8.patients_inventory	pinv_product_number
_8.patients_prescriptions	prx_order_number
_81.client_contacts	clicon_fax_number
_81.encounters_claims_supplemental_informations	ecsi_control_number
_81.encounters_cpt_codes	ecp_prescription_number
_81.encounters_ub04	enc_ub04_81_a_number
_81.encounters_ub04	enc_ub04_81_b_number
_81.encounters_ub04	enc_ub04_81_c_number
_81.encounters_ub04	enc_ub04_81_d_number
_81.hl7_orders	ord_group_number
_81.inventory	inv_lot_number
_81.inventory	inv_product_number
_81.patients	pat_emergency_number
_81.patients_demographics_snapshots	pds_emergency_number
_81.patients_histories	ph_enc_version_number
_81.patients_inventory	pinv_lot_number
_81.patients_inventory	pinv_product_number
_81.patients_prescriptions	prx_order_number
_999.client_contacts	clicon_fax_number
_999.encounters_claims_supplemental_informations	ecsi_control_number
_999.encounters_cpt_codes	ecp_prescription_number
_999.encounters_ub04	enc_ub04_81_a_number
_999.encounters_ub04	enc_ub04_81_b_number
_999.encounters_ub04	enc_ub04_81_c_number
_999.encounters_ub04	enc_ub04_81_d_number
_999.hl7_orders	ord_group_number
_999.inventory	inv_lot_number
_999.inventory	inv_product_number
_999.patients	pat_emergency_number
_999.patients_demographics_snapshots	pds_emergency_number
_999.patients_histories	ph_enc_version_number
_999.patients_inventory	pinv_lot_number
_999.patients_inventory	pinv_product_number
_999.patients_prescriptions	prx_order_number
aurora_standard.acptwrk	cpt_number
aurora_standard.acptwrk	dec_number
aurora_standard.addcdm	dept_number
aurora_standard.b2badd	mr_number
aurora_standard.bhbadd	mr_number
aurora_standard.bhldgr	mr_number
aurora_standard.bhphybak	mr_number
aurora_standard.bhtldgr	mr_number
aurora_standard.caadj	gl_number
aurora_standard.cachrg	gl_number
aurora_standard.cachrg2	gl_number
aurora_standard.cachrgca	gl_number
aurora_standard.cachrgevo	gl_number
aurora_standard.canullchrg	gl_number
aurora_standard.capay	gl_number
aurora_standard.caroom	gl_number
aurora_standard.cgsinptr	auto_number
aurora_standard.chcimmuc	join_number
aurora_standard.chcmanuc	join_number
aurora_standard.chcprovc	join_number
aurora_standard.chcseric	join_number
aurora_standard.chm15chd	phys_number
aurora_standard.chm835ps	svc_number
aurora_standard.chmbatex	mc_number
aurora_standard.chmblogd	seq_number
aurora_standard.chmmbc37	policy_number
aurora_standard.chmmbc37	ocna_number
aurora_standard.chmmbc50	payor_number
aurora_standard.chmmbc51	check_number
aurora_standard.chmmhbcr	check_number
aurora_standard.chmmneca	orig_number
aurora_standard.chmpatmd	mr_number
aurora_standard.chmphync	mr_number
aurora_standard.chmpress	client_number
aurora_standard.chpcobrd	cobra_number
aurora_standard.chpemphd	seq_number
aurora_standard.chpliced	license_number
aurora_standard.chpparba	cus_number
aurora_standard.chqcardd	phy_number
aurora_standard.chqchekd	phy_number
aurora_standard.chqchrtd	phy_number
aurora_standard.chqcmeud	phy_number
aurora_standard.chqletrd	phy_number
aurora_standard.chqliabd	phy_number
aurora_standard.chqlicnd	license_number
aurora_standard.chqlicnd	phy_number
aurora_standard.chqnpdbd	phy_number
aurora_standard.chqphync	phy_number
aurora_standard.chqstafd	phy_number
aurora_standard.chrdfile	id_number
aurora_standard.chtclokd	inc_number
aurora_standard.hhtclokd	inc_number
aurora_standard.oeorder	phy_number
aurora_standard.stfasstr	po_number
aurora_standard.stonwall	dept_number
aurora_standard.stpapckv	document_number
aurora_standard.stpapckv	posting_number
aurora_standard.stpapckv	check_number
aurora_standard.stpapckv	account_number
aurora_standard.stxerord	err_number
aurora_standard.stxerorh	err_number
aurora_standard.stxhelpd	hlp_number
aurora_standard.stxmssgr	mssg_number
aurora_standard.stycntrc	ein_number
aurora_standard.stycntrc	state_number
aurora_standard.stycntrc	suta_number
aurora_standard.stydeddv	document_number
aurora_standard.stydeddv	check_number
aurora_standard.stydeddv	empl_acct_number
aurora_standard.styempid	inc_number
aurora_standard.styincdv	document_number
aurora_standard.styincdv	check_number
aurora_standard.styobldv	document_number
aurora_standard.styobldv	check_number
aurora_standard.styoctcc	gov_entity_id_number
aurora_standard.styoctcc	form_1095c_number
aurora_standard.styoctcc	ale_form_1095c_number
aurora_standard.stypddrd	trace_number
aurora_standard.styptodv	document_number
aurora_standard.styrtimd	inc_number
aurora_standard.stytimed	inc_number
aurora_standard.stytypid	inc_number
aurora_standard.stywtwoe	state_number
aurora_standard.stywtwoe	local_number
aurora_standard.timetabl	inc_number
aurora_standard.timetabl_in	inc_number
aurora_standard.tmpmrrpt	control_number
aurora_standard.vault_relationships	relationship_code_number
common.appointments_clienttell_statuses	acs_number
common.card_connect_merchant_accounts	ccma_hsn_number
common.card_connect_merchant_devices_map	ccmdm_hsn_number
common.faxes	fax_number
xlnt.builds	bamboo_build_number
xlnt.selenium_test_queue	build_number
xlnt.selenium_test_results	build_number

notes

Table	Column
_1.appointments_requests	aptreq_notes
_1.charts_medications	cm_notes
_1.charts_procedures	cp_notes
_1.encounters	enc_notes
_1.encounters_soap	esp_notes
_1.encounters_soap_templates	est_notes
_1.encounters_soap_vitals	espv_notes
_1.inventory	inv_notes
_1.patients	pat_notes
_1.patients	pat_popup_notes
_1.patients_demographics_snapshots	pds_notes
_1.patients_demographics_snapshots	pds_popup_notes
_1.patients_enrollments	pert_notes
_1.patients_immunizations	pim_admin_notes
_1.patients_inventory	pinv_administered_notes
_1.patients_medications	pms_notes
_1.patients_payments_ledger_map	pplm_notes
_1.patients_prescriptions	prx_notes
_1.patients_vitals	pvs_notes
_1.precerts	pre_notes
_1.soaps	soap_notes
_1188.appointments_requests	aptreq_notes
_1188.charts_medications	cm_notes
_1188.charts_procedures	cp_notes
_1188.encounters	enc_notes
_1188.encounters_soap	esp_notes
_1188.encounters_soap_templates	est_notes
_1188.encounters_soap_vitals	espv_notes
_1188.inventory	inv_notes
_1188.patients	pat_notes
_1188.patients	pat_popup_notes
_1188.patients_demographics_snapshots	pds_notes
_1188.patients_demographics_snapshots	pds_popup_notes
_1188.patients_enrollments	pert_notes
_1188.patients_immunizations	pim_admin_notes
_1188.patients_inventory	pinv_administered_notes
_1188.patients_medications	pms_notes
_1188.patients_payments_ledger_map	pplm_notes
_1188.patients_prescriptions	prx_notes
_1188.patients_vitals	pvs_notes
_1188.precerts	pre_notes
_1188.soaps	soap_notes
_1218.appointments_requests	aptreq_notes
_1218.charts_medications	cm_notes
_1218.charts_procedures	cp_notes
_1218.encounters	enc_notes
_1218.encounters_soap	esp_notes
_1218.encounters_soap_templates	est_notes
_1218.encounters_soap_vitals	espv_notes
_1218.inventory	inv_notes
_1218.patients	pat_notes
_1218.patients	pat_popup_notes
_1218.patients_demographics_snapshots	pds_notes
_1218.patients_demographics_snapshots	pds_popup_notes
_1218.patients_enrollments	pert_notes
_1218.patients_immunizations	pim_admin_notes
_1218.patients_inventory	pinv_administered_notes
_1218.patients_medications	pms_notes
_1218.patients_payments_ledger_map	pplm_notes
_1218.patients_prescriptions	prx_notes
_1218.patients_vitals	pvs_notes
_1218.precerts	pre_notes
_1218.soaps	soap_notes
_1548.appointments_requests	aptreq_notes
_1548.charts_medications	cm_notes
_1548.charts_procedures	cp_notes
_1548.encounters	enc_notes
_1548.encounters_soap	esp_notes
_1548.encounters_soap_templates	est_notes
_1548.encounters_soap_vitals	espv_notes
_1548.inventory	inv_notes
_1548.patients	pat_notes
_1548.patients	pat_popup_notes
_1548.patients_demographics_snapshots	pds_notes
_1548.patients_demographics_snapshots	pds_popup_notes
_1548.patients_enrollments	pert_notes
_1548.patients_immunizations	pim_admin_notes
_1548.patients_inventory	pinv_administered_notes
_1548.patients_medications	pms_notes
_1548.patients_payments_ledger_map	pplm_notes
_1548.patients_prescriptions	prx_notes
_1548.patients_vitals	pvs_notes
_1548.precerts	pre_notes
_1548.soaps	soap_notes
_435.appointments_requests	aptreq_notes
_435.charts_medications	cm_notes
_435.charts_procedures	cp_notes
_435.encounters	enc_notes
_435.encounters_soap	esp_notes
_435.encounters_soap_templates	est_notes
_435.encounters_soap_vitals	espv_notes
_435.inventory	inv_notes
_435.patients	pat_notes
_435.patients	pat_popup_notes
_435.patients_demographics_snapshots	pds_notes
_435.patients_demographics_snapshots	pds_popup_notes
_435.patients_enrollments	pert_notes
_435.patients_immunizations	pim_admin_notes
_435.patients_inventory	pinv_administered_notes
_435.patients_medications	pms_notes
_435.patients_payments_ledger_map	pplm_notes
_435.patients_prescriptions	prx_notes
_435.patients_vitals	pvs_notes
_435.precerts	pre_notes
_435.soaps	soap_notes
_436.appointments_requests	aptreq_notes
_436.charts_medications	cm_notes
_436.charts_procedures	cp_notes
_436.encounters	enc_notes
_436.encounters_soap	esp_notes
_436.encounters_soap_templates	est_notes
_436.encounters_soap_vitals	espv_notes
_436.inventory	inv_notes
_436.patients	pat_notes
_436.patients	pat_popup_notes
_436.patients_demographics_snapshots	pds_notes
_436.patients_demographics_snapshots	pds_popup_notes
_436.patients_enrollments	pert_notes
_436.patients_immunizations	pim_admin_notes
_436.patients_inventory	pinv_administered_notes
_436.patients_medications	pms_notes
_436.patients_payments_ledger_map	pplm_notes
_436.patients_prescriptions	prx_notes
_436.patients_vitals	pvs_notes
_436.precerts	pre_notes
_436.soaps	soap_notes
_436_archive_testing.appointments_requests	aptreq_notes
_436_archive_testing.charts_medications	cm_notes
_436_archive_testing.charts_procedures	cp_notes
_436_archive_testing.encounters	enc_notes
_436_archive_testing.encounters_soap	esp_notes
_436_archive_testing.encounters_soap_templates	est_notes
_436_archive_testing.encounters_soap_vitals	espv_notes
_436_archive_testing.inventory	inv_notes
_436_archive_testing.patients	pat_notes
_436_archive_testing.patients	pat_popup_notes
_436_archive_testing.patients_demographics_snapshots	pds_notes
_436_archive_testing.patients_demographics_snapshots	pds_popup_notes
_436_archive_testing.patients_enrollments	pert_notes
_436_archive_testing.patients_immunizations	pim_admin_notes
_436_archive_testing.patients_inventory	pinv_administered_notes
_436_archive_testing.patients_medications	pms_notes
_436_archive_testing.patients_payments_ledger_map	pplm_notes
_436_archive_testing.patients_prescriptions	prx_notes
_436_archive_testing.patients_vitals	pvs_notes
_436_archive_testing.precerts	pre_notes
_436_archive_testing.soaps	soap_notes
_437.appointments_requests	aptreq_notes
_437.charts_medications	cm_notes
_437.charts_procedures	cp_notes
_437.encounters	enc_notes
_437.encounters_soap	esp_notes
_437.encounters_soap_templates	est_notes
_437.encounters_soap_vitals	espv_notes
_437.inventory	inv_notes
_437.patients	pat_notes
_437.patients	pat_popup_notes
_437.patients_demographics_snapshots	pds_notes
_437.patients_demographics_snapshots	pds_popup_notes
_437.patients_enrollments	pert_notes
_437.patients_immunizations	pim_admin_notes
_437.patients_inventory	pinv_administered_notes
_437.patients_medications	pms_notes
_437.patients_payments_ledger_map	pplm_notes
_437.patients_prescriptions	prx_notes
_437.patients_vitals	pvs_notes
_437.precerts	pre_notes
_437.soaps	soap_notes
_8.appointments_requests	aptreq_notes
_8.charts_medications	cm_notes
_8.charts_procedures	cp_notes
_8.encounters	enc_notes
_8.encounters_soap	esp_notes
_8.encounters_soap_templates	est_notes
_8.encounters_soap_vitals	espv_notes
_8.inventory	inv_notes
_8.patients	pat_notes
_8.patients	pat_popup_notes
_8.patients_demographics_snapshots	pds_notes
_8.patients_demographics_snapshots	pds_popup_notes
_8.patients_enrollments	pert_notes
_8.patients_immunizations	pim_admin_notes
_8.patients_inventory	pinv_administered_notes
_8.patients_medications	pms_notes
_8.patients_payments_ledger_map	pplm_notes
_8.patients_prescriptions	prx_notes
_8.patients_vitals	pvs_notes
_8.precerts	pre_notes
_8.soaps	soap_notes
_81.appointments_requests	aptreq_notes
_81.charts_medications	cm_notes
_81.charts_procedures	cp_notes
_81.encounters	enc_notes
_81.encounters_soap	esp_notes
_81.encounters_soap_templates	est_notes
_81.encounters_soap_vitals	espv_notes
_81.inventory	inv_notes
_81.patients	pat_notes
_81.patients	pat_popup_notes
_81.patients_demographics_snapshots	pds_notes
_81.patients_demographics_snapshots	pds_popup_notes
_81.patients_enrollments	pert_notes
_81.patients_immunizations	pim_admin_notes
_81.patients_inventory	pinv_administered_notes
_81.patients_medications	pms_notes
_81.patients_payments_ledger_map	pplm_notes
_81.patients_prescriptions	prx_notes
_81.patients_vitals	pvs_notes
_81.precerts	pre_notes
_81.soaps	soap_notes
_999.appointments_requests	aptreq_notes
_999.charts_medications	cm_notes
_999.charts_procedures	cp_notes
_999.encounters	enc_notes
_999.encounters_soap	esp_notes
_999.encounters_soap_templates	est_notes
_999.encounters_soap_vitals	espv_notes
_999.inventory	inv_notes
_999.patients	pat_notes
_999.patients	pat_popup_notes
_999.patients_demographics_snapshots	pds_notes
_999.patients_demographics_snapshots	pds_popup_notes
_999.patients_enrollments	pert_notes
_999.patients_immunizations	pim_admin_notes
_999.patients_inventory	pinv_administered_notes
_999.patients_medications	pms_notes
_999.patients_payments_ledger_map	pplm_notes
_999.patients_prescriptions	prx_notes
_999.patients_vitals	pvs_notes
_999.precerts	pre_notes
_999.soaps	soap_notes
aurora_standard.bookmarks	user_notes
aurora_standard.chmbened	i_send_prog_notes
aurora_standard.chmbened	o_send_prog_notes
aurora_standard.chmcolac	all_notes
aurora_standard.chmibend	r_send_prog_notes
aurora_standard.stucntrc	print_notes
common.clients_contract_data	ccd_termination_notes
common.clients_contract_data	ccd_follow_up_notes
common.clients_contract_data	ccd_finance_notes
common.clients_contract_data	ccd_at_risk_notes
common.contacts	con_notes
common.enrollments_options	ertop_notes
common.leads_vendors_map	lvm_notes
common.vaccines	vac_notes
common.vaccines_manufacturers	mvx_notes
template_library.encounters_soap_templates	est_notes

procedure

Table	Column
_1.encounters_soap	esp_procedure
_1.encounters_soap_templates	est_procedure
_1.soaps	soap_procedure
_1188.encounters_soap	esp_procedure
_1188.encounters_soap_templates	est_procedure
_1188.soaps	soap_procedure
_1218.encounters_soap	esp_procedure
_1218.encounters_soap_templates	est_procedure
_1218.soaps	soap_procedure
_1548.encounters_soap	esp_procedure
_1548.encounters_soap_templates	est_procedure
_1548.soaps	soap_procedure
_435.encounters_soap	esp_procedure
_435.encounters_soap_templates	est_procedure
_435.soaps	soap_procedure
_436.encounters_soap	esp_procedure
_436.encounters_soap_templates	est_procedure
_436.soaps	soap_procedure
_436_archive_testing.encounters_soap	esp_procedure
_436_archive_testing.encounters_soap_templates	est_procedure
_436_archive_testing.soaps	soap_procedure
_437.encounters_soap	esp_procedure
_437.encounters_soap_templates	est_procedure
_437.soaps	soap_procedure
_8.encounters_soap	esp_procedure
_8.encounters_soap_templates	est_procedure
_8.soaps	soap_procedure
_81.encounters_soap	esp_procedure
_81.encounters_soap_templates	est_procedure
_81.soaps	soap_procedure
_999.encounters_soap	esp_procedure
_999.encounters_soap_templates	est_procedure
_999.soaps	soap_procedure
aurora_standard.schprocedurc	nxt_procedure
template_library.encounters_soap_templates	est_procedure

visit_no

Table	Column
aurora_standard.anotesd	an_visit_no
aurora_standard.bdfiled	bd_visit_no
aurora_standard.chmarsi	pat_visit_no
aurora_standard.chmcampi	pat_visit_no
aurora_standard.chmcombr	to_visit_no
aurora_standard.chmexmpi	pat_visit_no
aurora_standard.chmokipd	pat_visit_no
aurora_standard.chmokopd	pat_visit_no
aurora_standard.chmraded	pat_visit_no
aurora_standard.chmradex	pat_visit_no
aurora_standard.chrcombr	to_visit_no
aurora_standard.ncexmpi	pat_visit_no

appt_time

Table	Column
aurora_standard.schapptmastr	actual_appt_time