aurora_standard.apsphy

Field	Type	Null	Key
phy_no	int(10)	YES	UNI
lname	varchar(20)	YES	MUL
fname	varchar(20)	YES
mname	varchar(20)	YES
address1	varchar(30)	YES
address2	varchar(20)	YES
city	varchar(20)	YES
state	varchar(2)	YES
zip_code	varchar(10)	YES
phone	varchar(10)	YES
drsv	varchar(20)	YES
ein_no	varchar(20)	YES
mc_pin	varchar(20)	YES
mc_group	varchar(20)	YES
md_pin	varchar(20)	YES
md_group	varchar(20)	YES
taxonomy	varchar(20)	YES
npi	varchar(20)	YES
mc_npi	varchar(20)	YES
md_npi	varchar(20)	YES
id_no	varchar(20)	YES
lic_no	varchar(20)	YES
cert_no	varchar(20)	YES
ssn	varchar(20)	YES
title	varchar(20)	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

mname

Table	Column
Azalea.employees	emp_mname
_1.billing_providers	bp_mname
_1.charts	chrt_mname
_1.client_contacts	clicon_mname
_1.cpoe_responses	cpoe_res_mname
_1.donors	don_mname
_1.encounters	enc_mname
_1.hl7_accessions	acc_mname
_1.non_patients	npat_mname
_1.orders	ord_mname
_1.patient_next_of_kin	pnk_mname
_1.patients	pat_mname
_1.patients	pat_birth_mname
_1.patients_demographics_snapshots	pds_mname
_1.patients_names	pn_mname
_1.patients_responsibility_estimates	prest_mname
_1.physicians	phy_mname
_1.precerts	pre_mname
_1.radiology_orders	rad_mname
_1.radiology_results	rad_res_mname
_1188.billing_providers	bp_mname
_1188.charts	chrt_mname
_1188.client_contacts	clicon_mname
_1188.cpoe_responses	cpoe_res_mname
_1188.donors	don_mname
_1188.encounters	enc_mname
_1188.hl7_accessions	acc_mname
_1188.non_patients	npat_mname
_1188.orders	ord_mname
_1188.patient_next_of_kin	pnk_mname
_1188.patients	pat_mname
_1188.patients	pat_birth_mname
_1188.patients_demographics_snapshots	pds_mname
_1188.patients_names	pn_mname
_1188.patients_responsibility_estimates	prest_mname
_1188.physicians	phy_mname
_1188.precerts	pre_mname
_1188.radiology_orders	rad_mname
_1188.radiology_results	rad_res_mname
_1218.billing_providers	bp_mname
_1218.charts	chrt_mname
_1218.client_contacts	clicon_mname
_1218.cpoe_responses	cpoe_res_mname
_1218.donors	don_mname
_1218.encounters	enc_mname
_1218.hl7_accessions	acc_mname
_1218.non_patients	npat_mname
_1218.orders	ord_mname
_1218.patient_next_of_kin	pnk_mname
_1218.patients	pat_mname
_1218.patients	pat_birth_mname
_1218.patients_demographics_snapshots	pds_mname
_1218.patients_names	pn_mname
_1218.patients_responsibility_estimates	prest_mname
_1218.physicians	phy_mname
_1218.precerts	pre_mname
_1218.radiology_orders	rad_mname
_1218.radiology_results	rad_res_mname
_1548.billing_providers	bp_mname
_1548.charts	chrt_mname
_1548.client_contacts	clicon_mname
_1548.cpoe_responses	cpoe_res_mname
_1548.donors	don_mname
_1548.encounters	enc_mname
_1548.hl7_accessions	acc_mname
_1548.non_patients	npat_mname
_1548.orders	ord_mname
_1548.patient_next_of_kin	pnk_mname
_1548.patients	pat_mname
_1548.patients	pat_birth_mname
_1548.patients_demographics_snapshots	pds_mname
_1548.patients_names	pn_mname
_1548.patients_responsibility_estimates	prest_mname
_1548.physicians	phy_mname
_1548.precerts	pre_mname
_1548.radiology_orders	rad_mname
_1548.radiology_results	rad_res_mname
_435.billing_providers	bp_mname
_435.charts	chrt_mname
_435.client_contacts	clicon_mname
_435.cpoe_responses	cpoe_res_mname
_435.donors	don_mname
_435.encounters	enc_mname
_435.hl7_accessions	acc_mname
_435.non_patients	npat_mname
_435.orders	ord_mname
_435.patient_next_of_kin	pnk_mname
_435.patients	pat_mname
_435.patients	pat_birth_mname
_435.patients_demographics_snapshots	pds_mname
_435.patients_names	pn_mname
_435.patients_responsibility_estimates	prest_mname
_435.physicians	phy_mname
_435.precerts	pre_mname
_435.radiology_orders	rad_mname
_435.radiology_results	rad_res_mname
_436.billing_providers	bp_mname
_436.charts	chrt_mname
_436.client_contacts	clicon_mname
_436.cpoe_responses	cpoe_res_mname
_436.donors	don_mname
_436.encounters	enc_mname
_436.hl7_accessions	acc_mname
_436.non_patients	npat_mname
_436.orders	ord_mname
_436.patient_next_of_kin	pnk_mname
_436.patients	pat_mname
_436.patients	pat_birth_mname
_436.patients_demographics_snapshots	pds_mname
_436.patients_names	pn_mname
_436.patients_responsibility_estimates	prest_mname
_436.physicians	phy_mname
_436.precerts	pre_mname
_436.radiology_orders	rad_mname
_436.radiology_results	rad_res_mname
_436_archive_testing.billing_providers	bp_mname
_436_archive_testing.charts	chrt_mname
_436_archive_testing.client_contacts	clicon_mname
_436_archive_testing.cpoe_responses	cpoe_res_mname
_436_archive_testing.donors	don_mname
_436_archive_testing.encounters	enc_mname
_436_archive_testing.hl7_accessions	acc_mname
_436_archive_testing.non_patients	npat_mname
_436_archive_testing.orders	ord_mname
_436_archive_testing.patient_next_of_kin	pnk_mname
_436_archive_testing.patients	pat_mname
_436_archive_testing.patients	pat_birth_mname
_436_archive_testing.patients_demographics_snapshots	pds_mname
_436_archive_testing.patients_responsibility_estimates	prest_mname
_436_archive_testing.physicians	phy_mname
_436_archive_testing.precerts	pre_mname
_436_archive_testing.radiology_orders	rad_mname
_436_archive_testing.radiology_results	rad_res_mname
_437.billing_providers	bp_mname
_437.charts	chrt_mname
_437.client_contacts	clicon_mname
_437.cpoe_responses	cpoe_res_mname
_437.donors	don_mname
_437.encounters	enc_mname
_437.hl7_accessions	acc_mname
_437.non_patients	npat_mname
_437.orders	ord_mname
_437.patient_next_of_kin	pnk_mname
_437.patients	pat_mname
_437.patients	pat_birth_mname
_437.patients_demographics_snapshots	pds_mname
_437.patients_names	pn_mname
_437.patients_responsibility_estimates	prest_mname
_437.physicians	phy_mname
_437.precerts	pre_mname
_437.radiology_orders	rad_mname
_437.radiology_results	rad_res_mname
_8.billing_providers	bp_mname
_8.charts	chrt_mname
_8.client_contacts	clicon_mname
_8.cpoe_responses	cpoe_res_mname
_8.donors	don_mname
_8.encounters	enc_mname
_8.hl7_accessions	acc_mname
_8.non_patients	npat_mname
_8.orders	ord_mname
_8.patient_next_of_kin	pnk_mname
_8.patients	pat_mname
_8.patients	pat_birth_mname
_8.patients_demographics_snapshots	pds_mname
_8.patients_names	pn_mname
_8.patients_responsibility_estimates	prest_mname
_8.physicians	phy_mname
_8.precerts	pre_mname
_8.radiology_orders	rad_mname
_8.radiology_results	rad_res_mname
_81.billing_providers	bp_mname
_81.charts	chrt_mname
_81.client_contacts	clicon_mname
_81.cpoe_responses	cpoe_res_mname
_81.donors	don_mname
_81.encounters	enc_mname
_81.hl7_accessions	acc_mname
_81.non_patients	npat_mname
_81.orders	ord_mname
_81.patient_next_of_kin	pnk_mname
_81.patients	pat_mname
_81.patients	pat_birth_mname
_81.patients_demographics_snapshots	pds_mname
_81.patients_names	pn_mname
_81.patients_responsibility_estimates	prest_mname
_81.physicians	phy_mname
_81.precerts	pre_mname
_81.radiology_orders	rad_mname
_81.radiology_results	rad_res_mname
_999.billing_providers	bp_mname
_999.charts	chrt_mname
_999.client_contacts	clicon_mname
_999.cpoe_responses	cpoe_res_mname
_999.donors	don_mname
_999.encounters	enc_mname
_999.hl7_accessions	acc_mname
_999.non_patients	npat_mname
_999.orders	ord_mname
_999.patient_next_of_kin	pnk_mname
_999.patients	pat_mname
_999.patients	pat_birth_mname
_999.patients_demographics_snapshots	pds_mname
_999.patients_names	pn_mname
_999.patients_responsibility_estimates	prest_mname
_999.physicians	phy_mname
_999.precerts	pre_mname
_999.radiology_orders	rad_mname
_999.radiology_results	rad_res_mname
aurora_standard.abmmpi	gu_mname
aurora_standard.abmvis	gu_mname
aurora_standard.bhar	g_mname
aurora_standard.bmnkin	n_mname
aurora_standard.bpar	g_mname
aurora_standard.bpar2	g_mname
aurora_standard.c7mpi	gu_mname
aurora_standard.chmpdemo	p_mname
aurora_standard.chmpdemo	sp_mname
aurora_standard.chmpdemo	fam_phy_mname
aurora_standard.chmpdemo	attend_phy_mname
aurora_standard.chmpdemo	admit_phy_mname
aurora_standard.chmpsvcd	rend_mname
aurora_standard.chmpsvcd	ref_mname
aurora_standard.styoctcc	contact_mname
aurora_standard.styoctcc	gov_entity_contact_person_mname
aurora_standard.styoempd	depend_mname
aurora_standard.styoempr	empl_mname
common.applicants	app_mname
common.users	usr_mname

