aurora_standard.kcmpi

Field	Type	Null
ssn	varchar(11)	YES
mr_no	varchar(20)	YES
lname	varchar(20)	YES
fname	varchar(20)	YES
mname	varchar(20)	YES
maidname	varchar(20)	YES
dob	char(10)	YES
sex	varchar(1)	YES
guanum	char(10)	YES
nkname	varchar(20)	YES
nkrel	varchar(2)	YES
nkadd1	varchar(20)	YES
nkadd2	varchar(20)	YES
nkcity	varchar(20)	YES
nkst	varchar(2)	YES
nkzip	char(5)	YES
nkzip2	char(4)	YES
nkphone	char(20)	YES
nkempno	char(10)	YES
nkcphone	char(20)	YES
add1	char(30)	YES
add2	char(20)	YES
county	char(20)	YES
city	char(20)	YES
st	char(2)	YES
zip	char(5)	YES
zip2	char(4)	YES
phone	varchar(20)	YES
empno	char(10)	YES
empphone	varchar(20)	YES
cphone	varchar(20)	YES
retire_date	char(10)	YES
marital	varchar(1)	YES
race	varchar(1)	YES
religion	varchar(2)	YES
death_date	char(20)	YES
patlan	varchar(10)	YES
country	varchar(3)	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

phone

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

city

