aurora_standard.chmhcahp

Field	Type	Null
fname	char(42)	YES
middle	char(1)	YES
lname	char(42)	YES
suffix	char(42)	YES
addr	char(60)	YES
addr2	char(42)	YES
city	char(42)	YES
state	char(2)	YES
zip5	char(5)	YES
area_code	char(3)	YES
phone	char(10)	YES
mrn	char(42)	YES
dob	char(10)	YES
sex	char(1)	YES
langid	char(2)	YES
race	char(10)	YES
ethnicity	char(42)	YES
marital	char(10)	YES
email	char(50)	YES
visittype	char(3)	YES
facilityname	char(42)	YES
facilitynpi	char(10)	YES
facilitynum	char(42)	YES
visit_no	char(42)	YES
adm_dt	char(10)	YES
dis_dt	char(10)	YES
admitsource	char(10)	YES
dis_status	char(10)	YES
dis_unit	char(42)	YES
dis_unitname	char(42)	YES
msdrg	char(10)	YES
icd9	char(10)	YES
icd9_2	char(10)	YES
icd9_3	char(10)	YES
deceased	char(1)	YES
icu	char(1)	YES
ed_admit	char(1)	YES
plannumber	char(42)	YES
planname	char(42)	YES
clinicname	char(42)	YES
clinic_npi	char(10)	YES
clinic_num	char(42)	YES
dr_fname	char(42)	YES
dr_lname	char(42)	YES
dr_title	char(42)	YES
dr_npi	char(10)	YES
dr_spec	char(42)	YES
dr_id	char(42)	YES
pcpid	char(1)	YES
cpt	char(42)	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.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.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

phone

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

city

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

state

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

Table	Column
AzaleaStats.login_events	loge_entered_email
Messaging.messages_contacts	mc_email
_1.charts	chrt_email
_1.client_contacts	clicon_email
_1.encounters	enc_email
_1.non_patients	npat_email
_1.patients	pat_email
_1.patients	pat_email_no_email
_1.patients_demographics_snapshots	pds_email
_1.patients_demographics_snapshots	pds_email_no_email
_1.physicians	phy_email
_1.precerts	pre_email
_1188.charts	chrt_email
_1188.client_contacts	clicon_email
_1188.encounters	enc_email
_1188.non_patients	npat_email
_1188.patients	pat_email
_1188.patients	pat_email_no_email
_1188.patients_demographics_snapshots	pds_email
_1188.patients_demographics_snapshots	pds_email_no_email
_1188.physicians	phy_email
_1188.precerts	pre_email
_1218.charts	chrt_email
_1218.client_contacts	clicon_email
_1218.encounters	enc_email
_1218.non_patients	npat_email
_1218.patients	pat_email
_1218.patients	pat_email_no_email
_1218.patients_demographics_snapshots	pds_email
_1218.patients_demographics_snapshots	pds_email_no_email
_1218.physicians	phy_email
_1218.precerts	pre_email
_1548.charts	chrt_email
_1548.client_contacts	clicon_email
_1548.encounters	enc_email
_1548.non_patients	npat_email
_1548.patients	pat_email
_1548.patients	pat_email_no_email
_1548.patients_demographics_snapshots	pds_email
_1548.patients_demographics_snapshots	pds_email_no_email
_1548.physicians	phy_email
_1548.precerts	pre_email
_435.charts	chrt_email
_435.client_contacts	clicon_email
_435.encounters	enc_email
_435.non_patients	npat_email
_435.patients	pat_email
_435.patients	pat_email_no_email
_435.patients_demographics_snapshots	pds_email
_435.patients_demographics_snapshots	pds_email_no_email
_435.physicians	phy_email
_435.precerts	pre_email
_436.charts	chrt_email
_436.client_contacts	clicon_email
_436.encounters	enc_email
_436.non_patients	npat_email
_436.patients	pat_email
_436.patients	pat_email_no_email
_436.patients_demographics_snapshots	pds_email
_436.patients_demographics_snapshots	pds_email_no_email
_436.physicians	phy_email
_436.precerts	pre_email
_436_archive_testing.charts	chrt_email
_436_archive_testing.client_contacts	clicon_email
_436_archive_testing.encounters	enc_email
_436_archive_testing.non_patients	npat_email
_436_archive_testing.patients	pat_email
_436_archive_testing.patients	pat_email_no_email
_436_archive_testing.patients_demographics_snapshots	pds_email
_436_archive_testing.patients_demographics_snapshots	pds_email_no_email
_436_archive_testing.physicians	phy_email
_436_archive_testing.precerts	pre_email
_437.charts	chrt_email
_437.client_contacts	clicon_email
_437.encounters	enc_email
_437.non_patients	npat_email
_437.patients	pat_email
_437.patients	pat_email_no_email
_437.patients_demographics_snapshots	pds_email
_437.patients_demographics_snapshots	pds_email_no_email
_437.physicians	phy_email
_437.precerts	pre_email
_8.charts	chrt_email
_8.client_contacts	clicon_email
_8.encounters	enc_email
_8.non_patients	npat_email
_8.patients	pat_email
_8.patients	pat_email_no_email
_8.patients_demographics_snapshots	pds_email
_8.patients_demographics_snapshots	pds_email_no_email
_8.physicians	phy_email
_8.precerts	pre_email
_81.charts	chrt_email
_81.client_contacts	clicon_email
_81.encounters	enc_email
_81.non_patients	npat_email
_81.patients	pat_email
_81.patients	pat_email_no_email
_81.patients_demographics_snapshots	pds_email
_81.patients_demographics_snapshots	pds_email_no_email
_81.physicians	phy_email
_81.precerts	pre_email
_999.charts	chrt_email
_999.client_contacts	clicon_email
_999.encounters	enc_email
_999.non_patients	npat_email
_999.patients	pat_email
_999.patients	pat_email_no_email
_999.patients_demographics_snapshots	pds_email
_999.patients_demographics_snapshots	pds_email_no_email
_999.physicians	phy_email
_999.precerts	pre_email
ahiWiki.ipblocks	ipb_block_email
ahiWiki.user	user_email
aurora_standard.chmhl7ic	company_email
aurora_standard.chmhstmr	pat_email
aurora_standard.stp1099c	contact_email
aurora_standard.stp1099c	vend_email
aurora_standard.stprepsd	rep_email
aurora_standard.stpvendr	ap_email
aurora_standard.stpvendr	agent_email
aurora_standard.styuimmr	cont_email
aurora_standard.styw2mm1	cont_email
common.applicants	app_email
common.applicants	app_employer_1_supervisor_email
common.applicants	app_employer_2_supervisor_email
common.applicants	app_employer_3_supervisor_email
common.applicants	app_employer_4_supervisor_email
common.clients	cli_email
common.clients_contract_data	ccd_payer_email
common.contact_imports	ci_email
common.contacts	con_email
common.customers	cus_email
common.dashboardmd_users	dmdu_email
common.leads	lea_email
common.login_blocks	lb_email
common.login_events	loge_entered_email
common.sessions	session_email
common.telehealth_codes	thc_invite_email
common.users	usr_email
sessions.sessions	session_email

