aurora_standard.customer

Field	Type	Null	Key	Extra
customer_num	bigint(20) unsigned	NO	PRI	auto_increment
fname	varchar(15)	YES
lname	varchar(15)	YES
company	varchar(20)	YES
address1	varchar(20)	YES
address2	varchar(20)	YES
city	varchar(15)	YES
state	varchar(2)	YES
zipcode	varchar(5)	YES
phone	varchar(18)	YES

References

Local Column

References

fname

Table	Column
Azalea.employees	emp_fname
_1.billing_providers	bp_fname
_1.charts	chrt_fname
_1.client_contacts	clicon_fname
_1.cpoe_responses	cpoe_res_fname
_1.donors	don_fname
_1.encounters	enc_fname
_1.encounters_soap_templates	est_phy_fname
_1.hl7_accessions	acc_fname
_1.non_patients	npat_fname
_1.orders	ord_fname
_1.patient_next_of_kin	pnk_fname
_1.patients	pat_fname
_1.patients	pat_birth_fname
_1.patients_demographics_snapshots	pds_fname
_1.patients_names	pn_fname
_1.patients_responsibility_estimates	prest_fname
_1.physicians	phy_fname
_1.precerts	pre_fname
_1.radiology_orders	rad_fname
_1.radiology_results	rad_res_fname
_1188.billing_providers	bp_fname
_1188.charts	chrt_fname
_1188.client_contacts	clicon_fname
_1188.cpoe_responses	cpoe_res_fname
_1188.donors	don_fname
_1188.encounters	enc_fname
_1188.encounters_soap_templates	est_phy_fname
_1188.hl7_accessions	acc_fname
_1188.non_patients	npat_fname
_1188.orders	ord_fname
_1188.patient_next_of_kin	pnk_fname
_1188.patients	pat_fname
_1188.patients	pat_birth_fname
_1188.patients_demographics_snapshots	pds_fname
_1188.patients_names	pn_fname
_1188.patients_responsibility_estimates	prest_fname
_1188.physicians	phy_fname
_1188.precerts	pre_fname
_1188.radiology_orders	rad_fname
_1188.radiology_results	rad_res_fname
_1218.billing_providers	bp_fname
_1218.charts	chrt_fname
_1218.client_contacts	clicon_fname
_1218.cpoe_responses	cpoe_res_fname
_1218.donors	don_fname
_1218.encounters	enc_fname
_1218.encounters_soap_templates	est_phy_fname
_1218.hl7_accessions	acc_fname
_1218.non_patients	npat_fname
_1218.orders	ord_fname
_1218.patient_next_of_kin	pnk_fname
_1218.patients	pat_fname
_1218.patients	pat_birth_fname
_1218.patients_demographics_snapshots	pds_fname
_1218.patients_names	pn_fname
_1218.patients_responsibility_estimates	prest_fname
_1218.physicians	phy_fname
_1218.precerts	pre_fname
_1218.radiology_orders	rad_fname
_1218.radiology_results	rad_res_fname
_1548.billing_providers	bp_fname
_1548.charts	chrt_fname
_1548.client_contacts	clicon_fname
_1548.cpoe_responses	cpoe_res_fname
_1548.donors	don_fname
_1548.encounters	enc_fname
_1548.encounters_soap_templates	est_phy_fname
_1548.hl7_accessions	acc_fname
_1548.non_patients	npat_fname
_1548.orders	ord_fname
_1548.patient_next_of_kin	pnk_fname
_1548.patients	pat_fname
_1548.patients	pat_birth_fname
_1548.patients_demographics_snapshots	pds_fname
_1548.patients_names	pn_fname
_1548.patients_responsibility_estimates	prest_fname
_1548.physicians	phy_fname
_1548.precerts	pre_fname
_1548.radiology_orders	rad_fname
_1548.radiology_results	rad_res_fname
_435.billing_providers	bp_fname
_435.charts	chrt_fname
_435.client_contacts	clicon_fname
_435.cpoe_responses	cpoe_res_fname
_435.donors	don_fname
_435.encounters	enc_fname
_435.encounters_soap_templates	est_phy_fname
_435.hl7_accessions	acc_fname
_435.non_patients	npat_fname
_435.orders	ord_fname
_435.patient_next_of_kin	pnk_fname
_435.patients	pat_fname
_435.patients	pat_birth_fname
_435.patients_demographics_snapshots	pds_fname
_435.patients_names	pn_fname
_435.patients_responsibility_estimates	prest_fname
_435.physicians	phy_fname
_435.precerts	pre_fname
_435.radiology_orders	rad_fname
_435.radiology_results	rad_res_fname
_436.billing_providers	bp_fname
_436.charts	chrt_fname
_436.client_contacts	clicon_fname
_436.cpoe_responses	cpoe_res_fname
_436.donors	don_fname
_436.encounters	enc_fname
_436.encounters_soap_templates	est_phy_fname
_436.hl7_accessions	acc_fname
_436.non_patients	npat_fname
_436.orders	ord_fname
_436.patient_next_of_kin	pnk_fname
_436.patients	pat_fname
_436.patients	pat_birth_fname
_436.patients_demographics_snapshots	pds_fname
_436.patients_names	pn_fname
_436.patients_responsibility_estimates	prest_fname
_436.physicians	phy_fname
_436.precerts	pre_fname
_436.radiology_orders	rad_fname
_436.radiology_results	rad_res_fname
_436_archive_testing.billing_providers	bp_fname
_436_archive_testing.charts	chrt_fname
_436_archive_testing.client_contacts	clicon_fname
_436_archive_testing.cpoe_responses	cpoe_res_fname
_436_archive_testing.donors	don_fname
_436_archive_testing.encounters	enc_fname
_436_archive_testing.encounters_soap_templates	est_phy_fname
_436_archive_testing.hl7_accessions	acc_fname
_436_archive_testing.non_patients	npat_fname
_436_archive_testing.orders	ord_fname
_436_archive_testing.patient_next_of_kin	pnk_fname
_436_archive_testing.patients	pat_fname
_436_archive_testing.patients	pat_birth_fname
_436_archive_testing.patients_demographics_snapshots	pds_fname
_436_archive_testing.patients_responsibility_estimates	prest_fname
_436_archive_testing.physicians	phy_fname
_436_archive_testing.precerts	pre_fname
_436_archive_testing.radiology_orders	rad_fname
_436_archive_testing.radiology_results	rad_res_fname
_437.billing_providers	bp_fname
_437.charts	chrt_fname
_437.client_contacts	clicon_fname
_437.cpoe_responses	cpoe_res_fname
_437.donors	don_fname
_437.encounters	enc_fname
_437.encounters_soap_templates	est_phy_fname
_437.hl7_accessions	acc_fname
_437.non_patients	npat_fname
_437.orders	ord_fname
_437.patient_next_of_kin	pnk_fname
_437.patients	pat_fname
_437.patients	pat_birth_fname
_437.patients_demographics_snapshots	pds_fname
_437.patients_names	pn_fname
_437.patients_responsibility_estimates	prest_fname
_437.physicians	phy_fname
_437.precerts	pre_fname
_437.radiology_orders	rad_fname
_437.radiology_results	rad_res_fname
_8.billing_providers	bp_fname
_8.charts	chrt_fname
_8.client_contacts	clicon_fname
_8.cpoe_responses	cpoe_res_fname
_8.donors	don_fname
_8.encounters	enc_fname
_8.encounters_soap_templates	est_phy_fname
_8.hl7_accessions	acc_fname
_8.non_patients	npat_fname
_8.orders	ord_fname
_8.patient_next_of_kin	pnk_fname
_8.patients	pat_fname
_8.patients	pat_birth_fname
_8.patients_demographics_snapshots	pds_fname
_8.patients_names	pn_fname
_8.patients_responsibility_estimates	prest_fname
_8.physicians	phy_fname
_8.precerts	pre_fname
_8.radiology_orders	rad_fname
_8.radiology_results	rad_res_fname
_81.billing_providers	bp_fname
_81.charts	chrt_fname
_81.client_contacts	clicon_fname
_81.cpoe_responses	cpoe_res_fname
_81.donors	don_fname
_81.encounters	enc_fname
_81.encounters_soap_templates	est_phy_fname
_81.hl7_accessions	acc_fname
_81.non_patients	npat_fname
_81.orders	ord_fname
_81.patient_next_of_kin	pnk_fname
_81.patients	pat_fname
_81.patients	pat_birth_fname
_81.patients_demographics_snapshots	pds_fname
_81.patients_names	pn_fname
_81.patients_responsibility_estimates	prest_fname
_81.physicians	phy_fname
_81.precerts	pre_fname
_81.radiology_orders	rad_fname
_81.radiology_results	rad_res_fname
_999.billing_providers	bp_fname
_999.charts	chrt_fname
_999.client_contacts	clicon_fname
_999.cpoe_responses	cpoe_res_fname
_999.donors	don_fname
_999.encounters	enc_fname
_999.encounters_soap_templates	est_phy_fname
_999.hl7_accessions	acc_fname
_999.non_patients	npat_fname
_999.orders	ord_fname
_999.patient_next_of_kin	pnk_fname
_999.patients	pat_fname
_999.patients	pat_birth_fname
_999.patients_demographics_snapshots	pds_fname
_999.patients_names	pn_fname
_999.patients_responsibility_estimates	prest_fname
_999.physicians	phy_fname
_999.precerts	pre_fname
_999.radiology_orders	rad_fname
_999.radiology_results	rad_res_fname
aurora_standard.abmmpi	gu_fname
aurora_standard.abmmpi	n1_fname
aurora_standard.abmmpi	n2_fname
aurora_standard.abmvis	gu_fname
aurora_standard.bhar	g_fname
aurora_standard.bmnkin	n_fname
aurora_standard.bpar	g_fname
aurora_standard.bpar2	g_fname
aurora_standard.c7mpi	gu_fname
aurora_standard.chmarstph	att_fname
aurora_standard.chmarstph	sur_fname
aurora_standard.chmarstph	oth_fname
aurora_standard.chmarstph	oth2_fname
aurora_standard.chmarstpo	att_fname
aurora_standard.chmarstpo	sur_fname
aurora_standard.chmarstpo	oth_fname
aurora_standard.chmarstpo	oth2_fname
aurora_standard.chmhcahp	dr_fname
aurora_standard.chmlastr	pat_fname
aurora_standard.chmlastr	adm_phy_fname
aurora_standard.chmlastr	rnd_phy_fname
aurora_standard.chmlastr	ref_phy_fname
aurora_standard.chmlastr	att_phy_fname
aurora_standard.chmlastr	op_phy_fname
aurora_standard.chmlastr	oth_phy_fname
aurora_standard.chmlastr	sub_fname
aurora_standard.chmpdemo	p_fname
aurora_standard.chmpdemo	sp_fname
aurora_standard.chmpdemo	gu_fname
aurora_standard.chmpdemo	fam_phy_fname
aurora_standard.chmpdemo	attend_phy_fname
aurora_standard.chmpdemo	admit_phy_fname
aurora_standard.chmpsvcd	rend_fname
aurora_standard.chmpsvcd	ref_fname
aurora_standard.chmtxstr	pat_fname
aurora_standard.chmtxstr	att_phy_fname
aurora_standard.chmtxstr	op_phy_fname
aurora_standard.chmtxstr	cons_phy_fname
aurora_standard.styoctcc	contact_fname
aurora_standard.styoctcc	gov_entity_contact_person_fname
aurora_standard.styoempd	depend_fname
aurora_standard.styoempr	empl_fname
common.applicants	app_fname
common.contacts	con_fname
common.dashboardmd_users	dmdu_fname
common.users	usr_fname
template_library.encounters_soap_templates	est_phy_fname

lname

