aurora_standard.bpmr2

Field	Type	Null	Default	Key
mrno	char(9)	YES
acct_no	int(11)	NO	0	PRI
lname	char(35)	YES
fname	char(35)	YES
p_ssn	char(9)	YES
p_dob	char(8)	YES
p_sex	char(1)	YES
pat_type	char(1)	YES
adm_dt	char(6)	YES
dis_dt	char(6)	YES
adm_phy	char(5)	YES
att_phy	char(5)	YES
ref_phy	char(5)	YES
con1_phy	char(5)	YES
con2_phy	char(5)	YES
con3_phy	char(5)	YES
con4_phy	char(5)	YES
con5_phy	char(5)	YES
drg	char(5)	YES
adm_dx	char(8)	YES
adm_dx_oth	char(232)	YES
pro01	char(8)	YES
pdt01	char(6)	YES
pmd01	char(5)	YES
pro02	char(8)	YES
pdt02	char(6)	YES
pmd02	char(5)	YES
pro03	char(8)	YES
pdt03	char(6)	YES
pmd03	char(5)	YES
pro04	char(8)	YES
pdt04	char(6)	YES
pmd04	char(5)	YES
pro05	char(8)	YES
pdt05	char(6)	YES
pmd05	char(5)	YES
pro06	char(8)	YES
pdt06	char(6)	YES
pmd06	char(5)	YES
pro07	char(8)	YES
pdt07	char(6)	YES
pmd07	char(5)	YES
pro08	char(8)	YES
pdt08	char(6)	YES
pmd08	char(5)	YES
pro09	char(8)	YES
pdt09	char(6)	YES
pmd09	char(5)	YES
pro10	char(8)	YES
pdt10	char(6)	YES
pmd10	char(5)	YES
pro11	char(8)	YES
pdt11	char(6)	YES
pmd11	char(5)	YES
pro12	char(8)	YES
pdt12	char(6)	YES
pmd12	char(5)	YES
pro13	char(8)	YES
pdt13	char(6)	YES
pmd13	char(5)	YES
pro14	char(8)	YES
pdt14	char(6)	YES
pmd14	char(5)	YES
pro15	char(8)	YES
pdt15	char(6)	YES
pmd15	char(5)	YES
pro16	char(8)	YES
pdt16	char(6)	YES
pmd16	char(5)	YES
pro17	char(8)	YES
pdt17	char(6)	YES
pmd17	char(5)	YES
pro18	char(8)	YES
pdt18	char(6)	YES
pmd18	char(5)	YES
pro19	char(8)	YES
pdt19	char(6)	YES
pmd19	char(5)	YES
pro20	char(8)	YES
pdt20	char(6)	YES
pmd20	char(5)	YES
pro21	char(8)	YES
pdt21	char(6)	YES
pmd21	char(5)	YES
pro22	char(8)	YES
pdt22	char(6)	YES
pmd22	char(5)	YES
pro23	char(8)	YES
pdt23	char(6)	YES
pmd23	char(5)	YES
pro24	char(8)	YES
pdt24	char(6)	YES
pmd24	char(5)	YES
pro25	char(8)	YES
pdt25	char(6)	YES
pmd25	char(5)	YES
pro26	char(8)	YES
pdt26	char(6)	YES
pmd26	char(5)	YES
pro27	char(8)	YES
pdt27	char(6)	YES
pmd27	char(5)	YES
pro28	char(8)	YES
pdt28	char(6)	YES
pmd28	char(5)	YES
pro29	char(8)	YES
pdt29	char(6)	YES
pmd29	char(5)	YES
pro30	char(8)	YES
pdt30	char(6)	YES
pmd30	char(5)	YES
dx01	char(8)	YES
dx02	char(8)	YES
dx03	char(8)	YES
dx04	char(8)	YES
dx05	char(8)	YES
dx06	char(8)	YES
dx07	char(8)	YES
dx08	char(8)	YES
dx09	char(8)	YES
dx10	char(8)	YES
dx11	char(8)	YES
dx12	char(8)	YES
dx13	char(8)	YES
dx14	char(8)	YES
dx15	char(8)	YES
dx16	char(8)	YES
dx17	char(8)	YES
dx18	char(8)	YES
dx19	char(8)	YES
dx20	char(8)	YES
dx21	char(8)	YES
dx22	char(8)	YES
dx23	char(8)	YES
dx24	char(8)	YES
dx25	char(8)	YES
dx26	char(8)	YES
dx27	char(8)	YES
dx28	char(8)	YES
dx29	char(8)	YES
dx30	char(8)	YES
occur1	char(2)	YES
occdt1	char(6)	YES
occur2	char(2)	YES
occdt2	char(6)	YES
occur3	char(2)	YES
occdt3	char(6)	YES
occur4	char(2)	YES
occdt4	char(6)	YES
occur5	char(2)	YES
occdt5	char(6)	YES
cpt01	char(8)	YES
mod01	char(10)	YES
cptmd01	char(5)	YES
cptdt01	char(6)	YES
cpt02	char(8)	YES
mod02	char(10)	YES
cptmd02	char(5)	YES
cptdt02	char(6)	YES
cpt03	char(8)	YES
mod03	char(10)	YES
cptmd03	char(5)	YES
cptdt03	char(6)	YES
cpt04	char(8)	YES
mod04	char(10)	YES
cptmd04	char(5)	YES
cptdt04	char(6)	YES
cpt05	char(8)	YES
mod05	char(10)	YES
cptmd05	char(5)	YES
cptdt05	char(6)	YES
cpt06	char(8)	YES
mod06	char(10)	YES
cptmd06	char(5)	YES
cptdt06	char(6)	YES
cpt07	char(8)	YES
mod07	char(10)	YES
cptmd07	char(5)	YES
cptdt07	char(6)	YES
cpt08	char(8)	YES
mod08	char(10)	YES
cptmd08	char(5)	YES
cptdt08	char(6)	YES
cpt09	char(8)	YES
mod09	char(10)	YES
cptmd09	char(5)	YES
cptdt09	char(6)	YES
cpt10	char(8)	YES
mod10	char(10)	YES
cptmd10	char(5)	YES
cptdt10	char(6)	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