Table	Column
Azalea.employees	emp_city
_1.billing_providers	bp_city
_1.buildings	bld_city
_1.charts	chrt_city
_1.client_contacts	clicon_city
_1.encounters	enc_city
_1.encounters	enc_employer_city
_1.encounters	enc_guarantor_city
_1.encounters	enc_ins1_employer_city
_1.encounters	enc_ins2_employer_city
_1.encounters	enc_ins3_employer_city
_1.hl7_lab_locations	hll_city
_1.insurances	ins_city
_1.insurances_claims_centers	icc_city
_1.insurances_repository	irep_ins_employer_city
_1.locations	loc_city
_1.non_patients	npat_city
_1.orders	ord_city
_1.orders	ord_ins1_employer_city
_1.orders	ord_ins2_employer_city
_1.patient_next_of_kin	pnk_city
_1.patients	pat_city
_1.patients	pat_employer_city
_1.patients	pat_guarantor_city
_1.patients	pat_ins1_employer_city
_1.patients	pat_ins2_employer_city
_1.patients	pat_ins3_employer_city
_1.patients	pat_emergency_city
_1.patients_demographics_snapshots	pds_city
_1.patients_demographics_snapshots	pds_employer_city
_1.patients_demographics_snapshots	pds_guarantor_city
_1.patients_demographics_snapshots	pds_ins1_employer_city
_1.patients_demographics_snapshots	pds_ins2_employer_city
_1.patients_demographics_snapshots	pds_ins3_employer_city
_1.physicians	phy_city
_1.precerts	pre_city
_1.precerts	pre_employer_city
_1.precerts	pre_guarantor_city
_1.precerts	pre_ins1_employer_city
_1.precerts	pre_ins2_employer_city
_1.radiology_orders	rad_city
_1.radiology_orders	rad_ins1_employer_city
_1.radiology_orders	rad_ins2_employer_city
_1188.billing_providers	bp_city
_1188.buildings	bld_city
_1188.charts	chrt_city
_1188.client_contacts	clicon_city
_1188.encounters	enc_city
_1188.encounters	enc_employer_city
_1188.encounters	enc_guarantor_city
_1188.encounters	enc_ins1_employer_city
_1188.encounters	enc_ins2_employer_city
_1188.encounters	enc_ins3_employer_city
_1188.hl7_lab_locations	hll_city
_1188.insurances	ins_city
_1188.insurances_claims_centers	icc_city
_1188.insurances_repository	irep_ins_employer_city
_1188.locations	loc_city
_1188.non_patients	npat_city
_1188.orders	ord_city
_1188.orders	ord_ins1_employer_city
_1188.orders	ord_ins2_employer_city
_1188.patient_next_of_kin	pnk_city
_1188.patients	pat_city
_1188.patients	pat_employer_city
_1188.patients	pat_guarantor_city
_1188.patients	pat_ins1_employer_city
_1188.patients	pat_ins2_employer_city
_1188.patients	pat_ins3_employer_city
_1188.patients	pat_emergency_city
_1188.patients_demographics_snapshots	pds_city
_1188.patients_demographics_snapshots	pds_employer_city
_1188.patients_demographics_snapshots	pds_guarantor_city
_1188.patients_demographics_snapshots	pds_ins1_employer_city
_1188.patients_demographics_snapshots	pds_ins2_employer_city
_1188.patients_demographics_snapshots	pds_ins3_employer_city
_1188.physicians	phy_city
_1188.precerts	pre_city
_1188.precerts	pre_employer_city
_1188.precerts	pre_guarantor_city
_1188.precerts	pre_ins1_employer_city
_1188.precerts	pre_ins2_employer_city
_1188.radiology_orders	rad_city
_1188.radiology_orders	rad_ins1_employer_city
_1188.radiology_orders	rad_ins2_employer_city
_1218.billing_providers	bp_city
_1218.buildings	bld_city
_1218.charts	chrt_city
_1218.client_contacts	clicon_city
_1218.encounters	enc_city
_1218.encounters	enc_employer_city
_1218.encounters	enc_guarantor_city
_1218.encounters	enc_ins1_employer_city
_1218.encounters	enc_ins2_employer_city
_1218.encounters	enc_ins3_employer_city
_1218.hl7_lab_locations	hll_city
_1218.insurances	ins_city
_1218.insurances_claims_centers	icc_city
_1218.insurances_repository	irep_ins_employer_city
_1218.locations	loc_city
_1218.non_patients	npat_city
_1218.orders	ord_city
_1218.orders	ord_ins1_employer_city
_1218.orders	ord_ins2_employer_city
_1218.patient_next_of_kin	pnk_city
_1218.patients	pat_city
_1218.patients	pat_employer_city
_1218.patients	pat_guarantor_city
_1218.patients	pat_ins1_employer_city
_1218.patients	pat_ins2_employer_city
_1218.patients	pat_ins3_employer_city
_1218.patients	pat_emergency_city
_1218.patients_demographics_snapshots	pds_city
_1218.patients_demographics_snapshots	pds_employer_city
_1218.patients_demographics_snapshots	pds_guarantor_city
_1218.patients_demographics_snapshots	pds_ins1_employer_city
_1218.patients_demographics_snapshots	pds_ins2_employer_city
_1218.patients_demographics_snapshots	pds_ins3_employer_city
_1218.physicians	phy_city
_1218.precerts	pre_city
_1218.precerts	pre_employer_city
_1218.precerts	pre_guarantor_city
_1218.precerts	pre_ins1_employer_city
_1218.precerts	pre_ins2_employer_city
_1218.radiology_orders	rad_city
_1218.radiology_orders	rad_ins1_employer_city
_1218.radiology_orders	rad_ins2_employer_city
_1548.billing_providers	bp_city
_1548.buildings	bld_city
_1548.charts	chrt_city
_1548.client_contacts	clicon_city
_1548.encounters	enc_city
_1548.encounters	enc_employer_city
_1548.encounters	enc_guarantor_city
_1548.encounters	enc_ins1_employer_city
_1548.encounters	enc_ins2_employer_city
_1548.encounters	enc_ins3_employer_city
_1548.hl7_lab_locations	hll_city
_1548.insurances	ins_city
_1548.insurances_claims_centers	icc_city
_1548.insurances_repository	irep_ins_employer_city
_1548.locations	loc_city
_1548.non_patients	npat_city
_1548.orders	ord_city
_1548.orders	ord_ins1_employer_city
_1548.orders	ord_ins2_employer_city
_1548.patient_next_of_kin	pnk_city
_1548.patients	pat_city
_1548.patients	pat_employer_city
_1548.patients	pat_guarantor_city
_1548.patients	pat_ins1_employer_city
_1548.patients	pat_ins2_employer_city
_1548.patients	pat_ins3_employer_city
_1548.patients	pat_emergency_city
_1548.patients_demographics_snapshots	pds_city
_1548.patients_demographics_snapshots	pds_employer_city
_1548.patients_demographics_snapshots	pds_guarantor_city
_1548.patients_demographics_snapshots	pds_ins1_employer_city
_1548.patients_demographics_snapshots	pds_ins2_employer_city
_1548.patients_demographics_snapshots	pds_ins3_employer_city
_1548.physicians	phy_city
_1548.precerts	pre_city
_1548.precerts	pre_employer_city
_1548.precerts	pre_guarantor_city
_1548.precerts	pre_ins1_employer_city
_1548.precerts	pre_ins2_employer_city
_1548.radiology_orders	rad_city
_1548.radiology_orders	rad_ins1_employer_city
_1548.radiology_orders	rad_ins2_employer_city
_435.billing_providers	bp_city
_435.buildings	bld_city
_435.charts	chrt_city
_435.client_contacts	clicon_city
_435.encounters	enc_city
_435.encounters	enc_employer_city
_435.encounters	enc_guarantor_city
_435.encounters	enc_ins1_employer_city
_435.encounters	enc_ins2_employer_city
_435.encounters	enc_ins3_employer_city
_435.hl7_lab_locations	hll_city
_435.insurances	ins_city
_435.insurances_claims_centers	icc_city
_435.insurances_repository	irep_ins_employer_city
_435.locations	loc_city
_435.non_patients	npat_city
_435.orders	ord_city
_435.orders	ord_ins1_employer_city
_435.orders	ord_ins2_employer_city
_435.patient_next_of_kin	pnk_city
_435.patients	pat_city
_435.patients	pat_employer_city
_435.patients	pat_guarantor_city
_435.patients	pat_ins1_employer_city
_435.patients	pat_ins2_employer_city
_435.patients	pat_ins3_employer_city
_435.patients	pat_emergency_city
_435.patients_demographics_snapshots	pds_city
_435.patients_demographics_snapshots	pds_employer_city
_435.patients_demographics_snapshots	pds_guarantor_city
_435.patients_demographics_snapshots	pds_ins1_employer_city
_435.patients_demographics_snapshots	pds_ins2_employer_city
_435.patients_demographics_snapshots	pds_ins3_employer_city
_435.physicians	phy_city
_435.precerts	pre_city
_435.precerts	pre_employer_city
_435.precerts	pre_guarantor_city
_435.precerts	pre_ins1_employer_city
_435.precerts	pre_ins2_employer_city
_435.radiology_orders	rad_city
_435.radiology_orders	rad_ins1_employer_city
_435.radiology_orders	rad_ins2_employer_city
_436.billing_providers	bp_city
_436.buildings	bld_city
_436.charts	chrt_city
_436.client_contacts	clicon_city
_436.encounters	enc_city
_436.encounters	enc_employer_city
_436.encounters	enc_guarantor_city
_436.encounters	enc_ins1_employer_city
_436.encounters	enc_ins2_employer_city
_436.encounters	enc_ins3_employer_city
_436.hl7_lab_locations	hll_city
_436.insurances	ins_city
_436.insurances_claims_centers	icc_city
_436.insurances_repository	irep_ins_employer_city
_436.locations	loc_city
_436.non_patients	npat_city
_436.orders	ord_city
_436.orders	ord_ins1_employer_city
_436.orders	ord_ins2_employer_city
_436.patient_next_of_kin	pnk_city
_436.patients	pat_city
_436.patients	pat_employer_city
_436.patients	pat_guarantor_city
_436.patients	pat_ins1_employer_city
_436.patients	pat_ins2_employer_city
_436.patients	pat_ins3_employer_city
_436.patients	pat_emergency_city
_436.patients_demographics_snapshots	pds_city
_436.patients_demographics_snapshots	pds_employer_city
_436.patients_demographics_snapshots	pds_guarantor_city
_436.patients_demographics_snapshots	pds_ins1_employer_city
_436.patients_demographics_snapshots	pds_ins2_employer_city
_436.patients_demographics_snapshots	pds_ins3_employer_city
_436.physicians	phy_city
_436.precerts	pre_city
_436.precerts	pre_employer_city
_436.precerts	pre_guarantor_city
_436.precerts	pre_ins1_employer_city
_436.precerts	pre_ins2_employer_city
_436.radiology_orders	rad_city
_436.radiology_orders	rad_ins1_employer_city
_436.radiology_orders	rad_ins2_employer_city
_436_archive_testing.billing_providers	bp_city
_436_archive_testing.buildings	bld_city
_436_archive_testing.charts	chrt_city
_436_archive_testing.client_contacts	clicon_city
_436_archive_testing.encounters	enc_city
_436_archive_testing.encounters	enc_employer_city
_436_archive_testing.encounters	enc_guarantor_city
_436_archive_testing.encounters	enc_ins1_employer_city
_436_archive_testing.encounters	enc_ins2_employer_city
_436_archive_testing.encounters	enc_ins3_employer_city
_436_archive_testing.hl7_lab_locations	hll_city
_436_archive_testing.insurances	ins_city
_436_archive_testing.insurances_claims_centers	icc_city
_436_archive_testing.insurances_repository	irep_ins_employer_city
_436_archive_testing.locations	loc_city
_436_archive_testing.non_patients	npat_city
_436_archive_testing.orders	ord_city
_436_archive_testing.orders	ord_ins1_employer_city
_436_archive_testing.orders	ord_ins2_employer_city
_436_archive_testing.patient_next_of_kin	pnk_city
_436_archive_testing.patients	pat_city
_436_archive_testing.patients	pat_employer_city
_436_archive_testing.patients	pat_guarantor_city
_436_archive_testing.patients	pat_ins1_employer_city
_436_archive_testing.patients	pat_ins2_employer_city
_436_archive_testing.patients	pat_ins3_employer_city
_436_archive_testing.patients	pat_emergency_city
_436_archive_testing.patients_demographics_snapshots	pds_city
_436_archive_testing.patients_demographics_snapshots	pds_employer_city
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_city
_436_archive_testing.patients_demographics_snapshots	pds_ins1_employer_city
_436_archive_testing.patients_demographics_snapshots	pds_ins2_employer_city
_436_archive_testing.patients_demographics_snapshots	pds_ins3_employer_city
_436_archive_testing.physicians	phy_city
_436_archive_testing.precerts	pre_city
_436_archive_testing.precerts	pre_employer_city
_436_archive_testing.precerts	pre_guarantor_city
_436_archive_testing.precerts	pre_ins1_employer_city
_436_archive_testing.precerts	pre_ins2_employer_city
_436_archive_testing.radiology_orders	rad_city
_436_archive_testing.radiology_orders	rad_ins1_employer_city
_436_archive_testing.radiology_orders	rad_ins2_employer_city
_437.billing_providers	bp_city
_437.buildings	bld_city
_437.charts	chrt_city
_437.client_contacts	clicon_city
_437.encounters	enc_city
_437.encounters	enc_employer_city
_437.encounters	enc_guarantor_city
_437.encounters	enc_ins1_employer_city
_437.encounters	enc_ins2_employer_city
_437.encounters	enc_ins3_employer_city
_437.hl7_lab_locations	hll_city
_437.insurances	ins_city
_437.insurances_claims_centers	icc_city
_437.insurances_repository	irep_ins_employer_city
_437.locations	loc_city
_437.non_patients	npat_city
_437.orders	ord_city
_437.orders	ord_ins1_employer_city
_437.orders	ord_ins2_employer_city
_437.patient_next_of_kin	pnk_city
_437.patients	pat_city
_437.patients	pat_employer_city
_437.patients	pat_guarantor_city
_437.patients	pat_ins1_employer_city
_437.patients	pat_ins2_employer_city
_437.patients	pat_ins3_employer_city
_437.patients	pat_emergency_city
_437.patients_demographics_snapshots	pds_city
_437.patients_demographics_snapshots	pds_employer_city
_437.patients_demographics_snapshots	pds_guarantor_city
_437.patients_demographics_snapshots	pds_ins1_employer_city
_437.patients_demographics_snapshots	pds_ins2_employer_city
_437.patients_demographics_snapshots	pds_ins3_employer_city
_437.physicians	phy_city
_437.precerts	pre_city
_437.precerts	pre_employer_city
_437.precerts	pre_guarantor_city
_437.precerts	pre_ins1_employer_city
_437.precerts	pre_ins2_employer_city
_437.radiology_orders	rad_city
_437.radiology_orders	rad_ins1_employer_city
_437.radiology_orders	rad_ins2_employer_city
_8.billing_providers	bp_city
_8.buildings	bld_city
_8.charts	chrt_city
_8.client_contacts	clicon_city
_8.encounters	enc_city
_8.encounters	enc_employer_city
_8.encounters	enc_guarantor_city
_8.encounters	enc_ins1_employer_city
_8.encounters	enc_ins2_employer_city
_8.encounters	enc_ins3_employer_city
_8.hl7_lab_locations	hll_city
_8.insurances	ins_city
_8.insurances_claims_centers	icc_city
_8.insurances_repository	irep_ins_employer_city
_8.locations	loc_city
_8.non_patients	npat_city
_8.orders	ord_city
_8.orders	ord_ins1_employer_city
_8.orders	ord_ins2_employer_city
_8.patient_next_of_kin	pnk_city
_8.patients	pat_city
_8.patients	pat_employer_city
_8.patients	pat_guarantor_city
_8.patients	pat_ins1_employer_city
_8.patients	pat_ins2_employer_city
_8.patients	pat_ins3_employer_city
_8.patients	pat_emergency_city
_8.patients_demographics_snapshots	pds_city
_8.patients_demographics_snapshots	pds_employer_city
_8.patients_demographics_snapshots	pds_guarantor_city
_8.patients_demographics_snapshots	pds_ins1_employer_city
_8.patients_demographics_snapshots	pds_ins2_employer_city
_8.patients_demographics_snapshots	pds_ins3_employer_city
_8.physicians	phy_city
_8.precerts	pre_city
_8.precerts	pre_employer_city
_8.precerts	pre_guarantor_city
_8.precerts	pre_ins1_employer_city
_8.precerts	pre_ins2_employer_city
_8.radiology_orders	rad_city
_8.radiology_orders	rad_ins1_employer_city
_8.radiology_orders	rad_ins2_employer_city
_81.billing_providers	bp_city
_81.buildings	bld_city
_81.charts	chrt_city
_81.client_contacts	clicon_city
_81.encounters	enc_city
_81.encounters	enc_employer_city
_81.encounters	enc_guarantor_city
_81.encounters	enc_ins1_employer_city
_81.encounters	enc_ins2_employer_city
_81.encounters	enc_ins3_employer_city
_81.hl7_lab_locations	hll_city
_81.insurances	ins_city
_81.insurances_claims_centers	icc_city
_81.insurances_repository	irep_ins_employer_city
_81.locations	loc_city
_81.non_patients	npat_city
_81.orders	ord_city
_81.orders	ord_ins1_employer_city
_81.orders	ord_ins2_employer_city
_81.patient_next_of_kin	pnk_city
_81.patients	pat_city
_81.patients	pat_employer_city
_81.patients	pat_guarantor_city
_81.patients	pat_ins1_employer_city
_81.patients	pat_ins2_employer_city
_81.patients	pat_ins3_employer_city
_81.patients	pat_emergency_city
_81.patients_demographics_snapshots	pds_city
_81.patients_demographics_snapshots	pds_employer_city
_81.patients_demographics_snapshots	pds_guarantor_city
_81.patients_demographics_snapshots	pds_ins1_employer_city
_81.patients_demographics_snapshots	pds_ins2_employer_city
_81.patients_demographics_snapshots	pds_ins3_employer_city
_81.physicians	phy_city
_81.precerts	pre_city
_81.precerts	pre_employer_city
_81.precerts	pre_guarantor_city
_81.precerts	pre_ins1_employer_city
_81.precerts	pre_ins2_employer_city
_81.radiology_orders	rad_city
_81.radiology_orders	rad_ins1_employer_city
_81.radiology_orders	rad_ins2_employer_city
_999.billing_providers	bp_city
_999.buildings	bld_city
_999.charts	chrt_city
_999.client_contacts	clicon_city
_999.encounters	enc_city
_999.encounters	enc_employer_city
_999.encounters	enc_guarantor_city
_999.encounters	enc_ins1_employer_city
_999.encounters	enc_ins2_employer_city
_999.encounters	enc_ins3_employer_city
_999.hl7_lab_locations	hll_city
_999.insurances	ins_city
_999.insurances_claims_centers	icc_city
_999.insurances_repository	irep_ins_employer_city
_999.locations	loc_city
_999.non_patients	npat_city
_999.orders	ord_city
_999.orders	ord_ins1_employer_city
_999.orders	ord_ins2_employer_city
_999.patient_next_of_kin	pnk_city
_999.patients	pat_city
_999.patients	pat_employer_city
_999.patients	pat_guarantor_city
_999.patients	pat_ins1_employer_city
_999.patients	pat_ins2_employer_city
_999.patients	pat_ins3_employer_city
_999.patients	pat_emergency_city
_999.patients_demographics_snapshots	pds_city
_999.patients_demographics_snapshots	pds_employer_city
_999.patients_demographics_snapshots	pds_guarantor_city
_999.patients_demographics_snapshots	pds_ins1_employer_city
_999.patients_demographics_snapshots	pds_ins2_employer_city
_999.patients_demographics_snapshots	pds_ins3_employer_city
_999.physicians	phy_city
_999.precerts	pre_city
_999.precerts	pre_employer_city
_999.precerts	pre_guarantor_city
_999.precerts	pre_ins1_employer_city
_999.precerts	pre_ins2_employer_city
_999.radiology_orders	rad_city
_999.radiology_orders	rad_ins1_employer_city
_999.radiology_orders	rad_ins2_employer_city
aurora_standard.abmmpi	p_city
aurora_standard.abmmpi	emp_city
aurora_standard.abmmpi	i1_city
aurora_standard.abmmpi	i2_city
aurora_standard.abmmpi	i3_city
aurora_standard.abmmpi	gu_city
aurora_standard.abmmpi	gu_emp_city
aurora_standard.abmmpi	n1_city
aurora_standard.abmmpi	n2_city
aurora_standard.abmvis	p_city
aurora_standard.abmvis	gu_city
aurora_standard.abmvis	i1_city
aurora_standard.abmvis	i2_city
aurora_standard.abmvis	i3_city
aurora_standard.anmpi	p_city
aurora_standard.apsmpi	p_city
aurora_standard.aseympi	p_city
aurora_standard.bdmpi	sp_city
aurora_standard.bdmpi	nk_city
aurora_standard.bdmpi	pat_city
aurora_standard.bempi	p_city
aurora_standard.bfhos	gu_city
aurora_standard.bfpasr	gu_city
aurora_standard.bfrhc	gu_city
aurora_standard.bhar	p_city
aurora_standard.bhar	g_city
aurora_standard.bhar	ge_city
aurora_standard.bhar	co1_city
aurora_standard.bhar	co2_city
aurora_standard.bhar	co3_city
aurora_standard.bhar	co4_city
aurora_standard.bhar	co5_city
aurora_standard.bhar	co6_city
aurora_standard.bhar	em_city
aurora_standard.bmmpi	p_city
aurora_standard.bmmpi	gu_city
aurora_standard.bmnkin	n_city
aurora_standard.bmpact	p_city
aurora_standard.bmpact	gu_city
aurora_standard.bpar	p_city
aurora_standard.bpar	g_city
aurora_standard.bpar	ge_city
aurora_standard.bpar	co1_city
aurora_standard.bpar	co2_city
aurora_standard.bpar	co3_city
aurora_standard.bpar	co4_city
aurora_standard.bpar	co5_city
aurora_standard.bpar	co6_city
aurora_standard.bpar	em_city
aurora_standard.bpar2	p_city
aurora_standard.bpar2	g_city
aurora_standard.bpar2	ge_city
aurora_standard.bpar2	co1_city
aurora_standard.bpar2	co2_city
aurora_standard.bpar2	co3_city
aurora_standard.bpar2	co4_city
aurora_standard.bpar2	co5_city
aurora_standard.bpar2	co6_city
aurora_standard.bpar2	em_city
aurora_standard.bpmpi	p_city
aurora_standard.bpmpi2	p_city
aurora_standard.bs2mpi	contact1_city
aurora_standard.bs2mpi	p_city
aurora_standard.bsinsur	spouse_city
aurora_standard.bsinsur	nextkin_city
aurora_standard.bsinsur	patient_city
aurora_standard.bsmpi	contact1_city
aurora_standard.bsmpi	p_city
aurora_standard.c7insur2	ins_city
aurora_standard.c7insur3	ins_city
aurora_standard.c7mpi	p_city
aurora_standard.c7mpi	p2_city
aurora_standard.c7mpi	insur_city
aurora_standard.c7mpi	gu_city
aurora_standard.c7mpi	gu2_city
aurora_standard.c8mpi	p_city
aurora_standard.campi	spouse_city
aurora_standard.campi	nextkin_city
aurora_standard.campi	patient_city
aurora_standard.chhl7adt	patient_city
aurora_standard.chhl7in1	ins_city
aurora_standard.chhl7in1	ins_empl_city
aurora_standard.chlswbhd	fac_city
aurora_standard.chlswbhd	agt_city
aurora_standard.chlswbhd	sfw_city
aurora_standard.chltrnhd	fac_city
aurora_standard.chltrnhd	agt_city
aurora_standard.chltrnhd	sfw_city
aurora_standard.chmadmwc	ref_city_st
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.chmpatwc	mom_city_st
aurora_standard.chmpatwc	dad_city_st
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

