aurora_standard.chmexdtl

Field	Type	Null
visit_no	int(11)	YES
pay_adj	char(1)	YES
tr_type	char(3)	YES
dept	char(3)	YES
proc_code	char(10)	YES
rev_code	char(4)	YES
cpt_code	char(10)	YES
order_no	char(1)	YES
tr_date	date	YES
proc_date	date	YES
units	decimal(16,2)	YES
amt	decimal(16,2)	YES
ins_co	smallint(6)	YES
gl_dr	char(1)	YES
gl_cr	char(1)	YES
bill_date	date	YES
claim_type	char(1)	YES
chg_type	char(1)	YES
location	char(3)	YES
ins_co2	smallint(6)	YES
amt_denied	decimal(16,2)	YES
deductible	decimal(16,2)	YES
co_ins	decimal(16,2)	YES
lab_amt	decimal(16,2)	YES
bill_from	date	YES
bill_to	date	YES
cd_desc	char(1)	YES
other_ins	char(1)	YES
non_cov_amt	decimal(16,2)	YES
mr_no	char(20)	YES
service_date	date	YES
invoice_no	smallint(6)	YES
phy_no	smallint(6)	YES

References

Local Column

References

cpt_code

Table	Column
Loinc.loinc_codes	lc_cpt_code
_1.clients_fee_schedules_map	cfsm_cpt_code
_1.clinical_interventions_test_codes_map	citcm_cpt_code
_1.immunizations_cpt_map	icm_cpt_code
_1.insurances_allowables_cpt_map	iacm_cpt_code
_1.insurances_contracted_pricing	icp_cpt_code
_1.insurances_contracted_pricing_log	icpl_cpt_code
_1.patients_responsibility_estimates_services	prests_cpt_code
_1188.clients_fee_schedules_map	cfsm_cpt_code
_1188.clinical_interventions_test_codes_map	citcm_cpt_code
_1188.immunizations_cpt_map	icm_cpt_code
_1188.insurances_allowables_cpt_map	iacm_cpt_code
_1188.insurances_contracted_pricing	icp_cpt_code
_1188.insurances_contracted_pricing_log	icpl_cpt_code
_1188.patients_responsibility_estimates_services	prests_cpt_code
_1218.clients_fee_schedules_map	cfsm_cpt_code
_1218.clinical_interventions_test_codes_map	citcm_cpt_code
_1218.immunizations_cpt_map	icm_cpt_code
_1218.insurances_allowables_cpt_map	iacm_cpt_code
_1218.insurances_contracted_pricing	icp_cpt_code
_1218.insurances_contracted_pricing_log	icpl_cpt_code
_1218.patients_responsibility_estimates_services	prests_cpt_code
_1548.clients_fee_schedules_map	cfsm_cpt_code
_1548.clinical_interventions_test_codes_map	citcm_cpt_code
_1548.immunizations_cpt_map	icm_cpt_code
_1548.insurances_allowables_cpt_map	iacm_cpt_code
_1548.insurances_contracted_pricing	icp_cpt_code
_1548.insurances_contracted_pricing_log	icpl_cpt_code
_1548.patients_responsibility_estimates_services	prests_cpt_code
_435.clients_fee_schedules_map	cfsm_cpt_code
_435.clinical_interventions_test_codes_map	citcm_cpt_code
_435.immunizations_cpt_map	icm_cpt_code
_435.insurances_allowables_cpt_map	iacm_cpt_code
_435.insurances_contracted_pricing	icp_cpt_code
_435.insurances_contracted_pricing_log	icpl_cpt_code
_435.patients_responsibility_estimates_services	prests_cpt_code
_436.clients_fee_schedules_map	cfsm_cpt_code
_436.clinical_interventions_test_codes_map	citcm_cpt_code
_436.immunizations_cpt_map	icm_cpt_code
_436.insurances_allowables_cpt_map	iacm_cpt_code
_436.insurances_contracted_pricing	icp_cpt_code
_436.insurances_contracted_pricing_log	icpl_cpt_code
_436.patients_responsibility_estimates_services	prests_cpt_code
_436_archive_testing.clients_fee_schedules_map	cfsm_cpt_code
_436_archive_testing.clinical_interventions_test_codes_map	citcm_cpt_code
_436_archive_testing.immunizations_cpt_map	icm_cpt_code
_436_archive_testing.insurances_allowables_cpt_map	iacm_cpt_code
_436_archive_testing.insurances_contracted_pricing	icp_cpt_code
_436_archive_testing.insurances_contracted_pricing_log	icpl_cpt_code
_436_archive_testing.patients_responsibility_estimates_services	prests_cpt_code
_437.clients_fee_schedules_map	cfsm_cpt_code
_437.clinical_interventions_test_codes_map	citcm_cpt_code
_437.immunizations_cpt_map	icm_cpt_code
_437.insurances_allowables_cpt_map	iacm_cpt_code
_437.insurances_contracted_pricing	icp_cpt_code
_437.insurances_contracted_pricing_log	icpl_cpt_code
_437.patients_responsibility_estimates_services	prests_cpt_code
_8.clients_fee_schedules_map	cfsm_cpt_code
_8.clinical_interventions_test_codes_map	citcm_cpt_code
_8.immunizations_cpt_map	icm_cpt_code
_8.insurances_allowables_cpt_map	iacm_cpt_code
_8.insurances_contracted_pricing	icp_cpt_code
_8.insurances_contracted_pricing_log	icpl_cpt_code
_8.patients_responsibility_estimates_services	prests_cpt_code
_81.clients_fee_schedules_map	cfsm_cpt_code
_81.clinical_interventions_test_codes_map	citcm_cpt_code
_81.immunizations_cpt_map	icm_cpt_code
_81.insurances_allowables_cpt_map	iacm_cpt_code
_81.insurances_contracted_pricing	icp_cpt_code
_81.insurances_contracted_pricing_log	icpl_cpt_code
_81.patients_responsibility_estimates_services	prests_cpt_code
_999.clients_fee_schedules_map	cfsm_cpt_code
_999.clinical_interventions_test_codes_map	citcm_cpt_code
_999.immunizations_cpt_map	icm_cpt_code
_999.insurances_allowables_cpt_map	iacm_cpt_code
_999.insurances_contracted_pricing	icp_cpt_code
_999.insurances_contracted_pricing_log	icpl_cpt_code
_999.patients_responsibility_estimates_services	prests_cpt_code
aurora_standard.axlscdm	md_cpt_code
aurora_standard.axlscdm	ci_cpt_code
aurora_standard.c5cdm	oth_cpt_code
aurora_standard.c5cdm	wc_cpt_code
aurora_standard.c5cdm	comm_cpt_code
aurora_standard.c5cdmdr	oth_cpt_code
aurora_standard.c5cdmdr	wc_cpt_code
aurora_standard.c5cdmdr	comm_cpt_code
aurora_standard.c7cdm	comm_cpt_code
aurora_standard.c8cdm	comm_cpt_code
aurora_standard.chmprica	prev_cpt_code
aurora_standard.chmprica	cur_cpt_code
aurora_standard.chmpricc	comm_cpt_code
aurora_standard.glsprice	comm_cpt_code
common.loinc_codes	lc_cpt_code
common.mednec	med_cpt_code
common.test_codes_cpt	tcc_cpt_code

