aurora_standard.c7chrg

Field	Type	Null	Key
vis_no	int(11)	YES	MUL
pric_cd	varchar(10)	YES
chg_dt	varchar(8)	YES	MUL
units	smallint(6)	YES
amt	decimal(16,2)	YES
phy_no	smallint(6)	YES
rev_cd	varchar(4)	YES
cpt_cd	varchar(5)	YES
mod_1	varchar(2)	YES
mod_2	varchar(2)	YES
mod_3	varchar(2)	YES
claim_typ	varchar(1)	YES
rm_chrg	varchar(1)	YES
not_in_cdm	varchar(1)	YES

References

Local Column

References

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

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.chmexdtl	lab_amt
aurora_standard.chmexdtl	non_cov_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

mod_1

Table	Column
aurora_standard.axlscdm	md_mod_1
aurora_standard.axlscdm	ci_mod_1
aurora_standard.chmprica	prev_mod_1
aurora_standard.chmprica	cur_mod_1

mod_2

Table	Column
aurora_standard.axlscdm	md_mod_2
aurora_standard.axlscdm	ci_mod_2
aurora_standard.chmprica	prev_mod_2
aurora_standard.chmprica	cur_mod_2

rev_cd

Table	Column
aurora_standard.bfcdminv	d_rev_cd
aurora_standard.bfcdmpro	d_rev_cd
aurora_standard.bfcdmrhc	d_rev_cd
aurora_standard.chmsubcc	start_rev_cd
aurora_standard.chmsubcc	end_rev_cd
aurora_standard.hl7dg1	drg_grp_rev_cd

vis_no

Table	Column
aurora_standard.bmvis	moms_vis_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