zip

Table	Column
Azalea.employees	emp_zip
_1.billing_providers	bp_zip
_1.buildings	bld_zip
_1.charts	chrt_zip
_1.client_contacts	clicon_zip
_1.encounters	enc_zip
_1.encounters	enc_employer_zip
_1.encounters	enc_guarantor_zip
_1.encounters	enc_ins1_employer_zip
_1.encounters	enc_ins2_employer_zip
_1.encounters	enc_ins3_employer_zip
_1.hl7_lab_locations	hll_zip
_1.insurances	ins_zip
_1.insurances_claims_centers	icc_zip
_1.insurances_repository	irep_ins_employer_zip
_1.locations	loc_zip
_1.non_patients	npat_zip
_1.orders	ord_zip
_1.orders	ord_ins1_employer_zip
_1.orders	ord_ins2_employer_zip
_1.patient_next_of_kin	pnk_zip
_1.patients	pat_zip
_1.patients	pat_employer_zip
_1.patients	pat_guarantor_zip
_1.patients	pat_ins1_employer_zip
_1.patients	pat_ins2_employer_zip
_1.patients	pat_ins3_employer_zip
_1.patients	pat_emergency_zip
_1.patients_demographics_snapshots	pds_zip
_1.patients_demographics_snapshots	pds_employer_zip
_1.patients_demographics_snapshots	pds_guarantor_zip
_1.patients_demographics_snapshots	pds_ins1_employer_zip
_1.patients_demographics_snapshots	pds_ins2_employer_zip
_1.patients_demographics_snapshots	pds_ins3_employer_zip
_1.physicians	phy_zip
_1.precerts	pre_zip
_1.precerts	pre_employer_zip
_1.precerts	pre_guarantor_zip
_1.precerts	pre_ins1_employer_zip
_1.precerts	pre_ins2_employer_zip
_1.radiology_orders	rad_zip
_1.radiology_orders	rad_ins1_employer_zip
_1.radiology_orders	rad_ins2_employer_zip
_1188.billing_providers	bp_zip
_1188.buildings	bld_zip
_1188.charts	chrt_zip
_1188.client_contacts	clicon_zip
_1188.encounters	enc_zip
_1188.encounters	enc_employer_zip
_1188.encounters	enc_guarantor_zip
_1188.encounters	enc_ins1_employer_zip
_1188.encounters	enc_ins2_employer_zip
_1188.encounters	enc_ins3_employer_zip
_1188.hl7_lab_locations	hll_zip
_1188.insurances	ins_zip
_1188.insurances_claims_centers	icc_zip
_1188.insurances_repository	irep_ins_employer_zip
_1188.locations	loc_zip
_1188.non_patients	npat_zip
_1188.orders	ord_zip
_1188.orders	ord_ins1_employer_zip
_1188.orders	ord_ins2_employer_zip
_1188.patient_next_of_kin	pnk_zip
_1188.patients	pat_zip
_1188.patients	pat_employer_zip
_1188.patients	pat_guarantor_zip
_1188.patients	pat_ins1_employer_zip
_1188.patients	pat_ins2_employer_zip
_1188.patients	pat_ins3_employer_zip
_1188.patients	pat_emergency_zip
_1188.patients_demographics_snapshots	pds_zip
_1188.patients_demographics_snapshots	pds_employer_zip
_1188.patients_demographics_snapshots	pds_guarantor_zip
_1188.patients_demographics_snapshots	pds_ins1_employer_zip
_1188.patients_demographics_snapshots	pds_ins2_employer_zip
_1188.patients_demographics_snapshots	pds_ins3_employer_zip
_1188.physicians	phy_zip
_1188.precerts	pre_zip
_1188.precerts	pre_employer_zip
_1188.precerts	pre_guarantor_zip
_1188.precerts	pre_ins1_employer_zip
_1188.precerts	pre_ins2_employer_zip
_1188.radiology_orders	rad_zip
_1188.radiology_orders	rad_ins1_employer_zip
_1188.radiology_orders	rad_ins2_employer_zip
_1218.billing_providers	bp_zip
_1218.buildings	bld_zip
_1218.charts	chrt_zip
_1218.client_contacts	clicon_zip
_1218.encounters	enc_zip
_1218.encounters	enc_employer_zip
_1218.encounters	enc_guarantor_zip
_1218.encounters	enc_ins1_employer_zip
_1218.encounters	enc_ins2_employer_zip
_1218.encounters	enc_ins3_employer_zip
_1218.hl7_lab_locations	hll_zip
_1218.insurances	ins_zip
_1218.insurances_claims_centers	icc_zip
_1218.insurances_repository	irep_ins_employer_zip
_1218.locations	loc_zip
_1218.non_patients	npat_zip
_1218.orders	ord_zip
_1218.orders	ord_ins1_employer_zip
_1218.orders	ord_ins2_employer_zip
_1218.patient_next_of_kin	pnk_zip
_1218.patients	pat_zip
_1218.patients	pat_employer_zip
_1218.patients	pat_guarantor_zip
_1218.patients	pat_ins1_employer_zip
_1218.patients	pat_ins2_employer_zip
_1218.patients	pat_ins3_employer_zip
_1218.patients	pat_emergency_zip
_1218.patients_demographics_snapshots	pds_zip
_1218.patients_demographics_snapshots	pds_employer_zip
_1218.patients_demographics_snapshots	pds_guarantor_zip
_1218.patients_demographics_snapshots	pds_ins1_employer_zip
_1218.patients_demographics_snapshots	pds_ins2_employer_zip
_1218.patients_demographics_snapshots	pds_ins3_employer_zip
_1218.physicians	phy_zip
_1218.precerts	pre_zip
_1218.precerts	pre_employer_zip
_1218.precerts	pre_guarantor_zip
_1218.precerts	pre_ins1_employer_zip
_1218.precerts	pre_ins2_employer_zip
_1218.radiology_orders	rad_zip
_1218.radiology_orders	rad_ins1_employer_zip
_1218.radiology_orders	rad_ins2_employer_zip
_1548.billing_providers	bp_zip
_1548.buildings	bld_zip
_1548.charts	chrt_zip
_1548.client_contacts	clicon_zip
_1548.encounters	enc_zip
_1548.encounters	enc_employer_zip
_1548.encounters	enc_guarantor_zip
_1548.encounters	enc_ins1_employer_zip
_1548.encounters	enc_ins2_employer_zip
_1548.encounters	enc_ins3_employer_zip
_1548.hl7_lab_locations	hll_zip
_1548.insurances	ins_zip
_1548.insurances_claims_centers	icc_zip
_1548.insurances_repository	irep_ins_employer_zip
_1548.locations	loc_zip
_1548.non_patients	npat_zip
_1548.orders	ord_zip
_1548.orders	ord_ins1_employer_zip
_1548.orders	ord_ins2_employer_zip
_1548.patient_next_of_kin	pnk_zip
_1548.patients	pat_zip
_1548.patients	pat_employer_zip
_1548.patients	pat_guarantor_zip
_1548.patients	pat_ins1_employer_zip
_1548.patients	pat_ins2_employer_zip
_1548.patients	pat_ins3_employer_zip
_1548.patients	pat_emergency_zip
_1548.patients_demographics_snapshots	pds_zip
_1548.patients_demographics_snapshots	pds_employer_zip
_1548.patients_demographics_snapshots	pds_guarantor_zip
_1548.patients_demographics_snapshots	pds_ins1_employer_zip
_1548.patients_demographics_snapshots	pds_ins2_employer_zip
_1548.patients_demographics_snapshots	pds_ins3_employer_zip
_1548.physicians	phy_zip
_1548.precerts	pre_zip
_1548.precerts	pre_employer_zip
_1548.precerts	pre_guarantor_zip
_1548.precerts	pre_ins1_employer_zip
_1548.precerts	pre_ins2_employer_zip
_1548.radiology_orders	rad_zip
_1548.radiology_orders	rad_ins1_employer_zip
_1548.radiology_orders	rad_ins2_employer_zip
_435.billing_providers	bp_zip
_435.buildings	bld_zip
_435.charts	chrt_zip
_435.client_contacts	clicon_zip
_435.encounters	enc_zip
_435.encounters	enc_employer_zip
_435.encounters	enc_guarantor_zip
_435.encounters	enc_ins1_employer_zip
_435.encounters	enc_ins2_employer_zip
_435.encounters	enc_ins3_employer_zip
_435.hl7_lab_locations	hll_zip
_435.insurances	ins_zip
_435.insurances_claims_centers	icc_zip
_435.insurances_repository	irep_ins_employer_zip
_435.locations	loc_zip
_435.non_patients	npat_zip
_435.orders	ord_zip
_435.orders	ord_ins1_employer_zip
_435.orders	ord_ins2_employer_zip
_435.patient_next_of_kin	pnk_zip
_435.patients	pat_zip
_435.patients	pat_employer_zip
_435.patients	pat_guarantor_zip
_435.patients	pat_ins1_employer_zip
_435.patients	pat_ins2_employer_zip
_435.patients	pat_ins3_employer_zip
_435.patients	pat_emergency_zip
_435.patients_demographics_snapshots	pds_zip
_435.patients_demographics_snapshots	pds_employer_zip
_435.patients_demographics_snapshots	pds_guarantor_zip
_435.patients_demographics_snapshots	pds_ins1_employer_zip
_435.patients_demographics_snapshots	pds_ins2_employer_zip
_435.patients_demographics_snapshots	pds_ins3_employer_zip
_435.physicians	phy_zip
_435.precerts	pre_zip
_435.precerts	pre_employer_zip
_435.precerts	pre_guarantor_zip
_435.precerts	pre_ins1_employer_zip
_435.precerts	pre_ins2_employer_zip
_435.radiology_orders	rad_zip
_435.radiology_orders	rad_ins1_employer_zip
_435.radiology_orders	rad_ins2_employer_zip
_436.billing_providers	bp_zip
_436.buildings	bld_zip
_436.charts	chrt_zip
_436.client_contacts	clicon_zip
_436.encounters	enc_zip
_436.encounters	enc_employer_zip
_436.encounters	enc_guarantor_zip
_436.encounters	enc_ins1_employer_zip
_436.encounters	enc_ins2_employer_zip
_436.encounters	enc_ins3_employer_zip
_436.hl7_lab_locations	hll_zip
_436.insurances	ins_zip
_436.insurances_claims_centers	icc_zip
_436.insurances_repository	irep_ins_employer_zip
_436.locations	loc_zip
_436.non_patients	npat_zip
_436.orders	ord_zip
_436.orders	ord_ins1_employer_zip
_436.orders	ord_ins2_employer_zip
_436.patient_next_of_kin	pnk_zip
_436.patients	pat_zip
_436.patients	pat_employer_zip
_436.patients	pat_guarantor_zip
_436.patients	pat_ins1_employer_zip
_436.patients	pat_ins2_employer_zip
_436.patients	pat_ins3_employer_zip
_436.patients	pat_emergency_zip
_436.patients_demographics_snapshots	pds_zip
_436.patients_demographics_snapshots	pds_employer_zip
_436.patients_demographics_snapshots	pds_guarantor_zip
_436.patients_demographics_snapshots	pds_ins1_employer_zip
_436.patients_demographics_snapshots	pds_ins2_employer_zip
_436.patients_demographics_snapshots	pds_ins3_employer_zip
_436.physicians	phy_zip
_436.precerts	pre_zip
_436.precerts	pre_employer_zip
_436.precerts	pre_guarantor_zip
_436.precerts	pre_ins1_employer_zip
_436.precerts	pre_ins2_employer_zip
_436.radiology_orders	rad_zip
_436.radiology_orders	rad_ins1_employer_zip
_436.radiology_orders	rad_ins2_employer_zip
_436_archive_testing.billing_providers	bp_zip
_436_archive_testing.buildings	bld_zip
_436_archive_testing.charts	chrt_zip
_436_archive_testing.client_contacts	clicon_zip
_436_archive_testing.encounters	enc_zip
_436_archive_testing.encounters	enc_employer_zip
_436_archive_testing.encounters	enc_guarantor_zip
_436_archive_testing.encounters	enc_ins1_employer_zip
_436_archive_testing.encounters	enc_ins2_employer_zip
_436_archive_testing.encounters	enc_ins3_employer_zip
_436_archive_testing.hl7_lab_locations	hll_zip
_436_archive_testing.insurances	ins_zip
_436_archive_testing.insurances_claims_centers	icc_zip
_436_archive_testing.insurances_repository	irep_ins_employer_zip
_436_archive_testing.locations	loc_zip
_436_archive_testing.non_patients	npat_zip
_436_archive_testing.orders	ord_zip
_436_archive_testing.orders	ord_ins1_employer_zip
_436_archive_testing.orders	ord_ins2_employer_zip
_436_archive_testing.patient_next_of_kin	pnk_zip
_436_archive_testing.patients	pat_zip
_436_archive_testing.patients	pat_employer_zip
_436_archive_testing.patients	pat_guarantor_zip
_436_archive_testing.patients	pat_ins1_employer_zip
_436_archive_testing.patients	pat_ins2_employer_zip
_436_archive_testing.patients	pat_ins3_employer_zip
_436_archive_testing.patients	pat_emergency_zip
_436_archive_testing.patients_demographics_snapshots	pds_zip
_436_archive_testing.patients_demographics_snapshots	pds_employer_zip
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_zip
_436_archive_testing.patients_demographics_snapshots	pds_ins1_employer_zip
_436_archive_testing.patients_demographics_snapshots	pds_ins2_employer_zip
_436_archive_testing.patients_demographics_snapshots	pds_ins3_employer_zip
_436_archive_testing.physicians	phy_zip
_436_archive_testing.precerts	pre_zip
_436_archive_testing.precerts	pre_employer_zip
_436_archive_testing.precerts	pre_guarantor_zip
_436_archive_testing.precerts	pre_ins1_employer_zip
_436_archive_testing.precerts	pre_ins2_employer_zip
_436_archive_testing.radiology_orders	rad_zip
_436_archive_testing.radiology_orders	rad_ins1_employer_zip
_436_archive_testing.radiology_orders	rad_ins2_employer_zip
_437.billing_providers	bp_zip
_437.buildings	bld_zip
_437.charts	chrt_zip
_437.client_contacts	clicon_zip
_437.encounters	enc_zip
_437.encounters	enc_employer_zip
_437.encounters	enc_guarantor_zip
_437.encounters	enc_ins1_employer_zip
_437.encounters	enc_ins2_employer_zip
_437.encounters	enc_ins3_employer_zip
_437.hl7_lab_locations	hll_zip
_437.insurances	ins_zip
_437.insurances_claims_centers	icc_zip
_437.insurances_repository	irep_ins_employer_zip
_437.locations	loc_zip
_437.non_patients	npat_zip
_437.orders	ord_zip
_437.orders	ord_ins1_employer_zip
_437.orders	ord_ins2_employer_zip
_437.patient_next_of_kin	pnk_zip
_437.patients	pat_zip
_437.patients	pat_employer_zip
_437.patients	pat_guarantor_zip
_437.patients	pat_ins1_employer_zip
_437.patients	pat_ins2_employer_zip
_437.patients	pat_ins3_employer_zip
_437.patients	pat_emergency_zip
_437.patients_demographics_snapshots	pds_zip
_437.patients_demographics_snapshots	pds_employer_zip
_437.patients_demographics_snapshots	pds_guarantor_zip
_437.patients_demographics_snapshots	pds_ins1_employer_zip
_437.patients_demographics_snapshots	pds_ins2_employer_zip
_437.patients_demographics_snapshots	pds_ins3_employer_zip
_437.physicians	phy_zip
_437.precerts	pre_zip
_437.precerts	pre_employer_zip
_437.precerts	pre_guarantor_zip
_437.precerts	pre_ins1_employer_zip
_437.precerts	pre_ins2_employer_zip
_437.radiology_orders	rad_zip
_437.radiology_orders	rad_ins1_employer_zip
_437.radiology_orders	rad_ins2_employer_zip
_8.billing_providers	bp_zip
_8.buildings	bld_zip
_8.charts	chrt_zip
_8.client_contacts	clicon_zip
_8.encounters	enc_zip
_8.encounters	enc_employer_zip
_8.encounters	enc_guarantor_zip
_8.encounters	enc_ins1_employer_zip
_8.encounters	enc_ins2_employer_zip
_8.encounters	enc_ins3_employer_zip
_8.hl7_lab_locations	hll_zip
_8.insurances	ins_zip
_8.insurances_claims_centers	icc_zip
_8.insurances_repository	irep_ins_employer_zip
_8.locations	loc_zip
_8.non_patients	npat_zip
_8.orders	ord_zip
_8.orders	ord_ins1_employer_zip
_8.orders	ord_ins2_employer_zip
_8.patient_next_of_kin	pnk_zip
_8.patients	pat_zip
_8.patients	pat_employer_zip
_8.patients	pat_guarantor_zip
_8.patients	pat_ins1_employer_zip
_8.patients	pat_ins2_employer_zip
_8.patients	pat_ins3_employer_zip
_8.patients	pat_emergency_zip
_8.patients_demographics_snapshots	pds_zip
_8.patients_demographics_snapshots	pds_employer_zip
_8.patients_demographics_snapshots	pds_guarantor_zip
_8.patients_demographics_snapshots	pds_ins1_employer_zip
_8.patients_demographics_snapshots	pds_ins2_employer_zip
_8.patients_demographics_snapshots	pds_ins3_employer_zip
_8.physicians	phy_zip
_8.precerts	pre_zip
_8.precerts	pre_employer_zip
_8.precerts	pre_guarantor_zip
_8.precerts	pre_ins1_employer_zip
_8.precerts	pre_ins2_employer_zip
_8.radiology_orders	rad_zip
_8.radiology_orders	rad_ins1_employer_zip
_8.radiology_orders	rad_ins2_employer_zip
_81.billing_providers	bp_zip
_81.buildings	bld_zip
_81.charts	chrt_zip
_81.client_contacts	clicon_zip
_81.encounters	enc_zip
_81.encounters	enc_employer_zip
_81.encounters	enc_guarantor_zip
_81.encounters	enc_ins1_employer_zip
_81.encounters	enc_ins2_employer_zip
_81.encounters	enc_ins3_employer_zip
_81.hl7_lab_locations	hll_zip
_81.insurances	ins_zip
_81.insurances_claims_centers	icc_zip
_81.insurances_repository	irep_ins_employer_zip
_81.locations	loc_zip
_81.non_patients	npat_zip
_81.orders	ord_zip
_81.orders	ord_ins1_employer_zip
_81.orders	ord_ins2_employer_zip
_81.patient_next_of_kin	pnk_zip
_81.patients	pat_zip
_81.patients	pat_employer_zip
_81.patients	pat_guarantor_zip
_81.patients	pat_ins1_employer_zip
_81.patients	pat_ins2_employer_zip
_81.patients	pat_ins3_employer_zip
_81.patients	pat_emergency_zip
_81.patients_demographics_snapshots	pds_zip
_81.patients_demographics_snapshots	pds_employer_zip
_81.patients_demographics_snapshots	pds_guarantor_zip
_81.patients_demographics_snapshots	pds_ins1_employer_zip
_81.patients_demographics_snapshots	pds_ins2_employer_zip
_81.patients_demographics_snapshots	pds_ins3_employer_zip
_81.physicians	phy_zip
_81.precerts	pre_zip
_81.precerts	pre_employer_zip
_81.precerts	pre_guarantor_zip
_81.precerts	pre_ins1_employer_zip
_81.precerts	pre_ins2_employer_zip
_81.radiology_orders	rad_zip
_81.radiology_orders	rad_ins1_employer_zip
_81.radiology_orders	rad_ins2_employer_zip
_999.billing_providers	bp_zip
_999.buildings	bld_zip
_999.charts	chrt_zip
_999.client_contacts	clicon_zip
_999.encounters	enc_zip
_999.encounters	enc_employer_zip
_999.encounters	enc_guarantor_zip
_999.encounters	enc_ins1_employer_zip
_999.encounters	enc_ins2_employer_zip
_999.encounters	enc_ins3_employer_zip
_999.hl7_lab_locations	hll_zip
_999.insurances	ins_zip
_999.insurances_claims_centers	icc_zip
_999.insurances_repository	irep_ins_employer_zip
_999.locations	loc_zip
_999.non_patients	npat_zip
_999.orders	ord_zip
_999.orders	ord_ins1_employer_zip
_999.orders	ord_ins2_employer_zip
_999.patient_next_of_kin	pnk_zip
_999.patients	pat_zip
_999.patients	pat_employer_zip
_999.patients	pat_guarantor_zip
_999.patients	pat_ins1_employer_zip
_999.patients	pat_ins2_employer_zip
_999.patients	pat_ins3_employer_zip
_999.patients	pat_emergency_zip
_999.patients_demographics_snapshots	pds_zip
_999.patients_demographics_snapshots	pds_employer_zip
_999.patients_demographics_snapshots	pds_guarantor_zip
_999.patients_demographics_snapshots	pds_ins1_employer_zip
_999.patients_demographics_snapshots	pds_ins2_employer_zip
_999.patients_demographics_snapshots	pds_ins3_employer_zip
_999.physicians	phy_zip
_999.precerts	pre_zip
_999.precerts	pre_employer_zip
_999.precerts	pre_guarantor_zip
_999.precerts	pre_ins1_employer_zip
_999.precerts	pre_ins2_employer_zip
_999.radiology_orders	rad_zip
_999.radiology_orders	rad_ins1_employer_zip
_999.radiology_orders	rad_ins2_employer_zip
aurora_standard.abmmpi	p_zip
aurora_standard.abmmpi	emp_zip
aurora_standard.abmmpi	i1_zip
aurora_standard.abmmpi	i2_zip
aurora_standard.abmmpi	i3_zip
aurora_standard.abmmpi	gu_zip
aurora_standard.abmmpi	gu_emp_zip
aurora_standard.abmmpi	n1_zip
aurora_standard.abmmpi	n2_zip
aurora_standard.abmvis	p_zip
aurora_standard.abmvis	gu_zip
aurora_standard.abmvis	i1_zip
aurora_standard.abmvis	i2_zip
aurora_standard.abmvis	i3_zip
aurora_standard.anmpi	p_zip
aurora_standard.apsmpi	p_zip
aurora_standard.aseympi	p_zip2
aurora_standard.bempi	p_zip
aurora_standard.bempi	p_zip2
aurora_standard.bhar	p_zip
aurora_standard.bhar	g_zip
aurora_standard.bhar	ge_zip
aurora_standard.bhar	co1_zip
aurora_standard.bhar	co2_zip
aurora_standard.bhar	co3_zip
aurora_standard.bhar	co4_zip
aurora_standard.bhar	co5_zip
aurora_standard.bhar	co6_zip
aurora_standard.bhar	em_zip
aurora_standard.bmmpi	p_zip
aurora_standard.bmmpi	gu_zip
aurora_standard.bmnkin	n_zip
aurora_standard.bmpact	p_zip
aurora_standard.bmpact	gu_zip
aurora_standard.bpar	p_zip
aurora_standard.bpar	g_zip
aurora_standard.bpar	ge_zip
aurora_standard.bpar	co1_zip
aurora_standard.bpar	co2_zip
aurora_standard.bpar	co3_zip
aurora_standard.bpar	co4_zip
aurora_standard.bpar	co5_zip
aurora_standard.bpar	co6_zip
aurora_standard.bpar	em_zip
aurora_standard.bpar2	p_zip
aurora_standard.bpar2	g_zip
aurora_standard.bpar2	ge_zip
aurora_standard.bpar2	co1_zip
aurora_standard.bpar2	co2_zip
aurora_standard.bpar2	co3_zip
aurora_standard.bpar2	co4_zip
aurora_standard.bpar2	co5_zip
aurora_standard.bpar2	co6_zip
aurora_standard.bpar2	em_zip
aurora_standard.bpmpi	p_zip
aurora_standard.bpmpi2	p_zip
aurora_standard.bs2mpi	contact1_zip
aurora_standard.bs2mpi	p_zip
aurora_standard.bsmpi	contact1_zip
aurora_standard.bsmpi	p_zip
aurora_standard.c7insur2	ins_zip
aurora_standard.c7insur3	ins_zip
aurora_standard.c7mpi	p_zip
aurora_standard.c7mpi	p2_zip
aurora_standard.c7mpi	insur_zip
aurora_standard.c7mpi	gu_zip
aurora_standard.c7mpi	gu2_zip
aurora_standard.c8mpi	p_zip
aurora_standard.c9mpi	p_zip
aurora_standard.c9mpi	nk_zip
aurora_standard.chlswbhd	fac_zip
aurora_standard.chlswbhd	agt_zip
aurora_standard.chlswbhd	sfw_zip
aurora_standard.chltrnhd	fac_zip
aurora_standard.chltrnhd	agt_zip
aurora_standard.chltrnhd	sfw_zip
aurora_standard.chmarcnbf	g_zip
aurora_standard.chmarcnbf	ins1_zip
aurora_standard.chmarcnbf	ins2_zip
aurora_standard.chmarsi	pat_zip
aurora_standard.chmarsi	gu_zip
aurora_standard.chmarsi	gu_emp_zip
aurora_standard.chmarsi	pat_emp_zip
aurora_standard.chmarsi	ins1_zip
aurora_standard.chmarsi	ins1_empl_zip
aurora_standard.chmarsi	ins2_zip
aurora_standard.chmarsi	insured_zip2
aurora_standard.chmarsi	ins2_empl_zip
aurora_standard.chmarsi	ins3_zip
aurora_standard.chmarsi	ins3_empl_zip
aurora_standard.chmarst	fac_zip
aurora_standard.chmarsti	fac_zip
aurora_standard.chmarstps	ins_zip
aurora_standard.chmarstps	emp_zip
aurora_standard.chmarstpt	ins_zip
aurora_standard.chmarstpt	emp_zip
aurora_standard.chmazstd	pat_zip
aurora_standard.chmazsti	pat_zip
aurora_standard.chmazsto	pat_zip
aurora_standard.chmbatex	pat_zip2
aurora_standard.chmcampi	pat_zip
aurora_standard.chmcampi	gu_zip
aurora_standard.chmcampi	gu_emp_zip
aurora_standard.chmcampi	pat_emp_zip
aurora_standard.chmcampi	ins1_zip
aurora_standard.chmcampi	ins1_empl_zip
aurora_standard.chmcampi	ins2_zip
aurora_standard.chmcampi	insured_zip2
aurora_standard.chmcampi	ins2_empl_zip
aurora_standard.chmcampi	ins3_zip
aurora_standard.chmcampi	ins3_empl_zip
aurora_standard.chmcmhed	debtor_zip
aurora_standard.chmcmhed	pat_zip
aurora_standard.chmexmpi	pat_zip
aurora_standard.chmexmpi	gu_zip
aurora_standard.chmexmpi	gu_emp_zip
aurora_standard.chmexmpi	pat_emp_zip
aurora_standard.chmexmpi	ins1_zip
aurora_standard.chmexmpi	ins1_empl_zip
aurora_standard.chmexmpi	ins2_zip
aurora_standard.chmexmpi	insured_zip2
aurora_standard.chmexmpi	ins2_empl_zip
aurora_standard.chmexmpi	ins3_zip
aurora_standard.chmexmpi	ins3_empl_zip
aurora_standard.chmexvis	ins1_zip
aurora_standard.chmexvis	ins2_zip
aurora_standard.chmexvis	insured_zip2
aurora_standard.chmexvis	ins3_zip
aurora_standard.chmhistp	p_zip
aurora_standard.chmibend	send_claims_zip2
aurora_standard.chmlastr	pat_zip
aurora_standard.chmlastr	pat_empl_zip
aurora_standard.chmmbc37	plan_carrier_zip
aurora_standard.chmmrhdr	upd_zip
aurora_standard.chmnvstb	prov_zip
aurora_standard.chmnvstb	payto_zip
aurora_standard.chmnvstr	prov_zip
aurora_standard.chmnvstr	payto_zip
aurora_standard.chmokipd	pat_zip
aurora_standard.chmokopd	pat_zip
aurora_standard.chmozpcd	debtor_zip
aurora_standard.chmpdemo	p_zip
aurora_standard.chmpdemo	p_emp_zip
aurora_standard.chmpdemo	sp_zip
aurora_standard.chmpdemo	gu_zip
aurora_standard.chmpdemo	gu_emp_zip
aurora_standard.chmpdemo	ins1_zip
aurora_standard.chmpdemo	ins1_empl_zip
aurora_standard.chmpdemo	ins2_zip
aurora_standard.chmpdemo	insured_zip2
aurora_standard.chmpdemo	ins2_empl_zip
aurora_standard.chmpdemo	ins3_zip
aurora_standard.chmpdemo	ins3_empl_zip
aurora_standard.chmradex	pat_zip
aurora_standard.chmradex	pat_emp_zip
aurora_standard.chmradex	gu_zip
aurora_standard.chmradex	gu_emp_zip
aurora_standard.chmradex	ins1_zip
aurora_standard.chmradex	ins1_empl_zip
aurora_standard.chmradex	ins2_zip
aurora_standard.chmradex	insured_zip2
aurora_standard.chmradex	ins2_empl_zip
aurora_standard.chmradex	ins3_zip
aurora_standard.chmradex	ins3_empl_zip
aurora_standard.chmtxstr	pat_zip
aurora_standard.chmtxstr	pat_empl_zip
aurora_standard.chmub04r	f_09_zip2
aurora_standard.chmub04r	l_38_4_zip2
aurora_standard.chmub92r	l_13_zip2
aurora_standard.chmub92r	l_38_4_zip2
aurora_standard.chmub92r	l_66_a_zip2
aurora_standard.chmub92r	l_66_b_zip2
aurora_standard.chmub92r	l_66_c_zip2
aurora_standard.chmutah4	pat_zip
aurora_standard.chpdeped	depend_zip
aurora_standard.stp1099c	company_zip
aurora_standard.stp1099c	vend_zip
aurora_standard.stprepsd	rep_zip
aurora_standard.stpvendr	agent_zip
aurora_standard.styoctcc	employer_zip
aurora_standard.styoctcc	gov_entity_zip
aurora_standard.styoempr	empl_zip
aurora_standard.tmpub04r	f_09_zip2
aurora_standard.tmpub04r	l_38_4_zip2
common.applicants	app_zip
common.applicants	app_employer_1_zip
common.applicants	app_employer_2_zip
common.applicants	app_employer_3_zip
common.applicants	app_employer_4_zip
common.clients	cli_zip
common.clients	cli_billing_zip
common.clients	cli_mailing_zip
common.clients_contract_data	ccd_payer_zip
common.contacts	con_zip
common.customers	cus_zip
common.customers	cus_billing_zip
common.lab_interfaces	lif_cli_zip
common.lab_interfaces_performing_sites	lips_zip
common.labs	lab_zip
common.leads	lea_zip
rcmroi.dev__sf_users	addr_zip
rcmroi.prod__sf_users	addr_zip
rcmroi.test__sf_users	addr_zip

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

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