units

Table	Column
Loinc.loinc_codes	lc_ipcc_units
Loinc.loinc_codes	lc_submitted_units
Loinc.loinc_codes	lc_example_units
Loinc.loinc_codes	lc_curated_range_and_units
Loinc.loinc_codes	lc_example_ucum_units
Loinc.loinc_codes	lc_example_si_ucum_units
Loinc.loinc_codes_example_units	lceu_example_units
_1.charts_cpt_codes	chcp_num_units
_1.charts_medications	cm_quantity_units
_1.charts_procedures	cp_num_units
_1.clients_fee_schedules_map	cfsm_num_units
_1.clinical_interventions_coded_attributes	cica_units
_1.clinical_interventions_lab_results_map	cilrm_units
_1.configured_encounters_templates_cpt_codes	cetcc_num_units
_1.encounters_cpt_codes	ecp_num_units
_1.encounters_cpt_codes_templates	ecpt_num_units
_1.hl7_results	res_observ_units
_1.labs_results	lr_observ_units
_1.patients_immunizations	pim_administered_units
_1.patients_immunizations_templates	pimt_administered_units
_1.patients_inventory	pinv_administered_units
_1.patients_medications	pms_quantity_units
_1.patients_prescriptions	prx_quantity_units
_1.patients_responsibility_estimates_services	prests_ndc_num_units
_1.patients_responsibility_estimates_services	prests_num_units
_1.patients_responsibility_estimates_services	prests_allowed_units
_1.precerts_cpt_codes	pcp_num_units
_1188.charts_cpt_codes	chcp_num_units
_1188.charts_medications	cm_quantity_units
_1188.charts_procedures	cp_num_units
_1188.clients_fee_schedules_map	cfsm_num_units
_1188.clinical_interventions_lab_results_map	cilrm_units
_1188.configured_encounters_templates_cpt_codes	cetcc_num_units
_1188.encounters_cpt_codes	ecp_num_units
_1188.encounters_cpt_codes_templates	ecpt_num_units
_1188.hl7_results	res_observ_units
_1188.labs_results	lr_observ_units
_1188.patients_immunizations	pim_administered_units
_1188.patients_immunizations_templates	pimt_administered_units
_1188.patients_inventory	pinv_administered_units
_1188.patients_medications	pms_quantity_units
_1188.patients_prescriptions	prx_quantity_units
_1188.patients_responsibility_estimates_services	prests_ndc_num_units
_1188.patients_responsibility_estimates_services	prests_num_units
_1188.patients_responsibility_estimates_services	prests_allowed_units
_1188.precerts_cpt_codes	pcp_num_units
_1218.charts_cpt_codes	chcp_num_units
_1218.charts_medications	cm_quantity_units
_1218.charts_procedures	cp_num_units
_1218.clients_fee_schedules_map	cfsm_num_units
_1218.clinical_interventions_lab_results_map	cilrm_units
_1218.configured_encounters_templates_cpt_codes	cetcc_num_units
_1218.encounters_cpt_codes	ecp_num_units
_1218.encounters_cpt_codes_templates	ecpt_num_units
_1218.hl7_results	res_observ_units
_1218.labs_results	lr_observ_units
_1218.patients_immunizations	pim_administered_units
_1218.patients_immunizations_templates	pimt_administered_units
_1218.patients_inventory	pinv_administered_units
_1218.patients_medications	pms_quantity_units
_1218.patients_prescriptions	prx_quantity_units
_1218.patients_responsibility_estimates_services	prests_ndc_num_units
_1218.patients_responsibility_estimates_services	prests_num_units
_1218.patients_responsibility_estimates_services	prests_allowed_units
_1218.precerts_cpt_codes	pcp_num_units
_1548.charts_cpt_codes	chcp_num_units
_1548.charts_medications	cm_quantity_units
_1548.charts_procedures	cp_num_units
_1548.clients_fee_schedules_map	cfsm_num_units
_1548.clinical_interventions_coded_attributes	cica_units
_1548.clinical_interventions_lab_results_map	cilrm_units
_1548.configured_encounters_templates_cpt_codes	cetcc_num_units
_1548.encounters_cpt_codes	ecp_num_units
_1548.encounters_cpt_codes_templates	ecpt_num_units
_1548.hl7_results	res_observ_units
_1548.labs_results	lr_observ_units
_1548.patients_immunizations	pim_administered_units
_1548.patients_immunizations_templates	pimt_administered_units
_1548.patients_inventory	pinv_administered_units
_1548.patients_medications	pms_quantity_units
_1548.patients_prescriptions	prx_quantity_units
_1548.patients_responsibility_estimates_services	prests_ndc_num_units
_1548.patients_responsibility_estimates_services	prests_num_units
_1548.patients_responsibility_estimates_services	prests_allowed_units
_1548.precerts_cpt_codes	pcp_num_units
_435.charts_cpt_codes	chcp_num_units
_435.charts_medications	cm_quantity_units
_435.charts_procedures	cp_num_units
_435.clients_fee_schedules_map	cfsm_num_units
_435.clinical_interventions_coded_attributes	cica_units
_435.clinical_interventions_lab_results_map	cilrm_units
_435.configured_encounters_templates_cpt_codes	cetcc_num_units
_435.encounters_cpt_codes	ecp_num_units
_435.encounters_cpt_codes_templates	ecpt_num_units
_435.hl7_results	res_observ_units
_435.labs_results	lr_observ_units
_435.patients_immunizations	pim_administered_units
_435.patients_immunizations_templates	pimt_administered_units
_435.patients_inventory	pinv_administered_units
_435.patients_medications	pms_quantity_units
_435.patients_prescriptions	prx_quantity_units
_435.patients_responsibility_estimates_services	prests_ndc_num_units
_435.patients_responsibility_estimates_services	prests_num_units
_435.precerts_cpt_codes	pcp_num_units
_436.charts_cpt_codes	chcp_num_units
_436.charts_medications	cm_quantity_units
_436.charts_procedures	cp_num_units
_436.clients_fee_schedules_map	cfsm_num_units
_436.clinical_interventions_coded_attributes	cica_units
_436.clinical_interventions_lab_results_map	cilrm_units
_436.configured_encounters_templates_cpt_codes	cetcc_num_units
_436.encounters_cpt_codes	ecp_num_units
_436.encounters_cpt_codes_templates	ecpt_num_units
_436.hl7_results	res_observ_units
_436.labs_results	lr_observ_units
_436.patients_immunizations	pim_administered_units
_436.patients_immunizations_templates	pimt_administered_units
_436.patients_inventory	pinv_administered_units
_436.patients_medications	pms_quantity_units
_436.patients_prescriptions	prx_quantity_units
_436.patients_responsibility_estimates_services	prests_ndc_num_units
_436.patients_responsibility_estimates_services	prests_num_units
_436.precerts_cpt_codes	pcp_num_units
_436_archive_testing.charts_cpt_codes	chcp_num_units
_436_archive_testing.charts_medications	cm_quantity_units
_436_archive_testing.charts_procedures	cp_num_units
_436_archive_testing.clients_fee_schedules_map	cfsm_num_units
_436_archive_testing.clinical_interventions_coded_attributes	cica_units
_436_archive_testing.clinical_interventions_lab_results_map	cilrm_units
_436_archive_testing.configured_encounters_templates_cpt_codes	cetcc_num_units
_436_archive_testing.encounters_cpt_codes	ecp_num_units
_436_archive_testing.encounters_cpt_codes_templates	ecpt_num_units
_436_archive_testing.hl7_results	res_observ_units
_436_archive_testing.labs_results	lr_observ_units
_436_archive_testing.patients_immunizations	pim_administered_units
_436_archive_testing.patients_immunizations_templates	pimt_administered_units
_436_archive_testing.patients_inventory	pinv_administered_units
_436_archive_testing.patients_medications	pms_quantity_units
_436_archive_testing.patients_prescriptions	prx_quantity_units
_436_archive_testing.patients_responsibility_estimates_services	prests_ndc_num_units
_436_archive_testing.patients_responsibility_estimates_services	prests_num_units
_436_archive_testing.precerts_cpt_codes	pcp_num_units
_437.charts_cpt_codes	chcp_num_units
_437.charts_medications	cm_quantity_units
_437.charts_procedures	cp_num_units
_437.clients_fee_schedules_map	cfsm_num_units
_437.clinical_interventions_coded_attributes	cica_units
_437.clinical_interventions_lab_results_map	cilrm_units
_437.configured_encounters_templates_cpt_codes	cetcc_num_units
_437.encounters_cpt_codes	ecp_num_units
_437.encounters_cpt_codes_templates	ecpt_num_units
_437.hl7_results	res_observ_units
_437.labs_results	lr_observ_units
_437.patients_immunizations	pim_administered_units
_437.patients_immunizations_templates	pimt_administered_units
_437.patients_inventory	pinv_administered_units
_437.patients_medications	pms_quantity_units
_437.patients_prescriptions	prx_quantity_units
_437.patients_responsibility_estimates_services	prests_ndc_num_units
_437.patients_responsibility_estimates_services	prests_num_units
_437.precerts_cpt_codes	pcp_num_units
_8.charts_cpt_codes	chcp_num_units
_8.charts_medications	cm_quantity_units
_8.charts_procedures	cp_num_units
_8.clients_fee_schedules_map	cfsm_num_units
_8.clinical_interventions_coded_attributes	cica_units
_8.clinical_interventions_lab_results_map	cilrm_units
_8.configured_encounters_templates_cpt_codes	cetcc_num_units
_8.daily_close_calculations	dcc_ecp_num_units
_8.encounters_cpt_codes	ecp_num_units
_8.encounters_cpt_codes_templates	ecpt_num_units
_8.hl7_results	res_observ_units
_8.labs_results	lr_observ_units
_8.patients_immunizations	pim_administered_units
_8.patients_immunizations_templates	pimt_administered_units
_8.patients_inventory	pinv_administered_units
_8.patients_medications	pms_quantity_units
_8.patients_prescriptions	prx_quantity_units
_8.patients_responsibility_estimates_services	prests_ndc_num_units
_8.patients_responsibility_estimates_services	prests_num_units
_8.patients_responsibility_estimates_services	prests_allowed_units
_8.precerts_cpt_codes	pcp_num_units
_81.charts_cpt_codes	chcp_num_units
_81.charts_medications	cm_quantity_units
_81.charts_procedures	cp_num_units
_81.clients_fee_schedules_map	cfsm_num_units
_81.clinical_interventions_lab_results_map	cilrm_units
_81.configured_encounters_templates_cpt_codes	cetcc_num_units
_81.encounters_cpt_codes	ecp_num_units
_81.encounters_cpt_codes_templates	ecpt_num_units
_81.hl7_results	res_observ_units
_81.labs_results	lr_observ_units
_81.patients_immunizations	pim_administered_units
_81.patients_immunizations_templates	pimt_administered_units
_81.patients_inventory	pinv_administered_units
_81.patients_medications	pms_quantity_units
_81.patients_prescriptions	prx_quantity_units
_81.patients_responsibility_estimates_services	prests_ndc_num_units
_81.patients_responsibility_estimates_services	prests_num_units
_81.patients_responsibility_estimates_services	prests_allowed_units
_81.precerts_cpt_codes	pcp_num_units
_999.charts_cpt_codes	chcp_num_units
_999.charts_medications	cm_quantity_units
_999.charts_procedures	cp_num_units
_999.clients_fee_schedules_map	cfsm_num_units
_999.clinical_interventions_coded_attributes	cica_units
_999.clinical_interventions_lab_results_map	cilrm_units
_999.configured_encounters_templates_cpt_codes	cetcc_num_units
_999.encounters_cpt_codes	ecp_num_units
_999.encounters_cpt_codes_templates	ecpt_num_units
_999.hl7_results	res_observ_units
_999.labs_results	lr_observ_units
_999.patients_immunizations	pim_administered_units
_999.patients_immunizations_templates	pimt_administered_units
_999.patients_inventory	pinv_administered_units
_999.patients_medications	pms_quantity_units
_999.patients_prescriptions	prx_quantity_units
_999.patients_responsibility_estimates_services	prests_ndc_num_units
_999.patients_responsibility_estimates_services	prests_num_units
_999.patients_responsibility_estimates_services	prests_allowed_units
_999.precerts_cpt_codes	pcp_num_units
aurora_standard.c7cdmrx	bill_units
aurora_standard.cachrg	chg_units
aurora_standard.cachrg2	chg_units
aurora_standard.cachrgca	chg_units
aurora_standard.cachrgevo	chg_units
aurora_standard.canullchrg	chg_units
aurora_standard.caroom	chg_units
aurora_standard.chmabstr	blood_units
aurora_standard.chmapcbr	cpt_units
aurora_standard.chmapcir	cpt_units
aurora_standard.choordmd	order_units
aurora_standard.choordrc	default_units
aurora_standard.chrordrr	dispense_units
aurora_standard.oeorder	order_units
common.loinc_codes	lc_ipcc_units
common.loinc_codes	lc_submitted_units
common.loinc_codes	lc_example_units
common.loinc_codes	lc_curated_range_and_units
common.loinc_codes	lc_example_ucum_units
common.loinc_codes	lc_example_si_ucum_units
common.test_codes_cpt	tcc_units
template_library.encounters_cpt_codes_templates	ecpt_num_units
template_library.patients_immunizations_templates	pimt_administered_units