deceased

Table	Column
HSPI_Bastrop.patient_abstracts	is_deceased
HSPI_Bastrop.patients	is_deceased
HSPI_CURES2015_B1.patient_abstracts	is_deceased
HSPI_CURES2015_B1.patients	is_deceased
HSPI_Central_Hospital.patient_abstracts	is_deceased
HSPI_Central_Hospital.patients	is_deceased
HSPI_Dewitt.patient_abstracts	is_deceased
HSPI_Dewitt.patients	is_deceased
HSPI_Fulton.patient_abstracts	is_deceased
HSPI_Fulton.patients	is_deceased
HSPI_Inferno.patient_abstracts	is_deceased
HSPI_Inferno.patients	is_deceased
HSPI_MU2015_E1.patient_abstracts	is_deceased
HSPI_MU2015_E1.patients	is_deceased
HSPI_MU2015_G2.patient_abstracts	is_deceased
HSPI_MU2015_G2.patients	is_deceased
HSPI_MU2015_G9.patient_abstracts	is_deceased
HSPI_MU2015_G9.patients	is_deceased
HSPI_Ness.patients	is_deceased
HSPI_Sandbox.patient_abstracts	is_deceased
HSPI_Sandbox.patients	is_deceased
HSPI_Summit_General.patient_abstracts	is_deceased
HSPI_Summit_General.patients	is_deceased
HSPI_United_Physicians.patient_abstracts	is_deceased
HSPI_United_Physicians.patients	is_deceased
MPI.patient_abstracts	is_deceased
MPI.patients	is_deceased

sex

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

suffix

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

mrn