race

Table	Column
_1.charts	chrt_race
_1.encounters	enc_race
_1.orders_afps	oafp_race
_1.patients	pat_race
_1.precerts	pre_race
_1188.charts	chrt_race
_1188.encounters	enc_race
_1188.orders_afps	oafp_race
_1188.patients	pat_race
_1188.precerts	pre_race
_1218.charts	chrt_race
_1218.encounters	enc_race
_1218.orders_afps	oafp_race
_1218.patients	pat_race
_1218.precerts	pre_race
_1548.charts	chrt_race
_1548.encounters	enc_race
_1548.orders_afps	oafp_race
_1548.patients	pat_race
_1548.precerts	pre_race
_435.charts	chrt_race
_435.encounters	enc_race
_435.orders_afps	oafp_race
_435.patients	pat_race
_435.precerts	pre_race
_436.charts	chrt_race
_436.encounters	enc_race
_436.orders_afps	oafp_race
_436.patients	pat_race
_436.precerts	pre_race
_436_archive_testing.charts	chrt_race
_436_archive_testing.encounters	enc_race
_436_archive_testing.orders_afps	oafp_race
_436_archive_testing.patients	pat_race
_436_archive_testing.precerts	pre_race
_437.charts	chrt_race
_437.encounters	enc_race
_437.orders_afps	oafp_race
_437.patients	pat_race
_437.precerts	pre_race
_8.charts	chrt_race
_8.encounters	enc_race
_8.orders_afps	oafp_race
_8.patients	pat_race
_8.precerts	pre_race
_81.charts	chrt_race
_81.encounters	enc_race
_81.orders_afps	oafp_race
_81.patients	pat_race
_81.precerts	pre_race
_999.charts	chrt_race
_999.encounters	enc_race
_999.orders_afps	oafp_race
_999.patients	pat_race
_999.precerts	pre_race
aurora_standard.bhar	p_race
aurora_standard.bhar	g_race
aurora_standard.bhguar	g_race
aurora_standard.bhtguar	g_race
aurora_standard.bpar	p_race
aurora_standard.bpar	g_race
aurora_standard.bpar2	p_race
aurora_standard.bpar2	g_race
aurora_standard.bpmpi	p_race
aurora_standard.bpmpi2	p_race
aurora_standard.chmazstd	pat_race
aurora_standard.chmazsti	pat_race
aurora_standard.chmazsto	pat_race
aurora_standard.chmhistp	p_race
aurora_standard.chmlastr	pat_race
aurora_standard.chmmhast	pat_race
aurora_standard.chmokipd	pat_race
aurora_standard.chmokopd	pat_race
aurora_standard.chmtxstr	pat_race
aurora_standard.hl7gt1	guar_race
aurora_standard.tmpmrrpt	sex_race