rev_code

Table	Column
_1.adjustment_rules	ar_adj_rev_code
_1.charts_cpt_codes	chcp_rev_code
_1.clients_fee_schedules_map	cfsm_rev_code
_1.configured_encounters_templates_cpt_codes	cetcc_rev_code
_1.cpt	cpt_rev_code
_1.encounters_cpt_codes	ecp_rev_code
_1.encounters_cpt_codes_templates	ecpt_rev_code
_1188.charts_cpt_codes	chcp_rev_code
_1188.clients_fee_schedules_map	cfsm_rev_code
_1188.configured_encounters_templates_cpt_codes	cetcc_rev_code
_1188.cpt	cpt_rev_code
_1188.encounters_cpt_codes	ecp_rev_code
_1188.encounters_cpt_codes_templates	ecpt_rev_code
_1218.adjustment_rules	ar_adj_rev_code
_1218.charts_cpt_codes	chcp_rev_code
_1218.clients_fee_schedules_map	cfsm_rev_code
_1218.configured_encounters_templates_cpt_codes	cetcc_rev_code
_1218.cpt	cpt_rev_code
_1218.encounters_cpt_codes	ecp_rev_code
_1218.encounters_cpt_codes_templates	ecpt_rev_code
_1548.adjustment_rules	ar_adj_rev_code
_1548.charts_cpt_codes	chcp_rev_code
_1548.clients_fee_schedules_map	cfsm_rev_code
_1548.configured_encounters_templates_cpt_codes	cetcc_rev_code
_1548.cpt	cpt_rev_code
_1548.encounters_cpt_codes	ecp_rev_code
_1548.encounters_cpt_codes_templates	ecpt_rev_code
_435.adjustment_rules	ar_adj_rev_code
_435.charts_cpt_codes	chcp_rev_code
_435.clients_fee_schedules_map	cfsm_rev_code
_435.configured_encounters_templates_cpt_codes	cetcc_rev_code
_435.cpt	cpt_rev_code
_435.encounters_cpt_codes	ecp_rev_code
_435.encounters_cpt_codes_templates	ecpt_rev_code
_436.adjustment_rules	ar_adj_rev_code
_436.charts_cpt_codes	chcp_rev_code
_436.clients_fee_schedules_map	cfsm_rev_code
_436.configured_encounters_templates_cpt_codes	cetcc_rev_code
_436.cpt	cpt_rev_code
_436.encounters_cpt_codes	ecp_rev_code
_436.encounters_cpt_codes_templates	ecpt_rev_code
_436_archive_testing.adjustment_rules	ar_adj_rev_code
_436_archive_testing.charts_cpt_codes	chcp_rev_code
_436_archive_testing.clients_fee_schedules_map	cfsm_rev_code
_436_archive_testing.configured_encounters_templates_cpt_codes	cetcc_rev_code
_436_archive_testing.cpt	cpt_rev_code
_436_archive_testing.encounters_cpt_codes	ecp_rev_code
_436_archive_testing.encounters_cpt_codes_templates	ecpt_rev_code
_437.adjustment_rules	ar_adj_rev_code
_437.charts_cpt_codes	chcp_rev_code
_437.clients_fee_schedules_map	cfsm_rev_code
_437.configured_encounters_templates_cpt_codes	cetcc_rev_code
_437.cpt	cpt_rev_code
_437.encounters_cpt_codes	ecp_rev_code
_437.encounters_cpt_codes_templates	ecpt_rev_code
_8.adjustment_rules	ar_adj_rev_code
_8.charts_cpt_codes	chcp_rev_code
_8.clients_fee_schedules_map	cfsm_rev_code
_8.configured_encounters_templates_cpt_codes	cetcc_rev_code
_8.cpt	cpt_rev_code
_8.daily_close_calculations	dcc_rev_code
_8.encounters_cpt_codes	ecp_rev_code
_8.encounters_cpt_codes_templates	ecpt_rev_code
_81.charts_cpt_codes	chcp_rev_code
_81.clients_fee_schedules_map	cfsm_rev_code
_81.configured_encounters_templates_cpt_codes	cetcc_rev_code
_81.cpt	cpt_rev_code
_81.encounters_cpt_codes	ecp_rev_code
_81.encounters_cpt_codes_templates	ecpt_rev_code
_999.adjustment_rules	ar_adj_rev_code
_999.charts_cpt_codes	chcp_rev_code
_999.clients_fee_schedules_map	cfsm_rev_code
_999.configured_encounters_templates_cpt_codes	cetcc_rev_code
_999.cpt	cpt_rev_code
_999.encounters_cpt_codes	ecp_rev_code
_999.encounters_cpt_codes_templates	ecpt_rev_code
aurora_standard.audpchgd	ub_rev_code
aurora_standard.audroomd	ub_rev_code
aurora_standard.c7cdm	ub_rev_code
aurora_standard.c7cdm	md_rev_code
aurora_standard.c7cdm	comm_rev_code
aurora_standard.c8cdm	ub_rev_code
aurora_standard.c8cdm	md_rev_code
aurora_standard.c8cdm	comm_rev_code
aurora_standard.chm835ps	ub_rev_code
aurora_standard.chmbchgd	ub_rev_code
aurora_standard.chmcptcd	ub_rev_code
aurora_standard.chmpchgd	ub_rev_code
aurora_standard.chmprica	prev_rev_code
aurora_standard.chmprica	cur_rev_code
aurora_standard.chmpricc	ub_rev_code
aurora_standard.chmpricc	md_rev_code
aurora_standard.chmpricc	comm_rev_code
aurora_standard.chmpricx	ub_rev_code
aurora_standard.chmroomd	ub_rev_code
aurora_standard.chmstatc	def_ub_rev_code
aurora_standard.glsprice	ub_rev_code
aurora_standard.glsprice	md_rev_code
aurora_standard.glsprice	comm_rev_code
aurora_standard.oebatchaud	ub_rev_code
aurora_standard.stiinvtr	ub_rev_code
aurora_standard.tmp04d	ub_rev_code
aurora_standard.tmp15chd	ub_rev_code
aurora_standard.ttiinvtr	ub_rev_code
template_library.cpt	cpt_rev_code
template_library.encounters_cpt_codes_templates	ecpt_rev_code