title

Table	Column
Azalea.employees	emp_title
AzaleaStats.pull_requests	pull_title
_1.billing_reports_queue	brq_title
_1.clinical_interventions_test_codes_map	citcm_reporting_title
_1.daily_close_schedules	dcs_title
_1.encounters_forms	efrm_title
_1.encounters_soap_templates	est_phy_title
_1.erx_notifications	erx_nots_title
_1.forms	frm_title
_1.handouts	hand_title
_1.notes	not_title
_1.orders_test_codes_map	otcm_reporting_title
_1.radiology_orders_test_codes_map	rtcm_reporting_title
_1.radiology_results_test_codes_map	rrtcm_reporting_title
_1.reports_queue	rq_title
_1188.billing_reports_queue	brq_title
_1188.clinical_interventions_test_codes_map	citcm_reporting_title
_1188.daily_close_schedules	dcs_title
_1188.encounters_forms	efrm_title
_1188.encounters_soap_templates	est_phy_title
_1188.erx_notifications	erx_nots_title
_1188.forms	frm_title
_1188.handouts	hand_title
_1188.notes	not_title
_1188.orders_test_codes_map	otcm_reporting_title
_1188.radiology_orders_test_codes_map	rtcm_reporting_title
_1188.radiology_results_test_codes_map	rrtcm_reporting_title
_1188.reports_queue	rq_title
_1218.billing_reports_queue	brq_title
_1218.clinical_interventions_test_codes_map	citcm_reporting_title
_1218.daily_close_schedules	dcs_title
_1218.encounters_forms	efrm_title
_1218.encounters_soap_templates	est_phy_title
_1218.erx_notifications	erx_nots_title
_1218.forms	frm_title
_1218.handouts	hand_title
_1218.notes	not_title
_1218.orders_test_codes_map	otcm_reporting_title
_1218.radiology_orders_test_codes_map	rtcm_reporting_title
_1218.radiology_results_test_codes_map	rrtcm_reporting_title
_1218.reports_queue	rq_title
_1548.billing_reports_queue	brq_title
_1548.clinical_interventions_test_codes_map	citcm_reporting_title
_1548.daily_close_schedules	dcs_title
_1548.encounters_forms	efrm_title
_1548.encounters_soap_templates	est_phy_title
_1548.erx_notifications	erx_nots_title
_1548.forms	frm_title
_1548.handouts	hand_title
_1548.notes	not_title
_1548.orders_test_codes_map	otcm_reporting_title
_1548.radiology_orders_test_codes_map	rtcm_reporting_title
_1548.radiology_results_test_codes_map	rrtcm_reporting_title
_1548.reports_queue	rq_title
_435.billing_reports_queue	brq_title
_435.clinical_interventions_test_codes_map	citcm_reporting_title
_435.daily_close_schedules	dcs_title
_435.encounters_forms	efrm_title
_435.encounters_soap_templates	est_phy_title
_435.erx_notifications	erx_nots_title
_435.forms	frm_title
_435.handouts	hand_title
_435.notes	not_title
_435.orders_test_codes_map	otcm_reporting_title
_435.radiology_orders_test_codes_map	rtcm_reporting_title
_435.radiology_results_test_codes_map	rrtcm_reporting_title
_435.reports_queue	rq_title
_436.billing_reports_queue	brq_title
_436.clinical_interventions_test_codes_map	citcm_reporting_title
_436.daily_close_schedules	dcs_title
_436.encounters_forms	efrm_title
_436.encounters_soap_templates	est_phy_title
_436.erx_notifications	erx_nots_title
_436.forms	frm_title
_436.handouts	hand_title
_436.notes	not_title
_436.orders_test_codes_map	otcm_reporting_title
_436.radiology_orders_test_codes_map	rtcm_reporting_title
_436.radiology_results_test_codes_map	rrtcm_reporting_title
_436.reports_queue	rq_title
_436_archive_testing.billing_reports_queue	brq_title
_436_archive_testing.clinical_interventions_test_codes_map	citcm_reporting_title
_436_archive_testing.daily_close_schedules	dcs_title
_436_archive_testing.encounters_forms	efrm_title
_436_archive_testing.encounters_soap_templates	est_phy_title
_436_archive_testing.erx_notifications	erx_nots_title
_436_archive_testing.forms	frm_title
_436_archive_testing.handouts	hand_title
_436_archive_testing.notes	not_title
_436_archive_testing.orders_test_codes_map	otcm_reporting_title
_436_archive_testing.radiology_orders_test_codes_map	rtcm_reporting_title
_436_archive_testing.radiology_results_test_codes_map	rrtcm_reporting_title
_436_archive_testing.reports_queue	rq_title
_437.billing_reports_queue	brq_title
_437.clinical_interventions_test_codes_map	citcm_reporting_title
_437.daily_close_schedules	dcs_title
_437.encounters_forms	efrm_title
_437.encounters_soap_templates	est_phy_title
_437.erx_notifications	erx_nots_title
_437.forms	frm_title
_437.handouts	hand_title
_437.notes	not_title
_437.orders_test_codes_map	otcm_reporting_title
_437.radiology_orders_test_codes_map	rtcm_reporting_title
_437.radiology_results_test_codes_map	rrtcm_reporting_title
_437.reports_queue	rq_title
_8.billing_reports_queue	brq_title
_8.clinical_interventions_test_codes_map	citcm_reporting_title
_8.daily_close_schedules	dcs_title
_8.encounters_forms	efrm_title
_8.encounters_soap_templates	est_phy_title
_8.erx_notifications	erx_nots_title
_8.forms	frm_title
_8.handouts	hand_title
_8.notes	not_title
_8.orders_test_codes_map	otcm_reporting_title
_8.radiology_orders_test_codes_map	rtcm_reporting_title
_8.radiology_results_test_codes_map	rrtcm_reporting_title
_8.reports_queue	rq_title
_81.billing_reports_queue	brq_title
_81.clinical_interventions_test_codes_map	citcm_reporting_title
_81.daily_close_schedules	dcs_title
_81.encounters_forms	efrm_title
_81.encounters_soap_templates	est_phy_title
_81.erx_notifications	erx_nots_title
_81.forms	frm_title
_81.handouts	hand_title
_81.notes	not_title
_81.orders_test_codes_map	otcm_reporting_title
_81.radiology_orders_test_codes_map	rtcm_reporting_title
_81.radiology_results_test_codes_map	rrtcm_reporting_title
_81.reports_queue	rq_title
_999.billing_reports_queue	brq_title
_999.clinical_interventions_test_codes_map	citcm_reporting_title
_999.daily_close_schedules	dcs_title
_999.encounters_forms	efrm_title
_999.encounters_soap_templates	est_phy_title
_999.erx_notifications	erx_nots_title
_999.forms	frm_title
_999.handouts	hand_title
_999.notes	not_title
_999.orders_test_codes_map	otcm_reporting_title
_999.radiology_orders_test_codes_map	rtcm_reporting_title
_999.radiology_results_test_codes_map	rrtcm_reporting_title
_999.reports_queue	rq_title
ahiWiki.archive	ar_title
ahiWiki.category	cat_title
ahiWiki.iwlinks	iwl_title
ahiWiki.job	job_title
ahiWiki.langlinks	ll_title
ahiWiki.logging	log_title
ahiWiki.page	page_title
ahiWiki.pagelinks	pl_title
ahiWiki.protected_titles	pt_title
ahiWiki.querycache	qc_title
ahiWiki.querycachetwo	qcc_title
ahiWiki.recentchanges	rc_title
ahiWiki.redirect	rd_title
ahiWiki.searchindex	si_title
ahiWiki.templatelinks	tl_title
ahiWiki.watchlist	wl_title
aurora_standard.bsguar	nm_title
aurora_standard.bvguar	nm_title
aurora_standard.bvmpi	nm_title
aurora_standard.bvmpi2	nm_title
aurora_standard.cgsclipr	clip_title
aurora_standard.chmapccc	grp_title
aurora_standard.chmdi10c	long_title
aurora_standard.chmdiage	long_title
aurora_standard.chmdiagx	long_title
aurora_standard.chmhcahp	dr_title
aurora_standard.chmpdemo	p_title
aurora_standard.chmpdemo	sp_title
aurora_standard.chmpdemo	gu_title
aurora_standard.chmpdemo	fam_phy_title
aurora_standard.chmpdemo	attend_phy_title
aurora_standard.chmpdemo	admit_phy_title
aurora_standard.chmpr10c	long_title
aurora_standard.chmpsvcd	rend_title
aurora_standard.chmpsvcd	ref_title
aurora_standard.chpcempr	job_title
aurora_standard.chpcntrc	educ_dir_title
aurora_standard.chtraind	stu_title
aurora_standard.chxtechc	tech_title
aurora_standard.chytechc	tech_title
aurora_standard.hl7gt1	job_title
aurora_standard.hl7in2	job_title
aurora_standard.newicd10	short_title
aurora_standard.newicd10	long_title
aurora_standard.newicd9c	short_title
aurora_standard.newicd9c	long_title
aurora_standard.ohoemplr	job_title
aurora_standard.stfnotee	note_title
aurora_standard.stfnoter	note_title
aurora_standard.styemplr	job_title
aurora_standard.wrkicd9	short_title
common.contacts	con_title
common.cqm_info	cit_title
common.leads	lea_title
common.reports_queue_orders	rqo_title
common.test_codes	tco_reporting_title
common.users	usr_title
common.view_configs_options	vwco_title
common.view_configs_options	vwco_hide_title
template_library.encounters_soap_templates	est_phy_title
template_library.forms	frm_title