Table	Column
aurora_standard.abmmpi	p_st
aurora_standard.abmmpi	emp_st
aurora_standard.abmmpi	i1_st
aurora_standard.abmmpi	i2_st
aurora_standard.abmmpi	i3_st
aurora_standard.abmmpi	gu_st
aurora_standard.abmmpi	gu_emp_st
aurora_standard.abmmpi	n1_st
aurora_standard.abmmpi	n2_st
aurora_standard.abmvis	p_st
aurora_standard.abmvis	gu_st
aurora_standard.abmvis	i1_st
aurora_standard.abmvis	i2_st
aurora_standard.abmvis	i3_st
aurora_standard.addinsrc	city_st
aurora_standard.anmpi	p_st
aurora_standard.apsmpi	p_st
aurora_standard.aseympi	p_st
aurora_standard.bdallvis	acc_st
aurora_standard.bdmpi	nk_st
aurora_standard.bdmpi	pat_st
aurora_standard.bdvis	acc_st
aurora_standard.bempi	p_st
aurora_standard.bfhos	gu_st
aurora_standard.bfpasr	gu_st
aurora_standard.bfphync	city_st_zip
aurora_standard.bfrhc	gu_st
aurora_standard.bhar	p_st
aurora_standard.bhar	g_st
aurora_standard.bhar	ge_st
aurora_standard.bhar	co1_st
aurora_standard.bhar	co2_st
aurora_standard.bhar	co3_st
aurora_standard.bhar	co4_st
aurora_standard.bhar	co5_st
aurora_standard.bhar	co6_st
aurora_standard.bhar	em_st
aurora_standard.bmmpi	p_st
aurora_standard.bmmpi	gu_st
aurora_standard.bmnkin	n_st
aurora_standard.bmpact	p_st
aurora_standard.bmpact	gu_st
aurora_standard.bpar	p_st
aurora_standard.bpar	g_st
aurora_standard.bpar	ge_st
aurora_standard.bpar	co1_st
aurora_standard.bpar	co2_st
aurora_standard.bpar	co3_st
aurora_standard.bpar	co4_st
aurora_standard.bpar	co5_st
aurora_standard.bpar	co6_st
aurora_standard.bpar	em_st
aurora_standard.bpar2	p_st
aurora_standard.bpar2	g_st
aurora_standard.bpar2	ge_st
aurora_standard.bpar2	co1_st
aurora_standard.bpar2	co2_st
aurora_standard.bpar2	co3_st
aurora_standard.bpar2	co4_st
aurora_standard.bpar2	co5_st
aurora_standard.bpar2	co6_st
aurora_standard.bpar2	em_st
aurora_standard.bpmpi	p_st
aurora_standard.bpmpi2	p_st
aurora_standard.bs2mpi	contact1_st
aurora_standard.bs2mpi	p_st
aurora_standard.bsmpi	contact1_st
aurora_standard.bsmpi	p_st
aurora_standard.bvmpi	work_st
aurora_standard.bvmpi2	work_st
aurora_standard.c7insur2	ins_st
aurora_standard.c7insur3	ins_st
aurora_standard.c7mpi	p_st
aurora_standard.c7mpi	p2_st
aurora_standard.c7mpi	insur_st
aurora_standard.c7mpi	gu_st
aurora_standard.c7mpi	gu2_st
aurora_standard.c7vis	acc_st
aurora_standard.c8mpi	p_st
aurora_standard.cavis	acc_st
aurora_standard.cavish	acc_st
aurora_standard.chlswbhd	fac_st
aurora_standard.chlswbhd	agt_st
aurora_standard.chlswbhd	sfw_st
aurora_standard.chltrnhd	fac_st
aurora_standard.chltrnhd	agt_st
aurora_standard.chltrnhd	sfw_st
aurora_standard.chmadmtr	accident_st
aurora_standard.chmarcnbf	ins1_st
aurora_standard.chmarcnbf	ins2_st
aurora_standard.chmarsi	pat_st
aurora_standard.chmarsi	gu_st
aurora_standard.chmarsi	gu_emp_st
aurora_standard.chmarsi	pat_emp_st
aurora_standard.chmarsi	ins1_st
aurora_standard.chmarsi	ins1_empl_st
aurora_standard.chmarsi	ins2_st
aurora_standard.chmarsi	ins2_empl_st
aurora_standard.chmarsi	ins3_st
aurora_standard.chmarsi	ins3_empl_st
aurora_standard.chmazstd	pat_st
aurora_standard.chmazstd	accident_st
aurora_standard.chmazsti	pat_st
aurora_standard.chmazsti	accident_st
aurora_standard.chmazsto	pat_st
aurora_standard.chmazsto	accident_st
aurora_standard.chmbatex	pat_st
aurora_standard.chmcampi	pat_st
aurora_standard.chmcampi	gu_st
aurora_standard.chmcampi	gu_emp_st
aurora_standard.chmcampi	pat_emp_st
aurora_standard.chmcampi	ins1_st
aurora_standard.chmcampi	ins1_empl_st
aurora_standard.chmcampi	ins2_st
aurora_standard.chmcampi	ins2_empl_st
aurora_standard.chmcampi	ins3_st
aurora_standard.chmcampi	ins3_empl_st
aurora_standard.chmcosta	accident_st
aurora_standard.chmexmpi	pat_st
aurora_standard.chmexmpi	gu_st
aurora_standard.chmexmpi	gu_emp_st
aurora_standard.chmexmpi	pat_emp_st
aurora_standard.chmexmpi	ins1_st
aurora_standard.chmexmpi	ins1_empl_st
aurora_standard.chmexmpi	ins2_st
aurora_standard.chmexmpi	ins2_empl_st
aurora_standard.chmexmpi	ins3_st
aurora_standard.chmexmpi	ins3_empl_st
aurora_standard.chmexvis	ins1_st
aurora_standard.chmexvis	ins2_st
aurora_standard.chmexvis	ins3_st
aurora_standard.chmhid4a	accident_st
aurora_standard.chmhistp	p_st
aurora_standard.chmibend	send_claims_st
aurora_standard.chmlastr	pat_st
aurora_standard.chmnvstb	prov_st
aurora_standard.chmnvstb	payto_st
aurora_standard.chmnvstb	acc_st
aurora_standard.chmnvstr	prov_st
aurora_standard.chmnvstr	payto_st
aurora_standard.chmnvstr	acc_st
aurora_standard.chmokipd	pat_st
aurora_standard.chmokopd	pat_st
aurora_standard.chmpatwc	school_st
aurora_standard.chmpdemo	p_st
aurora_standard.chmpdemo	p_emp_st
aurora_standard.chmpdemo	sp_st
aurora_standard.chmpdemo	gu_st
aurora_standard.chmpdemo	gu_emp_st
aurora_standard.chmpdemo	ins1_st
aurora_standard.chmpdemo	ins1_empl_st
aurora_standard.chmpdemo	ins2_st
aurora_standard.chmpdemo	ins2_empl_st
aurora_standard.chmpdemo	ins3_st
aurora_standard.chmpdemo	ins3_empl_st
aurora_standard.chmradex	pat_st
aurora_standard.chmradex	pat_emp_st
aurora_standard.chmradex	gu_st
aurora_standard.chmradex	gu_emp_st
aurora_standard.chmradex	ins1_st
aurora_standard.chmradex	ins1_empl_st
aurora_standard.chmradex	ins2_st
aurora_standard.chmradex	ins2_empl_st
aurora_standard.chmradex	ins3_st
aurora_standard.chmradex	ins3_empl_st
aurora_standard.chmtxstr	pat_st
aurora_standard.chmub04r	f_09_st
aurora_standard.chmub04r	f_29_acc_st
aurora_standard.kcvis	acc_st
aurora_standard.kcvisit	acc_st
aurora_standard.stxratid	investments_st
aurora_standard.tmpub04r	f_09_st
aurora_standard.tmpub04r	f_29_acc_st

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

