aurora_standard.aseycmh

Field	Type	Null
serv_code	char(10)	YES
bill_descrip	char(50)	YES
rev_cd	char(10)	YES
ins_cd	char(2)	YES
cpt	char(10)	YES
modifier	char(2)	YES
unit_cd	char(2)	YES
charge_amt	decimal(10,2)	YES
dept	char(3)	YES
fc1	char(2)	YES
cpt1	char(10)	YES
mod1	char(2)	YES
fc2	char(2)	YES
cpt2	char(10)	YES
mod2	char(2)	YES
fc3	char(2)	YES
cpt3	char(10)	YES

References

Local Column

References

mod1

Table	Column
_1.charts_cpt_codes	chcp_mod1
_1.charts_procedures	cp_mod1
_1.configured_encounters_templates_cpt_codes	cetcc_mod1
_1.encounters_cpt_codes	ecp_mod1
_1.encounters_cpt_codes_templates	ecpt_mod1
_1.patients_responsibility_estimates_services	prests_mod1
_1.precerts_cpt_codes	pcp_mod1
_1188.charts_cpt_codes	chcp_mod1
_1188.charts_procedures	cp_mod1
_1188.configured_encounters_templates_cpt_codes	cetcc_mod1
_1188.encounters_cpt_codes	ecp_mod1
_1188.encounters_cpt_codes_templates	ecpt_mod1
_1188.patients_responsibility_estimates_services	prests_mod1
_1188.precerts_cpt_codes	pcp_mod1
_1218.charts_cpt_codes	chcp_mod1
_1218.charts_procedures	cp_mod1
_1218.configured_encounters_templates_cpt_codes	cetcc_mod1
_1218.encounters_cpt_codes	ecp_mod1
_1218.encounters_cpt_codes_templates	ecpt_mod1
_1218.patients_responsibility_estimates_services	prests_mod1
_1218.precerts_cpt_codes	pcp_mod1
_1548.charts_cpt_codes	chcp_mod1
_1548.charts_procedures	cp_mod1
_1548.configured_encounters_templates_cpt_codes	cetcc_mod1
_1548.encounters_cpt_codes	ecp_mod1
_1548.encounters_cpt_codes_templates	ecpt_mod1
_1548.patients_responsibility_estimates_services	prests_mod1
_1548.precerts_cpt_codes	pcp_mod1
_435.charts_cpt_codes	chcp_mod1
_435.charts_procedures	cp_mod1
_435.configured_encounters_templates_cpt_codes	cetcc_mod1
_435.encounters_cpt_codes	ecp_mod1
_435.encounters_cpt_codes_templates	ecpt_mod1
_435.patients_responsibility_estimates_services	prests_mod1
_435.precerts_cpt_codes	pcp_mod1
_436.charts_cpt_codes	chcp_mod1
_436.charts_procedures	cp_mod1
_436.configured_encounters_templates_cpt_codes	cetcc_mod1
_436.encounters_cpt_codes	ecp_mod1
_436.encounters_cpt_codes_templates	ecpt_mod1
_436.patients_responsibility_estimates_services	prests_mod1
_436.precerts_cpt_codes	pcp_mod1
_436_archive_testing.charts_cpt_codes	chcp_mod1
_436_archive_testing.charts_procedures	cp_mod1
_436_archive_testing.configured_encounters_templates_cpt_codes	cetcc_mod1
_436_archive_testing.encounters_cpt_codes	ecp_mod1
_436_archive_testing.encounters_cpt_codes_templates	ecpt_mod1
_436_archive_testing.patients_responsibility_estimates_services	prests_mod1
_436_archive_testing.precerts_cpt_codes	pcp_mod1
_437.charts_cpt_codes	chcp_mod1
_437.charts_procedures	cp_mod1
_437.configured_encounters_templates_cpt_codes	cetcc_mod1
_437.encounters_cpt_codes	ecp_mod1
_437.encounters_cpt_codes_templates	ecpt_mod1
_437.patients_responsibility_estimates_services	prests_mod1
_437.precerts_cpt_codes	pcp_mod1
_8.charts_cpt_codes	chcp_mod1
_8.charts_procedures	cp_mod1
_8.configured_encounters_templates_cpt_codes	cetcc_mod1
_8.encounters_cpt_codes	ecp_mod1
_8.encounters_cpt_codes_templates	ecpt_mod1
_8.patients_responsibility_estimates_services	prests_mod1
_8.precerts_cpt_codes	pcp_mod1
_81.charts_cpt_codes	chcp_mod1
_81.charts_procedures	cp_mod1
_81.configured_encounters_templates_cpt_codes	cetcc_mod1
_81.encounters_cpt_codes	ecp_mod1
_81.encounters_cpt_codes_templates	ecpt_mod1
_81.patients_responsibility_estimates_services	prests_mod1
_81.precerts_cpt_codes	pcp_mod1
_999.charts_cpt_codes	chcp_mod1
_999.charts_procedures	cp_mod1
_999.configured_encounters_templates_cpt_codes	cetcc_mod1
_999.encounters_cpt_codes	ecp_mod1
_999.encounters_cpt_codes_templates	ecpt_mod1
_999.patients_responsibility_estimates_services	prests_mod1
_999.precerts_cpt_codes	pcp_mod1
template_library.encounters_cpt_codes_templates	ecpt_mod1