ssn

Table	Column
Azalea.employees	emp_ssn
_1.charts	chrt_ssn
_1.cpoe_responses	cpoe_res_ssn
_1.encounters	enc_ssn
_1.encounters	enc_guarantor_ssn
_1.encounters	enc_ins1_insured_ssn
_1.encounters	enc_ins2_insured_ssn
_1.encounters	enc_ins3_insured_ssn
_1.examples	exa_ssn
_1.hl7_accessions	acc_ssn
_1.insurances_repository	irep_ins_insured_ssn
_1.non_patients	npat_ssn
_1.orders	ord_ssn
_1.patients	pat_ssn
_1.patients	pat_guarantor_ssn
_1.patients	pat_ins1_insured_ssn
_1.patients	pat_ins2_insured_ssn
_1.patients	pat_ins3_insured_ssn
_1.patients_demographics_snapshots	pds_ssn
_1.patients_demographics_snapshots	pds_guarantor_ssn
_1.patients_demographics_snapshots	pds_ins1_insured_ssn
_1.patients_demographics_snapshots	pds_ins2_insured_ssn
_1.patients_demographics_snapshots	pds_ins3_insured_ssn
_1.patients_responsibility_estimates	prest_ssn
_1.precerts	pre_ssn
_1.precerts	pre_guarantor_ssn
_1.precerts	pre_ins1_insured_ssn
_1.precerts	pre_ins2_insured_ssn
_1.radiology_orders	rad_ssn
_1.radiology_results	rad_res_ssn
_1188.charts	chrt_ssn
_1188.cpoe_responses	cpoe_res_ssn
_1188.encounters	enc_ssn
_1188.encounters	enc_guarantor_ssn
_1188.encounters	enc_ins1_insured_ssn
_1188.encounters	enc_ins2_insured_ssn
_1188.encounters	enc_ins3_insured_ssn
_1188.examples	exa_ssn
_1188.hl7_accessions	acc_ssn
_1188.insurances_repository	irep_ins_insured_ssn
_1188.non_patients	npat_ssn
_1188.orders	ord_ssn
_1188.patients	pat_ssn
_1188.patients	pat_guarantor_ssn
_1188.patients	pat_ins1_insured_ssn
_1188.patients	pat_ins2_insured_ssn
_1188.patients	pat_ins3_insured_ssn
_1188.patients_demographics_snapshots	pds_ssn
_1188.patients_demographics_snapshots	pds_guarantor_ssn
_1188.patients_demographics_snapshots	pds_ins1_insured_ssn
_1188.patients_demographics_snapshots	pds_ins2_insured_ssn
_1188.patients_demographics_snapshots	pds_ins3_insured_ssn
_1188.patients_responsibility_estimates	prest_ssn
_1188.precerts	pre_ssn
_1188.precerts	pre_guarantor_ssn
_1188.precerts	pre_ins1_insured_ssn
_1188.precerts	pre_ins2_insured_ssn
_1188.radiology_orders	rad_ssn
_1188.radiology_results	rad_res_ssn
_1218.charts	chrt_ssn
_1218.cpoe_responses	cpoe_res_ssn
_1218.encounters	enc_ssn
_1218.encounters	enc_guarantor_ssn
_1218.encounters	enc_ins1_insured_ssn
_1218.encounters	enc_ins2_insured_ssn
_1218.encounters	enc_ins3_insured_ssn
_1218.examples	exa_ssn
_1218.hl7_accessions	acc_ssn
_1218.insurances_repository	irep_ins_insured_ssn
_1218.non_patients	npat_ssn
_1218.orders	ord_ssn
_1218.patients	pat_ssn
_1218.patients	pat_guarantor_ssn
_1218.patients	pat_ins1_insured_ssn
_1218.patients	pat_ins2_insured_ssn
_1218.patients	pat_ins3_insured_ssn
_1218.patients_demographics_snapshots	pds_ssn
_1218.patients_demographics_snapshots	pds_guarantor_ssn
_1218.patients_demographics_snapshots	pds_ins1_insured_ssn
_1218.patients_demographics_snapshots	pds_ins2_insured_ssn
_1218.patients_demographics_snapshots	pds_ins3_insured_ssn
_1218.patients_responsibility_estimates	prest_ssn
_1218.precerts	pre_ssn
_1218.precerts	pre_guarantor_ssn
_1218.precerts	pre_ins1_insured_ssn
_1218.precerts	pre_ins2_insured_ssn
_1218.radiology_orders	rad_ssn
_1218.radiology_results	rad_res_ssn
_1548.charts	chrt_ssn
_1548.cpoe_responses	cpoe_res_ssn
_1548.encounters	enc_ssn
_1548.encounters	enc_guarantor_ssn
_1548.encounters	enc_ins1_insured_ssn
_1548.encounters	enc_ins2_insured_ssn
_1548.encounters	enc_ins3_insured_ssn
_1548.examples	exa_ssn
_1548.hl7_accessions	acc_ssn
_1548.insurances_repository	irep_ins_insured_ssn
_1548.non_patients	npat_ssn
_1548.orders	ord_ssn
_1548.patients	pat_ssn
_1548.patients	pat_guarantor_ssn
_1548.patients	pat_ins1_insured_ssn
_1548.patients	pat_ins2_insured_ssn
_1548.patients	pat_ins3_insured_ssn
_1548.patients_demographics_snapshots	pds_ssn
_1548.patients_demographics_snapshots	pds_guarantor_ssn
_1548.patients_demographics_snapshots	pds_ins1_insured_ssn
_1548.patients_demographics_snapshots	pds_ins2_insured_ssn
_1548.patients_demographics_snapshots	pds_ins3_insured_ssn
_1548.patients_responsibility_estimates	prest_ssn
_1548.precerts	pre_ssn
_1548.precerts	pre_guarantor_ssn
_1548.precerts	pre_ins1_insured_ssn
_1548.precerts	pre_ins2_insured_ssn
_1548.radiology_orders	rad_ssn
_1548.radiology_results	rad_res_ssn
_435.charts	chrt_ssn
_435.cpoe_responses	cpoe_res_ssn
_435.encounters	enc_ssn
_435.encounters	enc_guarantor_ssn
_435.encounters	enc_ins1_insured_ssn
_435.encounters	enc_ins2_insured_ssn
_435.encounters	enc_ins3_insured_ssn
_435.examples	exa_ssn
_435.hl7_accessions	acc_ssn
_435.insurances_repository	irep_ins_insured_ssn
_435.non_patients	npat_ssn
_435.orders	ord_ssn
_435.patients	pat_ssn
_435.patients	pat_guarantor_ssn
_435.patients	pat_ins1_insured_ssn
_435.patients	pat_ins2_insured_ssn
_435.patients	pat_ins3_insured_ssn
_435.patients_demographics_snapshots	pds_ssn
_435.patients_demographics_snapshots	pds_guarantor_ssn
_435.patients_demographics_snapshots	pds_ins1_insured_ssn
_435.patients_demographics_snapshots	pds_ins2_insured_ssn
_435.patients_demographics_snapshots	pds_ins3_insured_ssn
_435.patients_responsibility_estimates	prest_ssn
_435.precerts	pre_ssn
_435.precerts	pre_guarantor_ssn
_435.precerts	pre_ins1_insured_ssn
_435.precerts	pre_ins2_insured_ssn
_435.radiology_orders	rad_ssn
_435.radiology_results	rad_res_ssn
_436.charts	chrt_ssn
_436.cpoe_responses	cpoe_res_ssn
_436.encounters	enc_ssn
_436.encounters	enc_guarantor_ssn
_436.encounters	enc_ins1_insured_ssn
_436.encounters	enc_ins2_insured_ssn
_436.encounters	enc_ins3_insured_ssn
_436.examples	exa_ssn
_436.hl7_accessions	acc_ssn
_436.insurances_repository	irep_ins_insured_ssn
_436.non_patients	npat_ssn
_436.orders	ord_ssn
_436.patients	pat_ssn
_436.patients	pat_guarantor_ssn
_436.patients	pat_ins1_insured_ssn
_436.patients	pat_ins2_insured_ssn
_436.patients	pat_ins3_insured_ssn
_436.patients_demographics_snapshots	pds_ssn
_436.patients_demographics_snapshots	pds_guarantor_ssn
_436.patients_demographics_snapshots	pds_ins1_insured_ssn
_436.patients_demographics_snapshots	pds_ins2_insured_ssn
_436.patients_demographics_snapshots	pds_ins3_insured_ssn
_436.patients_responsibility_estimates	prest_ssn
_436.precerts	pre_ssn
_436.precerts	pre_guarantor_ssn
_436.precerts	pre_ins1_insured_ssn
_436.precerts	pre_ins2_insured_ssn
_436.radiology_orders	rad_ssn
_436.radiology_results	rad_res_ssn
_436_archive_testing.charts	chrt_ssn
_436_archive_testing.cpoe_responses	cpoe_res_ssn
_436_archive_testing.encounters	enc_ssn
_436_archive_testing.encounters	enc_guarantor_ssn
_436_archive_testing.encounters	enc_ins1_insured_ssn
_436_archive_testing.encounters	enc_ins2_insured_ssn
_436_archive_testing.encounters	enc_ins3_insured_ssn
_436_archive_testing.examples	exa_ssn
_436_archive_testing.hl7_accessions	acc_ssn
_436_archive_testing.insurances_repository	irep_ins_insured_ssn
_436_archive_testing.non_patients	npat_ssn
_436_archive_testing.orders	ord_ssn
_436_archive_testing.patients	pat_ssn
_436_archive_testing.patients	pat_guarantor_ssn
_436_archive_testing.patients	pat_ins1_insured_ssn
_436_archive_testing.patients	pat_ins2_insured_ssn
_436_archive_testing.patients	pat_ins3_insured_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ssn
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ins1_insured_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ins2_insured_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ins3_insured_ssn
_436_archive_testing.patients_responsibility_estimates	prest_ssn
_436_archive_testing.precerts	pre_ssn
_436_archive_testing.precerts	pre_guarantor_ssn
_436_archive_testing.precerts	pre_ins1_insured_ssn
_436_archive_testing.precerts	pre_ins2_insured_ssn
_436_archive_testing.radiology_orders	rad_ssn
_436_archive_testing.radiology_results	rad_res_ssn
_437.charts	chrt_ssn
_437.cpoe_responses	cpoe_res_ssn
_437.encounters	enc_ssn
_437.encounters	enc_guarantor_ssn
_437.encounters	enc_ins1_insured_ssn
_437.encounters	enc_ins2_insured_ssn
_437.encounters	enc_ins3_insured_ssn
_437.examples	exa_ssn
_437.hl7_accessions	acc_ssn
_437.insurances_repository	irep_ins_insured_ssn
_437.non_patients	npat_ssn
_437.orders	ord_ssn
_437.patients	pat_ssn
_437.patients	pat_guarantor_ssn
_437.patients	pat_ins1_insured_ssn
_437.patients	pat_ins2_insured_ssn
_437.patients	pat_ins3_insured_ssn
_437.patients_demographics_snapshots	pds_ssn
_437.patients_demographics_snapshots	pds_guarantor_ssn
_437.patients_demographics_snapshots	pds_ins1_insured_ssn
_437.patients_demographics_snapshots	pds_ins2_insured_ssn
_437.patients_demographics_snapshots	pds_ins3_insured_ssn
_437.patients_responsibility_estimates	prest_ssn
_437.precerts	pre_ssn
_437.precerts	pre_guarantor_ssn
_437.precerts	pre_ins1_insured_ssn
_437.precerts	pre_ins2_insured_ssn
_437.radiology_orders	rad_ssn
_437.radiology_results	rad_res_ssn
_8.charts	chrt_ssn
_8.cpoe_responses	cpoe_res_ssn
_8.encounters	enc_ssn
_8.encounters	enc_guarantor_ssn
_8.encounters	enc_ins1_insured_ssn
_8.encounters	enc_ins2_insured_ssn
_8.encounters	enc_ins3_insured_ssn
_8.examples	exa_ssn
_8.hl7_accessions	acc_ssn
_8.insurances_repository	irep_ins_insured_ssn
_8.non_patients	npat_ssn
_8.orders	ord_ssn
_8.patients	pat_ssn
_8.patients	pat_guarantor_ssn
_8.patients	pat_ins1_insured_ssn
_8.patients	pat_ins2_insured_ssn
_8.patients	pat_ins3_insured_ssn
_8.patients_demographics_snapshots	pds_ssn
_8.patients_demographics_snapshots	pds_guarantor_ssn
_8.patients_demographics_snapshots	pds_ins1_insured_ssn
_8.patients_demographics_snapshots	pds_ins2_insured_ssn
_8.patients_demographics_snapshots	pds_ins3_insured_ssn
_8.patients_responsibility_estimates	prest_ssn
_8.precerts	pre_ssn
_8.precerts	pre_guarantor_ssn
_8.precerts	pre_ins1_insured_ssn
_8.precerts	pre_ins2_insured_ssn
_8.radiology_orders	rad_ssn
_8.radiology_results	rad_res_ssn
_81.charts	chrt_ssn
_81.cpoe_responses	cpoe_res_ssn
_81.encounters	enc_ssn
_81.encounters	enc_guarantor_ssn
_81.encounters	enc_ins1_insured_ssn
_81.encounters	enc_ins2_insured_ssn
_81.encounters	enc_ins3_insured_ssn
_81.examples	exa_ssn
_81.hl7_accessions	acc_ssn
_81.insurances_repository	irep_ins_insured_ssn
_81.non_patients	npat_ssn
_81.orders	ord_ssn
_81.patients	pat_ssn
_81.patients	pat_guarantor_ssn
_81.patients	pat_ins1_insured_ssn
_81.patients	pat_ins2_insured_ssn
_81.patients	pat_ins3_insured_ssn
_81.patients_demographics_snapshots	pds_ssn
_81.patients_demographics_snapshots	pds_guarantor_ssn
_81.patients_demographics_snapshots	pds_ins1_insured_ssn
_81.patients_demographics_snapshots	pds_ins2_insured_ssn
_81.patients_demographics_snapshots	pds_ins3_insured_ssn
_81.patients_responsibility_estimates	prest_ssn
_81.precerts	pre_ssn
_81.precerts	pre_guarantor_ssn
_81.precerts	pre_ins1_insured_ssn
_81.precerts	pre_ins2_insured_ssn
_81.radiology_orders	rad_ssn
_81.radiology_results	rad_res_ssn
_999.charts	chrt_ssn
_999.cpoe_responses	cpoe_res_ssn
_999.encounters	enc_ssn
_999.encounters	enc_guarantor_ssn
_999.encounters	enc_ins1_insured_ssn
_999.encounters	enc_ins2_insured_ssn
_999.encounters	enc_ins3_insured_ssn
_999.examples	exa_ssn
_999.hl7_accessions	acc_ssn
_999.insurances_repository	irep_ins_insured_ssn
_999.non_patients	npat_ssn
_999.orders	ord_ssn
_999.patients	pat_ssn
_999.patients	pat_guarantor_ssn
_999.patients	pat_ins1_insured_ssn
_999.patients	pat_ins2_insured_ssn
_999.patients	pat_ins3_insured_ssn
_999.patients_demographics_snapshots	pds_ssn
_999.patients_demographics_snapshots	pds_guarantor_ssn
_999.patients_demographics_snapshots	pds_ins1_insured_ssn
_999.patients_demographics_snapshots	pds_ins2_insured_ssn
_999.patients_demographics_snapshots	pds_ins3_insured_ssn
_999.patients_responsibility_estimates	prest_ssn
_999.precerts	pre_ssn
_999.precerts	pre_guarantor_ssn
_999.precerts	pre_ins1_insured_ssn
_999.precerts	pre_ins2_insured_ssn
_999.radiology_orders	rad_ssn
_999.radiology_results	rad_res_ssn
aurora_standard.abmmpi	gu_ssn
aurora_standard.abmvis	gu_ssn
aurora_standard.adupgu	guar_ssn
aurora_standard.aswguar	guar_ssn
aurora_standard.b2badd	p_ssn
aurora_standard.b2mrdr	p_ssn
aurora_standard.bdallvis	pat_ssn
aurora_standard.bdguar	guar_ssn
aurora_standard.bdmpi	p_ssn
aurora_standard.bdmpi	sp_ssn
aurora_standard.bdvis	pat_ssn
aurora_standard.bevis	p_ssn
aurora_standard.bevisbd	p_ssn
aurora_standard.bevisbd2	p_ssn
aurora_standard.bhar	p_ssn
aurora_standard.bhar	new_ssn
aurora_standard.bhar	g_ssn
aurora_standard.bhbadd	p_ssn
aurora_standard.bhguar	guar_ssn
aurora_standard.bhldgr	p_ssn
aurora_standard.bhldgr	guar_ssn
aurora_standard.bhmrdr	p_ssn
aurora_standard.bhppat	p_ssn
aurora_standard.bhtguar	guar_ssn
aurora_standard.bhtldgr	p_ssn
aurora_standard.bhtldgr	guar_ssn
aurora_standard.bhtmrdr	p_ssn
aurora_standard.bhtppat	p_ssn
aurora_standard.bmguar	guar_ssn
aurora_standard.bmmpi	p_ssn
aurora_standard.bmnkin	n_ssn
aurora_standard.bmpact	p_ssn
aurora_standard.bmpat	p_ssn
aurora_standard.bpar	p_ssn
aurora_standard.bpar	new_ssn
aurora_standard.bpar	g_ssn
aurora_standard.bpar2	p_ssn
aurora_standard.bpar2	new_ssn
aurora_standard.bpar2	g_ssn
aurora_standard.bpmpi	p_ssn
aurora_standard.bpmpi2	p_ssn
aurora_standard.bpmr	p_ssn
aurora_standard.bpmr2	p_ssn
aurora_standard.bsguar	guar_ssn
aurora_standard.bsinsur	spouse_ssn
aurora_standard.bsvis	pat_ssn
aurora_standard.bsvisbd	pat_ssn
aurora_standard.bvguar	gu_ssn
aurora_standard.bvmpi	p_ssn
aurora_standard.bvmpi2	p_ssn
aurora_standard.c7guarr	guar_ssn
aurora_standard.c7mpi	p_ssn
aurora_standard.c7mpi	gu_ssn
aurora_standard.c7vis	pat_ssn
aurora_standard.c8dtls	p_ssn
aurora_standard.c8guar	guar_ssn
aurora_standard.c8guar2	guar_ssn
aurora_standard.c9mpi	p_ssn
aurora_standard.c9vis	p_ssn
aurora_standard.cafc	pat_ssn
aurora_standard.caguarr	guar_ssn
aurora_standard.campi	spouse_ssn
aurora_standard.cavis	pat_ssn
aurora_standard.cavish	pat_ssn
aurora_standard.chhl7in2	ins_ssn
aurora_standard.chlmdssd	prev_ssn
aurora_standard.chltrnsd	prev_ssn
aurora_standard.chmarcnbf	g_ssn
aurora_standard.chmarcnbf	p_ssn
aurora_standard.chmarsi	pat_ssn
aurora_standard.chmarsi	gu_ssn
aurora_standard.chmarsi	sp_ssn
aurora_standard.chmazstd	pat_ssn
aurora_standard.chmazsti	pat_ssn
aurora_standard.chmazsto	pat_ssn
aurora_standard.chmcampi	pat_ssn
aurora_standard.chmcampi	gu_ssn
aurora_standard.chmcampi	sp_ssn
aurora_standard.chmcmhed	debtor_1_ssn
aurora_standard.chmcmhed	debtor_2_ssn
aurora_standard.chmcmhed	pat_ssn
aurora_standard.chmcssnd	new_ssn
aurora_standard.chmcssnd	old_ssn
aurora_standard.chmexmpi	pat_ssn
aurora_standard.chmexmpi	gu_ssn
aurora_standard.chmexmpi	sp_ssn
aurora_standard.chmexvis	pat_ssn
aurora_standard.chmguarr	guar_ssn
aurora_standard.chmhistp	p_ssn
aurora_standard.chmlastr	pat_ssn
aurora_standard.chmmhast	pat_ssn
aurora_standard.chmokipd	pat_ssn
aurora_standard.chmokopd	pat_ssn
aurora_standard.chmoperc	auto_ssn
aurora_standard.chmozpcd	debtor_1_ssn
aurora_standard.chmozpcd	debtor_2_ssn
aurora_standard.chmpatmr	spouse_ssn
aurora_standard.chmpatwc	mom_ssn
aurora_standard.chmpatwc	dad_ssn
aurora_standard.chmpdemo	p_ssn
aurora_standard.chmpdemo	sp_ssn
aurora_standard.chmpdemo	gu_ssn
aurora_standard.chmradex	pat_ssn
aurora_standard.chmradex	gu_ssn
aurora_standard.chmradex	sp_ssn
aurora_standard.chmtxstr	pat_ssn
aurora_standard.chpcobdd	dep_ssn
aurora_standard.chpdeped	depend_ssn
aurora_standard.chpempdd	person_ssn
aurora_standard.chxcntrc	id_is_ssn
aurora_standard.hl7gt1	guar_ssn
aurora_standard.hl7gt1ad	guar_ssn
aurora_standard.hl7in2	ins_ssn
aurora_standard.hl7in2ad	ins_ssn
aurora_standard.hl7pid	pat_ssn
aurora_standard.hl7pidad	pat_ssn
aurora_standard.kcvis	pat_ssn
aurora_standard.kcvisit	pat_ssn
aurora_standard.nbspouse	spouse_ssn
aurora_standard.ncexmpi	pat_ssn
aurora_standard.oddpaydd	empl_ssn
aurora_standard.oddpayid	empl_ssn
aurora_standard.oddpayod	empl_ssn
aurora_standard.oddpayre	empl_ssn
aurora_standard.odhpaydd	empl_ssn
aurora_standard.odhpayid	empl_ssn
aurora_standard.odhpayod	empl_ssn
aurora_standard.odhpayre	empl_ssn
aurora_standard.styoempd	depend_ssn
common.customers	cus_require_ssn

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