add1

Table	Column
aurora_standard.bdmpi	sp_add1
aurora_standard.bdmpi	nk_add1
aurora_standard.bdmpi	pat_add1
aurora_standard.bhar	p_add1
aurora_standard.bhar	g_add1
aurora_standard.bhar	ge_add1
aurora_standard.bhar	co1_add1
aurora_standard.bhar	co2_add1
aurora_standard.bhar	co3_add1
aurora_standard.bhar	co4_add1
aurora_standard.bhar	co5_add1
aurora_standard.bhar	co6_add1
aurora_standard.bmmpi	p_add1
aurora_standard.bmmpi	gu_add1
aurora_standard.bmnkin	n_add1
aurora_standard.bmpact	p_add1
aurora_standard.bmpact	gu_add1
aurora_standard.bpar	p_add1
aurora_standard.bpar	g_add1
aurora_standard.bpar	ge_add1
aurora_standard.bpar	co1_add1
aurora_standard.bpar	co2_add1
aurora_standard.bpar	co3_add1
aurora_standard.bpar	co4_add1
aurora_standard.bpar	co5_add1
aurora_standard.bpar	co6_add1
aurora_standard.bpar2	p_add1
aurora_standard.bpar2	g_add1
aurora_standard.bpar2	ge_add1
aurora_standard.bpar2	co1_add1
aurora_standard.bpar2	co2_add1
aurora_standard.bpar2	co3_add1
aurora_standard.bpar2	co4_add1
aurora_standard.bpar2	co5_add1
aurora_standard.bpar2	co6_add1
aurora_standard.bpmpi	p_add1
aurora_standard.bpmpi2	p_add1
aurora_standard.bs2mpi	contact1_add1
aurora_standard.bsinsur	spouse_add1
aurora_standard.bsinsur	nextkin_add1
aurora_standard.bsinsur	patient_add1
aurora_standard.bsmpi	contact1_add1
aurora_standard.c7mpi	p_add1
aurora_standard.c7mpi	p2_add1
aurora_standard.c7mpi	insur_add1
aurora_standard.c7mpi	gu_add1
aurora_standard.c7mpi	gu2_add1
aurora_standard.c8mpi	p_add1
aurora_standard.campi	spouse_add1
aurora_standard.campi	nextkin_add1
aurora_standard.campi	patient_add1
aurora_standard.chhl7adt	patient_add1
aurora_standard.chmarsi	pat_add1
aurora_standard.chmarsi	insured_add1
aurora_standard.chmbatex	pat_add1
aurora_standard.chmcampi	pat_add1
aurora_standard.chmcampi	insured_add1
aurora_standard.chmexmpi	pat_add1
aurora_standard.chmexmpi	insured_add1
aurora_standard.chmexvis	insured_add1
aurora_standard.chmhistp	p_add1
aurora_standard.chmlastr	pat_add1
aurora_standard.chmp340b	patient_add1
aurora_standard.chmpatir	subscri_add1
aurora_standard.chmpatmr	spouse_add1
aurora_standard.chmpatmr	nextkin_add1
aurora_standard.chmpatmr	patient_add1
aurora_standard.chmpdemo	p_add1
aurora_standard.chmpdemo	sp_add1
aurora_standard.chmpdemo	insured_add1
aurora_standard.chmpress	patient_add1
aurora_standard.chmradex	pat_add1
aurora_standard.chmradex	insured_add1
aurora_standard.chmtxstr	pat_add1
aurora_standard.chmub04r	f_09_add1
aurora_standard.chmub92r	l_13_add1
aurora_standard.chmub92r	l_66_a_add1
aurora_standard.chmub92r	l_66_b_add1
aurora_standard.chmub92r	l_66_c_add1
aurora_standard.nbspouse	spouse_add1
aurora_standard.stprepsd	rep_add1
aurora_standard.styoctcc	employer_add1
aurora_standard.styoempr	empl_add1
aurora_standard.tmpub04r	f_09_add1