location

Table	Column
_1.cpoe_responses	cpoe_res_location
_1.encounters_soap_vitals	espv_location
_1.hl7_accessions	acc_location
_1.patients_immunizations	pim_location
_1.precerts	pre_scheduled_location
_1.precerts_map	prem_location
_1.radiology_results	rad_res_location
_1188.cpoe_responses	cpoe_res_location
_1188.encounters_soap_vitals	espv_location
_1188.hl7_accessions	acc_location
_1188.patients_immunizations	pim_location
_1188.precerts	pre_scheduled_location
_1188.precerts_map	prem_location
_1188.radiology_results	rad_res_location
_1218.cpoe_responses	cpoe_res_location
_1218.encounters_soap_vitals	espv_location
_1218.hl7_accessions	acc_location
_1218.patients_immunizations	pim_location
_1218.precerts	pre_scheduled_location
_1218.precerts_map	prem_location
_1218.radiology_results	rad_res_location
_1548.cpoe_responses	cpoe_res_location
_1548.encounters_soap_vitals	espv_location
_1548.hl7_accessions	acc_location
_1548.patients_immunizations	pim_location
_1548.precerts	pre_scheduled_location
_1548.precerts_map	prem_location
_1548.radiology_results	rad_res_location
_435.cpoe_responses	cpoe_res_location
_435.encounters_soap_vitals	espv_location
_435.hl7_accessions	acc_location
_435.patients_immunizations	pim_location
_435.precerts	pre_scheduled_location
_435.precerts_map	prem_location
_435.radiology_results	rad_res_location
_436.cpoe_responses	cpoe_res_location
_436.encounters_soap_vitals	espv_location
_436.hl7_accessions	acc_location
_436.patients_immunizations	pim_location
_436.precerts	pre_scheduled_location
_436.precerts_map	prem_location
_436.radiology_results	rad_res_location
_436_archive_testing.cpoe_responses	cpoe_res_location
_436_archive_testing.encounters_soap_vitals	espv_location
_436_archive_testing.hl7_accessions	acc_location
_436_archive_testing.patients_immunizations	pim_location
_436_archive_testing.precerts	pre_scheduled_location
_436_archive_testing.precerts_map	prem_location
_436_archive_testing.radiology_results	rad_res_location
_437.cpoe_responses	cpoe_res_location
_437.encounters_soap_vitals	espv_location
_437.hl7_accessions	acc_location
_437.patients_immunizations	pim_location
_437.precerts	pre_scheduled_location
_437.precerts_map	prem_location
_437.radiology_results	rad_res_location
_8.cpoe_responses	cpoe_res_location
_8.encounters_soap_vitals	espv_location
_8.hl7_accessions	acc_location
_8.patients_immunizations	pim_location
_8.precerts	pre_scheduled_location
_8.precerts_map	prem_location
_8.radiology_results	rad_res_location
_81.cpoe_responses	cpoe_res_location
_81.encounters_soap_vitals	espv_location
_81.hl7_accessions	acc_location
_81.patients_immunizations	pim_location
_81.precerts	pre_scheduled_location
_81.precerts_map	prem_location
_81.radiology_results	rad_res_location
_999.cpoe_responses	cpoe_res_location
_999.encounters_soap_vitals	espv_location
_999.hl7_accessions	acc_location
_999.patients_immunizations	pim_location
_999.precerts	pre_scheduled_location
_999.precerts_map	prem_location
_999.radiology_results	rad_res_location
aurora_standard.bhguar	emp_location
aurora_standard.bhtguar	emp_location
aurora_standard.chpinsrd	class_location
aurora_standard.chplocac	class_location
aurora_standard.chqcmeud	cme_location
aurora_standard.chqletrd	letter_location
aurora_standard.chrcntrc	rx_location
aurora_standard.mergdocs	file_location
aurora_standard.mergsigs	file_location
aurora_standard.sthcadjd	stock_location
aurora_standard.sticadjd	stock_location
aurora_standard.stilocar	stock_location
aurora_standard.stipyxlc	rev_location
aurora_standard.stipyxlc	exp_location
aurora_standard.stistkld	stock_location
aurora_standard.stock2	stock_location
aurora_standard.stoshipd	stock_location
aurora_standard.tmplocar	stock_location