Table	Column
_1.charts	chrt_mrn
_1.cpoe_responses	cpoe_res_mrn
_1.encounters	enc_mrn
_1.hl7_accessions	acc_mrn
_1.orders	ord_mrn
_1.patients	pat_mrn
_1.patients_demographics_snapshots	pds_mrn
_1.precerts	pre_mrn
_1.radiology_orders	rad_mrn
_1.radiology_results	rad_res_mrn
_1188.charts	chrt_mrn
_1188.cpoe_responses	cpoe_res_mrn
_1188.encounters	enc_mrn
_1188.hl7_accessions	acc_mrn
_1188.orders	ord_mrn
_1188.patients	pat_mrn
_1188.patients_demographics_snapshots	pds_mrn
_1188.precerts	pre_mrn
_1188.radiology_orders	rad_mrn
_1188.radiology_results	rad_res_mrn
_1218.charts	chrt_mrn
_1218.cpoe_responses	cpoe_res_mrn
_1218.encounters	enc_mrn
_1218.hl7_accessions	acc_mrn
_1218.orders	ord_mrn
_1218.patients	pat_mrn
_1218.patients_demographics_snapshots	pds_mrn
_1218.precerts	pre_mrn
_1218.radiology_orders	rad_mrn
_1218.radiology_results	rad_res_mrn
_1548.charts	chrt_mrn
_1548.cpoe_responses	cpoe_res_mrn
_1548.encounters	enc_mrn
_1548.hl7_accessions	acc_mrn
_1548.orders	ord_mrn
_1548.patients	pat_mrn
_1548.patients_demographics_snapshots	pds_mrn
_1548.precerts	pre_mrn
_1548.radiology_orders	rad_mrn
_1548.radiology_results	rad_res_mrn
_435.charts	chrt_mrn
_435.cpoe_responses	cpoe_res_mrn
_435.encounters	enc_mrn
_435.hl7_accessions	acc_mrn
_435.orders	ord_mrn
_435.patients	pat_mrn
_435.patients_demographics_snapshots	pds_mrn
_435.precerts	pre_mrn
_435.radiology_orders	rad_mrn
_435.radiology_results	rad_res_mrn
_436.charts	chrt_mrn
_436.cpoe_responses	cpoe_res_mrn
_436.encounters	enc_mrn
_436.hl7_accessions	acc_mrn
_436.orders	ord_mrn
_436.patients	pat_mrn
_436.patients_demographics_snapshots	pds_mrn
_436.precerts	pre_mrn
_436.radiology_orders	rad_mrn
_436.radiology_results	rad_res_mrn
_436_archive_testing.charts	chrt_mrn
_436_archive_testing.cpoe_responses	cpoe_res_mrn
_436_archive_testing.encounters	enc_mrn
_436_archive_testing.hl7_accessions	acc_mrn
_436_archive_testing.orders	ord_mrn
_436_archive_testing.patients	pat_mrn
_436_archive_testing.patients_demographics_snapshots	pds_mrn
_436_archive_testing.precerts	pre_mrn
_436_archive_testing.radiology_orders	rad_mrn
_436_archive_testing.radiology_results	rad_res_mrn
_437.charts	chrt_mrn
_437.cpoe_responses	cpoe_res_mrn
_437.encounters	enc_mrn
_437.hl7_accessions	acc_mrn
_437.orders	ord_mrn
_437.patients	pat_mrn
_437.patients_demographics_snapshots	pds_mrn
_437.precerts	pre_mrn
_437.radiology_orders	rad_mrn
_437.radiology_results	rad_res_mrn
_8.charts	chrt_mrn
_8.cpoe_responses	cpoe_res_mrn
_8.encounters	enc_mrn
_8.hl7_accessions	acc_mrn
_8.orders	ord_mrn
_8.patients	pat_mrn
_8.patients_demographics_snapshots	pds_mrn
_8.precerts	pre_mrn
_8.radiology_orders	rad_mrn
_8.radiology_results	rad_res_mrn
_81.charts	chrt_mrn
_81.cpoe_responses	cpoe_res_mrn
_81.encounters	enc_mrn
_81.hl7_accessions	acc_mrn
_81.orders	ord_mrn
_81.patients	pat_mrn
_81.patients_demographics_snapshots	pds_mrn
_81.precerts	pre_mrn
_81.radiology_orders	rad_mrn
_81.radiology_results	rad_res_mrn
_999.charts	chrt_mrn
_999.cpoe_responses	cpoe_res_mrn
_999.encounters	enc_mrn
_999.hl7_accessions	acc_mrn
_999.orders	ord_mrn
_999.patients	pat_mrn
_999.patients_demographics_snapshots	pds_mrn
_999.precerts	pre_mrn
_999.radiology_orders	rad_mrn
_999.radiology_results	rad_res_mrn

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

