aurora_standard.chmhistp

Field	Type	Null	Key	Extra
fac_no	char(3)	NO
mrno	char(9)	YES
acct_no	int(11)	YES
lname	char(35)	YES
fname	char(35)	YES
mname	char(35)	YES
p_add1	char(40)	YES
p_add2	char(40)	YES
p_city	char(28)	YES
p_st	char(2)	YES
p_zip	char(10)	YES
p_county	char(2)	YES
p_phone	char(10)	YES
p_ssn	char(9)	YES
p_dob	date	YES
p_sex	char(1)	YES
p_race	char(1)	YES
p_ms	char(1)	YES
adm_dt	date	YES
dis_dt	date	YES
att_phy	char(5)	YES
pat_type	char(1)	YES
reg_type	char(1)	YES
purge_dt	date	YES
tot_chrgs	decimal(10,2)	YES
tot_pmts	decimal(10,2)	YES
tot_adjs	decimal(10,2)	YES
bd_bal	decimal(10,2)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

fname

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

lname

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

mname

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

mrno

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

adm_dt

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

acct_no

Table	Column
aurora_standard.chmcashd	non_pat_acct_no
aurora_standard.chmnbcgd	non_pat_acct_no
aurora_standard.chmnbpyd	non_pat_acct_no
aurora_standard.chmnchgd	non_pat_acct_no
aurora_standard.chmnpatr	non_pat_acct_no
aurora_standard.chmnpayd	non_pat_acct_no
aurora_standard.chmrefnd	contr_acct_no
aurora_standard.chpcashr	cash_acct_no
aurora_standard.chpcobpd	cash_acct_no
aurora_standard.chpcobpd	bal_acct_no
aurora_standard.chrcntrc	rx_inv_acct_no
aurora_standard.chrcntrc	rx_exp_acct_no
aurora_standard.curs_temp	cash_acct_no
aurora_standard.np_statm	non_pat_acct_no
aurora_standard.sticntrc	inv_acct_no
aurora_standard.sticntrc	sales_acct_no
aurora_standard.sticntrc	cog_acct_no
aurora_standard.sticntrc	adj_acct_no
aurora_standard.sticntrc	count_acct_no
aurora_standard.sticntrc	hold_acct_no
aurora_standard.stiinvtr	inv_acct_no
aurora_standard.stiinvtr	cog_acct_no
aurora_standard.stiinvtr	sales_acct_no
aurora_standard.stiinvtr	supp_acct_no
aurora_standard.stitrand	exp_acct_no
aurora_standard.stiwhser	inv_acct_no
aurora_standard.stpcntrc	ap_acct_no
aurora_standard.stpcntrc	cd_cash_acct_no
aurora_standard.stpcntrc	cd_disc_acct_no
aurora_standard.stpinvce	disc_acct_no
aurora_standard.stpinvce	ap_acct_no
aurora_standard.stpinvce	cash_acct_no
aurora_standard.stpopend	ap_acct_no
aurora_standard.stpopend	cash_acct_no
aurora_standard.stpvendr	cash_acct_no
aurora_standard.stpvendr	exp_acct_no
aurora_standard.stpvendr	hosp_acct_no
aurora_standard.strcntrc	ar_acct_no
aurora_standard.strcntrc	ar_sales_acct_no
aurora_standard.strcntrc	ar_tax_acct_no
aurora_standard.strcntrc	ar_frght_acct_no
aurora_standard.strcntrc	ar_misc_acct_no
aurora_standard.strcntrc	ar_fc_acct_no
aurora_standard.strcntrc	cr_cash_acct_no
aurora_standard.strcntrc	cr_disc_acct_no
aurora_standard.strinvce	disc_acct_no
aurora_standard.strinvce	tax_acct_no
aurora_standard.strinvce	frght_acct_no
aurora_standard.strinvce	misc_acct_no
aurora_standard.strinvce	ar_acct_no
aurora_standard.stropend	ar_acct_no
aurora_standard.stucntrc	ap_acct_no
aurora_standard.stucntrc	disc_acct_no
aurora_standard.stucntrc	frght_acct_no
aurora_standard.stucntrc	misc_acct_no
aurora_standard.stucntrc	inv_acct_no
aurora_standard.stucntrc	adj_acct_no
aurora_standard.stucntrc	prepaid_acct_no
aurora_standard.stucntrc	supp_acct_no
aurora_standard.stucntrc	cap_acct_no
aurora_standard.stucntrc	non_acct_no
aurora_standard.stucntrc	diff_acct_no
aurora_standard.stucntrc	cash_acct_no
aurora_standard.stucntrc	ret_acct_no
aurora_standard.stucntrc	ret_fee_acct_no
aurora_standard.stuinvcd	gl_acct_no
aurora_standard.stultypr	gl_acct_no
aurora_standard.stuordrd	gl_acct_no
aurora_standard.stxcurrr	ex_diff_acct_no
aurora_standard.stxfinsd	fin_acct_no
aurora_standard.stxinfor	src_acct_no
aurora_standard.stxmtaxr	ar_acct_no
aurora_standard.stxmtaxr	ar_disc_acct_no
aurora_standard.stxmtaxr	ap_acct_no
aurora_standard.stxmtaxr	ap_disc_acct_no
aurora_standard.stycntrc	co_bank_acct_no
aurora_standard.styddepd	bank_acct_no
aurora_standard.styemplr	bank_acct_no
aurora_standard.styempod	bal_acct_no
aurora_standard.stypayod	bal_acct_no
aurora_standard.stypayre	cash_acct_no
aurora_standard.stypddrd	bank_acct_no
aurora_standard.styrevsd	cash_acct_no
aurora_standard.stytypod	bal_acct_no
aurora_standard.styuimmr	ui_acct_no
aurora_standard.ttiinvtr	inv_acct_no
aurora_standard.ttiinvtr	cog_acct_no
aurora_standard.ttiinvtr	sales_acct_no
aurora_standard.ttiinvtr	supp_acct_no
aurora_standard.wkactvv	inv_acct_no