claim_type

Table	Column
_1.encounters_claims_files	ecf_claim_type
_1188.encounters_claims_files	ecf_claim_type
_1218.encounters_claims_files	ecf_claim_type
_1548.encounters_claims_files	ecf_claim_type
_435.encounters_claims_files	ecf_claim_type
_436.encounters_claims_files	ecf_claim_type
_436_archive_testing.encounters_claims_files	ecf_claim_type
_437.encounters_claims_files	ecf_claim_type
_8.encounters_claims_files	ecf_claim_type
_81.encounters_claims_files	ecf_claim_type
_999.encounters_claims_files	ecf_claim_type

amt

Table	Column
_1.immunizations	imz_admin_amt
_1.inventory	inv_init_amt
_1188.immunizations	imz_admin_amt
_1188.inventory	inv_init_amt
_1218.immunizations	imz_admin_amt
_1218.inventory	inv_init_amt
_1548.immunizations	imz_admin_amt
_1548.inventory	inv_init_amt
_435.immunizations	imz_admin_amt
_435.inventory	inv_init_amt
_436.immunizations	imz_admin_amt
_436.inventory	inv_init_amt
_436_archive_testing.immunizations	imz_admin_amt
_436_archive_testing.inventory	inv_init_amt
_437.immunizations	imz_admin_amt
_437.inventory	inv_init_amt
_8.immunizations	imz_admin_amt
_8.inventory	inv_init_amt
_81.immunizations	imz_admin_amt
_81.inventory	inv_init_amt
_999.immunizations	imz_admin_amt
_999.inventory	inv_init_amt
aurora_standard.addcdm	cost_amt
aurora_standard.addcdm	charge_amt
aurora_standard.adjpay	pay_amt
aurora_standard.adjpay	adj_amt
aurora_standard.adshmd	self_pay_amt
aurora_standard.adshpmt	pmt_amt
aurora_standard.adshrev	self_pay_amt
aurora_standard.afcdm	charge_amt
aurora_standard.afcsum2	chrg_amt
aurora_standard.afcsum2	rm_amt
aurora_standard.afcsum2	adj_amt
aurora_standard.afcsum2	pay_amt
aurora_standard.ainsrvw	adj_amt
aurora_standard.ainsrvw	pay_amt
aurora_standard.ainsrvw	self_amt
aurora_standard.apsar	wo_amt
aurora_standard.apsar0	wo_amt
aurora_standard.apsarbd	wo_amt
aurora_standard.apscdm	charge_amt
aurora_standard.apscdm2	charge_amt
aurora_standard.apscdma	charge_amt
aurora_standard.arevenue	inp_amt
aurora_standard.arevenue	out_amt
aurora_standard.arevenue	non_pat_amt
aurora_standard.arevenue	rm_amt
aurora_standard.arvuwk	rvu_amt
aurora_standard.aseycmc	charge_amt
aurora_standard.aseycmh	charge_amt
aurora_standard.aswcdm	charge_amt
aurora_standard.b2badd	last_dt_amt
aurora_standard.b2mrdr	chg_amt
aurora_standard.bdcdm	charge_amt
aurora_standard.bdcdm	cost_amt
aurora_standard.becdm	charge_amt
aurora_standard.bevisbd	wo_amt
aurora_standard.bevisbd2	wo_amt
aurora_standard.bfcdm	charge_amt
aurora_standard.bfcdminv	charge_amt
aurora_standard.bfcdmpro	charge_amt
aurora_standard.bfcdmrhc	charge_amt
aurora_standard.bfhos	last_pmt_amt
aurora_standard.bfpasr	last_pmt_amt
aurora_standard.bfrhccdm	charge_amt
aurora_standard.bgcdm	charge_amt
aurora_standard.bhar	pp_amt
aurora_standard.bhbadd	last_dt_amt
aurora_standard.bhmrdr	chg_amt
aurora_standard.bhtmrdr	chg_amt
aurora_standard.bmcdm	charge_amt
aurora_standard.bmins	ins_paid_amt
aurora_standard.bokcdm	cost_amt
aurora_standard.bokcdm	charge_amt
aurora_standard.bpar	pp_amt
aurora_standard.bpar2	pp_amt
aurora_standard.bpcdmhos	charge_amt
aurora_standard.bpcdmrhc	charge_amt
aurora_standard.bvcdm	charge_amt
aurora_standard.bvclncdm	charge_amt
aurora_standard.c7cdm720	charge_amt
aurora_standard.c7cdmold	charge_amt
aurora_standard.c7cdmrx	charge_amt
aurora_standard.c7cdmxls	charge_amt
aurora_standard.c7dme	charge_amt
aurora_standard.c8bal0	unb_amt
aurora_standard.c8bal0	billed_amt
aurora_standard.c8bal0	late_amt
aurora_standard.c8bals	unb_amt
aurora_standard.c8bals	billed_amt
aurora_standard.c8bals	late_amt
aurora_standard.chhl7in1	policy_limit_amt
aurora_standard.chhl7in2	rm_cvrg_typ_amt
aurora_standard.chhl7in2	policy_type_amt
aurora_standard.chm835pd	billed_amt
aurora_standard.chm835pd	payment_amt
aurora_standard.chm835pd	non_cov_amt
aurora_standard.chm835pd	drg_amt
aurora_standard.chm835pd	allowed_amt
aurora_standard.chm835pd	denied_amt
aurora_standard.chm835pd	pps_outlier_amt
aurora_standard.chm835ps	charge_amt
aurora_standard.chm835ps	adj_amt
aurora_standard.chm835ps	pmt_amt
aurora_standard.chm835ps	allow_amt
aurora_standard.chmadmqr	last_pmt_amt
aurora_standard.chmagesd	age_1_amt
aurora_standard.chmagesd	age_2_amt
aurora_standard.chmagesd	age_3_amt
aurora_standard.chmagesd	age_4_amt
aurora_standard.chmagesd	age_5_amt
aurora_standard.chmagesd	age_6_amt
aurora_standard.chmagesd	age_7_amt
aurora_standard.chmagesd	age_8_amt
aurora_standard.chmagesd	age_9_amt
aurora_standard.chmagesd	age_10_amt
aurora_standard.chmagesd	age_11_amt
aurora_standard.chmagesd	age_12_amt
aurora_standard.chmagesd	age_13_amt
aurora_standard.chmarcpa	t_amt
aurora_standard.chmbened	i_ded_amt
aurora_standard.chmbened	i_copay_amt
aurora_standard.chmbened	i_dme_amt
aurora_standard.chmbened	i_orthotics_amt
aurora_standard.chmbened	o_ded_amt
aurora_standard.chmbened	o_copay_amt
aurora_standard.chmbened	o_dme_amt
aurora_standard.chmbened	o_orthotics_amt
aurora_standard.chmblogd	drg_amt
aurora_standard.chmblogd	reimburs_amt
aurora_standard.chmblogd	outlier_amt
aurora_standard.chmblogd	other_amt
aurora_standard.chmbremd	drg_amt
aurora_standard.chmbremd	reimburs_amt
aurora_standard.chmbremd	denied_amt
aurora_standard.chmbremd	allowed_amt
aurora_standard.chmcashd	ref_amt
aurora_standard.chmcptcd	chg_amt
aurora_standard.chmcptfc	fee_amt
aurora_standard.chmgltcr	oth_ins_amt
aurora_standard.chmibend	i_ded_amt
aurora_standard.chmibend	i_max_amt
aurora_standard.chmibend	r_dme_amt
aurora_standard.chmibend	r_orthotics_amt
aurora_standard.chmibend	o_ded_amt
aurora_standard.chmibend	o_max_amt
aurora_standard.chminsrd	per_diem_amt
aurora_standard.chmmbc41	co_ins_amt
aurora_standard.chmmbc41	paid_amt
aurora_standard.chmmbc50	approved_amt
aurora_standard.chmmbc50	paid_amt
aurora_standard.chmmbc55	co_ins_amt
aurora_standard.chmmbc55	deductible_amt
aurora_standard.chmmbc55	paid_amt
aurora_standard.chmmhbcd	ded_amt
aurora_standard.chmmhbcd	paid_amt
aurora_standard.chmmhbcr	approved_amt
aurora_standard.chmnormd	charge_amt
aurora_standard.chmplogd	drg_amt
aurora_standard.chmplogd	reimburs_amt
aurora_standard.chmplogd	outlier_amt
aurora_standard.chmplogd	other_amt
aurora_standard.chmpsvcd	bill_amt
aurora_standard.chmpsvcd	paid_amt
aurora_standard.chmpsvcd	adj_amt
aurora_standard.chmrefnd	refund_amt
aurora_standard.chmrefnd	adj_amt
aurora_standard.chmub04r	l_39_a_amt
aurora_standard.chmub04r	l_39_b_amt
aurora_standard.chmub04r	l_39_c_amt
aurora_standard.chmub04r	l_39_d_amt
aurora_standard.chmub04r	l_40_a_amt
aurora_standard.chmub04r	l_40_b_amt
aurora_standard.chmub04r	l_40_c_amt
aurora_standard.chmub04r	l_40_d_amt
aurora_standard.chmub04r	l_41_a_amt
aurora_standard.chmub04r	l_41_b_amt
aurora_standard.chmub04r	l_41_c_amt
aurora_standard.chmub04r	l_41_d_amt
aurora_standard.chmub92r	l_39_a_amt
aurora_standard.chmub92r	l_39_b_amt
aurora_standard.chmub92r	l_39_c_amt
aurora_standard.chmub92r	l_39_d_amt
aurora_standard.chmub92r	l_40_a_amt
aurora_standard.chmub92r	l_40_b_amt
aurora_standard.chmub92r	l_40_c_amt
aurora_standard.chmub92r	l_40_d_amt
aurora_standard.chmub92r	l_41_a_amt
aurora_standard.chmub92r	l_41_b_amt
aurora_standard.chmub92r	l_41_c_amt
aurora_standard.chmub92r	l_41_d_amt
aurora_standard.chmub92v	l_39a_amt
aurora_standard.chmub92v	l_39b_amt
aurora_standard.chmub92v	l_39c_amt
aurora_standard.chmub92v	l_39d_amt
aurora_standard.chmub92v	l_40a_amt
aurora_standard.chmub92v	l_40b_amt
aurora_standard.chmub92v	l_40c_amt
aurora_standard.chmub92v	l_40d_amt
aurora_standard.chmub92v	l_41a_amt
aurora_standard.chmub92v	l_41b_amt
aurora_standard.chmub92v	l_41c_amt
aurora_standard.chmub92v	l_41d_amt
aurora_standard.chmutaht	pat_est_amt
aurora_standard.chpcober	premium_amt
aurora_standard.chpcobrd	payment_amt
aurora_standard.chrcntrc	percent_amt
aurora_standard.chrpricc	add_on_amt
aurora_standard.credit	credit_amt
aurora_standard.gary14	posted_amt
aurora_standard.gary14	correct_amt
aurora_standard.hhl7chgd	charge_amt
aurora_standard.hl7ft1	ins_amt
aurora_standard.hl7in1	policy_limit_amt
aurora_standard.hl7in1ad	policy_limit_amt
aurora_standard.hl7in2	rm_cvrg_typ_amt
aurora_standard.hl7in2	policy_type_amt
aurora_standard.hl7in2ad	rm_cvrg_typ_amt
aurora_standard.hl7in2ad	policy_type_amt
aurora_standard.hl7pv1	contract_amt
aurora_standard.hl7pv1	bd_trans_amt
aurora_standard.hl7pv1	bd_recover_amt
aurora_standard.hl7pv1ad	contract_amt
aurora_standard.hl7pv1ad	bd_trans_amt
aurora_standard.hl7pv1ad	bd_recover_amt
aurora_standard.logdetld	reimburs_amt
aurora_standard.logdetld	adjust_amt
aurora_standard.logdetld	drg_amt
aurora_standard.logdetld	outlier_amt
aurora_standard.logdetld	other_amt
aurora_standard.logdetld	tot_1500_amt
aurora_standard.logdetld	ub_amt
aurora_standard.ohorx	cost_amt
aurora_standard.ohorx	charge_amt
aurora_standard.ohovisqr	last_pmt_amt
aurora_standard.samcdmc	charge_amt
aurora_standard.stfdeprd	bonus_amt
aurora_standard.stonwall	cost_amt
aurora_standard.stonwall	charge_amt
aurora_standard.stp1099r	total_amt
aurora_standard.stp1099r	cat_1_amt
aurora_standard.stp1099r	cat_2_amt
aurora_standard.stp1099r	cat_3_amt
aurora_standard.stp1099r	cat_4_amt
aurora_standard.stp1099r	cat_5_amt
aurora_standard.stp1099r	cat_6_amt
aurora_standard.stp1099r	cat_7_amt
aurora_standard.stp1099r	cat_8_amt
aurora_standard.stp1099r	cat_9_amt
aurora_standard.stp1099r	cat_10_amt
aurora_standard.stp1099r	cat_11_amt
aurora_standard.stp1099r	cat_12_amt
aurora_standard.stp1099r	cat_13_amt
aurora_standard.stp1099r	cat_14_amt
aurora_standard.stp1099r	cat_15_amt
aurora_standard.stp1099r	cat_16_amt
aurora_standard.stp1099r	cat_17_amt
aurora_standard.stp1099r	cat_18_amt
aurora_standard.stpcashd	dist_amt
aurora_standard.stpcashd	goods_amt
aurora_standard.stpcashd	disc_amt
aurora_standard.stpcashe	cash_amt
aurora_standard.stpcashe	oa_amt
aurora_standard.stpinvcd	goods_amt
aurora_standard.stpopend	disc_amt
aurora_standard.stpopend	to_pay_amt
aurora_standard.stpvendr	on_acct_amt
aurora_standard.stpvendr	top_vnd_amt
aurora_standard.strcashd	dist_amt
aurora_standard.strcashd	goods_amt
aurora_standard.strcashd	disc_amt
aurora_standard.strcashe	cash_amt
aurora_standard.strcashe	oa_amt
aurora_standard.strcustr	on_acct_amt
aurora_standard.strnoted	payment_amt
aurora_standard.stropend	disc_amt
aurora_standard.strsuppd	annual_amt
aurora_standard.stuinvcd	exp_tax_amt
aurora_standard.stxbudgd	budget_amt
aurora_standard.stxmtaxd	mtax_amt
aurora_standard.stxmtaxd	disc_amt
aurora_standard.stxtaxld	mtax_amt
aurora_standard.styapckd	dist_amt
aurora_standard.stydedcr	dflt_hi_ded_amt
aurora_standard.stydedcr	dflt_lo_ded_amt
aurora_standard.styempdd	lo_ded_amt
aurora_standard.styempdd	hi_ded_amt
aurora_standard.styempid	lo_inc_amt
aurora_standard.styempid	hi_inc_amt
aurora_standard.styinccr	dflt_lo_inc_amt
aurora_standard.styinccr	dflt_hi_inc_amt
aurora_standard.stypaydd	lo_ded_amt
aurora_standard.stypaydd	hi_ded_amt
aurora_standard.stypayid	lo_inc_amt
aurora_standard.stypayid	hi_inc_amt
aurora_standard.stytaxtd	over_amt
aurora_standard.stytaxtd	base_amt
aurora_standard.stytypdd	lo_ded_amt
aurora_standard.stytypdd	hi_ded_amt
aurora_standard.stytypid	lo_inc_amt
aurora_standard.stytypid	hi_inc_amt
aurora_standard.timetabl_in	inc_amt
aurora_standard.tmparinq	bill_amt
aurora_standard.tmpbiggd	m_amt
aurora_standard.tmpbiggd	y_amt
aurora_standard.tmpub04r	l_39_a_amt
aurora_standard.tmpub04r	l_39_b_amt
aurora_standard.tmpub04r	l_39_c_amt
aurora_standard.tmpub04r	l_39_d_amt
aurora_standard.tmpub04r	l_40_a_amt
aurora_standard.tmpub04r	l_40_b_amt
aurora_standard.tmpub04r	l_40_c_amt
aurora_standard.tmpub04r	l_40_d_amt
aurora_standard.tmpub04r	l_41_a_amt
aurora_standard.tmpub04r	l_41_b_amt
aurora_standard.tmpub04r	l_41_c_amt
aurora_standard.tmpub04r	l_41_d_amt