ethnicity

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

cpt

Table	Column
_1.orders_test_codes_map	otcm_cpt
_1188.orders_test_codes_map	otcm_cpt
_1218.orders_test_codes_map	otcm_cpt
_1548.orders_test_codes_map	otcm_cpt
_435.orders_test_codes_map	otcm_cpt
_436.orders_test_codes_map	otcm_cpt
_436_archive_testing.orders_test_codes_map	otcm_cpt
_437.orders_test_codes_map	otcm_cpt
_8.orders_test_codes_map	otcm_cpt
_81.orders_test_codes_map	otcm_cpt
_999.orders_test_codes_map	otcm_cpt
aurora_standard.apscdm	mc_cpt
aurora_standard.apscdm	md_cpt
aurora_standard.apscdm	ci_cpt
aurora_standard.apscdm	wc_cpt
aurora_standard.apscdma	mc_cpt
aurora_standard.apscdma	md_cpt
aurora_standard.apscdma	ci_cpt
aurora_standard.apscdma	wc_cpt
aurora_standard.bfcdm	md_cpt
aurora_standard.bfrhccdm	md_cpt
aurora_standard.chmokopd	prin_cpt
aurora_standard.chmsubcc	start_cpt
aurora_standard.chmsubcc	end_cpt
aurora_standard.samcdmc	mc_cpt
aurora_standard.samcdmc	md_cpt
aurora_standard.workcpt	wk_cpt
common.test_codes	tco_cpt

addr