Table	Column
Azalea.employees	emp_lname
_1.billing_providers	bp_lname
_1.charts	chrt_lname
_1.client_contacts	clicon_lname
_1.cpoe_responses	cpoe_res_lname
_1.donors	don_lname
_1.encounters	enc_lname
_1.encounters_soap_templates	est_phy_lname
_1.hl7_accessions	acc_lname
_1.non_patients	npat_lname
_1.orders	ord_lname
_1.patient_next_of_kin	pnk_lname
_1.patients	pat_lname
_1.patients	pat_birth_lname
_1.patients_demographics_snapshots	pds_lname
_1.patients_names	pn_lname
_1.patients_responsibility_estimates	prest_lname
_1.physicians	phy_lname
_1.precerts	pre_lname
_1.radiology_orders	rad_lname
_1.radiology_results	rad_res_lname
_1188.billing_providers	bp_lname
_1188.charts	chrt_lname
_1188.client_contacts	clicon_lname
_1188.cpoe_responses	cpoe_res_lname
_1188.donors	don_lname
_1188.encounters	enc_lname
_1188.encounters_soap_templates	est_phy_lname
_1188.hl7_accessions	acc_lname
_1188.non_patients	npat_lname
_1188.orders	ord_lname
_1188.patient_next_of_kin	pnk_lname
_1188.patients	pat_lname
_1188.patients	pat_birth_lname
_1188.patients_demographics_snapshots	pds_lname
_1188.patients_names	pn_lname
_1188.patients_responsibility_estimates	prest_lname
_1188.physicians	phy_lname
_1188.precerts	pre_lname
_1188.radiology_orders	rad_lname
_1188.radiology_results	rad_res_lname
_1218.billing_providers	bp_lname
_1218.charts	chrt_lname
_1218.client_contacts	clicon_lname
_1218.cpoe_responses	cpoe_res_lname
_1218.donors	don_lname
_1218.encounters	enc_lname
_1218.encounters_soap_templates	est_phy_lname
_1218.hl7_accessions	acc_lname
_1218.non_patients	npat_lname
_1218.orders	ord_lname
_1218.patient_next_of_kin	pnk_lname
_1218.patients	pat_lname
_1218.patients	pat_birth_lname
_1218.patients_demographics_snapshots	pds_lname
_1218.patients_names	pn_lname
_1218.patients_responsibility_estimates	prest_lname
_1218.physicians	phy_lname
_1218.precerts	pre_lname
_1218.radiology_orders	rad_lname
_1218.radiology_results	rad_res_lname
_1548.billing_providers	bp_lname
_1548.charts	chrt_lname
_1548.client_contacts	clicon_lname
_1548.cpoe_responses	cpoe_res_lname
_1548.donors	don_lname
_1548.encounters	enc_lname
_1548.encounters_soap_templates	est_phy_lname
_1548.hl7_accessions	acc_lname
_1548.non_patients	npat_lname
_1548.orders	ord_lname
_1548.patient_next_of_kin	pnk_lname
_1548.patients	pat_lname
_1548.patients	pat_birth_lname
_1548.patients_demographics_snapshots	pds_lname
_1548.patients_names	pn_lname
_1548.patients_responsibility_estimates	prest_lname
_1548.physicians	phy_lname
_1548.precerts	pre_lname
_1548.radiology_orders	rad_lname
_1548.radiology_results	rad_res_lname
_435.billing_providers	bp_lname
_435.charts	chrt_lname
_435.client_contacts	clicon_lname
_435.cpoe_responses	cpoe_res_lname
_435.donors	don_lname
_435.encounters	enc_lname
_435.encounters_soap_templates	est_phy_lname
_435.hl7_accessions	acc_lname
_435.non_patients	npat_lname
_435.orders	ord_lname
_435.patient_next_of_kin	pnk_lname
_435.patients	pat_lname
_435.patients	pat_birth_lname
_435.patients_demographics_snapshots	pds_lname
_435.patients_names	pn_lname
_435.patients_responsibility_estimates	prest_lname
_435.physicians	phy_lname
_435.precerts	pre_lname
_435.radiology_orders	rad_lname
_435.radiology_results	rad_res_lname
_436.billing_providers	bp_lname
_436.charts	chrt_lname
_436.client_contacts	clicon_lname
_436.cpoe_responses	cpoe_res_lname
_436.donors	don_lname
_436.encounters	enc_lname
_436.encounters_soap_templates	est_phy_lname
_436.hl7_accessions	acc_lname
_436.non_patients	npat_lname
_436.orders	ord_lname
_436.patient_next_of_kin	pnk_lname
_436.patients	pat_lname
_436.patients	pat_birth_lname
_436.patients_demographics_snapshots	pds_lname
_436.patients_names	pn_lname
_436.patients_responsibility_estimates	prest_lname
_436.physicians	phy_lname
_436.precerts	pre_lname
_436.radiology_orders	rad_lname
_436.radiology_results	rad_res_lname
_436_archive_testing.billing_providers	bp_lname
_436_archive_testing.charts	chrt_lname
_436_archive_testing.client_contacts	clicon_lname
_436_archive_testing.cpoe_responses	cpoe_res_lname
_436_archive_testing.donors	don_lname
_436_archive_testing.encounters	enc_lname
_436_archive_testing.encounters_soap_templates	est_phy_lname
_436_archive_testing.hl7_accessions	acc_lname
_436_archive_testing.non_patients	npat_lname
_436_archive_testing.orders	ord_lname
_436_archive_testing.patient_next_of_kin	pnk_lname
_436_archive_testing.patients	pat_lname
_436_archive_testing.patients	pat_birth_lname
_436_archive_testing.patients_demographics_snapshots	pds_lname
_436_archive_testing.patients_responsibility_estimates	prest_lname
_436_archive_testing.physicians	phy_lname
_436_archive_testing.precerts	pre_lname
_436_archive_testing.radiology_orders	rad_lname
_436_archive_testing.radiology_results	rad_res_lname
_437.billing_providers	bp_lname
_437.charts	chrt_lname
_437.client_contacts	clicon_lname
_437.cpoe_responses	cpoe_res_lname
_437.donors	don_lname
_437.encounters	enc_lname
_437.encounters_soap_templates	est_phy_lname
_437.hl7_accessions	acc_lname
_437.non_patients	npat_lname
_437.orders	ord_lname
_437.patient_next_of_kin	pnk_lname
_437.patients	pat_lname
_437.patients	pat_birth_lname
_437.patients_demographics_snapshots	pds_lname
_437.patients_names	pn_lname
_437.patients_responsibility_estimates	prest_lname
_437.physicians	phy_lname
_437.precerts	pre_lname
_437.radiology_orders	rad_lname
_437.radiology_results	rad_res_lname
_8.billing_providers	bp_lname
_8.charts	chrt_lname
_8.client_contacts	clicon_lname
_8.cpoe_responses	cpoe_res_lname
_8.donors	don_lname
_8.encounters	enc_lname
_8.encounters_soap_templates	est_phy_lname
_8.hl7_accessions	acc_lname
_8.non_patients	npat_lname
_8.orders	ord_lname
_8.patient_next_of_kin	pnk_lname
_8.patients	pat_lname
_8.patients	pat_birth_lname
_8.patients_demographics_snapshots	pds_lname
_8.patients_names	pn_lname
_8.patients_responsibility_estimates	prest_lname
_8.physicians	phy_lname
_8.precerts	pre_lname
_8.radiology_orders	rad_lname
_8.radiology_results	rad_res_lname
_81.billing_providers	bp_lname
_81.charts	chrt_lname
_81.client_contacts	clicon_lname
_81.cpoe_responses	cpoe_res_lname
_81.donors	don_lname
_81.encounters	enc_lname
_81.encounters_soap_templates	est_phy_lname
_81.hl7_accessions	acc_lname
_81.non_patients	npat_lname
_81.orders	ord_lname
_81.patient_next_of_kin	pnk_lname
_81.patients	pat_lname
_81.patients	pat_birth_lname
_81.patients_demographics_snapshots	pds_lname
_81.patients_names	pn_lname
_81.patients_responsibility_estimates	prest_lname
_81.physicians	phy_lname
_81.precerts	pre_lname
_81.radiology_orders	rad_lname
_81.radiology_results	rad_res_lname
_999.billing_providers	bp_lname
_999.charts	chrt_lname
_999.client_contacts	clicon_lname
_999.cpoe_responses	cpoe_res_lname
_999.donors	don_lname
_999.encounters	enc_lname
_999.encounters_soap_templates	est_phy_lname
_999.hl7_accessions	acc_lname
_999.non_patients	npat_lname
_999.orders	ord_lname
_999.patient_next_of_kin	pnk_lname
_999.patients	pat_lname
_999.patients	pat_birth_lname
_999.patients_demographics_snapshots	pds_lname
_999.patients_names	pn_lname
_999.patients_responsibility_estimates	prest_lname
_999.physicians	phy_lname
_999.precerts	pre_lname
_999.radiology_orders	rad_lname
_999.radiology_results	rad_res_lname
aurora_standard.abmmpi	gu_lname
aurora_standard.abmmpi	n1_lname
aurora_standard.abmmpi	n2_lname
aurora_standard.abmvis	gu_lname
aurora_standard.bhar	g_lname
aurora_standard.bmnkin	n_lname
aurora_standard.bpar	g_lname
aurora_standard.bpar2	g_lname
aurora_standard.c7mpi	gu_lname
aurora_standard.chmarstph	att_lname
aurora_standard.chmarstph	sur_lname
aurora_standard.chmarstph	oth_lname
aurora_standard.chmarstph	oth2_lname
aurora_standard.chmarstpo	att_lname
aurora_standard.chmarstpo	sur_lname
aurora_standard.chmarstpo	oth_lname
aurora_standard.chmarstpo	oth2_lname
aurora_standard.chmhcahp	dr_lname
aurora_standard.chmlastr	pat_lname
aurora_standard.chmlastr	adm_phy_lname
aurora_standard.chmlastr	rnd_phy_lname
aurora_standard.chmlastr	ref_phy_lname
aurora_standard.chmlastr	att_phy_lname
aurora_standard.chmlastr	op_phy_lname
aurora_standard.chmlastr	oth_phy_lname
aurora_standard.chmlastr	sub_lname
aurora_standard.chmlastr	oth_sub_lname
aurora_standard.chmpdemo	p_lname
aurora_standard.chmpdemo	sp_lname
aurora_standard.chmpdemo	gu_lname
aurora_standard.chmpdemo	fam_phy_lname
aurora_standard.chmpdemo	attend_phy_lname
aurora_standard.chmpdemo	admit_phy_lname
aurora_standard.chmpsvcd	rend_lname
aurora_standard.chmpsvcd	ref_lname
aurora_standard.chmtxstr	pat_lname
aurora_standard.chmtxstr	att_phy_lname
aurora_standard.chmtxstr	op_phy_lname
aurora_standard.chmtxstr	cons_phy_lname
aurora_standard.styoctcc	contact_lname
aurora_standard.styoctcc	gov_entity_contact_person_lname
aurora_standard.styoempd	depend_lname
aurora_standard.styoempr	empl_lname
common.applicants	app_lname
common.contacts	con_lname
common.dashboardmd_users	dmdu_lname
common.users	usr_lname
template_library.encounters_soap_templates	est_phy_lname

address1

Table	Column
Azalea.employees	emp_address1
_1.billing_providers	bp_address1
_1.buildings	bld_address1
_1.charts	chrt_address1
_1.client_contacts	clicon_address1
_1.encounters	enc_address1
_1.encounters	enc_employer_address1
_1.encounters	enc_guarantor_address1
_1.hl7_lab_locations	hll_address1
_1.insurances	ins_address1
_1.insurances_claims_centers	icc_address1
_1.locations	loc_address1
_1.non_patients	npat_address1
_1.orders	ord_address1
_1.patient_next_of_kin	pnk_address1
_1.patients	pat_address1
_1.patients	pat_employer_address1
_1.patients	pat_guarantor_address1
_1.patients	pat_emergency_address1
_1.patients_demographics_snapshots	pds_address1
_1.patients_demographics_snapshots	pds_employer_address1
_1.patients_demographics_snapshots	pds_guarantor_address1
_1.physicians	phy_address1
_1.precerts	pre_address1
_1.precerts	pre_employer_address1
_1.precerts	pre_guarantor_address1
_1.radiology_orders	rad_address1
_1188.billing_providers	bp_address1
_1188.buildings	bld_address1
_1188.charts	chrt_address1
_1188.client_contacts	clicon_address1
_1188.encounters	enc_address1
_1188.encounters	enc_employer_address1
_1188.encounters	enc_guarantor_address1
_1188.hl7_lab_locations	hll_address1
_1188.insurances	ins_address1
_1188.insurances_claims_centers	icc_address1
_1188.locations	loc_address1
_1188.non_patients	npat_address1
_1188.orders	ord_address1
_1188.patient_next_of_kin	pnk_address1
_1188.patients	pat_address1
_1188.patients	pat_employer_address1
_1188.patients	pat_guarantor_address1
_1188.patients	pat_emergency_address1
_1188.patients_demographics_snapshots	pds_address1
_1188.patients_demographics_snapshots	pds_employer_address1
_1188.patients_demographics_snapshots	pds_guarantor_address1
_1188.physicians	phy_address1
_1188.precerts	pre_address1
_1188.precerts	pre_employer_address1
_1188.precerts	pre_guarantor_address1
_1188.radiology_orders	rad_address1
_1218.billing_providers	bp_address1
_1218.buildings	bld_address1
_1218.charts	chrt_address1
_1218.client_contacts	clicon_address1
_1218.encounters	enc_address1
_1218.encounters	enc_employer_address1
_1218.encounters	enc_guarantor_address1
_1218.hl7_lab_locations	hll_address1
_1218.insurances	ins_address1
_1218.insurances_claims_centers	icc_address1
_1218.locations	loc_address1
_1218.non_patients	npat_address1
_1218.orders	ord_address1
_1218.patient_next_of_kin	pnk_address1
_1218.patients	pat_address1
_1218.patients	pat_employer_address1
_1218.patients	pat_guarantor_address1
_1218.patients	pat_emergency_address1
_1218.patients_demographics_snapshots	pds_address1
_1218.patients_demographics_snapshots	pds_employer_address1
_1218.patients_demographics_snapshots	pds_guarantor_address1
_1218.physicians	phy_address1
_1218.precerts	pre_address1
_1218.precerts	pre_employer_address1
_1218.precerts	pre_guarantor_address1
_1218.radiology_orders	rad_address1
_1548.billing_providers	bp_address1
_1548.buildings	bld_address1
_1548.charts	chrt_address1
_1548.client_contacts	clicon_address1
_1548.encounters	enc_address1
_1548.encounters	enc_employer_address1
_1548.encounters	enc_guarantor_address1
_1548.hl7_lab_locations	hll_address1
_1548.insurances	ins_address1
_1548.insurances_claims_centers	icc_address1
_1548.locations	loc_address1
_1548.non_patients	npat_address1
_1548.orders	ord_address1
_1548.patient_next_of_kin	pnk_address1
_1548.patients	pat_address1
_1548.patients	pat_employer_address1
_1548.patients	pat_guarantor_address1
_1548.patients	pat_emergency_address1
_1548.patients_demographics_snapshots	pds_address1
_1548.patients_demographics_snapshots	pds_employer_address1
_1548.patients_demographics_snapshots	pds_guarantor_address1
_1548.physicians	phy_address1
_1548.precerts	pre_address1
_1548.precerts	pre_employer_address1
_1548.precerts	pre_guarantor_address1
_1548.radiology_orders	rad_address1
_435.billing_providers	bp_address1
_435.buildings	bld_address1
_435.charts	chrt_address1
_435.client_contacts	clicon_address1
_435.encounters	enc_address1
_435.encounters	enc_employer_address1
_435.encounters	enc_guarantor_address1
_435.hl7_lab_locations	hll_address1
_435.insurances	ins_address1
_435.insurances_claims_centers	icc_address1
_435.locations	loc_address1
_435.non_patients	npat_address1
_435.orders	ord_address1
_435.patient_next_of_kin	pnk_address1
_435.patients	pat_address1
_435.patients	pat_employer_address1
_435.patients	pat_guarantor_address1
_435.patients	pat_emergency_address1
_435.patients_demographics_snapshots	pds_address1
_435.patients_demographics_snapshots	pds_employer_address1
_435.patients_demographics_snapshots	pds_guarantor_address1
_435.physicians	phy_address1
_435.precerts	pre_address1
_435.precerts	pre_employer_address1
_435.precerts	pre_guarantor_address1
_435.radiology_orders	rad_address1
_436.billing_providers	bp_address1
_436.buildings	bld_address1
_436.charts	chrt_address1
_436.client_contacts	clicon_address1
_436.encounters	enc_address1
_436.encounters	enc_employer_address1
_436.encounters	enc_guarantor_address1
_436.hl7_lab_locations	hll_address1
_436.insurances	ins_address1
_436.insurances_claims_centers	icc_address1
_436.locations	loc_address1
_436.non_patients	npat_address1
_436.orders	ord_address1
_436.patient_next_of_kin	pnk_address1
_436.patients	pat_address1
_436.patients	pat_employer_address1
_436.patients	pat_guarantor_address1
_436.patients	pat_emergency_address1
_436.patients_demographics_snapshots	pds_address1
_436.patients_demographics_snapshots	pds_employer_address1
_436.patients_demographics_snapshots	pds_guarantor_address1
_436.physicians	phy_address1
_436.precerts	pre_address1
_436.precerts	pre_employer_address1
_436.precerts	pre_guarantor_address1
_436.radiology_orders	rad_address1
_436_archive_testing.billing_providers	bp_address1
_436_archive_testing.buildings	bld_address1
_436_archive_testing.charts	chrt_address1
_436_archive_testing.client_contacts	clicon_address1
_436_archive_testing.encounters	enc_address1
_436_archive_testing.encounters	enc_employer_address1
_436_archive_testing.encounters	enc_guarantor_address1
_436_archive_testing.hl7_lab_locations	hll_address1
_436_archive_testing.insurances	ins_address1
_436_archive_testing.insurances_claims_centers	icc_address1
_436_archive_testing.locations	loc_address1
_436_archive_testing.non_patients	npat_address1
_436_archive_testing.orders	ord_address1
_436_archive_testing.patient_next_of_kin	pnk_address1
_436_archive_testing.patients	pat_address1
_436_archive_testing.patients	pat_employer_address1
_436_archive_testing.patients	pat_guarantor_address1
_436_archive_testing.patients	pat_emergency_address1
_436_archive_testing.patients_demographics_snapshots	pds_address1
_436_archive_testing.patients_demographics_snapshots	pds_employer_address1
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_address1
_436_archive_testing.physicians	phy_address1
_436_archive_testing.precerts	pre_address1
_436_archive_testing.precerts	pre_employer_address1
_436_archive_testing.precerts	pre_guarantor_address1
_436_archive_testing.radiology_orders	rad_address1
_437.billing_providers	bp_address1
_437.buildings	bld_address1
_437.charts	chrt_address1
_437.client_contacts	clicon_address1
_437.encounters	enc_address1
_437.encounters	enc_employer_address1
_437.encounters	enc_guarantor_address1
_437.hl7_lab_locations	hll_address1
_437.insurances	ins_address1
_437.insurances_claims_centers	icc_address1
_437.locations	loc_address1
_437.non_patients	npat_address1
_437.orders	ord_address1
_437.patient_next_of_kin	pnk_address1
_437.patients	pat_address1
_437.patients	pat_employer_address1
_437.patients	pat_guarantor_address1
_437.patients	pat_emergency_address1
_437.patients_demographics_snapshots	pds_address1
_437.patients_demographics_snapshots	pds_employer_address1
_437.patients_demographics_snapshots	pds_guarantor_address1
_437.physicians	phy_address1
_437.precerts	pre_address1
_437.precerts	pre_employer_address1
_437.precerts	pre_guarantor_address1
_437.radiology_orders	rad_address1
_8.billing_providers	bp_address1
_8.buildings	bld_address1
_8.charts	chrt_address1
_8.client_contacts	clicon_address1
_8.encounters	enc_address1
_8.encounters	enc_employer_address1
_8.encounters	enc_guarantor_address1
_8.hl7_lab_locations	hll_address1
_8.insurances	ins_address1
_8.insurances_claims_centers	icc_address1
_8.locations	loc_address1
_8.non_patients	npat_address1
_8.orders	ord_address1
_8.patient_next_of_kin	pnk_address1
_8.patients	pat_address1
_8.patients	pat_employer_address1
_8.patients	pat_guarantor_address1
_8.patients	pat_emergency_address1
_8.patients_demographics_snapshots	pds_address1
_8.patients_demographics_snapshots	pds_employer_address1
_8.patients_demographics_snapshots	pds_guarantor_address1
_8.physicians	phy_address1
_8.precerts	pre_address1
_8.precerts	pre_employer_address1
_8.precerts	pre_guarantor_address1
_8.radiology_orders	rad_address1
_81.billing_providers	bp_address1
_81.buildings	bld_address1
_81.charts	chrt_address1
_81.client_contacts	clicon_address1
_81.encounters	enc_address1
_81.encounters	enc_employer_address1
_81.encounters	enc_guarantor_address1
_81.hl7_lab_locations	hll_address1
_81.insurances	ins_address1
_81.insurances_claims_centers	icc_address1
_81.locations	loc_address1
_81.non_patients	npat_address1
_81.orders	ord_address1
_81.patient_next_of_kin	pnk_address1
_81.patients	pat_address1
_81.patients	pat_employer_address1
_81.patients	pat_guarantor_address1
_81.patients	pat_emergency_address1
_81.patients_demographics_snapshots	pds_address1
_81.patients_demographics_snapshots	pds_employer_address1
_81.patients_demographics_snapshots	pds_guarantor_address1
_81.physicians	phy_address1
_81.precerts	pre_address1
_81.precerts	pre_employer_address1
_81.precerts	pre_guarantor_address1
_81.radiology_orders	rad_address1
_999.billing_providers	bp_address1
_999.buildings	bld_address1
_999.charts	chrt_address1
_999.client_contacts	clicon_address1
_999.encounters	enc_address1
_999.encounters	enc_employer_address1
_999.encounters	enc_guarantor_address1
_999.hl7_lab_locations	hll_address1
_999.insurances	ins_address1
_999.insurances_claims_centers	icc_address1
_999.locations	loc_address1
_999.non_patients	npat_address1
_999.orders	ord_address1
_999.patient_next_of_kin	pnk_address1
_999.patients	pat_address1
_999.patients	pat_employer_address1
_999.patients	pat_guarantor_address1
_999.patients	pat_emergency_address1
_999.patients_demographics_snapshots	pds_address1
_999.patients_demographics_snapshots	pds_employer_address1
_999.patients_demographics_snapshots	pds_guarantor_address1
_999.physicians	phy_address1
_999.precerts	pre_address1
_999.precerts	pre_employer_address1
_999.precerts	pre_guarantor_address1
_999.radiology_orders	rad_address1
common.clients	cli_address1
common.clients	cli_billing_address1
common.clients	cli_mailing_address1
common.clients_contract_data	ccd_payer_address1
common.contacts	con_address1
common.customers	cus_address1
common.customers	cus_billing_address1
common.lab_interfaces	lif_cli_address1
common.lab_interfaces_performing_sites	lips_address1
common.labs	lab_address1
common.leads	lea_address1