deductible

Table	Column
_1.patients_responsibility_estimates	prest_deductible
_1.patients_responsibility_estimates_services	prests_deductible
_1188.patients_responsibility_estimates	prest_deductible
_1188.patients_responsibility_estimates_services	prests_deductible
_1218.patients_responsibility_estimates	prest_deductible
_1218.patients_responsibility_estimates_services	prests_deductible
_1548.patients_responsibility_estimates	prest_deductible
_1548.patients_responsibility_estimates_services	prests_deductible
_435.patients_responsibility_estimates	prest_deductible
_435.patients_responsibility_estimates_services	prests_deductible
_436.patients_responsibility_estimates	prest_deductible
_436.patients_responsibility_estimates_services	prests_deductible
_436_archive_testing.patients_responsibility_estimates	prest_deductible
_436_archive_testing.patients_responsibility_estimates_services	prests_deductible
_437.patients_responsibility_estimates	prest_deductible
_437.patients_responsibility_estimates_services	prests_deductible
_8.patients_responsibility_estimates	prest_deductible
_8.patients_responsibility_estimates_services	prests_deductible
_81.patients_responsibility_estimates	prest_deductible
_81.patients_responsibility_estimates_services	prests_deductible
_999.patients_responsibility_estimates	prest_deductible
_999.patients_responsibility_estimates_services	prests_deductible
aurora_standard.chminsrd	def_deductible
aurora_standard.chpinsuc	dep_deductible
aurora_standard.hl7in2	daily_deductible

