aurora_standard.axlscdm

Field	Type	Null
fac	varchar(10)	YES
serv_code	varchar(10)	NO
type_code	varchar(20)	YES
dept	varchar(4)	YES
charge_1	decimal(16,2)	YES
bill_descrip	varchar(50)	YES
other_desc	varchar(50)	YES
gl_ip_no	varchar(10)	YES
gl_ip_dept	varchar(10)	YES
gl_op_no	varchar(10)	YES
gl_op_dept	varchar(10)	YES
unit_cost	varchar(10)	YES
other_cost	varchar(10)	YES
inactive_flag	varchar(1)	YES
ndc	varchar(20)	YES
rev_cd	varchar(10)	YES
cpt_code	varchar(10)	YES
mod_1	varchar(2)	YES
mod_2	varchar(2)	YES
ub_flag	varchar(1)	YES
md_rev	varchar(4)	YES
md_cpt_code	varchar(10)	YES
md_mod_1	varchar(2)	YES
md_mod_2	varchar(2)	YES
md_ub_flag	varchar(1)	YES
ci_rev	varchar(4)	YES
ci_cpt_code	varchar(10)	YES
ci_mod_1	varchar(2)	YES
ci_mod_2	varchar(2)	YES
ci_ub_flag	varchar(1)	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.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

ndc

Table	Column
_1.charts_cpt_codes	chcp_ndc
_1.configured_encounters_templates_cpt_codes	cetcc_ndc
_1.encounters_cpt_codes	ecp_ndc
_1.encounters_cpt_codes_templates	ecpt_ndc
_1.immunizations	imz_ndc
_1188.charts_cpt_codes	chcp_ndc
_1188.configured_encounters_templates_cpt_codes	cetcc_ndc
_1188.encounters_cpt_codes	ecp_ndc
_1188.encounters_cpt_codes_templates	ecpt_ndc
_1188.immunizations	imz_ndc
_1218.charts_cpt_codes	chcp_ndc
_1218.configured_encounters_templates_cpt_codes	cetcc_ndc
_1218.encounters_cpt_codes	ecp_ndc
_1218.encounters_cpt_codes_templates	ecpt_ndc
_1218.immunizations	imz_ndc
_1548.charts_cpt_codes	chcp_ndc
_1548.configured_encounters_templates_cpt_codes	cetcc_ndc
_1548.encounters_cpt_codes	ecp_ndc
_1548.encounters_cpt_codes_templates	ecpt_ndc
_1548.immunizations	imz_ndc
_435.charts_cpt_codes	chcp_ndc
_435.configured_encounters_templates_cpt_codes	cetcc_ndc
_435.encounters_cpt_codes	ecp_ndc
_435.encounters_cpt_codes_templates	ecpt_ndc
_435.immunizations	imz_ndc
_436.charts_cpt_codes	chcp_ndc
_436.configured_encounters_templates_cpt_codes	cetcc_ndc
_436.encounters_cpt_codes	ecp_ndc
_436.encounters_cpt_codes_templates	ecpt_ndc
_436.immunizations	imz_ndc
_436_archive_testing.charts_cpt_codes	chcp_ndc
_436_archive_testing.configured_encounters_templates_cpt_codes	cetcc_ndc
_436_archive_testing.encounters_cpt_codes	ecp_ndc
_436_archive_testing.encounters_cpt_codes_templates	ecpt_ndc
_436_archive_testing.immunizations	imz_ndc
_437.charts_cpt_codes	chcp_ndc
_437.configured_encounters_templates_cpt_codes	cetcc_ndc
_437.encounters_cpt_codes	ecp_ndc
_437.encounters_cpt_codes_templates	ecpt_ndc
_437.immunizations	imz_ndc
_8.charts_cpt_codes	chcp_ndc
_8.configured_encounters_templates_cpt_codes	cetcc_ndc
_8.encounters_cpt_codes	ecp_ndc
_8.encounters_cpt_codes_templates	ecpt_ndc
_8.immunizations	imz_ndc
_81.charts_cpt_codes	chcp_ndc
_81.configured_encounters_templates_cpt_codes	cetcc_ndc
_81.encounters_cpt_codes	ecp_ndc
_81.encounters_cpt_codes_templates	ecpt_ndc
_81.immunizations	imz_ndc
_999.charts_cpt_codes	chcp_ndc
_999.configured_encounters_templates_cpt_codes	cetcc_ndc
_999.encounters_cpt_codes	ecp_ndc
_999.encounters_cpt_codes_templates	ecpt_ndc
_999.immunizations	imz_ndc
template_library.encounters_cpt_codes_templates	ecpt_ndc