address2

Table	Column
Azalea.employees	emp_address2
_1.billing_providers	bp_address2
_1.buildings	bld_address2
_1.charts	chrt_address2
_1.client_contacts	clicon_address2
_1.encounters	enc_address2
_1.encounters	enc_employer_address2
_1.encounters	enc_guarantor_address2
_1.hl7_lab_locations	hll_address2
_1.insurances	ins_address2
_1.insurances_claims_centers	icc_address2
_1.locations	loc_address2
_1.non_patients	npat_address2
_1.orders	ord_address2
_1.patient_next_of_kin	pnk_address2
_1.patients	pat_address2
_1.patients	pat_employer_address2
_1.patients	pat_guarantor_address2
_1.patients	pat_emergency_address2
_1.patients_demographics_snapshots	pds_address2
_1.patients_demographics_snapshots	pds_guarantor_address2
_1.physicians	phy_address2
_1.precerts	pre_address2
_1.precerts	pre_guarantor_address2
_1.radiology_orders	rad_address2
_1188.billing_providers	bp_address2
_1188.buildings	bld_address2
_1188.charts	chrt_address2
_1188.client_contacts	clicon_address2
_1188.encounters	enc_address2
_1188.encounters	enc_employer_address2
_1188.encounters	enc_guarantor_address2
_1188.hl7_lab_locations	hll_address2
_1188.insurances	ins_address2
_1188.insurances_claims_centers	icc_address2
_1188.locations	loc_address2
_1188.non_patients	npat_address2
_1188.orders	ord_address2
_1188.patient_next_of_kin	pnk_address2
_1188.patients	pat_address2
_1188.patients	pat_employer_address2
_1188.patients	pat_guarantor_address2
_1188.patients	pat_emergency_address2
_1188.patients_demographics_snapshots	pds_address2
_1188.patients_demographics_snapshots	pds_guarantor_address2
_1188.physicians	phy_address2
_1188.precerts	pre_address2
_1188.precerts	pre_guarantor_address2
_1188.radiology_orders	rad_address2
_1218.billing_providers	bp_address2
_1218.buildings	bld_address2
_1218.charts	chrt_address2
_1218.client_contacts	clicon_address2
_1218.encounters	enc_address2
_1218.encounters	enc_employer_address2
_1218.encounters	enc_guarantor_address2
_1218.hl7_lab_locations	hll_address2
_1218.insurances	ins_address2
_1218.insurances_claims_centers	icc_address2
_1218.locations	loc_address2
_1218.non_patients	npat_address2
_1218.orders	ord_address2
_1218.patient_next_of_kin	pnk_address2
_1218.patients	pat_address2
_1218.patients	pat_employer_address2
_1218.patients	pat_guarantor_address2
_1218.patients	pat_emergency_address2
_1218.patients_demographics_snapshots	pds_address2
_1218.patients_demographics_snapshots	pds_guarantor_address2
_1218.physicians	phy_address2
_1218.precerts	pre_address2
_1218.precerts	pre_guarantor_address2
_1218.radiology_orders	rad_address2
_1548.billing_providers	bp_address2
_1548.buildings	bld_address2
_1548.charts	chrt_address2
_1548.client_contacts	clicon_address2
_1548.encounters	enc_address2
_1548.encounters	enc_employer_address2
_1548.encounters	enc_guarantor_address2
_1548.hl7_lab_locations	hll_address2
_1548.insurances	ins_address2
_1548.insurances_claims_centers	icc_address2
_1548.locations	loc_address2
_1548.non_patients	npat_address2
_1548.orders	ord_address2
_1548.patient_next_of_kin	pnk_address2
_1548.patients	pat_address2
_1548.patients	pat_employer_address2
_1548.patients	pat_guarantor_address2
_1548.patients	pat_emergency_address2
_1548.patients_demographics_snapshots	pds_address2
_1548.patients_demographics_snapshots	pds_guarantor_address2
_1548.physicians	phy_address2
_1548.precerts	pre_address2
_1548.precerts	pre_guarantor_address2
_1548.radiology_orders	rad_address2
_435.billing_providers	bp_address2
_435.buildings	bld_address2
_435.charts	chrt_address2
_435.client_contacts	clicon_address2
_435.encounters	enc_address2
_435.encounters	enc_employer_address2
_435.encounters	enc_guarantor_address2
_435.hl7_lab_locations	hll_address2
_435.insurances	ins_address2
_435.insurances_claims_centers	icc_address2
_435.locations	loc_address2
_435.non_patients	npat_address2
_435.orders	ord_address2
_435.patient_next_of_kin	pnk_address2
_435.patients	pat_address2
_435.patients	pat_employer_address2
_435.patients	pat_guarantor_address2
_435.patients	pat_emergency_address2
_435.patients_demographics_snapshots	pds_address2
_435.patients_demographics_snapshots	pds_guarantor_address2
_435.physicians	phy_address2
_435.precerts	pre_address2
_435.precerts	pre_guarantor_address2
_435.radiology_orders	rad_address2
_436.billing_providers	bp_address2
_436.buildings	bld_address2
_436.charts	chrt_address2
_436.client_contacts	clicon_address2
_436.encounters	enc_address2
_436.encounters	enc_employer_address2
_436.encounters	enc_guarantor_address2
_436.hl7_lab_locations	hll_address2
_436.insurances	ins_address2
_436.insurances_claims_centers	icc_address2
_436.locations	loc_address2
_436.non_patients	npat_address2
_436.orders	ord_address2
_436.patient_next_of_kin	pnk_address2
_436.patients	pat_address2
_436.patients	pat_employer_address2
_436.patients	pat_guarantor_address2
_436.patients	pat_emergency_address2
_436.patients_demographics_snapshots	pds_address2
_436.patients_demographics_snapshots	pds_guarantor_address2
_436.physicians	phy_address2
_436.precerts	pre_address2
_436.precerts	pre_guarantor_address2
_436.radiology_orders	rad_address2
_436_archive_testing.billing_providers	bp_address2
_436_archive_testing.buildings	bld_address2
_436_archive_testing.charts	chrt_address2
_436_archive_testing.client_contacts	clicon_address2
_436_archive_testing.encounters	enc_address2
_436_archive_testing.encounters	enc_employer_address2
_436_archive_testing.encounters	enc_guarantor_address2
_436_archive_testing.hl7_lab_locations	hll_address2
_436_archive_testing.insurances	ins_address2
_436_archive_testing.insurances_claims_centers	icc_address2
_436_archive_testing.locations	loc_address2
_436_archive_testing.non_patients	npat_address2
_436_archive_testing.orders	ord_address2
_436_archive_testing.patient_next_of_kin	pnk_address2
_436_archive_testing.patients	pat_address2
_436_archive_testing.patients	pat_employer_address2
_436_archive_testing.patients	pat_guarantor_address2
_436_archive_testing.patients	pat_emergency_address2
_436_archive_testing.patients_demographics_snapshots	pds_address2
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_address2
_436_archive_testing.physicians	phy_address2
_436_archive_testing.precerts	pre_address2
_436_archive_testing.precerts	pre_guarantor_address2
_436_archive_testing.radiology_orders	rad_address2
_437.billing_providers	bp_address2
_437.buildings	bld_address2
_437.charts	chrt_address2
_437.client_contacts	clicon_address2
_437.encounters	enc_address2
_437.encounters	enc_employer_address2
_437.encounters	enc_guarantor_address2
_437.hl7_lab_locations	hll_address2
_437.insurances	ins_address2
_437.insurances_claims_centers	icc_address2
_437.locations	loc_address2
_437.non_patients	npat_address2
_437.orders	ord_address2
_437.patient_next_of_kin	pnk_address2
_437.patients	pat_address2
_437.patients	pat_employer_address2
_437.patients	pat_guarantor_address2
_437.patients	pat_emergency_address2
_437.patients_demographics_snapshots	pds_address2
_437.patients_demographics_snapshots	pds_guarantor_address2
_437.physicians	phy_address2
_437.precerts	pre_address2
_437.precerts	pre_guarantor_address2
_437.radiology_orders	rad_address2
_8.billing_providers	bp_address2
_8.buildings	bld_address2
_8.charts	chrt_address2
_8.client_contacts	clicon_address2
_8.encounters	enc_address2
_8.encounters	enc_employer_address2
_8.encounters	enc_guarantor_address2
_8.hl7_lab_locations	hll_address2
_8.insurances	ins_address2
_8.insurances_claims_centers	icc_address2
_8.locations	loc_address2
_8.non_patients	npat_address2
_8.orders	ord_address2
_8.patient_next_of_kin	pnk_address2
_8.patients	pat_address2
_8.patients	pat_employer_address2
_8.patients	pat_guarantor_address2
_8.patients	pat_emergency_address2
_8.patients_demographics_snapshots	pds_address2
_8.patients_demographics_snapshots	pds_guarantor_address2
_8.physicians	phy_address2
_8.precerts	pre_address2
_8.precerts	pre_guarantor_address2
_8.radiology_orders	rad_address2
_81.billing_providers	bp_address2
_81.buildings	bld_address2
_81.charts	chrt_address2
_81.client_contacts	clicon_address2
_81.encounters	enc_address2
_81.encounters	enc_employer_address2
_81.encounters	enc_guarantor_address2
_81.hl7_lab_locations	hll_address2
_81.insurances	ins_address2
_81.insurances_claims_centers	icc_address2
_81.locations	loc_address2
_81.non_patients	npat_address2
_81.orders	ord_address2
_81.patient_next_of_kin	pnk_address2
_81.patients	pat_address2
_81.patients	pat_employer_address2
_81.patients	pat_guarantor_address2
_81.patients	pat_emergency_address2
_81.patients_demographics_snapshots	pds_address2
_81.patients_demographics_snapshots	pds_guarantor_address2
_81.physicians	phy_address2
_81.precerts	pre_address2
_81.precerts	pre_guarantor_address2
_81.radiology_orders	rad_address2
_999.billing_providers	bp_address2
_999.buildings	bld_address2
_999.charts	chrt_address2
_999.client_contacts	clicon_address2
_999.encounters	enc_address2
_999.encounters	enc_employer_address2
_999.encounters	enc_guarantor_address2
_999.hl7_lab_locations	hll_address2
_999.insurances	ins_address2
_999.insurances_claims_centers	icc_address2
_999.locations	loc_address2
_999.non_patients	npat_address2
_999.orders	ord_address2
_999.patient_next_of_kin	pnk_address2
_999.patients	pat_address2
_999.patients	pat_employer_address2
_999.patients	pat_guarantor_address2
_999.patients	pat_emergency_address2
_999.patients_demographics_snapshots	pds_address2
_999.patients_demographics_snapshots	pds_guarantor_address2
_999.physicians	phy_address2
_999.precerts	pre_address2
_999.precerts	pre_guarantor_address2
_999.radiology_orders	rad_address2
common.clients	cli_address2
common.clients	cli_billing_address2
common.clients	cli_mailing_address2
common.clients_contract_data	ccd_payer_address2
common.contacts	con_address2
common.customers	cus_address2
common.customers	cus_billing_address2
common.lab_interfaces	lif_cli_address2
common.lab_interfaces_performing_sites	lips_address2
common.labs	lab_address2
common.leads	lea_address2