npi

Table	Column
_1.billing_providers	bp_npi
_1.erx_notifications	erx_nots_provider_npi
_1.insurances_group_billing	igb_use_individual_npi
_1.locations	loc_npi
_1.patients_prescriptions	prx_provider_npi
_1.patients_prescriptions	prx_pharmacy_npi
_1.physicians	phy_npi
_1.physicians	phy_verify_npi
_1188.billing_providers	bp_npi
_1188.erx_notifications	erx_nots_provider_npi
_1188.insurances_group_billing	igb_use_individual_npi
_1188.locations	loc_npi
_1188.patients_prescriptions	prx_provider_npi
_1188.patients_prescriptions	prx_pharmacy_npi
_1188.physicians	phy_npi
_1188.physicians	phy_verify_npi
_1218.billing_providers	bp_npi
_1218.erx_notifications	erx_nots_provider_npi
_1218.insurances_group_billing	igb_use_individual_npi
_1218.locations	loc_npi
_1218.patients_prescriptions	prx_provider_npi
_1218.patients_prescriptions	prx_pharmacy_npi
_1218.physicians	phy_npi
_1218.physicians	phy_verify_npi
_1548.billing_providers	bp_npi
_1548.erx_notifications	erx_nots_provider_npi
_1548.insurances_group_billing	igb_use_individual_npi
_1548.locations	loc_npi
_1548.patients_prescriptions	prx_provider_npi
_1548.patients_prescriptions	prx_pharmacy_npi
_1548.physicians	phy_npi
_1548.physicians	phy_verify_npi
_435.billing_providers	bp_npi
_435.erx_notifications	erx_nots_provider_npi
_435.insurances_group_billing	igb_use_individual_npi
_435.locations	loc_npi
_435.patients_prescriptions	prx_provider_npi
_435.patients_prescriptions	prx_pharmacy_npi
_435.physicians	phy_npi
_435.physicians	phy_verify_npi
_436.billing_providers	bp_npi
_436.erx_notifications	erx_nots_provider_npi
_436.insurances_group_billing	igb_use_individual_npi
_436.locations	loc_npi
_436.patients_prescriptions	prx_provider_npi
_436.patients_prescriptions	prx_pharmacy_npi
_436.physicians	phy_npi
_436.physicians	phy_verify_npi
_436_archive_testing.billing_providers	bp_npi
_436_archive_testing.erx_notifications	erx_nots_provider_npi
_436_archive_testing.insurances_group_billing	igb_use_individual_npi
_436_archive_testing.locations	loc_npi
_436_archive_testing.patients_prescriptions	prx_provider_npi
_436_archive_testing.patients_prescriptions	prx_pharmacy_npi
_436_archive_testing.physicians	phy_npi
_436_archive_testing.physicians	phy_verify_npi
_437.billing_providers	bp_npi
_437.erx_notifications	erx_nots_provider_npi
_437.insurances_group_billing	igb_use_individual_npi
_437.locations	loc_npi
_437.patients_prescriptions	prx_provider_npi
_437.patients_prescriptions	prx_pharmacy_npi
_437.physicians	phy_npi
_437.physicians	phy_verify_npi
_8.billing_providers	bp_npi
_8.erx_notifications	erx_nots_provider_npi
_8.insurances_group_billing	igb_use_individual_npi
_8.locations	loc_npi
_8.patients_prescriptions	prx_provider_npi
_8.patients_prescriptions	prx_pharmacy_npi
_8.physicians	phy_npi
_8.physicians	phy_verify_npi
_81.billing_providers	bp_npi
_81.erx_notifications	erx_nots_provider_npi
_81.insurances_group_billing	igb_use_individual_npi
_81.locations	loc_npi
_81.patients_prescriptions	prx_provider_npi
_81.patients_prescriptions	prx_pharmacy_npi
_81.physicians	phy_npi
_81.physicians	phy_verify_npi
_999.billing_providers	bp_npi
_999.erx_notifications	erx_nots_provider_npi
_999.insurances_group_billing	igb_use_individual_npi
_999.locations	loc_npi
_999.patients_prescriptions	prx_provider_npi
_999.patients_prescriptions	prx_pharmacy_npi
_999.physicians	phy_npi
_999.physicians	phy_verify_npi
aurora_standard.chm1500r	n_17b_npi
aurora_standard.chm1500r	n_32a_npi
aurora_standard.chm1500r	n_33a_npi
aurora_standard.chm15chd	n24j_npi
aurora_standard.chmarsi	fam_phy_npi
aurora_standard.chmarsi	attend_phy_npi
aurora_standard.chmarsi	admit_phy_npi
aurora_standard.chmarst	facility_npi
aurora_standard.chmarst	medicaid_npi
aurora_standard.chmarsti	facility_npi
aurora_standard.chmarsti	medicaid_npi
aurora_standard.chmarstph	att_npi
aurora_standard.chmarstph	sur_npi
aurora_standard.chmarstpo	att_npi
aurora_standard.chmarstpo	sur_npi
aurora_standard.chmazstd	att_phy_npi
aurora_standard.chmazstd	proc_phy_npi
aurora_standard.chmazstd	oth_phy_npi
aurora_standard.chmazsti	att_phy_npi
aurora_standard.chmazsti	proc_phy_npi
aurora_standard.chmazsti	oth_phy_npi
aurora_standard.chmazsto	att_phy_npi
aurora_standard.chmazsto	proc_phy_npi
aurora_standard.chmazsto	oth_phy_npi
aurora_standard.chmcampi	fam_phy_npi
aurora_standard.chmcampi	attend_phy_npi
aurora_standard.chmcampi	admit_phy_npi
aurora_standard.chmexmpi	fam_phy_npi
aurora_standard.chmexmpi	attend_phy_npi
aurora_standard.chmexmpi	admit_phy_npi
aurora_standard.chmexvis	attend_phy_npi
aurora_standard.chmexvis	admit_phy_npi
aurora_standard.chmhcahp	clinic_npi
aurora_standard.chmhcahp	dr_npi
aurora_standard.chmhid4a	facility_npi
aurora_standard.chmhid4a	att_npi
aurora_standard.chmhid4a	sur_npi
aurora_standard.chmhid4a	other1_qual_npi
aurora_standard.chmhid4a	other2_qual_npi
aurora_standard.chmhid4b	facility_npi
aurora_standard.chmhid4c	facility_npi
aurora_standard.chmhid4d	fac_npi
aurora_standard.chmhid4g	facility_npi
aurora_standard.chmlastr	att_phy_npi
aurora_standard.chmlastr	op_phy_npi
aurora_standard.chmlastr	oth_phy_npi
aurora_standard.chmlastr	rnd_phy_npi
aurora_standard.chmlastr	adm_phy_npi
aurora_standard.chmlastr	ref_phy_npi
aurora_standard.chmmhast	fac_npi
aurora_standard.chmmhast	att_phy_npi
aurora_standard.chmmhast	surg_npi
aurora_standard.chmnvstb	att_npi
aurora_standard.chmnvstb	op_npi
aurora_standard.chmnvstb	oth_npi
aurora_standard.chmnvstb	othb_npi
aurora_standard.chmnvstr	att_npi
aurora_standard.chmnvstr	op_npi
aurora_standard.chmnvstr	oth_npi
aurora_standard.chmnvstr	othb_npi
aurora_standard.chmp340b	prescriber_npi
aurora_standard.chmpdemo	fam_phy_npi
aurora_standard.chmpdemo	attend_phy_npi
aurora_standard.chmpdemo	admit_phy_npi
aurora_standard.chmphyne	box_17b_npi
aurora_standard.chmphyne	box_24j_npi
aurora_standard.chmphyne	box_33a_npi
aurora_standard.chmraded	phy_npi
aurora_standard.chmradex	fam_phy_npi
aurora_standard.chmradex	attend_phy_npi
aurora_standard.chmradex	admit_phy_npi
aurora_standard.chmub04b	f_56_npi
aurora_standard.chmub04b	f_76_npi
aurora_standard.chmub04b	f_77_npi
aurora_standard.chmub04b	f_78_npi
aurora_standard.chmub04b	f_79_npi
aurora_standard.tmpub04r	f_56_npi
aurora_standard.tmpub04r	f_76_npi
aurora_standard.tmpub04r	f_77_npi
aurora_standard.tmpub04r	f_78_npi
aurora_standard.tmpub04r	f_79_npi
common.clients	cli_npi
common.clients	cli_verify_npi
common.reports_filters_options_map	rfom_use_npi