Table	Column
aurora_standard.abmmpi	p_addr2
aurora_standard.abmmpi	i1_addr
aurora_standard.abmmpi	i2_addr
aurora_standard.abmmpi	i3_addr
aurora_standard.abmmpi	gu_addr2
aurora_standard.abmmpi	gu_emp_addr
aurora_standard.abmmpi	n1_addr2
aurora_standard.abmmpi	n2_addr2
aurora_standard.abmvis	p_addr2
aurora_standard.abmvis	gu_addr2
aurora_standard.abmvis	i1_addr
aurora_standard.abmvis	i2_addr
aurora_standard.abmvis	i3_addr
aurora_standard.anmpi	p_addr2
aurora_standard.apsmpi	p_addr2
aurora_standard.aseympi	p_addr2
aurora_standard.bempi	p_addr2
aurora_standard.bfhos	gu_addr
aurora_standard.bfpasr	gu_addr
aurora_standard.bfrhc	gu_addr
aurora_standard.bhar	em_addr
aurora_standard.bpar	em_addr
aurora_standard.bpar2	em_addr
aurora_standard.bs2mpi	sp_addr
aurora_standard.bs2mpi	p_addr2
aurora_standard.bsmpi	sp_addr
aurora_standard.bsmpi	p_addr2
aurora_standard.c7insur2	ins_addr
aurora_standard.c7insur3	ins_addr
aurora_standard.c9mpi	p_addr2
aurora_standard.c9mpi	nk_addr
aurora_standard.chhl7in1	ins_comp_addr
aurora_standard.chhl7in1	ins_addr2
aurora_standard.chhl7in1	ins_empl_addr2
aurora_standard.chmarcnbf	g_addr2
aurora_standard.chmarsi	gu_addr2
aurora_standard.chmarsi	gu_emp_addr2
aurora_standard.chmarsi	pat_emp_addr2
aurora_standard.chmarsi	ins1_addr2
aurora_standard.chmarsi	ins1_empl_addr
aurora_standard.chmarsi	ins2_addr2
aurora_standard.chmarsi	ins2_empl_addr
aurora_standard.chmarsi	ins3_addr2
aurora_standard.chmarsi	ins3_empl_addr
aurora_standard.chmarstps	ins_addr2
aurora_standard.chmarstps	emp_addr
aurora_standard.chmarstpt	ins_addr2
aurora_standard.chmarstpt	emp_addr
aurora_standard.chmazstd	pat_addr
aurora_standard.chmazsti	pat_addr
aurora_standard.chmazsto	pat_addr
aurora_standard.chmcampi	gu_addr2
aurora_standard.chmcampi	gu_emp_addr2
aurora_standard.chmcampi	pat_emp_addr2
aurora_standard.chmcampi	ins1_addr2
aurora_standard.chmcampi	ins1_empl_addr
aurora_standard.chmcampi	ins2_addr2
aurora_standard.chmcampi	ins2_empl_addr
aurora_standard.chmcampi	ins3_addr2
aurora_standard.chmcampi	ins3_empl_addr
aurora_standard.chmcmhed	debtor_addr
aurora_standard.chmcmhed	empl_addr
aurora_standard.chmcmhed	pat_addr
aurora_standard.chmexmpi	gu_addr2
aurora_standard.chmexmpi	gu_emp_addr2
aurora_standard.chmexmpi	pat_emp_addr2
aurora_standard.chmexmpi	ins1_addr2
aurora_standard.chmexmpi	ins1_empl_addr
aurora_standard.chmexmpi	ins2_addr2
aurora_standard.chmexmpi	ins2_empl_addr
aurora_standard.chmexmpi	ins3_addr2
aurora_standard.chmexmpi	ins3_empl_addr
aurora_standard.chmexvis	ins1_addr2
aurora_standard.chmexvis	ins2_addr2
aurora_standard.chmexvis	ins3_addr2
aurora_standard.chmguarr	bad_addr
aurora_standard.chmmbc37	plan_carrier_addr
aurora_standard.chmmcqud	emp_addr
aurora_standard.chmmcqud	sp_emp_addr
aurora_standard.chmnvstb	prov_addr
aurora_standard.chmnvstb	payto_addr
aurora_standard.chmnvstr	prov_addr
aurora_standard.chmnvstr	payto_addr
aurora_standard.chmokipd	pat_addr
aurora_standard.chmokopd	pat_addr
aurora_standard.chmozpcd	debtor_addr
aurora_standard.chmozpcd	empl_addr
aurora_standard.chmozpcd	bank_addr
aurora_standard.chmpdemo	p_emp_addr2
aurora_standard.chmpdemo	gu_addr2
aurora_standard.chmpdemo	gu_emp_addr2
aurora_standard.chmpdemo	ins1_addr2
aurora_standard.chmpdemo	ins1_empl_addr
aurora_standard.chmpdemo	ins2_addr2
aurora_standard.chmpdemo	ins2_empl_addr
aurora_standard.chmpdemo	ins3_addr2
aurora_standard.chmpdemo	ins3_empl_addr
aurora_standard.chmquesd	wc_addr2
aurora_standard.chmquesd	hmo_addr2
aurora_standard.chmquesd	auto_addr2
aurora_standard.chmquesd	other_addr2
aurora_standard.chmquesd	eghp3_addr2
aurora_standard.chmquesd	eghp4_addr2
aurora_standard.chmquesd	eghp5_addr2
aurora_standard.chmradex	pat_emp_addr2
aurora_standard.chmradex	gu_addr2
aurora_standard.chmradex	gu_emp_addr2
aurora_standard.chmradex	ins1_addr2
aurora_standard.chmradex	ins1_empl_addr
aurora_standard.chmradex	ins2_addr2
aurora_standard.chmradex	ins2_empl_addr
aurora_standard.chmradex	ins3_addr2
aurora_standard.chmradex	ins3_empl_addr
aurora_standard.chmutah	pat_addr
aurora_standard.chmutah1	pat_addr
aurora_standard.chmutah4	pat_addr
aurora_standard.chpdeped	depend_addr2
aurora_standard.hl7gt1	guar_addr
aurora_standard.hl7gt1	guar_empl_addr
aurora_standard.hl7gt1ad	guar_addr
aurora_standard.hl7gt1ad	guar_empl_addr
aurora_standard.hl7in1	ins_comp_addr
aurora_standard.hl7in1	ins_addr
aurora_standard.hl7in1	ins_empl_addr
aurora_standard.hl7in1ad	ins_comp_addr
aurora_standard.hl7in1ad	ins_addr
aurora_standard.hl7in1ad	ins_empl_addr
aurora_standard.hl7pid	pat_addr
aurora_standard.hl7pidad	pat_addr
aurora_standard.ohompi	emerg_addr
aurora_standard.stp1099c	company_addr
aurora_standard.stp1099c	vend_addr
aurora_standard.stpvendr	agent_addr2
common.sessions	session_ip_addr
sessions.sessions	session_ip_addr

adm_dt

Table	Column
aurora_standard.acampi	last_adm_dt
aurora_standard.bhppat	last_adm_dt
aurora_standard.bhtppat	last_adm_dt

visit_no

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

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

icd9

Table	Column
aurora_standard.chmmhast	prin_icd9
common.clients	cli_ext_icd9

middle

Table	Column
aurora_standard.chxhistr	h_middle
aurora_standard.chyhistr	h_middle

area_code

Table	Column
aurora_standard.stywthre	phone_area_code
aurora_standard.stywthre	fax_area_code