aurora_standard.acampi

Field	Type	Null	Default	Key
mrno	int(11)	NO	0
fname	char(20)	YES
mname	char(20)	YES
lname	char(20)	YES		MUL
suffix	char(10)	YES
sex	char(1)	YES
akaname	char(20)	YES
ssn	char(11)	YES
race_cd	char(10)	YES
marriage_cd	char(10)	YES
marital	char(10)	YES
religion_id	char(10)	YES
language_id	char(10)	YES
home_ph	char(20)	YES
work_ph	char(20)	YES
cell_ph	char(20)	YES
occupation	char(20)	YES
work_status	char(10)	YES
ice_1	char(20)	YES
ice_1_rel	char(10)	YES
ice_1_ph	char(20)	YES
ice_2	char(20)	YES
ice_2_rel	char(10)	YES
ice_2_ph	char(20)	YES
dob	char(10)	YES
last_adm_dt	char(10)	YES
deceased_cd	char(10)	YES
deceased_dt	char(10)	YES
ethnicity	char(10)	YES
deleted_cd	char(10)	YES
deleted_dt	char(10)	YES
address1	char(20)	YES
address2	char(20)	YES
city	char(20)	YES
state_idno	char(10)	YES
state_name	char(20)	YES
zip10	char(10)	YES
country	char(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

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

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

sex

Table	Column
HSPI_CURES2015_B1.patients	birth_sex
HSPI_Central_Hospital.patients	birth_sex
HSPI_Dewitt.patients	birth_sex
HSPI_Fulton.patients	birth_sex
HSPI_Inferno.patients	birth_sex
HSPI_MU2015_E1.patients	birth_sex
HSPI_MU2015_G2.patients	birth_sex
HSPI_MU2015_G9.patients	birth_sex
HSPI_Sandbox.patients	birth_sex
HSPI_Summit_General.patients	birth_sex
HSPI_United_Physicians.patients	birth_sex
MPI.patients	birth_sex
_1.charts	chrt_sex
_1.clinical_alerts	ca_pat_sex
_1.clinical_interventions	ci_pat_sex
_1.cpoe_responses	cpoe_res_sex
_1.encounters	enc_sex
_1.encounters	enc_ins1_insured_sex
_1.encounters	enc_ins2_insured_sex
_1.encounters	enc_ins3_insured_sex
_1.health_maintenance	hm_sex
_1.hl7_accessions	acc_sex
_1.insurances_repository	irep_ins_insured_sex
_1.non_patients	npat_sex
_1.orders	ord_sex
_1.patient_education	pe_sex
_1.patient_history_fields	phf_sex
_1.patients	pat_sex
_1.patients	pat_birth_sex
_1.patients	pat_ins1_insured_sex
_1.patients	pat_ins2_insured_sex
_1.patients	pat_ins3_insured_sex
_1.patients_demographics_snapshots	pds_sex
_1.patients_demographics_snapshots	pds_ins1_insured_sex
_1.patients_demographics_snapshots	pds_ins2_insured_sex
_1.patients_demographics_snapshots	pds_ins3_insured_sex
_1.patients_responsibility_estimates	prest_sex
_1.precerts	pre_sex
_1.precerts	pre_ins1_insured_sex
_1.precerts	pre_ins2_insured_sex
_1.radiology_orders	rad_sex
_1.radiology_results	rad_res_sex
_1188.charts	chrt_sex
_1188.clinical_alerts	ca_pat_sex
_1188.clinical_interventions	ci_pat_sex
_1188.cpoe_responses	cpoe_res_sex
_1188.encounters	enc_sex
_1188.encounters	enc_ins1_insured_sex
_1188.encounters	enc_ins2_insured_sex
_1188.encounters	enc_ins3_insured_sex
_1188.health_maintenance	hm_sex
_1188.hl7_accessions	acc_sex
_1188.insurances_repository	irep_ins_insured_sex
_1188.non_patients	npat_sex
_1188.orders	ord_sex
_1188.patient_education	pe_sex
_1188.patient_history_fields	phf_sex
_1188.patients	pat_sex
_1188.patients	pat_birth_sex
_1188.patients	pat_ins1_insured_sex
_1188.patients	pat_ins2_insured_sex
_1188.patients	pat_ins3_insured_sex
_1188.patients_demographics_snapshots	pds_sex
_1188.patients_demographics_snapshots	pds_ins1_insured_sex
_1188.patients_demographics_snapshots	pds_ins2_insured_sex
_1188.patients_demographics_snapshots	pds_ins3_insured_sex
_1188.patients_responsibility_estimates	prest_sex
_1188.precerts	pre_sex
_1188.precerts	pre_ins1_insured_sex
_1188.precerts	pre_ins2_insured_sex
_1188.radiology_orders	rad_sex
_1188.radiology_results	rad_res_sex
_1218.charts	chrt_sex
_1218.clinical_alerts	ca_pat_sex
_1218.clinical_interventions	ci_pat_sex
_1218.cpoe_responses	cpoe_res_sex
_1218.encounters	enc_sex
_1218.encounters	enc_ins1_insured_sex
_1218.encounters	enc_ins2_insured_sex
_1218.encounters	enc_ins3_insured_sex
_1218.health_maintenance	hm_sex
_1218.hl7_accessions	acc_sex
_1218.insurances_repository	irep_ins_insured_sex
_1218.non_patients	npat_sex
_1218.orders	ord_sex
_1218.patient_education	pe_sex
_1218.patient_history_fields	phf_sex
_1218.patients	pat_sex
_1218.patients	pat_birth_sex
_1218.patients	pat_ins1_insured_sex
_1218.patients	pat_ins2_insured_sex
_1218.patients	pat_ins3_insured_sex
_1218.patients_demographics_snapshots	pds_sex
_1218.patients_demographics_snapshots	pds_ins1_insured_sex
_1218.patients_demographics_snapshots	pds_ins2_insured_sex
_1218.patients_demographics_snapshots	pds_ins3_insured_sex
_1218.patients_responsibility_estimates	prest_sex
_1218.precerts	pre_sex
_1218.precerts	pre_ins1_insured_sex
_1218.precerts	pre_ins2_insured_sex
_1218.radiology_orders	rad_sex
_1218.radiology_results	rad_res_sex
_1548.charts	chrt_sex
_1548.clinical_alerts	ca_pat_sex
_1548.clinical_interventions	ci_pat_sex
_1548.cpoe_responses	cpoe_res_sex
_1548.encounters	enc_sex
_1548.encounters	enc_ins1_insured_sex
_1548.encounters	enc_ins2_insured_sex
_1548.encounters	enc_ins3_insured_sex
_1548.health_maintenance	hm_sex
_1548.hl7_accessions	acc_sex
_1548.insurances_repository	irep_ins_insured_sex
_1548.non_patients	npat_sex
_1548.orders	ord_sex
_1548.patient_education	pe_sex
_1548.patient_history_fields	phf_sex
_1548.patients	pat_sex
_1548.patients	pat_birth_sex
_1548.patients	pat_ins1_insured_sex
_1548.patients	pat_ins2_insured_sex
_1548.patients	pat_ins3_insured_sex
_1548.patients_demographics_snapshots	pds_sex
_1548.patients_demographics_snapshots	pds_ins1_insured_sex
_1548.patients_demographics_snapshots	pds_ins2_insured_sex
_1548.patients_demographics_snapshots	pds_ins3_insured_sex
_1548.patients_responsibility_estimates	prest_sex
_1548.precerts	pre_sex
_1548.precerts	pre_ins1_insured_sex
_1548.precerts	pre_ins2_insured_sex
_1548.radiology_orders	rad_sex
_1548.radiology_results	rad_res_sex
_435.charts	chrt_sex
_435.clinical_alerts	ca_pat_sex
_435.clinical_interventions	ci_pat_sex
_435.cpoe_responses	cpoe_res_sex
_435.encounters	enc_sex
_435.encounters	enc_ins1_insured_sex
_435.encounters	enc_ins2_insured_sex
_435.encounters	enc_ins3_insured_sex
_435.health_maintenance	hm_sex
_435.hl7_accessions	acc_sex
_435.insurances_repository	irep_ins_insured_sex
_435.non_patients	npat_sex
_435.orders	ord_sex
_435.patient_education	pe_sex
_435.patient_history_fields	phf_sex
_435.patients	pat_sex
_435.patients	pat_birth_sex
_435.patients	pat_ins1_insured_sex
_435.patients	pat_ins2_insured_sex
_435.patients	pat_ins3_insured_sex
_435.patients_demographics_snapshots	pds_sex
_435.patients_demographics_snapshots	pds_ins1_insured_sex
_435.patients_demographics_snapshots	pds_ins2_insured_sex
_435.patients_demographics_snapshots	pds_ins3_insured_sex
_435.patients_responsibility_estimates	prest_sex
_435.precerts	pre_sex
_435.precerts	pre_ins1_insured_sex
_435.precerts	pre_ins2_insured_sex
_435.radiology_orders	rad_sex
_435.radiology_results	rad_res_sex
_436.charts	chrt_sex
_436.clinical_alerts	ca_pat_sex
_436.clinical_interventions	ci_pat_sex
_436.cpoe_responses	cpoe_res_sex
_436.encounters	enc_sex
_436.encounters	enc_ins1_insured_sex
_436.encounters	enc_ins2_insured_sex
_436.encounters	enc_ins3_insured_sex
_436.health_maintenance	hm_sex
_436.hl7_accessions	acc_sex
_436.insurances_repository	irep_ins_insured_sex
_436.non_patients	npat_sex
_436.orders	ord_sex
_436.patient_education	pe_sex
_436.patient_history_fields	phf_sex
_436.patients	pat_sex
_436.patients	pat_birth_sex
_436.patients	pat_ins1_insured_sex
_436.patients	pat_ins2_insured_sex
_436.patients	pat_ins3_insured_sex
_436.patients_demographics_snapshots	pds_sex
_436.patients_demographics_snapshots	pds_ins1_insured_sex
_436.patients_demographics_snapshots	pds_ins2_insured_sex
_436.patients_demographics_snapshots	pds_ins3_insured_sex
_436.patients_responsibility_estimates	prest_sex
_436.precerts	pre_sex
_436.precerts	pre_ins1_insured_sex
_436.precerts	pre_ins2_insured_sex
_436.radiology_orders	rad_sex
_436.radiology_results	rad_res_sex
_436_archive_testing.charts	chrt_sex
_436_archive_testing.clinical_alerts	ca_pat_sex
_436_archive_testing.clinical_interventions	ci_pat_sex
_436_archive_testing.cpoe_responses	cpoe_res_sex
_436_archive_testing.encounters	enc_sex
_436_archive_testing.encounters	enc_ins1_insured_sex
_436_archive_testing.encounters	enc_ins2_insured_sex
_436_archive_testing.encounters	enc_ins3_insured_sex
_436_archive_testing.health_maintenance	hm_sex
_436_archive_testing.hl7_accessions	acc_sex
_436_archive_testing.insurances_repository	irep_ins_insured_sex
_436_archive_testing.non_patients	npat_sex
_436_archive_testing.orders	ord_sex
_436_archive_testing.patient_education	pe_sex
_436_archive_testing.patient_history_fields	phf_sex
_436_archive_testing.patients	pat_sex
_436_archive_testing.patients	pat_ins1_insured_sex
_436_archive_testing.patients	pat_ins2_insured_sex
_436_archive_testing.patients	pat_ins3_insured_sex
_436_archive_testing.patients_demographics_snapshots	pds_sex
_436_archive_testing.patients_demographics_snapshots	pds_ins1_insured_sex
_436_archive_testing.patients_demographics_snapshots	pds_ins2_insured_sex
_436_archive_testing.patients_demographics_snapshots	pds_ins3_insured_sex
_436_archive_testing.patients_responsibility_estimates	prest_sex
_436_archive_testing.precerts	pre_sex
_436_archive_testing.precerts	pre_ins1_insured_sex
_436_archive_testing.precerts	pre_ins2_insured_sex
_436_archive_testing.radiology_orders	rad_sex
_436_archive_testing.radiology_results	rad_res_sex
_437.charts	chrt_sex
_437.clinical_alerts	ca_pat_sex
_437.clinical_interventions	ci_pat_sex
_437.cpoe_responses	cpoe_res_sex
_437.encounters	enc_sex
_437.encounters	enc_ins1_insured_sex
_437.encounters	enc_ins2_insured_sex
_437.encounters	enc_ins3_insured_sex
_437.health_maintenance	hm_sex
_437.hl7_accessions	acc_sex
_437.insurances_repository	irep_ins_insured_sex
_437.non_patients	npat_sex
_437.orders	ord_sex
_437.patient_education	pe_sex
_437.patient_history_fields	phf_sex
_437.patients	pat_sex
_437.patients	pat_birth_sex
_437.patients	pat_ins1_insured_sex
_437.patients	pat_ins2_insured_sex
_437.patients	pat_ins3_insured_sex
_437.patients_demographics_snapshots	pds_sex
_437.patients_demographics_snapshots	pds_ins1_insured_sex
_437.patients_demographics_snapshots	pds_ins2_insured_sex
_437.patients_demographics_snapshots	pds_ins3_insured_sex
_437.patients_responsibility_estimates	prest_sex
_437.precerts	pre_sex
_437.precerts	pre_ins1_insured_sex
_437.precerts	pre_ins2_insured_sex
_437.radiology_orders	rad_sex
_437.radiology_results	rad_res_sex
_8.charts	chrt_sex
_8.clinical_alerts	ca_pat_sex
_8.clinical_interventions	ci_pat_sex
_8.cpoe_responses	cpoe_res_sex
_8.encounters	enc_sex
_8.encounters	enc_ins1_insured_sex
_8.encounters	enc_ins2_insured_sex
_8.encounters	enc_ins3_insured_sex
_8.health_maintenance	hm_sex
_8.hl7_accessions	acc_sex
_8.insurances_repository	irep_ins_insured_sex
_8.non_patients	npat_sex
_8.orders	ord_sex
_8.patient_education	pe_sex
_8.patient_history_fields	phf_sex
_8.patients	pat_sex
_8.patients	pat_birth_sex
_8.patients	pat_ins1_insured_sex
_8.patients	pat_ins2_insured_sex
_8.patients	pat_ins3_insured_sex
_8.patients_demographics_snapshots	pds_sex
_8.patients_demographics_snapshots	pds_ins1_insured_sex
_8.patients_demographics_snapshots	pds_ins2_insured_sex
_8.patients_demographics_snapshots	pds_ins3_insured_sex
_8.patients_responsibility_estimates	prest_sex
_8.precerts	pre_sex
_8.precerts	pre_ins1_insured_sex
_8.precerts	pre_ins2_insured_sex
_8.radiology_orders	rad_sex
_8.radiology_results	rad_res_sex
_81.charts	chrt_sex
_81.clinical_alerts	ca_pat_sex
_81.clinical_interventions	ci_pat_sex
_81.cpoe_responses	cpoe_res_sex
_81.encounters	enc_sex
_81.encounters	enc_ins1_insured_sex
_81.encounters	enc_ins2_insured_sex
_81.encounters	enc_ins3_insured_sex
_81.health_maintenance	hm_sex
_81.hl7_accessions	acc_sex
_81.insurances_repository	irep_ins_insured_sex
_81.non_patients	npat_sex
_81.orders	ord_sex
_81.patient_education	pe_sex
_81.patient_history_fields	phf_sex
_81.patients	pat_sex
_81.patients	pat_birth_sex
_81.patients	pat_ins1_insured_sex
_81.patients	pat_ins2_insured_sex
_81.patients	pat_ins3_insured_sex
_81.patients_demographics_snapshots	pds_sex
_81.patients_demographics_snapshots	pds_ins1_insured_sex
_81.patients_demographics_snapshots	pds_ins2_insured_sex
_81.patients_demographics_snapshots	pds_ins3_insured_sex
_81.patients_responsibility_estimates	prest_sex
_81.precerts	pre_sex
_81.precerts	pre_ins1_insured_sex
_81.precerts	pre_ins2_insured_sex
_81.radiology_orders	rad_sex
_81.radiology_results	rad_res_sex
_999.charts	chrt_sex
_999.clinical_alerts	ca_pat_sex
_999.clinical_interventions	ci_pat_sex
_999.cpoe_responses	cpoe_res_sex
_999.encounters	enc_sex
_999.encounters	enc_ins1_insured_sex
_999.encounters	enc_ins2_insured_sex
_999.encounters	enc_ins3_insured_sex
_999.health_maintenance	hm_sex
_999.hl7_accessions	acc_sex
_999.insurances_repository	irep_ins_insured_sex
_999.non_patients	npat_sex
_999.orders	ord_sex
_999.patient_education	pe_sex
_999.patient_history_fields	phf_sex
_999.patients	pat_sex
_999.patients	pat_birth_sex
_999.patients	pat_ins1_insured_sex
_999.patients	pat_ins2_insured_sex
_999.patients	pat_ins3_insured_sex
_999.patients_demographics_snapshots	pds_sex
_999.patients_demographics_snapshots	pds_ins1_insured_sex
_999.patients_demographics_snapshots	pds_ins2_insured_sex
_999.patients_demographics_snapshots	pds_ins3_insured_sex
_999.patients_responsibility_estimates	prest_sex
_999.precerts	pre_sex
_999.precerts	pre_ins1_insured_sex
_999.precerts	pre_ins2_insured_sex
_999.radiology_orders	rad_sex
_999.radiology_results	rad_res_sex
aurora_standard.abmmpi	i1_sex
aurora_standard.abmmpi	i2_sex
aurora_standard.abmmpi	i3_sex
aurora_standard.abmmpi	gu_sex
aurora_standard.abmvis	gu_sex
aurora_standard.abmvis	i1_sex
aurora_standard.abmvis	i2_sex
aurora_standard.abmvis	i3_sex
aurora_standard.bevis	pat_sex
aurora_standard.bevisbd	pat_sex
aurora_standard.bevisbd2	pat_sex
aurora_standard.bhar	p_sex
aurora_standard.bhar	g_sex
aurora_standard.bpar	p_sex
aurora_standard.bpar	g_sex
aurora_standard.bpar2	p_sex
aurora_standard.bpar2	g_sex
aurora_standard.bpmpi	p_sex
aurora_standard.bpmpi2	p_sex
aurora_standard.bpmr	p_sex
aurora_standard.bpmr2	p_sex
aurora_standard.c7mpi	p_sex
aurora_standard.c7mpi	gu_sex
aurora_standard.c8dtls	p_sex
aurora_standard.c9mpi	p_sex
aurora_standard.chhl7in1	ins_sex
aurora_standard.chmarbex	pat_sex
aurora_standard.chmarsi	pat_sex
aurora_standard.chmarsi	ins1_sex
aurora_standard.chmarsi	ins2_sex
aurora_standard.chmarsi	ins3_sex
aurora_standard.chmazstd	pat_sex
aurora_standard.chmazsti	pat_sex
aurora_standard.chmazsto	pat_sex
aurora_standard.chmbatex	pat_sex
aurora_standard.chmcampi	pat_sex
aurora_standard.chmcampi	ins1_sex
aurora_standard.chmcampi	ins2_sex
aurora_standard.chmcampi	ins3_sex
aurora_standard.chmcmhed	pat_sex
aurora_standard.chmexmpi	pat_sex
aurora_standard.chmexmpi	ins1_sex
aurora_standard.chmexmpi	ins2_sex
aurora_standard.chmexmpi	ins3_sex
aurora_standard.chmexvis	ins1_sex
aurora_standard.chmexvis	ins2_sex
aurora_standard.chmexvis	ins3_sex
aurora_standard.chmhcaph	pat_sex
aurora_standard.chmhcaps	pat_sex
aurora_standard.chmhistp	p_sex
aurora_standard.chmhstmr	pat_sex
aurora_standard.chmhstrm	pat_sex
aurora_standard.chmlastr	pat_sex
aurora_standard.chmmhast	pat_sex
aurora_standard.chmmrhdr	upd_sex
aurora_standard.chmnrcex	pat_sex
aurora_standard.chmokipd	pat_sex
aurora_standard.chmokopd	pat_sex
aurora_standard.chmpdemo	p_sex
aurora_standard.chmpdemo	ins1_sex
aurora_standard.chmpdemo	ins2_sex
aurora_standard.chmpdemo	ins3_sex
aurora_standard.chmradex	pat_sex
aurora_standard.chmradex	ins1_sex
aurora_standard.chmradex	ins2_sex
aurora_standard.chmradex	ins3_sex
aurora_standard.chmtxstr	pat_sex
aurora_standard.hl7gt1	guar_sex
aurora_standard.hl7gt1ad	guar_sex
aurora_standard.hl7in1	ins_sex
aurora_standard.hl7in1ad	ins_sex

suffix

Table	Column
_1.billing_providers	bp_suffix
_1.charts	chrt_suffix
_1.encounters	enc_suffix
_1.hl7_accessions	ord_suffix
_1.orders	ord_suffix
_1.patients	pat_suffix
_1.patients_demographics_snapshots	pds_suffix
_1.patients_names	pn_suffix
_1.physicians	phy_suffix
_1.precerts	pre_suffix
_1188.billing_providers	bp_suffix
_1188.charts	chrt_suffix
_1188.encounters	enc_suffix
_1188.hl7_accessions	ord_suffix
_1188.orders	ord_suffix
_1188.patients	pat_suffix
_1188.patients_demographics_snapshots	pds_suffix
_1188.patients_names	pn_suffix
_1188.physicians	phy_suffix
_1188.precerts	pre_suffix
_1218.billing_providers	bp_suffix
_1218.charts	chrt_suffix
_1218.encounters	enc_suffix
_1218.hl7_accessions	ord_suffix
_1218.orders	ord_suffix
_1218.patients	pat_suffix
_1218.patients_demographics_snapshots	pds_suffix
_1218.patients_names	pn_suffix
_1218.physicians	phy_suffix
_1218.precerts	pre_suffix
_1548.billing_providers	bp_suffix
_1548.charts	chrt_suffix
_1548.encounters	enc_suffix
_1548.hl7_accessions	ord_suffix
_1548.orders	ord_suffix
_1548.patients	pat_suffix
_1548.patients_demographics_snapshots	pds_suffix
_1548.patients_names	pn_suffix
_1548.physicians	phy_suffix
_1548.precerts	pre_suffix
_435.billing_providers	bp_suffix
_435.charts	chrt_suffix
_435.encounters	enc_suffix
_435.hl7_accessions	ord_suffix
_435.orders	ord_suffix
_435.patients	pat_suffix
_435.patients_demographics_snapshots	pds_suffix
_435.patients_names	pn_suffix
_435.physicians	phy_suffix
_435.precerts	pre_suffix
_436.billing_providers	bp_suffix
_436.charts	chrt_suffix
_436.encounters	enc_suffix
_436.hl7_accessions	ord_suffix
_436.orders	ord_suffix
_436.patients	pat_suffix
_436.patients_demographics_snapshots	pds_suffix
_436.patients_names	pn_suffix
_436.physicians	phy_suffix
_436.precerts	pre_suffix
_436_archive_testing.billing_providers	bp_suffix
_436_archive_testing.charts	chrt_suffix
_436_archive_testing.encounters	enc_suffix
_436_archive_testing.hl7_accessions	ord_suffix
_436_archive_testing.orders	ord_suffix
_436_archive_testing.patients	pat_suffix
_436_archive_testing.patients_demographics_snapshots	pds_suffix
_436_archive_testing.physicians	phy_suffix
_436_archive_testing.precerts	pre_suffix
_437.billing_providers	bp_suffix
_437.charts	chrt_suffix
_437.encounters	enc_suffix
_437.hl7_accessions	ord_suffix
_437.orders	ord_suffix
_437.patients	pat_suffix
_437.patients_demographics_snapshots	pds_suffix
_437.patients_names	pn_suffix
_437.physicians	phy_suffix
_437.precerts	pre_suffix
_8.billing_providers	bp_suffix
_8.charts	chrt_suffix
_8.encounters	enc_suffix
_8.hl7_accessions	ord_suffix
_8.orders	ord_suffix
_8.patients	pat_suffix
_8.patients_demographics_snapshots	pds_suffix
_8.patients_names	pn_suffix
_8.physicians	phy_suffix
_8.precerts	pre_suffix
_81.billing_providers	bp_suffix
_81.charts	chrt_suffix
_81.encounters	enc_suffix
_81.hl7_accessions	ord_suffix
_81.orders	ord_suffix
_81.patients	pat_suffix
_81.patients_demographics_snapshots	pds_suffix
_81.patients_names	pn_suffix
_81.physicians	phy_suffix
_81.precerts	pre_suffix
_999.billing_providers	bp_suffix
_999.charts	chrt_suffix
_999.encounters	enc_suffix
_999.hl7_accessions	ord_suffix
_999.orders	ord_suffix
_999.patients	pat_suffix
_999.patients_demographics_snapshots	pds_suffix
_999.patients_names	pn_suffix
_999.physicians	phy_suffix
_999.precerts	pre_suffix
aurora_standard.chmadmid	certif_suffix
aurora_standard.chmcosta	pat_suffix
aurora_standard.chmhid4a	pat_suffix
aurora_standard.chmpatid	certif_suffix
aurora_standard.styoctcc	contact_suffix
aurora_standard.styoempd	depend_suffix
aurora_standard.styoempr	empl_suffix
aurora_standard.visit_insurances	certif_suffix
common.users	usr_suffix

dob

Table	Column
_1.charts	chrt_dob
_1.cpoe_responses	cpoe_res_dob
_1.donors	don_dob
_1.encounters	enc_dob
_1.encounters	enc_guarantor_dob
_1.encounters	enc_ins1_insured_dob
_1.encounters	enc_ins2_insured_dob
_1.encounters	enc_ins3_insured_dob
_1.hl7_accessions	acc_dob
_1.insurances_repository	irep_ins_insured_dob
_1.orders	ord_dob
_1.patients	pat_dob
_1.patients	pat_guarantor_dob
_1.patients	pat_ins1_insured_dob
_1.patients	pat_ins2_insured_dob
_1.patients	pat_ins3_insured_dob
_1.patients_demographics_snapshots	pds_dob
_1.patients_demographics_snapshots	pds_guarantor_dob
_1.patients_demographics_snapshots	pds_ins1_insured_dob
_1.patients_demographics_snapshots	pds_ins2_insured_dob
_1.patients_demographics_snapshots	pds_ins3_insured_dob
_1.patients_responsibility_estimates	prest_dob
_1.precerts	pre_dob
_1.precerts	pre_guarantor_dob
_1.precerts	pre_ins1_insured_dob
_1.precerts	pre_ins2_insured_dob
_1.radiology_orders	rad_dob
_1.radiology_results	rad_res_dob
_1188.charts	chrt_dob
_1188.cpoe_responses	cpoe_res_dob
_1188.donors	don_dob
_1188.encounters	enc_dob
_1188.encounters	enc_guarantor_dob
_1188.encounters	enc_ins1_insured_dob
_1188.encounters	enc_ins2_insured_dob
_1188.encounters	enc_ins3_insured_dob
_1188.hl7_accessions	acc_dob
_1188.insurances_repository	irep_ins_insured_dob
_1188.orders	ord_dob
_1188.patients	pat_dob
_1188.patients	pat_guarantor_dob
_1188.patients	pat_ins1_insured_dob
_1188.patients	pat_ins2_insured_dob
_1188.patients	pat_ins3_insured_dob
_1188.patients_demographics_snapshots	pds_dob
_1188.patients_demographics_snapshots	pds_guarantor_dob
_1188.patients_demographics_snapshots	pds_ins1_insured_dob
_1188.patients_demographics_snapshots	pds_ins2_insured_dob
_1188.patients_demographics_snapshots	pds_ins3_insured_dob
_1188.patients_responsibility_estimates	prest_dob
_1188.precerts	pre_dob
_1188.precerts	pre_guarantor_dob
_1188.precerts	pre_ins1_insured_dob
_1188.precerts	pre_ins2_insured_dob
_1188.radiology_orders	rad_dob
_1188.radiology_results	rad_res_dob
_1218.charts	chrt_dob
_1218.cpoe_responses	cpoe_res_dob
_1218.donors	don_dob
_1218.encounters	enc_dob
_1218.encounters	enc_guarantor_dob
_1218.encounters	enc_ins1_insured_dob
_1218.encounters	enc_ins2_insured_dob
_1218.encounters	enc_ins3_insured_dob
_1218.hl7_accessions	acc_dob
_1218.insurances_repository	irep_ins_insured_dob
_1218.orders	ord_dob
_1218.patients	pat_dob
_1218.patients	pat_guarantor_dob
_1218.patients	pat_ins1_insured_dob
_1218.patients	pat_ins2_insured_dob
_1218.patients	pat_ins3_insured_dob
_1218.patients_demographics_snapshots	pds_dob
_1218.patients_demographics_snapshots	pds_guarantor_dob
_1218.patients_demographics_snapshots	pds_ins1_insured_dob
_1218.patients_demographics_snapshots	pds_ins2_insured_dob
_1218.patients_demographics_snapshots	pds_ins3_insured_dob
_1218.patients_responsibility_estimates	prest_dob
_1218.precerts	pre_dob
_1218.precerts	pre_guarantor_dob
_1218.precerts	pre_ins1_insured_dob
_1218.precerts	pre_ins2_insured_dob
_1218.radiology_orders	rad_dob
_1218.radiology_results	rad_res_dob
_1548.charts	chrt_dob
_1548.cpoe_responses	cpoe_res_dob
_1548.donors	don_dob
_1548.encounters	enc_dob
_1548.encounters	enc_guarantor_dob
_1548.encounters	enc_ins1_insured_dob
_1548.encounters	enc_ins2_insured_dob
_1548.encounters	enc_ins3_insured_dob
_1548.hl7_accessions	acc_dob
_1548.insurances_repository	irep_ins_insured_dob
_1548.orders	ord_dob
_1548.patients	pat_dob
_1548.patients	pat_guarantor_dob
_1548.patients	pat_ins1_insured_dob
_1548.patients	pat_ins2_insured_dob
_1548.patients	pat_ins3_insured_dob
_1548.patients_demographics_snapshots	pds_dob
_1548.patients_demographics_snapshots	pds_guarantor_dob
_1548.patients_demographics_snapshots	pds_ins1_insured_dob
_1548.patients_demographics_snapshots	pds_ins2_insured_dob
_1548.patients_demographics_snapshots	pds_ins3_insured_dob
_1548.patients_responsibility_estimates	prest_dob
_1548.precerts	pre_dob
_1548.precerts	pre_guarantor_dob
_1548.precerts	pre_ins1_insured_dob
_1548.precerts	pre_ins2_insured_dob
_1548.radiology_orders	rad_dob
_1548.radiology_results	rad_res_dob
_435.charts	chrt_dob
_435.cpoe_responses	cpoe_res_dob
_435.donors	don_dob
_435.encounters	enc_dob
_435.encounters	enc_guarantor_dob
_435.encounters	enc_ins1_insured_dob
_435.encounters	enc_ins2_insured_dob
_435.encounters	enc_ins3_insured_dob
_435.hl7_accessions	acc_dob
_435.insurances_repository	irep_ins_insured_dob
_435.orders	ord_dob
_435.patients	pat_dob
_435.patients	pat_guarantor_dob
_435.patients	pat_ins1_insured_dob
_435.patients	pat_ins2_insured_dob
_435.patients	pat_ins3_insured_dob
_435.patients_demographics_snapshots	pds_dob
_435.patients_demographics_snapshots	pds_guarantor_dob
_435.patients_demographics_snapshots	pds_ins1_insured_dob
_435.patients_demographics_snapshots	pds_ins2_insured_dob
_435.patients_demographics_snapshots	pds_ins3_insured_dob
_435.patients_responsibility_estimates	prest_dob
_435.precerts	pre_dob
_435.precerts	pre_guarantor_dob
_435.precerts	pre_ins1_insured_dob
_435.precerts	pre_ins2_insured_dob
_435.radiology_orders	rad_dob
_435.radiology_results	rad_res_dob
_436.charts	chrt_dob
_436.cpoe_responses	cpoe_res_dob
_436.donors	don_dob
_436.encounters	enc_dob
_436.encounters	enc_guarantor_dob
_436.encounters	enc_ins1_insured_dob
_436.encounters	enc_ins2_insured_dob
_436.encounters	enc_ins3_insured_dob
_436.hl7_accessions	acc_dob
_436.insurances_repository	irep_ins_insured_dob
_436.orders	ord_dob
_436.patients	pat_dob
_436.patients	pat_guarantor_dob
_436.patients	pat_ins1_insured_dob
_436.patients	pat_ins2_insured_dob
_436.patients	pat_ins3_insured_dob
_436.patients_demographics_snapshots	pds_dob
_436.patients_demographics_snapshots	pds_guarantor_dob
_436.patients_demographics_snapshots	pds_ins1_insured_dob
_436.patients_demographics_snapshots	pds_ins2_insured_dob
_436.patients_demographics_snapshots	pds_ins3_insured_dob
_436.patients_responsibility_estimates	prest_dob
_436.precerts	pre_dob
_436.precerts	pre_guarantor_dob
_436.precerts	pre_ins1_insured_dob
_436.precerts	pre_ins2_insured_dob
_436.radiology_orders	rad_dob
_436.radiology_results	rad_res_dob
_436_archive_testing.charts	chrt_dob
_436_archive_testing.cpoe_responses	cpoe_res_dob
_436_archive_testing.donors	don_dob
_436_archive_testing.encounters	enc_dob
_436_archive_testing.encounters	enc_guarantor_dob
_436_archive_testing.encounters	enc_ins1_insured_dob
_436_archive_testing.encounters	enc_ins2_insured_dob
_436_archive_testing.encounters	enc_ins3_insured_dob
_436_archive_testing.hl7_accessions	acc_dob
_436_archive_testing.insurances_repository	irep_ins_insured_dob
_436_archive_testing.orders	ord_dob
_436_archive_testing.patients	pat_dob
_436_archive_testing.patients	pat_guarantor_dob
_436_archive_testing.patients	pat_ins1_insured_dob
_436_archive_testing.patients	pat_ins2_insured_dob
_436_archive_testing.patients	pat_ins3_insured_dob
_436_archive_testing.patients_demographics_snapshots	pds_dob
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_dob
_436_archive_testing.patients_demographics_snapshots	pds_ins1_insured_dob
_436_archive_testing.patients_demographics_snapshots	pds_ins2_insured_dob
_436_archive_testing.patients_demographics_snapshots	pds_ins3_insured_dob
_436_archive_testing.patients_responsibility_estimates	prest_dob
_436_archive_testing.precerts	pre_dob
_436_archive_testing.precerts	pre_guarantor_dob
_436_archive_testing.precerts	pre_ins1_insured_dob
_436_archive_testing.precerts	pre_ins2_insured_dob
_436_archive_testing.radiology_orders	rad_dob
_436_archive_testing.radiology_results	rad_res_dob
_437.charts	chrt_dob
_437.cpoe_responses	cpoe_res_dob
_437.donors	don_dob
_437.encounters	enc_dob
_437.encounters	enc_guarantor_dob
_437.encounters	enc_ins1_insured_dob
_437.encounters	enc_ins2_insured_dob
_437.encounters	enc_ins3_insured_dob
_437.hl7_accessions	acc_dob
_437.insurances_repository	irep_ins_insured_dob
_437.orders	ord_dob
_437.patients	pat_dob
_437.patients	pat_guarantor_dob
_437.patients	pat_ins1_insured_dob
_437.patients	pat_ins2_insured_dob
_437.patients	pat_ins3_insured_dob
_437.patients_demographics_snapshots	pds_dob
_437.patients_demographics_snapshots	pds_guarantor_dob
_437.patients_demographics_snapshots	pds_ins1_insured_dob
_437.patients_demographics_snapshots	pds_ins2_insured_dob
_437.patients_demographics_snapshots	pds_ins3_insured_dob
_437.patients_responsibility_estimates	prest_dob
_437.precerts	pre_dob
_437.precerts	pre_guarantor_dob
_437.precerts	pre_ins1_insured_dob
_437.precerts	pre_ins2_insured_dob
_437.radiology_orders	rad_dob
_437.radiology_results	rad_res_dob
_8.charts	chrt_dob
_8.cpoe_responses	cpoe_res_dob
_8.donors	don_dob
_8.encounters	enc_dob
_8.encounters	enc_guarantor_dob
_8.encounters	enc_ins1_insured_dob
_8.encounters	enc_ins2_insured_dob
_8.encounters	enc_ins3_insured_dob
_8.hl7_accessions	acc_dob
_8.insurances_repository	irep_ins_insured_dob
_8.orders	ord_dob
_8.patients	pat_dob
_8.patients	pat_guarantor_dob
_8.patients	pat_ins1_insured_dob
_8.patients	pat_ins2_insured_dob
_8.patients	pat_ins3_insured_dob
_8.patients_demographics_snapshots	pds_dob
_8.patients_demographics_snapshots	pds_guarantor_dob
_8.patients_demographics_snapshots	pds_ins1_insured_dob
_8.patients_demographics_snapshots	pds_ins2_insured_dob
_8.patients_demographics_snapshots	pds_ins3_insured_dob
_8.patients_responsibility_estimates	prest_dob
_8.precerts	pre_dob
_8.precerts	pre_guarantor_dob
_8.precerts	pre_ins1_insured_dob
_8.precerts	pre_ins2_insured_dob
_8.radiology_orders	rad_dob
_8.radiology_results	rad_res_dob
_81.charts	chrt_dob
_81.cpoe_responses	cpoe_res_dob
_81.donors	don_dob
_81.encounters	enc_dob
_81.encounters	enc_guarantor_dob
_81.encounters	enc_ins1_insured_dob
_81.encounters	enc_ins2_insured_dob
_81.encounters	enc_ins3_insured_dob
_81.hl7_accessions	acc_dob
_81.insurances_repository	irep_ins_insured_dob
_81.orders	ord_dob
_81.patients	pat_dob
_81.patients	pat_guarantor_dob
_81.patients	pat_ins1_insured_dob
_81.patients	pat_ins2_insured_dob
_81.patients	pat_ins3_insured_dob
_81.patients_demographics_snapshots	pds_dob
_81.patients_demographics_snapshots	pds_guarantor_dob
_81.patients_demographics_snapshots	pds_ins1_insured_dob
_81.patients_demographics_snapshots	pds_ins2_insured_dob
_81.patients_demographics_snapshots	pds_ins3_insured_dob
_81.patients_responsibility_estimates	prest_dob
_81.precerts	pre_dob
_81.precerts	pre_guarantor_dob
_81.precerts	pre_ins1_insured_dob
_81.precerts	pre_ins2_insured_dob
_81.radiology_orders	rad_dob
_81.radiology_results	rad_res_dob
_999.charts	chrt_dob
_999.cpoe_responses	cpoe_res_dob
_999.donors	don_dob
_999.encounters	enc_dob
_999.encounters	enc_guarantor_dob
_999.encounters	enc_ins1_insured_dob
_999.encounters	enc_ins2_insured_dob
_999.encounters	enc_ins3_insured_dob
_999.hl7_accessions	acc_dob
_999.insurances_repository	irep_ins_insured_dob
_999.orders	ord_dob
_999.patients	pat_dob
_999.patients	pat_guarantor_dob
_999.patients	pat_ins1_insured_dob
_999.patients	pat_ins2_insured_dob
_999.patients	pat_ins3_insured_dob
_999.patients_demographics_snapshots	pds_dob
_999.patients_demographics_snapshots	pds_guarantor_dob
_999.patients_demographics_snapshots	pds_ins1_insured_dob
_999.patients_demographics_snapshots	pds_ins2_insured_dob
_999.patients_demographics_snapshots	pds_ins3_insured_dob
_999.patients_responsibility_estimates	prest_dob
_999.precerts	pre_dob
_999.precerts	pre_guarantor_dob
_999.precerts	pre_ins1_insured_dob
_999.precerts	pre_ins2_insured_dob
_999.radiology_orders	rad_dob
_999.radiology_results	rad_res_dob
aurora_standard.abmmpi	i1_dob
aurora_standard.abmmpi	i2_dob
aurora_standard.abmmpi	i3_dob
aurora_standard.abmmpi	gu_dob
aurora_standard.abmvis	gu_dob
aurora_standard.abmvis	i1_dob
aurora_standard.abmvis	i2_dob
aurora_standard.abmvis	i3_dob
aurora_standard.bevisbd2	p_dob
aurora_standard.bhar	p_dob
aurora_standard.bhar	g_dob
aurora_standard.bmmpi	p_dob
aurora_standard.bmnkin	n_dob
aurora_standard.bmpact	p_dob
aurora_standard.bmpat	p_dob
aurora_standard.bpar	p_dob
aurora_standard.bpar	g_dob
aurora_standard.bpar2	p_dob
aurora_standard.bpar2	g_dob
aurora_standard.bpmpi	p_dob
aurora_standard.bpmpi2	p_dob
aurora_standard.bpmr	p_dob
aurora_standard.bpmr2	p_dob
aurora_standard.c7mpi	p_dob
aurora_standard.c7mpi	gu_dob
aurora_standard.c8dtls	p_dob
aurora_standard.c8guar	g_dob
aurora_standard.c8guar2	g_dob
aurora_standard.c9mpi	p_dob
aurora_standard.chhl7in1	insured_dob
aurora_standard.chmarcnbf	g_dob
aurora_standard.chmarcnbf	p_dob
aurora_standard.chmarsi	pat_dob
aurora_standard.chmarsi	gu_dob
aurora_standard.chmarsi	sp_dob
aurora_standard.chmazstd	pat_dob
aurora_standard.chmazsti	pat_dob
aurora_standard.chmazsto	pat_dob
aurora_standard.chmbatex	pat_dob
aurora_standard.chmcampi	pat_dob
aurora_standard.chmcampi	gu_dob
aurora_standard.chmcampi	sp_dob
aurora_standard.chmclaim	pat_dob
aurora_standard.chmcmhed	guar_dob
aurora_standard.chmcmhed	pat_dob
aurora_standard.chmexmpi	pat_dob
aurora_standard.chmexmpi	gu_dob
aurora_standard.chmexmpi	sp_dob
aurora_standard.chmhistp	p_dob
aurora_standard.chmlastr	pat_dob
aurora_standard.chmmashr	pat_dob
aurora_standard.chmmhast	pat_dob
aurora_standard.chmnrcex	pat_dob
aurora_standard.chmokipd	pat_dob
aurora_standard.chmokopd	pat_dob
aurora_standard.chmozpcd	guar_dob
aurora_standard.chmozpcd	pat_dob
aurora_standard.chmpatir	subscr_dob
aurora_standard.chmpatwc	mom_dob
aurora_standard.chmpatwc	dad_dob
aurora_standard.chmpdemo	p_dob
aurora_standard.chmpdemo	sp_dob
aurora_standard.chmpdemo	gu_dob
aurora_standard.chmradex	pat_dob
aurora_standard.chmradex	gu_dob
aurora_standard.chmradex	sp_dob
aurora_standard.chmtxstr	pat_dob
aurora_standard.chqphync	phy_dob
aurora_standard.chxhistr	h_dob
aurora_standard.chyhistr	h_dob
aurora_standard.hl7in1	insured_dob
aurora_standard.hl7in1ad	insured_dob
aurora_standard.ncexmpi	pat_dob
aurora_standard.styoempd	depend_dob

ethnicity

Table	Column
_1.charts	chrt_ethnicity
_1.clinical_interventions	ci_ethnicity
_1.encounters	enc_ethnicity
_1.patients	pat_ethnicity
_1.patients_demographics_snapshots	pds_ethnicity
_1188.charts	chrt_ethnicity
_1188.clinical_interventions	ci_ethnicity
_1188.encounters	enc_ethnicity
_1188.patients	pat_ethnicity
_1188.patients_demographics_snapshots	pds_ethnicity
_1218.charts	chrt_ethnicity
_1218.clinical_interventions	ci_ethnicity
_1218.encounters	enc_ethnicity
_1218.patients	pat_ethnicity
_1218.patients_demographics_snapshots	pds_ethnicity
_1548.charts	chrt_ethnicity
_1548.clinical_interventions	ci_ethnicity
_1548.encounters	enc_ethnicity
_1548.patients	pat_ethnicity
_1548.patients_demographics_snapshots	pds_ethnicity
_435.charts	chrt_ethnicity
_435.clinical_interventions	ci_ethnicity
_435.encounters	enc_ethnicity
_435.patients	pat_ethnicity
_435.patients_demographics_snapshots	pds_ethnicity
_436.charts	chrt_ethnicity
_436.clinical_interventions	ci_ethnicity
_436.encounters	enc_ethnicity
_436.patients	pat_ethnicity
_436.patients_demographics_snapshots	pds_ethnicity
_436_archive_testing.charts	chrt_ethnicity
_436_archive_testing.clinical_interventions	ci_ethnicity
_436_archive_testing.encounters	enc_ethnicity
_436_archive_testing.patients	pat_ethnicity
_436_archive_testing.patients_demographics_snapshots	pds_ethnicity
_437.charts	chrt_ethnicity
_437.clinical_interventions	ci_ethnicity
_437.encounters	enc_ethnicity
_437.patients	pat_ethnicity
_437.patients_demographics_snapshots	pds_ethnicity
_8.charts	chrt_ethnicity
_8.clinical_interventions	ci_ethnicity
_8.encounters	enc_ethnicity
_8.patients	pat_ethnicity
_8.patients_demographics_snapshots	pds_ethnicity
_81.charts	chrt_ethnicity
_81.clinical_interventions	ci_ethnicity
_81.encounters	enc_ethnicity
_81.patients	pat_ethnicity
_81.patients_demographics_snapshots	pds_ethnicity
_999.charts	chrt_ethnicity
_999.clinical_interventions	ci_ethnicity
_999.encounters	enc_ethnicity
_999.patients	pat_ethnicity
_999.patients_demographics_snapshots	pds_ethnicity
aurora_standard.chmlastr	pat_ethnicity
aurora_standard.chmtxstr	pat_ethnicity

occupation

Table	Column
_1.encounters	enc_employer_occupation
_1.patients	pat_employer_occupation
_1.patients_demographics_snapshots	pds_employer_occupation
_1.precerts	pre_employer_occupation
_1188.encounters	enc_employer_occupation
_1188.patients	pat_employer_occupation
_1188.patients_demographics_snapshots	pds_employer_occupation
_1188.precerts	pre_employer_occupation
_1218.encounters	enc_employer_occupation
_1218.patients	pat_employer_occupation
_1218.patients_demographics_snapshots	pds_employer_occupation
_1218.precerts	pre_employer_occupation
_1548.encounters	enc_employer_occupation
_1548.patients	pat_employer_occupation
_1548.patients_demographics_snapshots	pds_employer_occupation
_1548.precerts	pre_employer_occupation
_435.encounters	enc_employer_occupation
_435.patients	pat_employer_occupation
_435.patients_demographics_snapshots	pds_employer_occupation
_435.precerts	pre_employer_occupation
_436.encounters	enc_employer_occupation
_436.patients	pat_employer_occupation
_436.patients_demographics_snapshots	pds_employer_occupation
_436.precerts	pre_employer_occupation
_436_archive_testing.encounters	enc_employer_occupation
_436_archive_testing.patients	pat_employer_occupation
_436_archive_testing.patients_demographics_snapshots	pds_employer_occupation
_436_archive_testing.precerts	pre_employer_occupation
_437.encounters	enc_employer_occupation
_437.patients	pat_employer_occupation
_437.patients_demographics_snapshots	pds_employer_occupation
_437.precerts	pre_employer_occupation
_8.encounters	enc_employer_occupation
_8.patients	pat_employer_occupation
_8.patients_demographics_snapshots	pds_employer_occupation
_8.precerts	pre_employer_occupation
_81.encounters	enc_employer_occupation
_81.patients	pat_employer_occupation
_81.patients_demographics_snapshots	pds_employer_occupation
_81.precerts	pre_employer_occupation
_999.encounters	enc_employer_occupation
_999.patients	pat_employer_occupation
_999.patients_demographics_snapshots	pds_employer_occupation
_999.precerts	pre_employer_occupation

deceased_dt

Table	Column
_1.patients	pat_deceased_dt
_1188.patients	pat_deceased_dt
_1218.patients	pat_deceased_dt
_1548.patients	pat_deceased_dt
_435.patients	pat_deceased_dt
_436.patients	pat_deceased_dt
_436_archive_testing.patients	pat_deceased_dt
_437.patients	pat_deceased_dt
_8.patients	pat_deceased_dt
_81.patients	pat_deceased_dt
_999.patients	pat_deceased_dt

country

Table	Column
aurora_standard.abmmpi	p_country
aurora_standard.abmmpi	i1_country
aurora_standard.abmmpi	i2_country
aurora_standard.abmmpi	i3_country
aurora_standard.abmvis	i1_country
aurora_standard.abmvis	i2_country
aurora_standard.abmvis	i3_country
aurora_standard.bs2mpi	p_country
aurora_standard.bsmpi	p_country
aurora_standard.c7mpi	p_country
aurora_standard.c7mpi	p2_country
aurora_standard.c7mpi	insur_country
aurora_standard.c7mpi	gu_country
aurora_standard.c7mpi	gu2_country
aurora_standard.chmazstd	pat_country
aurora_standard.chmazsti	pat_country
aurora_standard.chmazsto	pat_country
aurora_standard.chmub04r	f_09_country
aurora_standard.stxmtaxr	mtax_country
aurora_standard.styoctcc	employer_country
aurora_standard.styoempr	empl_country
aurora_standard.tmpub04r	f_09_country
rcmroi.dev__sf_users	addr_country
rcmroi.prod__sf_users	addr_country
rcmroi.test__sf_users	addr_country

mrno

Table	Column
aurora_standard.abmmpi	gu_mrno
aurora_standard.abmvis	gu_mrno
aurora_standard.amrnowk	good_mrno
aurora_standard.amrnowk	old_mrno
aurora_standard.apsmpi2	ca_mrno
aurora_standard.aseympi	ca_mrno
aurora_standard.b2badd	new_mrno
aurora_standard.b2mrdr	new_mrno
aurora_standard.bhbadd	new_mrno
aurora_standard.bhldgr	new_mrno
aurora_standard.bhmrdr	new_mrno
aurora_standard.bhtldgr	new_mrno
aurora_standard.bvmpi	new_mrno
aurora_standard.bvmpi2	new_mrno
aurora_standard.chmcntrc	assign_mrno
aurora_standard.chxcntrc	id_is_mrno

cell_ph

Table	Column
aurora_standard.bdmpi	sp_cell_ph
aurora_standard.bdmpi	nk_cell_ph
aurora_standard.bdmpi	pat_cell_ph
aurora_standard.bempi	p_cell_ph

marital

Table	Column
aurora_standard.chmarsi	pat_marital
aurora_standard.chmazstd	pat_marital
aurora_standard.chmazsti	pat_marital
aurora_standard.chmazsto	pat_marital
aurora_standard.chmcampi	pat_marital
aurora_standard.chmexmpi	pat_marital
aurora_standard.chmlastr	pat_marital
aurora_standard.chmmrhdr	upd_marital
aurora_standard.chmokipd	pat_marital
aurora_standard.chmokopd	pat_marital
aurora_standard.chmpdemo	p_marital
aurora_standard.chmradex	pat_marital
aurora_standard.chmtxstr	pat_marital
aurora_standard.ohoemadd	state_marital
aurora_standard.ohoemadd	fed_marital
aurora_standard.styemplr	state_marital
aurora_standard.stytaxtd	state_marital