phone

Table	Column
Azalea.employees	emp_phone
EFaxes.efax_accounts	efaxacc_phone
_1.billing_providers	bp_phone
_1.charts	chrt_phone
_1.client_contacts	clicon_primary_phone
_1.cpoe_responses	cpoe_res_phone
_1.donors	don_phone
_1.encounters	enc_phone
_1.encounters	enc_guarantor_phone
_1.examples	exa_phone
_1.hl7_accessions	acc_phone
_1.hl7_lab_locations	hll_phone
_1.insurances	ins_phone
_1.insurances_claims_centers	icc_phone
_1.locations	loc_phone
_1.non_patients	npat_phone
_1.orders	ord_phone
_1.patient_next_of_kin	pnk_phone
_1.patients	pat_phone
_1.patients	pat_guarantor_phone
_1.patients_demographics_snapshots	pds_phone
_1.patients_demographics_snapshots	pds_guarantor_phone
_1.physicians	phy_phone
_1.precerts	pre_phone
_1.precerts	pre_guarantor_phone
_1.radiology_orders	rad_phone
_1.radiology_results	rad_res_phone
_1188.billing_providers	bp_phone
_1188.charts	chrt_phone
_1188.client_contacts	clicon_primary_phone
_1188.cpoe_responses	cpoe_res_phone
_1188.donors	don_phone
_1188.encounters	enc_phone
_1188.encounters	enc_guarantor_phone
_1188.examples	exa_phone
_1188.hl7_accessions	acc_phone
_1188.hl7_lab_locations	hll_phone
_1188.insurances	ins_phone
_1188.insurances_claims_centers	icc_phone
_1188.locations	loc_phone
_1188.non_patients	npat_phone
_1188.orders	ord_phone
_1188.patient_next_of_kin	pnk_phone
_1188.patients	pat_phone
_1188.patients	pat_guarantor_phone
_1188.patients_demographics_snapshots	pds_phone
_1188.patients_demographics_snapshots	pds_guarantor_phone
_1188.physicians	phy_phone
_1188.precerts	pre_phone
_1188.precerts	pre_guarantor_phone
_1188.radiology_orders	rad_phone
_1188.radiology_results	rad_res_phone
_1218.billing_providers	bp_phone
_1218.charts	chrt_phone
_1218.client_contacts	clicon_primary_phone
_1218.cpoe_responses	cpoe_res_phone
_1218.donors	don_phone
_1218.encounters	enc_phone
_1218.encounters	enc_guarantor_phone
_1218.examples	exa_phone
_1218.hl7_accessions	acc_phone
_1218.hl7_lab_locations	hll_phone
_1218.insurances	ins_phone
_1218.insurances_claims_centers	icc_phone
_1218.locations	loc_phone
_1218.non_patients	npat_phone
_1218.orders	ord_phone
_1218.patient_next_of_kin	pnk_phone
_1218.patients	pat_phone
_1218.patients	pat_guarantor_phone
_1218.patients_demographics_snapshots	pds_phone
_1218.patients_demographics_snapshots	pds_guarantor_phone
_1218.physicians	phy_phone
_1218.precerts	pre_phone
_1218.precerts	pre_guarantor_phone
_1218.radiology_orders	rad_phone
_1218.radiology_results	rad_res_phone
_1548.billing_providers	bp_phone
_1548.charts	chrt_phone
_1548.client_contacts	clicon_primary_phone
_1548.cpoe_responses	cpoe_res_phone
_1548.donors	don_phone
_1548.encounters	enc_phone
_1548.encounters	enc_guarantor_phone
_1548.examples	exa_phone
_1548.hl7_accessions	acc_phone
_1548.hl7_lab_locations	hll_phone
_1548.insurances	ins_phone
_1548.insurances_claims_centers	icc_phone
_1548.locations	loc_phone
_1548.non_patients	npat_phone
_1548.orders	ord_phone
_1548.patient_next_of_kin	pnk_phone
_1548.patients	pat_phone
_1548.patients	pat_guarantor_phone
_1548.patients_demographics_snapshots	pds_phone
_1548.patients_demographics_snapshots	pds_guarantor_phone
_1548.physicians	phy_phone
_1548.precerts	pre_phone
_1548.precerts	pre_guarantor_phone
_1548.radiology_orders	rad_phone
_1548.radiology_results	rad_res_phone
_435.billing_providers	bp_phone
_435.charts	chrt_phone
_435.client_contacts	clicon_primary_phone
_435.cpoe_responses	cpoe_res_phone
_435.donors	don_phone
_435.encounters	enc_phone
_435.encounters	enc_guarantor_phone
_435.examples	exa_phone
_435.hl7_accessions	acc_phone
_435.hl7_lab_locations	hll_phone
_435.insurances	ins_phone
_435.insurances_claims_centers	icc_phone
_435.locations	loc_phone
_435.non_patients	npat_phone
_435.orders	ord_phone
_435.patient_next_of_kin	pnk_phone
_435.patients	pat_phone
_435.patients	pat_guarantor_phone
_435.patients_demographics_snapshots	pds_phone
_435.patients_demographics_snapshots	pds_guarantor_phone
_435.physicians	phy_phone
_435.precerts	pre_phone
_435.precerts	pre_guarantor_phone
_435.radiology_orders	rad_phone
_435.radiology_results	rad_res_phone
_436.billing_providers	bp_phone
_436.charts	chrt_phone
_436.client_contacts	clicon_primary_phone
_436.cpoe_responses	cpoe_res_phone
_436.donors	don_phone
_436.encounters	enc_phone
_436.encounters	enc_guarantor_phone
_436.examples	exa_phone
_436.hl7_accessions	acc_phone
_436.hl7_lab_locations	hll_phone
_436.insurances	ins_phone
_436.insurances_claims_centers	icc_phone
_436.locations	loc_phone
_436.non_patients	npat_phone
_436.orders	ord_phone
_436.patient_next_of_kin	pnk_phone
_436.patients	pat_phone
_436.patients	pat_guarantor_phone
_436.patients_demographics_snapshots	pds_phone
_436.patients_demographics_snapshots	pds_guarantor_phone
_436.physicians	phy_phone
_436.precerts	pre_phone
_436.precerts	pre_guarantor_phone
_436.radiology_orders	rad_phone
_436.radiology_results	rad_res_phone
_436_archive_testing.billing_providers	bp_phone
_436_archive_testing.charts	chrt_phone
_436_archive_testing.client_contacts	clicon_primary_phone
_436_archive_testing.cpoe_responses	cpoe_res_phone
_436_archive_testing.donors	don_phone
_436_archive_testing.encounters	enc_phone
_436_archive_testing.encounters	enc_guarantor_phone
_436_archive_testing.examples	exa_phone
_436_archive_testing.hl7_accessions	acc_phone
_436_archive_testing.hl7_lab_locations	hll_phone
_436_archive_testing.insurances	ins_phone
_436_archive_testing.insurances_claims_centers	icc_phone
_436_archive_testing.locations	loc_phone
_436_archive_testing.non_patients	npat_phone
_436_archive_testing.orders	ord_phone
_436_archive_testing.patient_next_of_kin	pnk_phone
_436_archive_testing.patients	pat_phone
_436_archive_testing.patients	pat_guarantor_phone
_436_archive_testing.patients_demographics_snapshots	pds_phone
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_phone
_436_archive_testing.physicians	phy_phone
_436_archive_testing.precerts	pre_phone
_436_archive_testing.precerts	pre_guarantor_phone
_436_archive_testing.radiology_orders	rad_phone
_436_archive_testing.radiology_results	rad_res_phone
_437.billing_providers	bp_phone
_437.charts	chrt_phone
_437.client_contacts	clicon_primary_phone
_437.cpoe_responses	cpoe_res_phone
_437.donors	don_phone
_437.encounters	enc_phone
_437.encounters	enc_guarantor_phone
_437.examples	exa_phone
_437.hl7_accessions	acc_phone
_437.hl7_lab_locations	hll_phone
_437.insurances	ins_phone
_437.insurances_claims_centers	icc_phone
_437.locations	loc_phone
_437.non_patients	npat_phone
_437.orders	ord_phone
_437.patient_next_of_kin	pnk_phone
_437.patients	pat_phone
_437.patients	pat_guarantor_phone
_437.patients_demographics_snapshots	pds_phone
_437.patients_demographics_snapshots	pds_guarantor_phone
_437.physicians	phy_phone
_437.precerts	pre_phone
_437.precerts	pre_guarantor_phone
_437.radiology_orders	rad_phone
_437.radiology_results	rad_res_phone
_8.billing_providers	bp_phone
_8.charts	chrt_phone
_8.client_contacts	clicon_primary_phone
_8.cpoe_responses	cpoe_res_phone
_8.donors	don_phone
_8.encounters	enc_phone
_8.encounters	enc_guarantor_phone
_8.examples	exa_phone
_8.hl7_accessions	acc_phone
_8.hl7_lab_locations	hll_phone
_8.insurances	ins_phone
_8.insurances_claims_centers	icc_phone
_8.locations	loc_phone
_8.non_patients	npat_phone
_8.orders	ord_phone
_8.patient_next_of_kin	pnk_phone
_8.patients	pat_phone
_8.patients	pat_guarantor_phone
_8.patients_demographics_snapshots	pds_phone
_8.patients_demographics_snapshots	pds_guarantor_phone
_8.physicians	phy_phone
_8.precerts	pre_phone
_8.precerts	pre_guarantor_phone
_8.radiology_orders	rad_phone
_8.radiology_results	rad_res_phone
_81.billing_providers	bp_phone
_81.charts	chrt_phone
_81.client_contacts	clicon_primary_phone
_81.cpoe_responses	cpoe_res_phone
_81.donors	don_phone
_81.encounters	enc_phone
_81.encounters	enc_guarantor_phone
_81.examples	exa_phone
_81.hl7_accessions	acc_phone
_81.hl7_lab_locations	hll_phone
_81.insurances	ins_phone
_81.insurances_claims_centers	icc_phone
_81.locations	loc_phone
_81.non_patients	npat_phone
_81.orders	ord_phone
_81.patient_next_of_kin	pnk_phone
_81.patients	pat_phone
_81.patients	pat_guarantor_phone
_81.patients_demographics_snapshots	pds_phone
_81.patients_demographics_snapshots	pds_guarantor_phone
_81.physicians	phy_phone
_81.precerts	pre_phone
_81.precerts	pre_guarantor_phone
_81.radiology_orders	rad_phone
_81.radiology_results	rad_res_phone
_999.billing_providers	bp_phone
_999.charts	chrt_phone
_999.client_contacts	clicon_primary_phone
_999.cpoe_responses	cpoe_res_phone
_999.donors	don_phone
_999.encounters	enc_phone
_999.encounters	enc_guarantor_phone
_999.examples	exa_phone
_999.hl7_accessions	acc_phone
_999.hl7_lab_locations	hll_phone
_999.insurances	ins_phone
_999.insurances_claims_centers	icc_phone
_999.locations	loc_phone
_999.non_patients	npat_phone
_999.orders	ord_phone
_999.patient_next_of_kin	pnk_phone
_999.patients	pat_phone
_999.patients	pat_guarantor_phone
_999.patients_demographics_snapshots	pds_phone
_999.patients_demographics_snapshots	pds_guarantor_phone
_999.physicians	phy_phone
_999.precerts	pre_phone
_999.precerts	pre_guarantor_phone
_999.radiology_orders	rad_phone
_999.radiology_results	rad_res_phone
aurora_standard.bdmpi	sp_phone
aurora_standard.bfinsrc	precert_phone
aurora_standard.bfrhc	gu_phone
aurora_standard.bhar	p_phone
aurora_standard.bhar	g_phone
aurora_standard.bhar	ge_phone
aurora_standard.bhar	em_phone
aurora_standard.bhguar	emp_phone
aurora_standard.bhphybak	home_phone
aurora_standard.bhphybak	office_phone
aurora_standard.bhphybak	cellular_phone
aurora_standard.bhphybak	page_phone
aurora_standard.bhtguar	emp_phone
aurora_standard.bmmpi	p_phone
aurora_standard.bmnkin	n_phone
aurora_standard.bmnkin	nw_phone
aurora_standard.bmnkin	nc_phone
aurora_standard.bmpact	p_phone
aurora_standard.bpar	p_phone
aurora_standard.bpar	g_phone
aurora_standard.bpar	ge_phone
aurora_standard.bpar	em_phone
aurora_standard.bpar2	p_phone
aurora_standard.bpar2	g_phone
aurora_standard.bpar2	ge_phone
aurora_standard.bpar2	em_phone
aurora_standard.bpmpi	p_phone
aurora_standard.bpmpi2	p_phone
aurora_standard.bsinsur	spouse_phone
aurora_standard.bsinsur	nextkin_phone
aurora_standard.bsinsur	patient_phone
aurora_standard.bsinsur	pat_emp_phone
aurora_standard.bsinsur	pat_cell_phone
aurora_standard.bsinsur	sp_cell_phone
aurora_standard.bsinsur	nk_cell_phone
aurora_standard.bvguar	work_phone
aurora_standard.bvmpi	work_phone
aurora_standard.bvmpi2	work_phone
aurora_standard.bwphync	office_phone
aurora_standard.c5insrc	precert_phone
aurora_standard.c5insrcdr	precert_phone
aurora_standard.c7insur2	ins_phone
aurora_standard.c7insur3	ins_phone
aurora_standard.c8mpi	p_phone
aurora_standard.c8phy	home_phone
aurora_standard.c8phy	office_phone
aurora_standard.c8phy	cellular_phone
aurora_standard.c8phy	page_phone
aurora_standard.cainsrc	precert_phone
aurora_standard.cainsrc2	precert_phone
aurora_standard.campi	spouse_phone
aurora_standard.campi	sp_cell_phone
aurora_standard.campi	nextkin_phone
aurora_standard.campi	nk_cell_phone
aurora_standard.campi	patient_phone
aurora_standard.campi	pat_emp_phone
aurora_standard.campi	pat_cell_phone
aurora_standard.caphy	office_phone
aurora_standard.caphync	hm_phone
aurora_standard.caphync	wk_phone
aurora_standard.caphync	cell_phone
aurora_standard.chlswbhd	fac_phone
aurora_standard.chlswbhd	agt_phone
aurora_standard.chlswbhd	sfw_phone
aurora_standard.chltrnhd	fac_phone
aurora_standard.chltrnhd	agt_phone
aurora_standard.chltrnhd	sfw_phone
aurora_standard.chmadmwc	ref_phone
aurora_standard.chmarcnbf	g_phone
aurora_standard.chmarcnbf	g_emp_phone
aurora_standard.chmarcnbf	ins1_phone
aurora_standard.chmarcnbf	ins2_phone
aurora_standard.chmarsi	pat_phone
aurora_standard.chmarsi	gu_phone
aurora_standard.chmarsi	pat_emp_phone
aurora_standard.chmarsi	sp_phone
aurora_standard.chmarst	fac_phone
aurora_standard.chmarsti	fac_phone
aurora_standard.chmcampi	pat_phone
aurora_standard.chmcampi	gu_phone
aurora_standard.chmcampi	pat_emp_phone
aurora_standard.chmcampi	sp_phone
aurora_standard.chmcmhed	debtor_phone
aurora_standard.chmcmhed	pat_phone
aurora_standard.chmcosta	pat_phone
aurora_standard.chmemplr	other_phone
aurora_standard.chmescpt	contact_phone
aurora_standard.chmexmpi	pat_phone
aurora_standard.chmexmpi	gu_phone
aurora_standard.chmexmpi	pat_emp_phone
aurora_standard.chmexmpi	sp_phone
aurora_standard.chmguarr	gu_emp_phone
aurora_standard.chmhistp	p_phone
aurora_standard.chmhl7ic	company_phone
aurora_standard.chminsrc	precert_phone
aurora_standard.chmnvstb	prov_phone
aurora_standard.chmnvstr	prov_phone
aurora_standard.chmozpcd	debtor_phone
aurora_standard.chmozpcd	bank_phone
aurora_standard.chmpatmr	spouse_phone
aurora_standard.chmpatmr	nextkin_phone
aurora_standard.chmpatmr	patient_phone
aurora_standard.chmpatmr	pat_emp_phone
aurora_standard.chmpatmr	pat_cell_phone
aurora_standard.chmpatmr	sp_cell_phone
aurora_standard.chmpatmr	nk_cell_phone
aurora_standard.chmpatwc	mom_phone
aurora_standard.chmpatwc	dad_phone
aurora_standard.chmpdemo	p_phone
aurora_standard.chmpdemo	p_emp_phone
aurora_standard.chmpdemo	sp_phone
aurora_standard.chmpdemo	gu_phone
aurora_standard.chmpdemo	ins1_phone
aurora_standard.chmpdemo	ins2_phone
aurora_standard.chmpdemo	ins3_phone
aurora_standard.chmphync	home_phone
aurora_standard.chmphync	office_phone
aurora_standard.chmphync	cellular_phone
aurora_standard.chmphync	page_phone
aurora_standard.chmradex	pat_phone
aurora_standard.chmradex	pat_emp_phone
aurora_standard.chmradex	gu_phone
aurora_standard.chmradex	sp_phone
aurora_standard.chpcardc	contact_phone
aurora_standard.chpcardd	contact_phone
aurora_standard.chpcempr	on_call_phone
aurora_standard.chpcntrc	educ_phone
aurora_standard.chpemerd	work_phone
aurora_standard.chpemerd	home_phone
aurora_standard.chpemerd	other_phone
aurora_standard.chpinsuc	precert_phone
aurora_standard.chppersr	on_call_phone
aurora_standard.chppersr	cell_phone
aurora_standard.chshotlr	other_phone
aurora_standard.cuphync	home_phone
aurora_standard.cuphync	office_phone
aurora_standard.nbspouse	spouse_phone
aurora_standard.ohoemplr	home_phone
aurora_standard.stp1099c	contact_phone
aurora_standard.stp1099c	vend_phone
aurora_standard.stppytor	fax_phone
aurora_standard.stprepsd	rep_phone
aurora_standard.stpvendr	fax_phone
aurora_standard.stpvendr	agent_phone
aurora_standard.strcustr	fax_phone
aurora_standard.styoctcc	contact_phone
aurora_standard.styoctcc	gov_entity_contact_phone
aurora_standard.styuimmr	cont_phone
aurora_standard.styw2mm1	cont_phone
aurora_standard.vault_providers	home_phone
aurora_standard.vault_providers	office_phone
aurora_standard.vault_providers	cell_phone
common.applicants	app_phone
common.applicants	app_cell_phone
common.applicants	app_employer_1_phone
common.applicants	app_employer_2_phone
common.applicants	app_employer_3_phone
common.applicants	app_employer_4_phone
common.applicants	app_reference_1_phone
common.applicants	app_reference_2_phone
common.applicants	app_reference_3_phone
common.applicants	app_reference_4_phone
common.clients_contract_data	ccd_payer_phone
common.contact_imports	ci_phone
common.fax_accounts	fxa_phone
common.lab_interfaces_performing_sites	lips_phone
common.leads	lea_phone
common.sfax_accounts	sfax_acc_phone
common.users	usr_cell_phone
rcmroi.dev__sf_users	mobile_phone
rcmroi.prod__sf_users	mobile_phone
rcmroi.test__sf_users	mobile_phone

