aurora_standard.chmnrcex

Field	Type	Null
facilityname	char(40)	YES
facilitynum	char(10)	YES
facilitynpi	char(10)	YES
fname	char(20)	YES
middleinit	char(1)	YES
lname	char(30)	YES
suffix	char(10)	YES
pat_sex	char(1)	YES
pat_dob	char(8)	YES
addr	char(20)	YES
addr2	char(20)	YES
city	char(20)	YES
state	char(2)	YES
zip5	char(5)	YES
phone	char(10)	YES
visittype	char(3)	YES
msdrg	char(6)	YES
pri_dx	char(10)	YES
sec_dx	char(10)	YES
ter_dx	char(10)	YES
dis_status	char(2)	YES
admitsource	char(15)	YES
adm_dt	char(8)	YES
dis_dt	char(8)	YES
service_indicator	char(8)	YES
pat_mr_no	char(10)	YES
visit_no	char(8)	YES
language	char(10)	YES
plannumber	char(6)	YES
drnpi	char(10)	YES
race	char(10)	YES
marital	char(1)	YES
icd10_1	char(10)	YES
icd10_2	char(10)	YES
icd10_3	char(10)	YES

References

Local Column

References

fname

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

lname

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

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

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

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

pat_sex

Table	Column
_1.clinical_alerts	ca_pat_sex
_1.clinical_interventions	ci_pat_sex
_1188.clinical_alerts	ca_pat_sex
_1188.clinical_interventions	ci_pat_sex
_1218.clinical_alerts	ca_pat_sex
_1218.clinical_interventions	ci_pat_sex
_1548.clinical_alerts	ca_pat_sex
_1548.clinical_interventions	ci_pat_sex
_435.clinical_alerts	ca_pat_sex
_435.clinical_interventions	ci_pat_sex
_436.clinical_alerts	ca_pat_sex
_436.clinical_interventions	ci_pat_sex
_436_archive_testing.clinical_alerts	ca_pat_sex
_436_archive_testing.clinical_interventions	ci_pat_sex
_437.clinical_alerts	ca_pat_sex
_437.clinical_interventions	ci_pat_sex
_8.clinical_alerts	ca_pat_sex
_8.clinical_interventions	ci_pat_sex
_81.clinical_alerts	ca_pat_sex
_81.clinical_interventions	ci_pat_sex
_999.clinical_alerts	ca_pat_sex
_999.clinical_interventions	ci_pat_sex

language

Table	Column
_1.clinical_interventions	ci_language
_1188.clinical_interventions	ci_language
_1218.clinical_interventions	ci_language
_1548.clinical_interventions	ci_language
_435.clinical_interventions	ci_language
_436.clinical_interventions	ci_language
_436_archive_testing.clinical_interventions	ci_language
_437.clinical_interventions	ci_language
_8.clinical_interventions	ci_language
_81.clinical_interventions	ci_language
_999.clinical_interventions	ci_language
ahiWiki.sites	site_language
aurora_standard.bdmpi	prim_language
aurora_standard.bsinsur	prim_language
aurora_standard.campi	prim_language
aurora_standard.chmpatmr	prim_language
aurora_standard.hl7pid	prim_language
aurora_standard.hl7pidad	prim_language

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