co_ins

Table	Column
_1.patients_responsibility_estimates	prest_co_ins
_1.patients_responsibility_estimates_services	prests_co_ins
_1188.patients_responsibility_estimates	prest_co_ins
_1188.patients_responsibility_estimates_services	prests_co_ins
_1218.patients_responsibility_estimates	prest_co_ins
_1218.patients_responsibility_estimates_services	prests_co_ins
_1548.patients_responsibility_estimates	prest_co_ins
_1548.patients_responsibility_estimates_services	prests_co_ins
_435.patients_responsibility_estimates	prest_co_ins
_435.patients_responsibility_estimates_services	prests_co_ins
_436.patients_responsibility_estimates	prest_co_ins
_436.patients_responsibility_estimates_services	prests_co_ins
_436_archive_testing.patients_responsibility_estimates	prest_co_ins
_436_archive_testing.patients_responsibility_estimates_services	prests_co_ins
_437.patients_responsibility_estimates	prest_co_ins
_437.patients_responsibility_estimates_services	prests_co_ins
_8.patients_responsibility_estimates	prest_co_ins
_8.patients_responsibility_estimates_services	prests_co_ins
_81.patients_responsibility_estimates	prest_co_ins
_81.patients_responsibility_estimates_services	prests_co_ins
_999.patients_responsibility_estimates	prest_co_ins
_999.patients_responsibility_estimates_services	prests_co_ins