type_code

Table	Column
_1.hl7_accessions	acc_type_code
_1.patients_icd9_problems_dx_modifiers	pipdm_type_code
_1188.hl7_accessions	acc_type_code
_1188.patients_icd9_problems_dx_modifiers	pipdm_type_code
_1218.hl7_accessions	acc_type_code
_1218.patients_icd9_problems_dx_modifiers	pipdm_type_code
_1548.hl7_accessions	acc_type_code
_1548.patients_icd9_problems_dx_modifiers	pipdm_type_code
_435.hl7_accessions	acc_type_code
_435.patients_icd9_problems_dx_modifiers	pipdm_type_code
_436.hl7_accessions	acc_type_code
_436.patients_icd9_problems_dx_modifiers	pipdm_type_code
_436_archive_testing.hl7_accessions	acc_type_code
_436_archive_testing.patients_icd9_problems_dx_modifiers	pipdm_type_code
_437.hl7_accessions	acc_type_code
_437.patients_icd9_problems_dx_modifiers	pipdm_type_code
_8.hl7_accessions	acc_type_code
_8.patients_icd9_problems_dx_modifiers	pipdm_type_code
_81.hl7_accessions	acc_type_code
_81.patients_icd9_problems_dx_modifiers	pipdm_type_code
_999.hl7_accessions	acc_type_code
_999.patients_icd9_problems_dx_modifiers	pipdm_type_code
aurora_standard.stmaintd	maint_type_code
aurora_standard.stmnoted	note_type_code
aurora_standard.stmwarrd	warr_type_code
common.clients	cli_service_type_code

fac

Table	Column
aurora_standard.TABLE 1424	new_fac
aurora_standard.TABLE 1425	new_fac
aurora_standard.chmcntrc	batch_by_fac
aurora_standard.chmpaytc	pmt_fac
aurora_standard.chmpaytc	adj_fac
aurora_standard.chmpaytc	ar_fac
aurora_standard.chpcntrc	cobra_cash_fac
aurora_standard.chpcntrc	cobra_bal_fac
aurora_standard.chpcntrc	cobra_fee_fac
aurora_standard.chscustd	dept_fac
aurora_standard.glxref	new_fac
aurora_standard.glxref	old_fac
aurora_standard.hl7msh	send_fac
aurora_standard.hl7msh	rec_fac
aurora_standard.hl7mshad	send_fac
aurora_standard.hl7mshad	rec_fac
aurora_standard.hl7pd1	pat_prim_fac
aurora_standard.hl7pd1ad	pat_prim_fac
aurora_standard.hl7pv1	servicing_fac
aurora_standard.hl7pv1ad	servicing_fac

dept

Table	Column
aurora_standard.TABLE 1424	new_dept
aurora_standard.TABLE 1425	new_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

other_desc

Table	Column
aurora_standard.chmbillc	form_other_desc

serv_code

Table	Column
aurora_standard.chmpcatd	rad_serv_code

mod_1

Table	Column
aurora_standard.chmprica	prev_mod_1
aurora_standard.chmprica	cur_mod_1

mod_2

Table	Column
aurora_standard.chmprica	prev_mod_2
aurora_standard.chmprica	cur_mod_2

charge_1

Table	Column
aurora_standard.chmpricc	prev_charge_1

unit_cost

Table	Column
aurora_standard.gary13	calc_avg_unit_cost
aurora_standard.gary14	calc_avg_unit_cost
aurora_standard.gary2	avg_unit_cost
aurora_standard.pharm1	pricc_unit_cost
aurora_standard.stilocar	avg_unit_cost
aurora_standard.stilocar	purch_unit_cost
aurora_standard.stipurcd	purch_unit_cost
aurora_standard.tmplocar	avg_unit_cost
aurora_standard.tmplocar	purch_unit_cost