mod2

Table	Column
_1.charts_cpt_codes	chcp_mod2
_1.charts_procedures	cp_mod2
_1.configured_encounters_templates_cpt_codes	cetcc_mod2
_1.encounters_cpt_codes	ecp_mod2
_1.encounters_cpt_codes_templates	ecpt_mod2
_1.patients_responsibility_estimates_services	prests_mod2
_1.precerts_cpt_codes	pcp_mod2
_1188.charts_cpt_codes	chcp_mod2
_1188.charts_procedures	cp_mod2
_1188.configured_encounters_templates_cpt_codes	cetcc_mod2
_1188.encounters_cpt_codes	ecp_mod2
_1188.encounters_cpt_codes_templates	ecpt_mod2
_1188.patients_responsibility_estimates_services	prests_mod2
_1188.precerts_cpt_codes	pcp_mod2
_1218.charts_cpt_codes	chcp_mod2
_1218.charts_procedures	cp_mod2
_1218.configured_encounters_templates_cpt_codes	cetcc_mod2
_1218.encounters_cpt_codes	ecp_mod2
_1218.encounters_cpt_codes_templates	ecpt_mod2
_1218.patients_responsibility_estimates_services	prests_mod2
_1218.precerts_cpt_codes	pcp_mod2
_1548.charts_cpt_codes	chcp_mod2
_1548.charts_procedures	cp_mod2
_1548.configured_encounters_templates_cpt_codes	cetcc_mod2
_1548.encounters_cpt_codes	ecp_mod2
_1548.encounters_cpt_codes_templates	ecpt_mod2
_1548.patients_responsibility_estimates_services	prests_mod2
_1548.precerts_cpt_codes	pcp_mod2
_435.charts_cpt_codes	chcp_mod2
_435.charts_procedures	cp_mod2
_435.configured_encounters_templates_cpt_codes	cetcc_mod2
_435.encounters_cpt_codes	ecp_mod2
_435.encounters_cpt_codes_templates	ecpt_mod2
_435.patients_responsibility_estimates_services	prests_mod2
_435.precerts_cpt_codes	pcp_mod2
_436.charts_cpt_codes	chcp_mod2
_436.charts_procedures	cp_mod2
_436.configured_encounters_templates_cpt_codes	cetcc_mod2
_436.encounters_cpt_codes	ecp_mod2
_436.encounters_cpt_codes_templates	ecpt_mod2
_436.patients_responsibility_estimates_services	prests_mod2
_436.precerts_cpt_codes	pcp_mod2
_436_archive_testing.charts_cpt_codes	chcp_mod2
_436_archive_testing.charts_procedures	cp_mod2
_436_archive_testing.configured_encounters_templates_cpt_codes	cetcc_mod2
_436_archive_testing.encounters_cpt_codes	ecp_mod2
_436_archive_testing.encounters_cpt_codes_templates	ecpt_mod2
_436_archive_testing.patients_responsibility_estimates_services	prests_mod2
_436_archive_testing.precerts_cpt_codes	pcp_mod2
_437.charts_cpt_codes	chcp_mod2
_437.charts_procedures	cp_mod2
_437.configured_encounters_templates_cpt_codes	cetcc_mod2
_437.encounters_cpt_codes	ecp_mod2
_437.encounters_cpt_codes_templates	ecpt_mod2
_437.patients_responsibility_estimates_services	prests_mod2
_437.precerts_cpt_codes	pcp_mod2
_8.charts_cpt_codes	chcp_mod2
_8.charts_procedures	cp_mod2
_8.configured_encounters_templates_cpt_codes	cetcc_mod2
_8.encounters_cpt_codes	ecp_mod2
_8.encounters_cpt_codes_templates	ecpt_mod2
_8.patients_responsibility_estimates_services	prests_mod2
_8.precerts_cpt_codes	pcp_mod2
_81.charts_cpt_codes	chcp_mod2
_81.charts_procedures	cp_mod2
_81.configured_encounters_templates_cpt_codes	cetcc_mod2
_81.encounters_cpt_codes	ecp_mod2
_81.encounters_cpt_codes_templates	ecpt_mod2
_81.patients_responsibility_estimates_services	prests_mod2
_81.precerts_cpt_codes	pcp_mod2
_999.charts_cpt_codes	chcp_mod2
_999.charts_procedures	cp_mod2
_999.configured_encounters_templates_cpt_codes	cetcc_mod2
_999.encounters_cpt_codes	ecp_mod2
_999.encounters_cpt_codes_templates	ecpt_mod2
_999.patients_responsibility_estimates_services	prests_mod2
_999.precerts_cpt_codes	pcp_mod2
template_library.encounters_cpt_codes_templates	ecpt_mod2