add2

Table	Column
aurora_standard.bdmpi	sp_add2
aurora_standard.bdmpi	nk_add2
aurora_standard.bdmpi	pat_add2
aurora_standard.bhar	p_add2
aurora_standard.bhar	g_add2
aurora_standard.bhar	ge_add2
aurora_standard.bhar	co1_add2
aurora_standard.bhar	co2_add2
aurora_standard.bhar	co3_add2
aurora_standard.bhar	co4_add2
aurora_standard.bhar	co5_add2
aurora_standard.bhar	co6_add2
aurora_standard.bpar	p_add2
aurora_standard.bpar	g_add2
aurora_standard.bpar	ge_add2
aurora_standard.bpar	co1_add2
aurora_standard.bpar	co2_add2
aurora_standard.bpar	co3_add2
aurora_standard.bpar	co4_add2
aurora_standard.bpar	co5_add2
aurora_standard.bpar	co6_add2
aurora_standard.bpar2	p_add2
aurora_standard.bpar2	g_add2
aurora_standard.bpar2	ge_add2
aurora_standard.bpar2	co1_add2
aurora_standard.bpar2	co2_add2
aurora_standard.bpar2	co3_add2
aurora_standard.bpar2	co4_add2
aurora_standard.bpar2	co5_add2
aurora_standard.bpar2	co6_add2
aurora_standard.bpmpi	p_add2
aurora_standard.bpmpi2	p_add2
aurora_standard.bs2mpi	contact1_add2
aurora_standard.bsinsur	spouse_add2
aurora_standard.bsinsur	nextkin_add2
aurora_standard.bsinsur	patient_add2
aurora_standard.bsmpi	contact1_add2
aurora_standard.c7mpi	p_add2
aurora_standard.c7mpi	p2_add2
aurora_standard.c7mpi	insur_add2
aurora_standard.c7mpi	gu_add2
aurora_standard.c7mpi	gu2_add2
aurora_standard.c8mpi	p_add2
aurora_standard.campi	spouse_add2
aurora_standard.campi	nextkin_add2
aurora_standard.campi	patient_add2
aurora_standard.chhl7adt	patient_add2
aurora_standard.chmarsi	pat_add2
aurora_standard.chmarsi	insured_add2
aurora_standard.chmbatex	pat_add2
aurora_standard.chmcampi	pat_add2
aurora_standard.chmcampi	insured_add2
aurora_standard.chmexmpi	pat_add2
aurora_standard.chmexmpi	insured_add2
aurora_standard.chmexvis	insured_add2
aurora_standard.chmhistp	p_add2
aurora_standard.chmlastr	pat_add2
aurora_standard.chmp340b	patient_add2
aurora_standard.chmpatmr	spouse_add2
aurora_standard.chmpatmr	nextkin_add2
aurora_standard.chmpatmr	patient_add2
aurora_standard.chmpdemo	p_add2
aurora_standard.chmpdemo	sp_add2
aurora_standard.chmpdemo	insured_add2
aurora_standard.chmradex	pat_add2
aurora_standard.chmradex	insured_add2
aurora_standard.chmtxstr	pat_add2
aurora_standard.chmub04r	f_09_add2
aurora_standard.chmub92r	l_13_add2
aurora_standard.chmub92r	l_66_a_add2
aurora_standard.chmub92r	l_66_b_add2
aurora_standard.chmub92r	l_66_c_add2
aurora_standard.nbspouse	spouse_add2
aurora_standard.stprepsd	rep_add2
aurora_standard.tmpub04r	f_09_add2