att_phy

Table	Column
aurora_standard.chmmhast	co_att_phy

fac_no

Table	Column
aurora_standard.chmprica	prev_fac_no
aurora_standard.chmprica	cur_fac_no
aurora_standard.chpcashr	cash_fac_no
aurora_standard.chpcobpd	cash_fac_no
aurora_standard.chpcobpd	bal_fac_no
aurora_standard.chscustd	dept_fac_no
aurora_standard.chshotlr	dept_fac_no
aurora_standard.chtemplr	dflt_fac_no
aurora_standard.curs_temp	cash_fac_no
aurora_standard.curs_temp	ap_fac_no
aurora_standard.stgrowpd	rod_beg_fac_no
aurora_standard.stgrowpd	rod_end_fac_no
aurora_standard.stpcashd	dist_fac_no
aurora_standard.stpcashd	disc_fac_no
aurora_standard.stpcashe	cash_fac_no
aurora_standard.stpcntrc	cash_fac_no
aurora_standard.stpcntrc	disc_fac_no
aurora_standard.stpinvce	cash_fac_no
aurora_standard.stpopend	ap_fac_no
aurora_standard.stpopend	cash_fac_no
aurora_standard.stucntrc	cash_fac_no
aurora_standard.stuinvce	cash_fac_no
aurora_standard.stxfinsd	fin_fac_no
aurora_standard.styaccrr	liab_fac_no
aurora_standard.styaccrr	expense_fac_no
aurora_standard.styemplr	cash_fac_no
aurora_standard.stypayfd	cash_fac_no
aurora_standard.stypayod	bal_fac_no
aurora_standard.stypayre	cash_fac_no
aurora_standard.styrevsd	cash_fac_no
aurora_standard.stytyper	cash_fac_no