dx10

Table	Column
_1.encounters_cpt_codes	ecp_dx10
_1188.encounters_cpt_codes	ecp_dx10
_1218.encounters_cpt_codes	ecp_dx10
_1548.encounters_cpt_codes	ecp_dx10
_435.encounters_cpt_codes	ecp_dx10
_436.encounters_cpt_codes	ecp_dx10
_436_archive_testing.encounters_cpt_codes	ecp_dx10
_437.encounters_cpt_codes	ecp_dx10
_8.encounters_cpt_codes	ecp_dx10
_81.encounters_cpt_codes	ecp_dx10
_999.encounters_cpt_codes	ecp_dx10
aurora_standard.chmmhast	other_dx10
aurora_standard.chmmhast	poa_dx10

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

drg

Table	Column
aurora_standard.abshl7d	i9_drg
aurora_standard.chmabstr	est_drg
aurora_standard.chmabstr	actual_drg
aurora_standard.chmclaim	fin_drg
aurora_standard.chmclaim	ms_drg
aurora_standard.chmcosta	ms_drg
aurora_standard.chmhidia	est_drg
aurora_standard.chmpresg	ms_drg
aurora_standard.chmpresg2	ms_drg
aurora_standard.chmvtotd	est_drg
aurora_standard.drg_work	w_drg
aurora_standard.logdetld	est_drg
aurora_standard.ohocpt	cpt_drg
aurora_standard.workdesc	w_drg

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

dx11

Table	Column
aurora_standard.chmmhast	other_dx11
aurora_standard.chmmhast	poa_dx11

dx12

Table	Column
aurora_standard.chmmhast	other_dx12
aurora_standard.chmmhast	poa_dx12

dx13

Table	Column
aurora_standard.chmmhast	other_dx13
aurora_standard.chmmhast	poa_dx13

dx14

Table	Column
aurora_standard.chmmhast	other_dx14
aurora_standard.chmmhast	poa_dx14

dx15

Table	Column
aurora_standard.chmmhast	other_dx15
aurora_standard.chmmhast	poa_dx15

dx16

Table	Column
aurora_standard.chmmhast	other_dx16
aurora_standard.chmmhast	poa_dx16

dx17

Table	Column
aurora_standard.chmmhast	other_dx17
aurora_standard.chmmhast	poa_dx17

dx18

Table	Column
aurora_standard.chmmhast	other_dx18
aurora_standard.chmmhast	poa_dx18

dx19

Table	Column
aurora_standard.chmmhast	other_dx19
aurora_standard.chmmhast	poa_dx19

dx20

Table	Column
aurora_standard.chmmhast	other_dx20
aurora_standard.chmmhast	poa_dx20

dx21

Table	Column
aurora_standard.chmmhast	other_dx21
aurora_standard.chmmhast	poa_dx21

dx22

Table	Column
aurora_standard.chmmhast	other_dx22
aurora_standard.chmmhast	poa_dx22

dx23

Table	Column
aurora_standard.chmmhast	other_dx23
aurora_standard.chmmhast	poa_dx23

dx24

Table	Column
aurora_standard.chmmhast	other_dx24
aurora_standard.chmmhast	poa_dx24

dx25

Table	Column
aurora_standard.chmmhast	other_dx25
aurora_standard.chmmhast	poa_dx25

dx26

Table	Column
aurora_standard.chmmhast	other_dx26
aurora_standard.chmmhast	poa_dx26

dx27

Table	Column
aurora_standard.chmmhast	other_dx27
aurora_standard.chmmhast	poa_dx27

dx28

Table	Column
aurora_standard.chmmhast	other_dx28
aurora_standard.chmmhast	poa_dx28

dx29

Table	Column
aurora_standard.chmmhast	other_dx29
aurora_standard.chmmhast	poa_dx29

att_phy

Table	Column
aurora_standard.chmmhast	co_att_phy