aurora_standard.c8name

Field	Type	Null
mpino	char(20)	YES
fullnm	char(40)	YES
fname	char(35)	YES
lname	char(20)	YES
mname	char(35)	YES
suffix	char(20)	YES
oth_nm	char(20)	YES

References

Local Column

References

fname

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

lname

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

mname

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

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

fullnm

Table	Column
aurora_standard.bmmpi	gu_fullnm
aurora_standard.bmpact	gu_fullnm