modifier

Table	Column
_1.clients_fee_schedules_map	cfsm_modifier
_1.cpt	cpt_modifier
_1.cpt_analysis_codes	cac_modifier
_1188.clients_fee_schedules_map	cfsm_modifier
_1188.cpt	cpt_modifier
_1188.cpt_analysis_codes	cac_modifier
_1218.clients_fee_schedules_map	cfsm_modifier
_1218.cpt	cpt_modifier
_1218.cpt_analysis_codes	cac_modifier
_1548.clients_fee_schedules_map	cfsm_modifier
_1548.cpt	cpt_modifier
_1548.cpt_analysis_codes	cac_modifier
_435.clients_fee_schedules_map	cfsm_modifier
_435.cpt	cpt_modifier
_435.cpt_analysis_codes	cac_modifier
_436.clients_fee_schedules_map	cfsm_modifier
_436.cpt	cpt_modifier
_436.cpt_analysis_codes	cac_modifier
_436_archive_testing.clients_fee_schedules_map	cfsm_modifier
_436_archive_testing.cpt	cpt_modifier
_436_archive_testing.cpt_analysis_codes	cac_modifier
_437.clients_fee_schedules_map	cfsm_modifier
_437.cpt	cpt_modifier
_437.cpt_analysis_codes	cac_modifier
_8.clients_fee_schedules_map	cfsm_modifier
_8.cpt	cpt_modifier
_8.cpt_analysis_codes	cac_modifier
_81.clients_fee_schedules_map	cfsm_modifier
_81.cpt	cpt_modifier
_81.cpt_analysis_codes	cac_modifier
_999.clients_fee_schedules_map	cfsm_modifier
_999.cpt	cpt_modifier
_999.cpt_analysis_codes	cac_modifier
aurora_standard.chmachgd	cpt_modifier
common.cqm_conditions	cqc_target_att_modifier
common.cqm_conditions	cqc_target2_att_modifier
template_library.cpt	cpt_modifier

cpt

Table	Column
_1.orders_test_codes_map	otcm_cpt
_1188.orders_test_codes_map	otcm_cpt
_1218.orders_test_codes_map	otcm_cpt
_1548.orders_test_codes_map	otcm_cpt
_435.orders_test_codes_map	otcm_cpt
_436.orders_test_codes_map	otcm_cpt
_436_archive_testing.orders_test_codes_map	otcm_cpt
_437.orders_test_codes_map	otcm_cpt
_8.orders_test_codes_map	otcm_cpt
_81.orders_test_codes_map	otcm_cpt
_999.orders_test_codes_map	otcm_cpt
aurora_standard.apscdm	mc_cpt
aurora_standard.apscdm	md_cpt
aurora_standard.apscdm	ci_cpt
aurora_standard.apscdm	wc_cpt
aurora_standard.apscdma	mc_cpt
aurora_standard.apscdma	md_cpt
aurora_standard.apscdma	ci_cpt
aurora_standard.apscdma	wc_cpt
aurora_standard.bfcdm	md_cpt
aurora_standard.bfrhccdm	md_cpt
aurora_standard.chmokopd	prin_cpt
aurora_standard.chmsubcc	start_cpt
aurora_standard.chmsubcc	end_cpt
aurora_standard.samcdmc	mc_cpt
aurora_standard.samcdmc	md_cpt
aurora_standard.workcpt	wk_cpt
common.test_codes	tco_cpt

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

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

ins_cd

Table	Column
aurora_standard.chhl7in2	non_cover_ins_cd
aurora_standard.hl7in2	non_cover_ins_cd
aurora_standard.hl7in2ad	non_cover_ins_cd

serv_code

Table	Column
aurora_standard.chmpcatd	rad_serv_code