taxonomy

Table	Column
_1.locations	loc_taxonomy
_1.physicians	phy_taxonomy
_1188.locations	loc_taxonomy
_1188.physicians	phy_taxonomy
_1218.locations	loc_taxonomy
_1218.physicians	phy_taxonomy
_1548.locations	loc_taxonomy
_1548.physicians	phy_taxonomy
_435.locations	loc_taxonomy
_435.physicians	phy_taxonomy
_436.locations	loc_taxonomy
_436.physicians	phy_taxonomy
_436_archive_testing.locations	loc_taxonomy
_436_archive_testing.physicians	phy_taxonomy
_437.locations	loc_taxonomy
_437.physicians	phy_taxonomy
_8.locations	loc_taxonomy
_8.physicians	phy_taxonomy
_81.locations	loc_taxonomy
_81.physicians	phy_taxonomy
_999.locations	loc_taxonomy
_999.physicians	phy_taxonomy
aurora_standard.chmutah6	att_taxonomy
aurora_standard.chmutah6	op_taxonomy
aurora_standard.chmutah6	oth_taxonomy
aurora_standard.chmutah6	ren_taxonomy
aurora_standard.chmutah6	ref_taxonomy
common.clients	cli_taxonomy

phy_no

Table	Column
aurora_standard.bsinsur	fam_phy_no
aurora_standard.c7mpi	pri_phy_no
aurora_standard.campi	fam_phy_no
aurora_standard.chmabstr	admit_phy_no
aurora_standard.chmabstr	attend_phy_no
aurora_standard.chmarsi	fam_phy_no
aurora_standard.chmcampi	fam_phy_no
aurora_standard.chmexmpi	fam_phy_no
aurora_standard.chmpatmr	fam_phy_no
aurora_standard.chmpdemo	fam_phy_no
aurora_standard.chmradex	fam_phy_no
aurora_standard.chpwkmnr	refer_phy_no

cert_no

Table	Column
aurora_standard.chmadmid	ins_cert_no
aurora_standard.chmadmtr	ins_cert_no
aurora_standard.chpcobrd	cobra_cert_no
aurora_standard.chqcardd	cardiac_cert_no
aurora_standard.chqphync	brd_cert_no
aurora_standard.hhmadmtr	ins_cert_no
aurora_standard.visit_insurances	ins_cert_no

id_no

Table	Column
aurora_standard.chxcntrc	auto_id_no
aurora_standard.chxhistd	h_id_no
aurora_standard.chxhistr	h_id_no
aurora_standard.chycntrc	auto_id_no
aurora_standard.chyhistd	h_id_no
aurora_standard.chyhistr	h_id_no

lic_no

Table	Column
aurora_standard.stoordrd	intl_lic_no
aurora_standard.stoordre	intl_lic_no

zip_code

Table	Column
common.fipsmap	fips_zip_code