proc_code

Table	Column
_435.procedures_results	pres_proc_code
_436.procedures_results	pres_proc_code
_436_archive_testing.procedures_results	pres_proc_code
_437.procedures_results	pres_proc_code

dept

Table	Column
aurora_standard.TABLE 1424	new_dept
aurora_standard.TABLE 1425	new_dept
aurora_standard.axlscdm	gl_ip_dept
aurora_standard.axlscdm	gl_op_dept
aurora_standard.chmpchsd	rev_loc_dept
aurora_standard.chmrefnd	contr_dept
aurora_standard.chpcashr	cash_dept
aurora_standard.chpcempr	home_dept
aurora_standard.chpcntrc	educ_dept
aurora_standard.chpcntrc	cobra_cash_dept
aurora_standard.chpcntrc	cobra_bal_dept
aurora_standard.chpcntrc	cobra_fee_dept
aurora_standard.chpcobpd	cash_dept
aurora_standard.chpcobpd	bal_dept
aurora_standard.chpempcd	empl_dept
aurora_standard.chtemplr	dflt_dept
aurora_standard.chteshtv	dflt_dept
aurora_standard.chtsfdpd	shift_dept
aurora_standard.chtsupvc	supv_dept
aurora_standard.empldept	home_dept
aurora_standard.glxref	new_dept
aurora_standard.glxref	old_dept
aurora_standard.ohofadtl	depr_dept
aurora_standard.stfactvd	depr_dept
aurora_standard.stfactvv	depr_dept
aurora_standard.stfasstr	depr_dept
aurora_standard.stfasstr	accm_dept
aurora_standard.stgrowpd	rod_beg_dept
aurora_standard.stgrowpd	rod_end_dept
aurora_standard.stoinvce	td_ds_dept
aurora_standard.stoinvce	st_tx_dept
aurora_standard.stoinvce	co_tx_dept
aurora_standard.stoinvce	ci_tx_dept
aurora_standard.stoinvce	freight_dept
aurora_standard.stoinvce	asset_dept
aurora_standard.stoordrd	inv_dept
aurora_standard.stoordrd	sls_dept
aurora_standard.stoordrd	cog_dept
aurora_standard.stxcalix	medgenix_dept
aurora_standard.stxcalix	california_dept
aurora_standard.stxfinsd	fin_dept
aurora_standard.styaccrr	liab_dept
aurora_standard.styaccrr	expense_dept
aurora_standard.stydedcr	dflt_dept
aurora_standard.styemplr	home_dept
aurora_standard.styemplr	dir_dept
aurora_standard.styempod	bal_dept
aurora_standard.styinccr	dflt_dept
aurora_standard.styinccr	acru_lia_dept
aurora_standard.styoblcr	dflt_dept
aurora_standard.stypayod	bal_dept
aurora_standard.stytypod	bal_dept
common.test_codes	tco_x_lab_area_dept

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

phy_no

Table	Column
aurora_standard.bsinsur	fam_phy_no
aurora_standard.c7mpi	pri_phy_no
aurora_standard.campi	fam_phy_no
aurora_standard.chmabstr	admit_phy_no
aurora_standard.chmabstr	attend_phy_no
aurora_standard.chmarsi	fam_phy_no
aurora_standard.chmcampi	fam_phy_no
aurora_standard.chmexmpi	fam_phy_no
aurora_standard.chmpatmr	fam_phy_no
aurora_standard.chmpdemo	fam_phy_no
aurora_standard.chmradex	fam_phy_no
aurora_standard.chpwkmnr	refer_phy_no

mr_no

Table	Column
aurora_standard.bsinsur	snf_mr_no
aurora_standard.bsinsur	prev_mr_no
aurora_standard.chhcntrc	auto_snf_mr_no
aurora_standard.chhcntrc	auto_mr_no
aurora_standard.chmarbex	pat_mr_no
aurora_standard.chmarsi	pat_mr_no
aurora_standard.chmbatex	pat_mr_no
aurora_standard.chmcampi	pat_mr_no
aurora_standard.chmcntrc	auto_snf_mr_no
aurora_standard.chmcntrc	auto_mr_no
aurora_standard.chmexmpi	pat_mr_no
aurora_standard.chmhstmr	pat_mr_no
aurora_standard.chmhstrm	pat_mr_no
aurora_standard.chmlastr	mother_mr_no
aurora_standard.chmmhast	co_mr_no
aurora_standard.chmmrhdr	upd_mr_no
aurora_standard.chmnrcex	pat_mr_no
aurora_standard.chmokipd	pat_mr_no
aurora_standard.chmokopd	pat_mr_no
aurora_standard.chmpatmr	snf_mr_no
aurora_standard.chmpatmr	prev_mr_no
aurora_standard.chmraded	pat_mr_no
aurora_standard.chmradex	pat_mr_no
aurora_standard.chmreqsr	ofc_mr_no
aurora_standard.ncexmpi	pat_mr_no

ins_co

Table	Column
aurora_standard.chmemplr	wc_ins_co
aurora_standard.chmprica	prev_ins_co
aurora_standard.chmprica	cur_ins_co
aurora_standard.chmquesr	work_comp_ins_co
aurora_standard.chqliabd	liab_ins_co

order_no

Table	Column
aurora_standard.chmpintr	rx_order_no

proc_date

Table	Column
aurora_standard.chmutah7	cpt_proc_date
aurora_standard.chmutaha	cpt_proc_date

cd_desc

Table	Column
aurora_standard.hl7in3	non_concur_cd_desc