city

Table	Column
Azalea.employees	emp_city
_1.billing_providers	bp_city
_1.buildings	bld_city
_1.charts	chrt_city
_1.client_contacts	clicon_city
_1.encounters	enc_city
_1.encounters	enc_employer_city
_1.encounters	enc_guarantor_city
_1.encounters	enc_ins1_employer_city
_1.encounters	enc_ins2_employer_city
_1.encounters	enc_ins3_employer_city
_1.hl7_lab_locations	hll_city
_1.insurances	ins_city
_1.insurances_claims_centers	icc_city
_1.insurances_repository	irep_ins_employer_city
_1.locations	loc_city
_1.non_patients	npat_city
_1.orders	ord_city
_1.orders	ord_ins1_employer_city
_1.orders	ord_ins2_employer_city
_1.patient_next_of_kin	pnk_city
_1.patients	pat_city
_1.patients	pat_employer_city
_1.patients	pat_guarantor_city
_1.patients	pat_ins1_employer_city
_1.patients	pat_ins2_employer_city
_1.patients	pat_ins3_employer_city
_1.patients	pat_emergency_city
_1.patients_demographics_snapshots	pds_city
_1.patients_demographics_snapshots	pds_employer_city
_1.patients_demographics_snapshots	pds_guarantor_city
_1.patients_demographics_snapshots	pds_ins1_employer_city
_1.patients_demographics_snapshots	pds_ins2_employer_city
_1.patients_demographics_snapshots	pds_ins3_employer_city
_1.physicians	phy_city
_1.precerts	pre_city
_1.precerts	pre_employer_city
_1.precerts	pre_guarantor_city
_1.precerts	pre_ins1_employer_city
_1.precerts	pre_ins2_employer_city
_1.radiology_orders	rad_city
_1.radiology_orders	rad_ins1_employer_city
_1.radiology_orders	rad_ins2_employer_city
_1188.billing_providers	bp_city
_1188.buildings	bld_city
_1188.charts	chrt_city
_1188.client_contacts	clicon_city
_1188.encounters	enc_city
_1188.encounters	enc_employer_city
_1188.encounters	enc_guarantor_city
_1188.encounters	enc_ins1_employer_city
_1188.encounters	enc_ins2_employer_city
_1188.encounters	enc_ins3_employer_city
_1188.hl7_lab_locations	hll_city
_1188.insurances	ins_city
_1188.insurances_claims_centers	icc_city
_1188.insurances_repository	irep_ins_employer_city
_1188.locations	loc_city
_1188.non_patients	npat_city
_1188.orders	ord_city
_1188.orders	ord_ins1_employer_city
_1188.orders	ord_ins2_employer_city
_1188.patient_next_of_kin	pnk_city
_1188.patients	pat_city
_1188.patients	pat_employer_city
_1188.patients	pat_guarantor_city
_1188.patients	pat_ins1_employer_city
_1188.patients	pat_ins2_employer_city
_1188.patients	pat_ins3_employer_city
_1188.patients	pat_emergency_city
_1188.patients_demographics_snapshots	pds_city
_1188.patients_demographics_snapshots	pds_employer_city
_1188.patients_demographics_snapshots	pds_guarantor_city
_1188.patients_demographics_snapshots	pds_ins1_employer_city
_1188.patients_demographics_snapshots	pds_ins2_employer_city
_1188.patients_demographics_snapshots	pds_ins3_employer_city
_1188.physicians	phy_city
_1188.precerts	pre_city
_1188.precerts	pre_employer_city
_1188.precerts	pre_guarantor_city
_1188.precerts	pre_ins1_employer_city
_1188.precerts	pre_ins2_employer_city
_1188.radiology_orders	rad_city
_1188.radiology_orders	rad_ins1_employer_city
_1188.radiology_orders	rad_ins2_employer_city
_1218.billing_providers	bp_city
_1218.buildings	bld_city
_1218.charts	chrt_city
_1218.client_contacts	clicon_city
_1218.encounters	enc_city
_1218.encounters	enc_employer_city
_1218.encounters	enc_guarantor_city
_1218.encounters	enc_ins1_employer_city
_1218.encounters	enc_ins2_employer_city
_1218.encounters	enc_ins3_employer_city
_1218.hl7_lab_locations	hll_city
_1218.insurances	ins_city
_1218.insurances_claims_centers	icc_city
_1218.insurances_repository	irep_ins_employer_city
_1218.locations	loc_city
_1218.non_patients	npat_city
_1218.orders	ord_city
_1218.orders	ord_ins1_employer_city
_1218.orders	ord_ins2_employer_city
_1218.patient_next_of_kin	pnk_city
_1218.patients	pat_city
_1218.patients	pat_employer_city
_1218.patients	pat_guarantor_city
_1218.patients	pat_ins1_employer_city
_1218.patients	pat_ins2_employer_city
_1218.patients	pat_ins3_employer_city
_1218.patients	pat_emergency_city
_1218.patients_demographics_snapshots	pds_city
_1218.patients_demographics_snapshots	pds_employer_city
_1218.patients_demographics_snapshots	pds_guarantor_city
_1218.patients_demographics_snapshots	pds_ins1_employer_city
_1218.patients_demographics_snapshots	pds_ins2_employer_city
_1218.patients_demographics_snapshots	pds_ins3_employer_city
_1218.physicians	phy_city
_1218.precerts	pre_city
_1218.precerts	pre_employer_city
_1218.precerts	pre_guarantor_city
_1218.precerts	pre_ins1_employer_city
_1218.precerts	pre_ins2_employer_city
_1218.radiology_orders	rad_city
_1218.radiology_orders	rad_ins1_employer_city
_1218.radiology_orders	rad_ins2_employer_city
_1548.billing_providers	bp_city
_1548.buildings	bld_city
_1548.charts	chrt_city
_1548.client_contacts	clicon_city
_1548.encounters	enc_city
_1548.encounters	enc_employer_city
_1548.encounters	enc_guarantor_city
_1548.encounters	enc_ins1_employer_city
_1548.encounters	enc_ins2_employer_city
_1548.encounters	enc_ins3_employer_city
_1548.hl7_lab_locations	hll_city
_1548.insurances	ins_city
_1548.insurances_claims_centers	icc_city
_1548.insurances_repository	irep_ins_employer_city
_1548.locations	loc_city
_1548.non_patients	npat_city
_1548.orders	ord_city
_1548.orders	ord_ins1_employer_city
_1548.orders	ord_ins2_employer_city
_1548.patient_next_of_kin	pnk_city
_1548.patients	pat_city
_1548.patients	pat_employer_city
_1548.patients	pat_guarantor_city
_1548.patients	pat_ins1_employer_city
_1548.patients	pat_ins2_employer_city
_1548.patients	pat_ins3_employer_city
_1548.patients	pat_emergency_city
_1548.patients_demographics_snapshots	pds_city
_1548.patients_demographics_snapshots	pds_employer_city
_1548.patients_demographics_snapshots	pds_guarantor_city
_1548.patients_demographics_snapshots	pds_ins1_employer_city
_1548.patients_demographics_snapshots	pds_ins2_employer_city
_1548.patients_demographics_snapshots	pds_ins3_employer_city
_1548.physicians	phy_city
_1548.precerts	pre_city
_1548.precerts	pre_employer_city
_1548.precerts	pre_guarantor_city
_1548.precerts	pre_ins1_employer_city
_1548.precerts	pre_ins2_employer_city
_1548.radiology_orders	rad_city
_1548.radiology_orders	rad_ins1_employer_city
_1548.radiology_orders	rad_ins2_employer_city
_435.billing_providers	bp_city
_435.buildings	bld_city
_435.charts	chrt_city
_435.client_contacts	clicon_city
_435.encounters	enc_city
_435.encounters	enc_employer_city
_435.encounters	enc_guarantor_city
_435.encounters	enc_ins1_employer_city
_435.encounters	enc_ins2_employer_city
_435.encounters	enc_ins3_employer_city
_435.hl7_lab_locations	hll_city
_435.insurances	ins_city
_435.insurances_claims_centers	icc_city
_435.insurances_repository	irep_ins_employer_city
_435.locations	loc_city
_435.non_patients	npat_city
_435.orders	ord_city
_435.orders	ord_ins1_employer_city
_435.orders	ord_ins2_employer_city
_435.patient_next_of_kin	pnk_city
_435.patients	pat_city
_435.patients	pat_employer_city
_435.patients	pat_guarantor_city
_435.patients	pat_ins1_employer_city
_435.patients	pat_ins2_employer_city
_435.patients	pat_ins3_employer_city
_435.patients	pat_emergency_city
_435.patients_demographics_snapshots	pds_city
_435.patients_demographics_snapshots	pds_employer_city
_435.patients_demographics_snapshots	pds_guarantor_city
_435.patients_demographics_snapshots	pds_ins1_employer_city
_435.patients_demographics_snapshots	pds_ins2_employer_city
_435.patients_demographics_snapshots	pds_ins3_employer_city
_435.physicians	phy_city
_435.precerts	pre_city
_435.precerts	pre_employer_city
_435.precerts	pre_guarantor_city
_435.precerts	pre_ins1_employer_city
_435.precerts	pre_ins2_employer_city
_435.radiology_orders	rad_city
_435.radiology_orders	rad_ins1_employer_city
_435.radiology_orders	rad_ins2_employer_city
_436.billing_providers	bp_city
_436.buildings	bld_city
_436.charts	chrt_city
_436.client_contacts	clicon_city
_436.encounters	enc_city
_436.encounters	enc_employer_city
_436.encounters	enc_guarantor_city
_436.encounters	enc_ins1_employer_city
_436.encounters	enc_ins2_employer_city
_436.encounters	enc_ins3_employer_city
_436.hl7_lab_locations	hll_city
_436.insurances	ins_city
_436.insurances_claims_centers	icc_city
_436.insurances_repository	irep_ins_employer_city
_436.locations	loc_city
_436.non_patients	npat_city
_436.orders	ord_city
_436.orders	ord_ins1_employer_city
_436.orders	ord_ins2_employer_city
_436.patient_next_of_kin	pnk_city
_436.patients	pat_city
_436.patients	pat_employer_city
_436.patients	pat_guarantor_city
_436.patients	pat_ins1_employer_city
_436.patients	pat_ins2_employer_city
_436.patients	pat_ins3_employer_city
_436.patients	pat_emergency_city
_436.patients_demographics_snapshots	pds_city
_436.patients_demographics_snapshots	pds_employer_city
_436.patients_demographics_snapshots	pds_guarantor_city
_436.patients_demographics_snapshots	pds_ins1_employer_city
_436.patients_demographics_snapshots	pds_ins2_employer_city
_436.patients_demographics_snapshots	pds_ins3_employer_city
_436.physicians	phy_city
_436.precerts	pre_city
_436.precerts	pre_employer_city
_436.precerts	pre_guarantor_city
_436.precerts	pre_ins1_employer_city
_436.precerts	pre_ins2_employer_city
_436.radiology_orders	rad_city
_436.radiology_orders	rad_ins1_employer_city
_436.radiology_orders	rad_ins2_employer_city
_436_archive_testing.billing_providers	bp_city
_436_archive_testing.buildings	bld_city
_436_archive_testing.charts	chrt_city
_436_archive_testing.client_contacts	clicon_city
_436_archive_testing.encounters	enc_city
_436_archive_testing.encounters	enc_employer_city
_436_archive_testing.encounters	enc_guarantor_city
_436_archive_testing.encounters	enc_ins1_employer_city
_436_archive_testing.encounters	enc_ins2_employer_city
_436_archive_testing.encounters	enc_ins3_employer_city
_436_archive_testing.hl7_lab_locations	hll_city
_436_archive_testing.insurances	ins_city
_436_archive_testing.insurances_claims_centers	icc_city
_436_archive_testing.insurances_repository	irep_ins_employer_city
_436_archive_testing.locations	loc_city
_436_archive_testing.non_patients	npat_city
_436_archive_testing.orders	ord_city
_436_archive_testing.orders	ord_ins1_employer_city
_436_archive_testing.orders	ord_ins2_employer_city
_436_archive_testing.patient_next_of_kin	pnk_city
_436_archive_testing.patients	pat_city
_436_archive_testing.patients	pat_employer_city
_436_archive_testing.patients	pat_guarantor_city
_436_archive_testing.patients	pat_ins1_employer_city
_436_archive_testing.patients	pat_ins2_employer_city
_436_archive_testing.patients	pat_ins3_employer_city
_436_archive_testing.patients	pat_emergency_city
_436_archive_testing.patients_demographics_snapshots	pds_city
_436_archive_testing.patients_demographics_snapshots	pds_employer_city
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_city
_436_archive_testing.patients_demographics_snapshots	pds_ins1_employer_city
_436_archive_testing.patients_demographics_snapshots	pds_ins2_employer_city
_436_archive_testing.patients_demographics_snapshots	pds_ins3_employer_city
_436_archive_testing.physicians	phy_city
_436_archive_testing.precerts	pre_city
_436_archive_testing.precerts	pre_employer_city
_436_archive_testing.precerts	pre_guarantor_city
_436_archive_testing.precerts	pre_ins1_employer_city
_436_archive_testing.precerts	pre_ins2_employer_city
_436_archive_testing.radiology_orders	rad_city
_436_archive_testing.radiology_orders	rad_ins1_employer_city
_436_archive_testing.radiology_orders	rad_ins2_employer_city
_437.billing_providers	bp_city
_437.buildings	bld_city
_437.charts	chrt_city
_437.client_contacts	clicon_city
_437.encounters	enc_city
_437.encounters	enc_employer_city
_437.encounters	enc_guarantor_city
_437.encounters	enc_ins1_employer_city
_437.encounters	enc_ins2_employer_city
_437.encounters	enc_ins3_employer_city
_437.hl7_lab_locations	hll_city
_437.insurances	ins_city
_437.insurances_claims_centers	icc_city
_437.insurances_repository	irep_ins_employer_city
_437.locations	loc_city
_437.non_patients	npat_city
_437.orders	ord_city
_437.orders	ord_ins1_employer_city
_437.orders	ord_ins2_employer_city
_437.patient_next_of_kin	pnk_city
_437.patients	pat_city
_437.patients	pat_employer_city
_437.patients	pat_guarantor_city
_437.patients	pat_ins1_employer_city
_437.patients	pat_ins2_employer_city
_437.patients	pat_ins3_employer_city
_437.patients	pat_emergency_city
_437.patients_demographics_snapshots	pds_city
_437.patients_demographics_snapshots	pds_employer_city
_437.patients_demographics_snapshots	pds_guarantor_city
_437.patients_demographics_snapshots	pds_ins1_employer_city
_437.patients_demographics_snapshots	pds_ins2_employer_city
_437.patients_demographics_snapshots	pds_ins3_employer_city
_437.physicians	phy_city
_437.precerts	pre_city
_437.precerts	pre_employer_city
_437.precerts	pre_guarantor_city
_437.precerts	pre_ins1_employer_city
_437.precerts	pre_ins2_employer_city
_437.radiology_orders	rad_city
_437.radiology_orders	rad_ins1_employer_city
_437.radiology_orders	rad_ins2_employer_city
_8.billing_providers	bp_city
_8.buildings	bld_city
_8.charts	chrt_city
_8.client_contacts	clicon_city
_8.encounters	enc_city
_8.encounters	enc_employer_city
_8.encounters	enc_guarantor_city
_8.encounters	enc_ins1_employer_city
_8.encounters	enc_ins2_employer_city
_8.encounters	enc_ins3_employer_city
_8.hl7_lab_locations	hll_city
_8.insurances	ins_city
_8.insurances_claims_centers	icc_city
_8.insurances_repository	irep_ins_employer_city
_8.locations	loc_city
_8.non_patients	npat_city
_8.orders	ord_city
_8.orders	ord_ins1_employer_city
_8.orders	ord_ins2_employer_city
_8.patient_next_of_kin	pnk_city
_8.patients	pat_city
_8.patients	pat_employer_city
_8.patients	pat_guarantor_city
_8.patients	pat_ins1_employer_city
_8.patients	pat_ins2_employer_city
_8.patients	pat_ins3_employer_city
_8.patients	pat_emergency_city
_8.patients_demographics_snapshots	pds_city
_8.patients_demographics_snapshots	pds_employer_city
_8.patients_demographics_snapshots	pds_guarantor_city
_8.patients_demographics_snapshots	pds_ins1_employer_city
_8.patients_demographics_snapshots	pds_ins2_employer_city
_8.patients_demographics_snapshots	pds_ins3_employer_city
_8.physicians	phy_city
_8.precerts	pre_city
_8.precerts	pre_employer_city
_8.precerts	pre_guarantor_city
_8.precerts	pre_ins1_employer_city
_8.precerts	pre_ins2_employer_city
_8.radiology_orders	rad_city
_8.radiology_orders	rad_ins1_employer_city
_8.radiology_orders	rad_ins2_employer_city
_81.billing_providers	bp_city
_81.buildings	bld_city
_81.charts	chrt_city
_81.client_contacts	clicon_city
_81.encounters	enc_city
_81.encounters	enc_employer_city
_81.encounters	enc_guarantor_city
_81.encounters	enc_ins1_employer_city
_81.encounters	enc_ins2_employer_city
_81.encounters	enc_ins3_employer_city
_81.hl7_lab_locations	hll_city
_81.insurances	ins_city
_81.insurances_claims_centers	icc_city
_81.insurances_repository	irep_ins_employer_city
_81.locations	loc_city
_81.non_patients	npat_city
_81.orders	ord_city
_81.orders	ord_ins1_employer_city
_81.orders	ord_ins2_employer_city
_81.patient_next_of_kin	pnk_city
_81.patients	pat_city
_81.patients	pat_employer_city
_81.patients	pat_guarantor_city
_81.patients	pat_ins1_employer_city
_81.patients	pat_ins2_employer_city
_81.patients	pat_ins3_employer_city
_81.patients	pat_emergency_city
_81.patients_demographics_snapshots	pds_city
_81.patients_demographics_snapshots	pds_employer_city
_81.patients_demographics_snapshots	pds_guarantor_city
_81.patients_demographics_snapshots	pds_ins1_employer_city
_81.patients_demographics_snapshots	pds_ins2_employer_city
_81.patients_demographics_snapshots	pds_ins3_employer_city
_81.physicians	phy_city
_81.precerts	pre_city
_81.precerts	pre_employer_city
_81.precerts	pre_guarantor_city
_81.precerts	pre_ins1_employer_city
_81.precerts	pre_ins2_employer_city
_81.radiology_orders	rad_city
_81.radiology_orders	rad_ins1_employer_city
_81.radiology_orders	rad_ins2_employer_city
_999.billing_providers	bp_city
_999.buildings	bld_city
_999.charts	chrt_city
_999.client_contacts	clicon_city
_999.encounters	enc_city
_999.encounters	enc_employer_city
_999.encounters	enc_guarantor_city
_999.encounters	enc_ins1_employer_city
_999.encounters	enc_ins2_employer_city
_999.encounters	enc_ins3_employer_city
_999.hl7_lab_locations	hll_city
_999.insurances	ins_city
_999.insurances_claims_centers	icc_city
_999.insurances_repository	irep_ins_employer_city
_999.locations	loc_city
_999.non_patients	npat_city
_999.orders	ord_city
_999.orders	ord_ins1_employer_city
_999.orders	ord_ins2_employer_city
_999.patient_next_of_kin	pnk_city
_999.patients	pat_city
_999.patients	pat_employer_city
_999.patients	pat_guarantor_city
_999.patients	pat_ins1_employer_city
_999.patients	pat_ins2_employer_city
_999.patients	pat_ins3_employer_city
_999.patients	pat_emergency_city
_999.patients_demographics_snapshots	pds_city
_999.patients_demographics_snapshots	pds_employer_city
_999.patients_demographics_snapshots	pds_guarantor_city
_999.patients_demographics_snapshots	pds_ins1_employer_city
_999.patients_demographics_snapshots	pds_ins2_employer_city
_999.patients_demographics_snapshots	pds_ins3_employer_city
_999.physicians	phy_city
_999.precerts	pre_city
_999.precerts	pre_employer_city
_999.precerts	pre_guarantor_city
_999.precerts	pre_ins1_employer_city
_999.precerts	pre_ins2_employer_city
_999.radiology_orders	rad_city
_999.radiology_orders	rad_ins1_employer_city
_999.radiology_orders	rad_ins2_employer_city
aurora_standard.abmmpi	p_city
aurora_standard.abmmpi	emp_city
aurora_standard.abmmpi	i1_city
aurora_standard.abmmpi	i2_city
aurora_standard.abmmpi	i3_city
aurora_standard.abmmpi	gu_city
aurora_standard.abmmpi	gu_emp_city
aurora_standard.abmmpi	n1_city
aurora_standard.abmmpi	n2_city
aurora_standard.abmvis	p_city
aurora_standard.abmvis	gu_city
aurora_standard.abmvis	i1_city
aurora_standard.abmvis	i2_city
aurora_standard.abmvis	i3_city
aurora_standard.anmpi	p_city
aurora_standard.apsmpi	p_city
aurora_standard.aseympi	p_city
aurora_standard.bdmpi	sp_city
aurora_standard.bdmpi	nk_city
aurora_standard.bdmpi	pat_city
aurora_standard.bempi	p_city
aurora_standard.bfhos	gu_city
aurora_standard.bfpasr	gu_city
aurora_standard.bfrhc	gu_city
aurora_standard.bhar	p_city
aurora_standard.bhar	g_city
aurora_standard.bhar	ge_city
aurora_standard.bhar	co1_city
aurora_standard.bhar	co2_city
aurora_standard.bhar	co3_city
aurora_standard.bhar	co4_city
aurora_standard.bhar	co5_city
aurora_standard.bhar	co6_city
aurora_standard.bhar	em_city
aurora_standard.bmmpi	p_city
aurora_standard.bmmpi	gu_city
aurora_standard.bmnkin	n_city
aurora_standard.bmpact	p_city
aurora_standard.bmpact	gu_city
aurora_standard.bpar	p_city
aurora_standard.bpar	g_city
aurora_standard.bpar	ge_city
aurora_standard.bpar	co1_city
aurora_standard.bpar	co2_city
aurora_standard.bpar	co3_city
aurora_standard.bpar	co4_city
aurora_standard.bpar	co5_city
aurora_standard.bpar	co6_city
aurora_standard.bpar	em_city
aurora_standard.bpar2	p_city
aurora_standard.bpar2	g_city
aurora_standard.bpar2	ge_city
aurora_standard.bpar2	co1_city
aurora_standard.bpar2	co2_city
aurora_standard.bpar2	co3_city
aurora_standard.bpar2	co4_city
aurora_standard.bpar2	co5_city
aurora_standard.bpar2	co6_city
aurora_standard.bpar2	em_city
aurora_standard.bpmpi	p_city
aurora_standard.bpmpi2	p_city
aurora_standard.bs2mpi	contact1_city
aurora_standard.bs2mpi	p_city
aurora_standard.bsinsur	spouse_city
aurora_standard.bsinsur	nextkin_city
aurora_standard.bsinsur	patient_city
aurora_standard.bsmpi	contact1_city
aurora_standard.bsmpi	p_city
aurora_standard.c7insur2	ins_city
aurora_standard.c7insur3	ins_city
aurora_standard.c7mpi	p_city
aurora_standard.c7mpi	p2_city
aurora_standard.c7mpi	insur_city
aurora_standard.c7mpi	gu_city
aurora_standard.c7mpi	gu2_city
aurora_standard.c8mpi	p_city
aurora_standard.campi	spouse_city
aurora_standard.campi	nextkin_city
aurora_standard.campi	patient_city
aurora_standard.chhl7adt	patient_city
aurora_standard.chhl7in1	ins_city
aurora_standard.chhl7in1	ins_empl_city
aurora_standard.chlswbhd	fac_city
aurora_standard.chlswbhd	agt_city
aurora_standard.chlswbhd	sfw_city
aurora_standard.chltrnhd	fac_city
aurora_standard.chltrnhd	agt_city
aurora_standard.chltrnhd	sfw_city
aurora_standard.chmarcnbf	g_city
aurora_standard.chmarcnbf	ins1_city
aurora_standard.chmarcnbf	ins2_city
aurora_standard.chmarsi	pat_city
aurora_standard.chmarsi	gu_city
aurora_standard.chmarsi	gu_emp_city
aurora_standard.chmarsi	pat_emp_city
aurora_standard.chmarsi	ins1_city
aurora_standard.chmarsi	ins1_empl_city
aurora_standard.chmarsi	ins2_city
aurora_standard.chmarsi	ins2_empl_city
aurora_standard.chmarsi	ins3_city
aurora_standard.chmarsi	ins3_empl_city
aurora_standard.chmarst	fac_city
aurora_standard.chmarsti	fac_city
aurora_standard.chmarstps	ins_city
aurora_standard.chmarstps	emp_city
aurora_standard.chmarstpt	ins_city
aurora_standard.chmarstpt	emp_city
aurora_standard.chmazstd	pat_city
aurora_standard.chmazsti	pat_city
aurora_standard.chmazsto	pat_city
aurora_standard.chmbatex	pat_city
aurora_standard.chmcampi	pat_city
aurora_standard.chmcampi	gu_city
aurora_standard.chmcampi	gu_emp_city
aurora_standard.chmcampi	pat_emp_city
aurora_standard.chmcampi	ins1_city
aurora_standard.chmcampi	ins1_empl_city
aurora_standard.chmcampi	ins2_city
aurora_standard.chmcampi	ins2_empl_city
aurora_standard.chmcampi	ins3_city
aurora_standard.chmcampi	ins3_empl_city
aurora_standard.chmcmhed	debtor_city
aurora_standard.chmcmhed	pat_city
aurora_standard.chmexmpi	pat_city
aurora_standard.chmexmpi	gu_city
aurora_standard.chmexmpi	gu_emp_city
aurora_standard.chmexmpi	pat_emp_city
aurora_standard.chmexmpi	ins1_city
aurora_standard.chmexmpi	ins1_empl_city
aurora_standard.chmexmpi	ins2_city
aurora_standard.chmexmpi	ins2_empl_city
aurora_standard.chmexmpi	ins3_city
aurora_standard.chmexmpi	ins3_empl_city
aurora_standard.chmexvis	ins1_city
aurora_standard.chmexvis	ins2_city
aurora_standard.chmexvis	ins3_city
aurora_standard.chmhistp	p_city
aurora_standard.chmibend	send_claims_city
aurora_standard.chmlastr	pat_city
aurora_standard.chmmbc35	facility_city
aurora_standard.chmmbc37	plan_carrier_city
aurora_standard.chmnvstb	prov_city
aurora_standard.chmnvstb	payto_city
aurora_standard.chmnvstr	prov_city
aurora_standard.chmnvstr	payto_city
aurora_standard.chmokipd	pat_city
aurora_standard.chmokopd	pat_city
aurora_standard.chmozpcd	debtor_city
aurora_standard.chmp340b	patient_city
aurora_standard.chmpatir	subscri_city
aurora_standard.chmpatmr	spouse_city
aurora_standard.chmpatmr	nextkin_city
aurora_standard.chmpatmr	patient_city
aurora_standard.chmpatwc	school_city
aurora_standard.chmpdemo	p_city
aurora_standard.chmpdemo	p_emp_city
aurora_standard.chmpdemo	sp_city
aurora_standard.chmpdemo	gu_city
aurora_standard.chmpdemo	gu_emp_city
aurora_standard.chmpdemo	ins1_city
aurora_standard.chmpdemo	ins1_empl_city
aurora_standard.chmpdemo	ins2_city
aurora_standard.chmpdemo	ins2_empl_city
aurora_standard.chmpdemo	ins3_city
aurora_standard.chmpdemo	ins3_empl_city
aurora_standard.chmpress	patient_city
aurora_standard.chmradex	pat_city
aurora_standard.chmradex	pat_emp_city
aurora_standard.chmradex	gu_city
aurora_standard.chmradex	gu_emp_city
aurora_standard.chmradex	ins1_city
aurora_standard.chmradex	ins1_empl_city
aurora_standard.chmradex	ins2_city
aurora_standard.chmradex	ins2_empl_city
aurora_standard.chmradex	ins3_city
aurora_standard.chmradex	ins3_empl_city
aurora_standard.chmtxstr	pat_city
aurora_standard.chmub04r	f_09_city
aurora_standard.chmub04r	l_38_4_city
aurora_standard.chmub92r	l_13_city
aurora_standard.chmub92r	l_38_4_city
aurora_standard.chmub92r	l_66_a_city
aurora_standard.chmub92r	l_66_b_city
aurora_standard.chmub92r	l_66_c_city
aurora_standard.chmutah4	pat_city
aurora_standard.chpdeped	depend_city
aurora_standard.nbspouse	spouse_city
aurora_standard.stp1099c	company_city
aurora_standard.stp1099c	vend_city
aurora_standard.stprepsd	rep_city
aurora_standard.stpvendr	agent_city
aurora_standard.styoctcc	employer_city
aurora_standard.styoctcc	gov_entity_city
aurora_standard.styoempr	empl_city
aurora_standard.tmpub04r	f_09_city
aurora_standard.tmpub04r	l_38_4_city
common.applicants	app_city
common.applicants	app_hs_city
common.applicants	app_c1_city
common.applicants	app_c2_city
common.applicants	app_gs_city
common.applicants	app_o1_city
common.applicants	app_o2_city
common.applicants	app_employer_1_city
common.applicants	app_employer_2_city
common.applicants	app_employer_3_city
common.applicants	app_employer_4_city
common.clients	cli_city
common.clients	cli_billing_city
common.clients	cli_mailing_city
common.clients_contract_data	ccd_payer_city
common.contacts	con_city
common.customers	cus_city
common.customers	cus_billing_city
common.lab_interfaces	lif_cli_city
common.lab_interfaces_performing_sites	lips_city
common.labs	lab_city
common.leads	lea_city
common.zipmap	zip_city
rcmroi.dev__sf_users	addr_city
rcmroi.prod__sf_users	addr_city
rcmroi.test__sf_users	addr_city