county

Table	Column
aurora_standard.bdmpi	pat_county
aurora_standard.bhar	p_county
aurora_standard.bhar	g_county
aurora_standard.bhguar	p_county
aurora_standard.bhtguar	p_county
aurora_standard.bpar	p_county
aurora_standard.bpar	g_county
aurora_standard.bpar2	p_county
aurora_standard.bpar2	g_county
aurora_standard.bpmpi	p_county
aurora_standard.bpmpi2	p_county
aurora_standard.bsinsur	patient_county
aurora_standard.c9mpi	p_county
aurora_standard.cains	patient_county
aurora_standard.campi	patient_county
aurora_standard.chmarsi	pat_county
aurora_standard.chmcampi	pat_county
aurora_standard.chmexmpi	pat_county
aurora_standard.chmhistp	p_county
aurora_standard.chmmrhdr	upd_county
aurora_standard.chmpatmr	patient_county
aurora_standard.chmpdemo	p_county
aurora_standard.chmpress	patient_county
aurora_standard.chmradex	pat_county

mr_no

Table	Column
aurora_standard.bsinsur	snf_mr_no
aurora_standard.bsinsur	prev_mr_no
aurora_standard.chhcntrc	auto_snf_mr_no
aurora_standard.chhcntrc	auto_mr_no
aurora_standard.chmarbex	pat_mr_no
aurora_standard.chmarsi	pat_mr_no
aurora_standard.chmbatex	pat_mr_no
aurora_standard.chmcampi	pat_mr_no
aurora_standard.chmcntrc	auto_snf_mr_no
aurora_standard.chmcntrc	auto_mr_no
aurora_standard.chmexmpi	pat_mr_no
aurora_standard.chmhstmr	pat_mr_no
aurora_standard.chmhstrm	pat_mr_no
aurora_standard.chmlastr	mother_mr_no
aurora_standard.chmmhast	co_mr_no
aurora_standard.chmmrhdr	upd_mr_no
aurora_standard.chmnrcex	pat_mr_no
aurora_standard.chmokipd	pat_mr_no
aurora_standard.chmokopd	pat_mr_no
aurora_standard.chmpatmr	snf_mr_no
aurora_standard.chmpatmr	prev_mr_no
aurora_standard.chmraded	pat_mr_no
aurora_standard.chmradex	pat_mr_no
aurora_standard.chmreqsr	ofc_mr_no
aurora_standard.ncexmpi	pat_mr_no

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

retire_date

Table	Column
aurora_standard.chmmcqud	sp_retire_date