state

Table	Column
Azalea.employees	emp_state
AzaleaStats.pull_requests	pull_state
AzaleaStats.pull_requests_environments	pullenv_state
_1.appointments_requests	aptreq_state
_1.billing_providers	bp_state
_1.buildings	bld_state
_1.charts	chrt_state
_1.client_contacts	clicon_state
_1.encounters	enc_state
_1.encounters	enc_employer_state
_1.encounters	enc_guarantor_state
_1.encounters	enc_ins1_employer_state
_1.encounters	enc_ins2_employer_state
_1.encounters	enc_ins3_employer_state
_1.encounters	enc_auto_accident_state
_1.hl7_lab_locations	hll_state
_1.insurances	ins_state
_1.insurances_claims_centers	icc_state
_1.insurances_repository	irep_ins_employer_state
_1.locations	loc_state
_1.non_patients	npat_state
_1.orders	ord_state
_1.orders	ord_ins1_employer_state
_1.orders	ord_ins2_employer_state
_1.patient_next_of_kin	pnk_state
_1.patients	pat_state
_1.patients	pat_employer_state
_1.patients	pat_guarantor_state
_1.patients	pat_ins1_employer_state
_1.patients	pat_ins2_employer_state
_1.patients	pat_ins3_employer_state
_1.patients	pat_emergency_state
_1.patients_demographics_snapshots	pds_state
_1.patients_demographics_snapshots	pds_employer_state
_1.patients_demographics_snapshots	pds_guarantor_state
_1.patients_demographics_snapshots	pds_ins1_employer_state
_1.patients_demographics_snapshots	pds_ins2_employer_state
_1.patients_demographics_snapshots	pds_ins3_employer_state
_1.physicians	phy_state
_1.physicians_servicing_states	physs_state
_1.precerts	pre_state
_1.precerts	pre_employer_state
_1.precerts	pre_guarantor_state
_1.precerts	pre_ins1_employer_state
_1.precerts	pre_ins2_employer_state
_1.precerts	pre_auto_accident_state
_1.radiology_orders	rad_state
_1.radiology_orders	rad_ins1_employer_state
_1.radiology_orders	rad_ins2_employer_state
_1188.appointments_requests	aptreq_state
_1188.billing_providers	bp_state
_1188.buildings	bld_state
_1188.charts	chrt_state
_1188.client_contacts	clicon_state
_1188.encounters	enc_state
_1188.encounters	enc_employer_state
_1188.encounters	enc_guarantor_state
_1188.encounters	enc_ins1_employer_state
_1188.encounters	enc_ins2_employer_state
_1188.encounters	enc_ins3_employer_state
_1188.encounters	enc_auto_accident_state
_1188.hl7_lab_locations	hll_state
_1188.insurances	ins_state
_1188.insurances_claims_centers	icc_state
_1188.insurances_repository	irep_ins_employer_state
_1188.locations	loc_state
_1188.non_patients	npat_state
_1188.orders	ord_state
_1188.orders	ord_ins1_employer_state
_1188.orders	ord_ins2_employer_state
_1188.patient_next_of_kin	pnk_state
_1188.patients	pat_state
_1188.patients	pat_employer_state
_1188.patients	pat_guarantor_state
_1188.patients	pat_ins1_employer_state
_1188.patients	pat_ins2_employer_state
_1188.patients	pat_ins3_employer_state
_1188.patients	pat_emergency_state
_1188.patients_demographics_snapshots	pds_state
_1188.patients_demographics_snapshots	pds_employer_state
_1188.patients_demographics_snapshots	pds_guarantor_state
_1188.patients_demographics_snapshots	pds_ins1_employer_state
_1188.patients_demographics_snapshots	pds_ins2_employer_state
_1188.patients_demographics_snapshots	pds_ins3_employer_state
_1188.physicians	phy_state
_1188.physicians_servicing_states	physs_state
_1188.precerts	pre_state
_1188.precerts	pre_employer_state
_1188.precerts	pre_guarantor_state
_1188.precerts	pre_ins1_employer_state
_1188.precerts	pre_ins2_employer_state
_1188.precerts	pre_auto_accident_state
_1188.radiology_orders	rad_state
_1188.radiology_orders	rad_ins1_employer_state
_1188.radiology_orders	rad_ins2_employer_state
_1218.appointments_requests	aptreq_state
_1218.billing_providers	bp_state
_1218.buildings	bld_state
_1218.charts	chrt_state
_1218.client_contacts	clicon_state
_1218.encounters	enc_state
_1218.encounters	enc_employer_state
_1218.encounters	enc_guarantor_state
_1218.encounters	enc_ins1_employer_state
_1218.encounters	enc_ins2_employer_state
_1218.encounters	enc_ins3_employer_state
_1218.encounters	enc_auto_accident_state
_1218.hl7_lab_locations	hll_state
_1218.insurances	ins_state
_1218.insurances_claims_centers	icc_state
_1218.insurances_repository	irep_ins_employer_state
_1218.locations	loc_state
_1218.non_patients	npat_state
_1218.orders	ord_state
_1218.orders	ord_ins1_employer_state
_1218.orders	ord_ins2_employer_state
_1218.patient_next_of_kin	pnk_state
_1218.patients	pat_state
_1218.patients	pat_employer_state
_1218.patients	pat_guarantor_state
_1218.patients	pat_ins1_employer_state
_1218.patients	pat_ins2_employer_state
_1218.patients	pat_ins3_employer_state
_1218.patients	pat_emergency_state
_1218.patients_demographics_snapshots	pds_state
_1218.patients_demographics_snapshots	pds_employer_state
_1218.patients_demographics_snapshots	pds_guarantor_state
_1218.patients_demographics_snapshots	pds_ins1_employer_state
_1218.patients_demographics_snapshots	pds_ins2_employer_state
_1218.patients_demographics_snapshots	pds_ins3_employer_state
_1218.physicians	phy_state
_1218.physicians_servicing_states	physs_state
_1218.precerts	pre_state
_1218.precerts	pre_employer_state
_1218.precerts	pre_guarantor_state
_1218.precerts	pre_ins1_employer_state
_1218.precerts	pre_ins2_employer_state
_1218.precerts	pre_auto_accident_state
_1218.radiology_orders	rad_state
_1218.radiology_orders	rad_ins1_employer_state
_1218.radiology_orders	rad_ins2_employer_state
_1548.appointments_requests	aptreq_state
_1548.billing_providers	bp_state
_1548.buildings	bld_state
_1548.charts	chrt_state
_1548.client_contacts	clicon_state
_1548.encounters	enc_state
_1548.encounters	enc_employer_state
_1548.encounters	enc_guarantor_state
_1548.encounters	enc_ins1_employer_state
_1548.encounters	enc_ins2_employer_state
_1548.encounters	enc_ins3_employer_state
_1548.encounters	enc_auto_accident_state
_1548.hl7_lab_locations	hll_state
_1548.insurances	ins_state
_1548.insurances_claims_centers	icc_state
_1548.insurances_repository	irep_ins_employer_state
_1548.locations	loc_state
_1548.non_patients	npat_state
_1548.orders	ord_state
_1548.orders	ord_ins1_employer_state
_1548.orders	ord_ins2_employer_state
_1548.patient_next_of_kin	pnk_state
_1548.patients	pat_state
_1548.patients	pat_employer_state
_1548.patients	pat_guarantor_state
_1548.patients	pat_ins1_employer_state
_1548.patients	pat_ins2_employer_state
_1548.patients	pat_ins3_employer_state
_1548.patients	pat_emergency_state
_1548.patients_demographics_snapshots	pds_state
_1548.patients_demographics_snapshots	pds_employer_state
_1548.patients_demographics_snapshots	pds_guarantor_state
_1548.patients_demographics_snapshots	pds_ins1_employer_state
_1548.patients_demographics_snapshots	pds_ins2_employer_state
_1548.patients_demographics_snapshots	pds_ins3_employer_state
_1548.physicians	phy_state
_1548.physicians_servicing_states	physs_state
_1548.precerts	pre_state
_1548.precerts	pre_employer_state
_1548.precerts	pre_guarantor_state
_1548.precerts	pre_ins1_employer_state
_1548.precerts	pre_ins2_employer_state
_1548.precerts	pre_auto_accident_state
_1548.radiology_orders	rad_state
_1548.radiology_orders	rad_ins1_employer_state
_1548.radiology_orders	rad_ins2_employer_state
_435.appointments_requests	aptreq_state
_435.billing_providers	bp_state
_435.buildings	bld_state
_435.charts	chrt_state
_435.client_contacts	clicon_state
_435.encounters	enc_state
_435.encounters	enc_employer_state
_435.encounters	enc_guarantor_state
_435.encounters	enc_ins1_employer_state
_435.encounters	enc_ins2_employer_state
_435.encounters	enc_ins3_employer_state
_435.encounters	enc_auto_accident_state
_435.hl7_lab_locations	hll_state
_435.insurances	ins_state
_435.insurances_claims_centers	icc_state
_435.insurances_repository	irep_ins_employer_state
_435.locations	loc_state
_435.non_patients	npat_state
_435.orders	ord_state
_435.orders	ord_ins1_employer_state
_435.orders	ord_ins2_employer_state
_435.patient_next_of_kin	pnk_state
_435.patients	pat_state
_435.patients	pat_employer_state
_435.patients	pat_guarantor_state
_435.patients	pat_ins1_employer_state
_435.patients	pat_ins2_employer_state
_435.patients	pat_ins3_employer_state
_435.patients	pat_emergency_state
_435.patients_demographics_snapshots	pds_state
_435.patients_demographics_snapshots	pds_employer_state
_435.patients_demographics_snapshots	pds_guarantor_state
_435.patients_demographics_snapshots	pds_ins1_employer_state
_435.patients_demographics_snapshots	pds_ins2_employer_state
_435.patients_demographics_snapshots	pds_ins3_employer_state
_435.physicians	phy_state
_435.physicians_servicing_states	physs_state
_435.precerts	pre_state
_435.precerts	pre_employer_state
_435.precerts	pre_guarantor_state
_435.precerts	pre_ins1_employer_state
_435.precerts	pre_ins2_employer_state
_435.precerts	pre_auto_accident_state
_435.radiology_orders	rad_state
_435.radiology_orders	rad_ins1_employer_state
_435.radiology_orders	rad_ins2_employer_state
_436.appointments_requests	aptreq_state
_436.billing_providers	bp_state
_436.buildings	bld_state
_436.charts	chrt_state
_436.client_contacts	clicon_state
_436.encounters	enc_state
_436.encounters	enc_employer_state
_436.encounters	enc_guarantor_state
_436.encounters	enc_ins1_employer_state
_436.encounters	enc_ins2_employer_state
_436.encounters	enc_ins3_employer_state
_436.encounters	enc_auto_accident_state
_436.hl7_lab_locations	hll_state
_436.insurances	ins_state
_436.insurances_claims_centers	icc_state
_436.insurances_repository	irep_ins_employer_state
_436.locations	loc_state
_436.non_patients	npat_state
_436.orders	ord_state
_436.orders	ord_ins1_employer_state
_436.orders	ord_ins2_employer_state
_436.patient_next_of_kin	pnk_state
_436.patients	pat_state
_436.patients	pat_employer_state
_436.patients	pat_guarantor_state
_436.patients	pat_ins1_employer_state
_436.patients	pat_ins2_employer_state
_436.patients	pat_ins3_employer_state
_436.patients	pat_emergency_state
_436.patients_demographics_snapshots	pds_state
_436.patients_demographics_snapshots	pds_employer_state
_436.patients_demographics_snapshots	pds_guarantor_state
_436.patients_demographics_snapshots	pds_ins1_employer_state
_436.patients_demographics_snapshots	pds_ins2_employer_state
_436.patients_demographics_snapshots	pds_ins3_employer_state
_436.physicians	phy_state
_436.physicians_servicing_states	physs_state
_436.precerts	pre_state
_436.precerts	pre_employer_state
_436.precerts	pre_guarantor_state
_436.precerts	pre_ins1_employer_state
_436.precerts	pre_ins2_employer_state
_436.precerts	pre_auto_accident_state
_436.radiology_orders	rad_state
_436.radiology_orders	rad_ins1_employer_state
_436.radiology_orders	rad_ins2_employer_state
_436_archive_testing.appointments_requests	aptreq_state
_436_archive_testing.billing_providers	bp_state
_436_archive_testing.buildings	bld_state
_436_archive_testing.charts	chrt_state
_436_archive_testing.client_contacts	clicon_state
_436_archive_testing.encounters	enc_state
_436_archive_testing.encounters	enc_employer_state
_436_archive_testing.encounters	enc_guarantor_state
_436_archive_testing.encounters	enc_ins1_employer_state
_436_archive_testing.encounters	enc_ins2_employer_state
_436_archive_testing.encounters	enc_ins3_employer_state
_436_archive_testing.encounters	enc_auto_accident_state
_436_archive_testing.hl7_lab_locations	hll_state
_436_archive_testing.insurances	ins_state
_436_archive_testing.insurances_claims_centers	icc_state
_436_archive_testing.insurances_repository	irep_ins_employer_state
_436_archive_testing.locations	loc_state
_436_archive_testing.non_patients	npat_state
_436_archive_testing.orders	ord_state
_436_archive_testing.orders	ord_ins1_employer_state
_436_archive_testing.orders	ord_ins2_employer_state
_436_archive_testing.patient_next_of_kin	pnk_state
_436_archive_testing.patients	pat_state
_436_archive_testing.patients	pat_employer_state
_436_archive_testing.patients	pat_guarantor_state
_436_archive_testing.patients	pat_ins1_employer_state
_436_archive_testing.patients	pat_ins2_employer_state
_436_archive_testing.patients	pat_ins3_employer_state
_436_archive_testing.patients	pat_emergency_state
_436_archive_testing.patients_demographics_snapshots	pds_state
_436_archive_testing.patients_demographics_snapshots	pds_employer_state
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_state
_436_archive_testing.patients_demographics_snapshots	pds_ins1_employer_state
_436_archive_testing.patients_demographics_snapshots	pds_ins2_employer_state
_436_archive_testing.patients_demographics_snapshots	pds_ins3_employer_state
_436_archive_testing.physicians	phy_state
_436_archive_testing.physicians_servicing_states	physs_state
_436_archive_testing.precerts	pre_state
_436_archive_testing.precerts	pre_employer_state
_436_archive_testing.precerts	pre_guarantor_state
_436_archive_testing.precerts	pre_ins1_employer_state
_436_archive_testing.precerts	pre_ins2_employer_state
_436_archive_testing.precerts	pre_auto_accident_state
_436_archive_testing.radiology_orders	rad_state
_436_archive_testing.radiology_orders	rad_ins1_employer_state
_436_archive_testing.radiology_orders	rad_ins2_employer_state
_437.appointments_requests	aptreq_state
_437.billing_providers	bp_state
_437.buildings	bld_state
_437.charts	chrt_state
_437.client_contacts	clicon_state
_437.encounters	enc_state
_437.encounters	enc_employer_state
_437.encounters	enc_guarantor_state
_437.encounters	enc_ins1_employer_state
_437.encounters	enc_ins2_employer_state
_437.encounters	enc_ins3_employer_state
_437.encounters	enc_auto_accident_state
_437.hl7_lab_locations	hll_state
_437.insurances	ins_state
_437.insurances_claims_centers	icc_state
_437.insurances_repository	irep_ins_employer_state
_437.locations	loc_state
_437.non_patients	npat_state
_437.orders	ord_state
_437.orders	ord_ins1_employer_state
_437.orders	ord_ins2_employer_state
_437.patient_next_of_kin	pnk_state
_437.patients	pat_state
_437.patients	pat_employer_state
_437.patients	pat_guarantor_state
_437.patients	pat_ins1_employer_state
_437.patients	pat_ins2_employer_state
_437.patients	pat_ins3_employer_state
_437.patients	pat_emergency_state
_437.patients_demographics_snapshots	pds_state
_437.patients_demographics_snapshots	pds_employer_state
_437.patients_demographics_snapshots	pds_guarantor_state
_437.patients_demographics_snapshots	pds_ins1_employer_state
_437.patients_demographics_snapshots	pds_ins2_employer_state
_437.patients_demographics_snapshots	pds_ins3_employer_state
_437.physicians	phy_state
_437.physicians_servicing_states	physs_state
_437.precerts	pre_state
_437.precerts	pre_employer_state
_437.precerts	pre_guarantor_state
_437.precerts	pre_ins1_employer_state
_437.precerts	pre_ins2_employer_state
_437.precerts	pre_auto_accident_state
_437.radiology_orders	rad_state
_437.radiology_orders	rad_ins1_employer_state
_437.radiology_orders	rad_ins2_employer_state
_8.appointments_requests	aptreq_state
_8.billing_providers	bp_state
_8.buildings	bld_state
_8.charts	chrt_state
_8.client_contacts	clicon_state
_8.encounters	enc_state
_8.encounters	enc_employer_state
_8.encounters	enc_guarantor_state
_8.encounters	enc_ins1_employer_state
_8.encounters	enc_ins2_employer_state
_8.encounters	enc_ins3_employer_state
_8.encounters	enc_auto_accident_state
_8.hl7_lab_locations	hll_state
_8.insurances	ins_state
_8.insurances_claims_centers	icc_state
_8.insurances_repository	irep_ins_employer_state
_8.locations	loc_state
_8.non_patients	npat_state
_8.orders	ord_state
_8.orders	ord_ins1_employer_state
_8.orders	ord_ins2_employer_state
_8.patient_next_of_kin	pnk_state
_8.patients	pat_state
_8.patients	pat_employer_state
_8.patients	pat_guarantor_state
_8.patients	pat_ins1_employer_state
_8.patients	pat_ins2_employer_state
_8.patients	pat_ins3_employer_state
_8.patients	pat_emergency_state
_8.patients_demographics_snapshots	pds_state
_8.patients_demographics_snapshots	pds_employer_state
_8.patients_demographics_snapshots	pds_guarantor_state
_8.patients_demographics_snapshots	pds_ins1_employer_state
_8.patients_demographics_snapshots	pds_ins2_employer_state
_8.patients_demographics_snapshots	pds_ins3_employer_state
_8.physicians	phy_state
_8.physicians_servicing_states	physs_state
_8.precerts	pre_state
_8.precerts	pre_employer_state
_8.precerts	pre_guarantor_state
_8.precerts	pre_ins1_employer_state
_8.precerts	pre_ins2_employer_state
_8.precerts	pre_auto_accident_state
_8.radiology_orders	rad_state
_8.radiology_orders	rad_ins1_employer_state
_8.radiology_orders	rad_ins2_employer_state
_81.appointments_requests	aptreq_state
_81.billing_providers	bp_state
_81.buildings	bld_state
_81.charts	chrt_state
_81.client_contacts	clicon_state
_81.encounters	enc_state
_81.encounters	enc_employer_state
_81.encounters	enc_guarantor_state
_81.encounters	enc_ins1_employer_state
_81.encounters	enc_ins2_employer_state
_81.encounters	enc_ins3_employer_state
_81.encounters	enc_auto_accident_state
_81.hl7_lab_locations	hll_state
_81.insurances	ins_state
_81.insurances_claims_centers	icc_state
_81.insurances_repository	irep_ins_employer_state
_81.locations	loc_state
_81.non_patients	npat_state
_81.orders	ord_state
_81.orders	ord_ins1_employer_state
_81.orders	ord_ins2_employer_state
_81.patient_next_of_kin	pnk_state
_81.patients	pat_state
_81.patients	pat_employer_state
_81.patients	pat_guarantor_state
_81.patients	pat_ins1_employer_state
_81.patients	pat_ins2_employer_state
_81.patients	pat_ins3_employer_state
_81.patients	pat_emergency_state
_81.patients_demographics_snapshots	pds_state
_81.patients_demographics_snapshots	pds_employer_state
_81.patients_demographics_snapshots	pds_guarantor_state
_81.patients_demographics_snapshots	pds_ins1_employer_state
_81.patients_demographics_snapshots	pds_ins2_employer_state
_81.patients_demographics_snapshots	pds_ins3_employer_state
_81.physicians	phy_state
_81.physicians_servicing_states	physs_state
_81.precerts	pre_state
_81.precerts	pre_employer_state
_81.precerts	pre_guarantor_state
_81.precerts	pre_ins1_employer_state
_81.precerts	pre_ins2_employer_state
_81.precerts	pre_auto_accident_state
_81.radiology_orders	rad_state
_81.radiology_orders	rad_ins1_employer_state
_81.radiology_orders	rad_ins2_employer_state
_999.appointments_requests	aptreq_state
_999.billing_providers	bp_state
_999.buildings	bld_state
_999.charts	chrt_state
_999.client_contacts	clicon_state
_999.encounters	enc_state
_999.encounters	enc_employer_state
_999.encounters	enc_guarantor_state
_999.encounters	enc_ins1_employer_state
_999.encounters	enc_ins2_employer_state
_999.encounters	enc_ins3_employer_state
_999.encounters	enc_auto_accident_state
_999.hl7_lab_locations	hll_state
_999.insurances	ins_state
_999.insurances_claims_centers	icc_state
_999.insurances_repository	irep_ins_employer_state
_999.locations	loc_state
_999.non_patients	npat_state
_999.orders	ord_state
_999.orders	ord_ins1_employer_state
_999.orders	ord_ins2_employer_state
_999.patient_next_of_kin	pnk_state
_999.patients	pat_state
_999.patients	pat_employer_state
_999.patients	pat_guarantor_state
_999.patients	pat_ins1_employer_state
_999.patients	pat_ins2_employer_state
_999.patients	pat_ins3_employer_state
_999.patients	pat_emergency_state
_999.patients_demographics_snapshots	pds_state
_999.patients_demographics_snapshots	pds_employer_state
_999.patients_demographics_snapshots	pds_guarantor_state
_999.patients_demographics_snapshots	pds_ins1_employer_state
_999.patients_demographics_snapshots	pds_ins2_employer_state
_999.patients_demographics_snapshots	pds_ins3_employer_state
_999.physicians	phy_state
_999.physicians_servicing_states	physs_state
_999.precerts	pre_state
_999.precerts	pre_employer_state
_999.precerts	pre_guarantor_state
_999.precerts	pre_ins1_employer_state
_999.precerts	pre_ins2_employer_state
_999.precerts	pre_auto_accident_state
_999.radiology_orders	rad_state
_999.radiology_orders	rad_ins1_employer_state
_999.radiology_orders	rad_ins2_employer_state
aurora_standard.afcsum2	in_state
aurora_standard.bdmpi	sp_state
aurora_standard.bsinsur	spouse_state
aurora_standard.bsinsur	nextkin_state
aurora_standard.bsinsur	patient_state
aurora_standard.campi	spouse_state
aurora_standard.campi	nextkin_state
aurora_standard.campi	patient_state
aurora_standard.chhl7adt	patient_state
aurora_standard.chhl7in1	ins_empl_state
aurora_standard.chltrand	oral_state
aurora_standard.chmarcnbf	g_state
aurora_standard.chmarst	fac_state
aurora_standard.chmarsti	fac_state
aurora_standard.chmarstps	ins_state
aurora_standard.chmarstps	emp_state
aurora_standard.chmarstpt	ins_state
aurora_standard.chmarstpt	emp_state
aurora_standard.chmcmhed	debtor_state
aurora_standard.chmcmhed	pat_state
aurora_standard.chmmbc35	facility_state
aurora_standard.chmmbc37	plan_carrier_state
aurora_standard.chmmbc55	accident_state
aurora_standard.chmmrhdr	upd_state
aurora_standard.chmozpcd	debtor_state
aurora_standard.chmp340b	patient_state
aurora_standard.chmpatir	subscri_state
aurora_standard.chmpatmr	spouse_state
aurora_standard.chmpatmr	nextkin_state
aurora_standard.chmpatmr	patient_state
aurora_standard.chmpress	patient_state
aurora_standard.chmub04r	l_38_4_state
aurora_standard.chmub92r	l_13_state
aurora_standard.chmub92r	l_38_4_state
aurora_standard.chmub92r	l_66_a_state
aurora_standard.chmub92r	l_66_b_state
aurora_standard.chmub92r	l_66_c_state
aurora_standard.chmutah4	pat_state
aurora_standard.chpdeped	depend_state
aurora_standard.chqlicnd	lic_state
aurora_standard.nbspouse	spouse_state
aurora_standard.ohoemadd	added_state
aurora_standard.stp1099c	company_state
aurora_standard.stp1099c	vend_state
aurora_standard.stp1099c	fed_state
aurora_standard.stprepsd	rep_state
aurora_standard.stpvendr	agent_state
aurora_standard.styoctcc	employer_state
aurora_standard.styoctcc	gov_entity_state
aurora_standard.styoempr	empl_state
aurora_standard.stytimod	work_state
aurora_standard.tmpub04r	l_38_4_state
aurora_standard.vend	city_state
common.applicants	app_state
common.applicants	app_hs_state
common.applicants	app_c1_state
common.applicants	app_c2_state
common.applicants	app_gs_state
common.applicants	app_o1_state
common.applicants	app_o2_state
common.applicants	app_employer_1_state
common.applicants	app_employer_2_state
common.applicants	app_employer_3_state
common.applicants	app_employer_4_state
common.clients	cli_state
common.clients	cli_billing_state
common.clients	cli_mailing_state
common.clients_contract_data	ccd_payer_state
common.contacts	con_state
common.customers	cus_state
common.customers	cus_billing_state
common.hl7_discharge_codes	hdc_state
common.lab_interfaces	lif_cli_state
common.lab_interfaces_performing_sites	lips_state
common.labs	lab_state
common.leads	lea_state
common.poverty_guidelines	povg_state
common.vaccine_funding_program_eligibility_codes	vfpe_state
common.zipmap	zip_state
rcmroi.dev__sf_users	addr_state
rcmroi.prod__sf_users	addr_state
rcmroi.test__sf_users	addr_state

company

Table	Column
_1.patients_implantable_devices	pid_company
_1188.patients_implantable_devices	pid_company
_1218.patients_implantable_devices	pid_company
_1548.patients_implantable_devices	pid_company
_435.patients_implantable_devices	pid_company
_436.patients_implantable_devices	pid_company
_436_archive_testing.patients_implantable_devices	pid_company
_437.patients_implantable_devices	pid_company
_8.patients_implantable_devices	pid_company
_81.patients_implantable_devices	pid_company
_999.patients_implantable_devices	pid_company
aurora_standard.c7insur	ins_company
aurora_standard.c7insur2	ins_company
aurora_standard.c7insur3	ins_company
aurora_standard.c9ins	ins_company
aurora_standard.cains	ins_company
common.contacts	con_company
common.faxes	fax_company

zipcode

Table	Column
aurora_standard.chmmhast	pat_zipcode