aurora_standard.c7cdm

Field	Type	Null	Key
service_code	varchar(10)	YES
type_code	varchar(1)	YES
department	varchar(4)	YES
issue_unit	varchar(10)	YES
charge_1	decimal(16,2)	YES
charge_2	decimal(16,2)	YES
charge_3	decimal(16,2)	YES
ub_flag	varchar(1)	YES
ub_rev_code	varchar(10)	YES	MUL
flag_1500	varchar(1)	YES
cpt_code	varchar(10)	YES
primary_descrip	varchar(30)	YES	MUL
other_descrip	varchar(20)	YES
gl_inp_no	int(11)	YES
gl_inp_no_d	varchar(3)	YES
gl_out_no	int(11)	YES
gl_out_no_d	varchar(3)	YES
unit_cost	decimal(16,2)	YES
inactive_flag	varchar(1)	YES
ndc	varchar(13)	YES
hcpcs_code	varchar(10)	YES
md_rev_code	varchar(4)	YES
comm_rev_code	varchar(4)	YES
comm_cpt_code	varchar(10)	YES
fac_no	varchar(3)	YES
mod_1	varchar(2)	YES
mod_2	varchar(2)	YES
mod_3	varchar(2)	YES
mod_4	varchar(2)	YES
mod_5	varchar(2)	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.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

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

ub_flag

Table	Column
aurora_standard.axlscdm	md_ub_flag
aurora_standard.axlscdm	ci_ub_flag

fac_no

Table	Column
aurora_standard.chmprica	prev_fac_no
aurora_standard.chmprica	cur_fac_no
aurora_standard.chpcashr	cash_fac_no
aurora_standard.chpcobpd	cash_fac_no
aurora_standard.chpcobpd	bal_fac_no
aurora_standard.chscustd	dept_fac_no
aurora_standard.chshotlr	dept_fac_no
aurora_standard.chtemplr	dflt_fac_no
aurora_standard.curs_temp	cash_fac_no
aurora_standard.curs_temp	ap_fac_no
aurora_standard.stgrowpd	rod_beg_fac_no
aurora_standard.stgrowpd	rod_end_fac_no
aurora_standard.stpcashd	dist_fac_no
aurora_standard.stpcashd	disc_fac_no
aurora_standard.stpcashe	cash_fac_no
aurora_standard.stpcntrc	cash_fac_no
aurora_standard.stpcntrc	disc_fac_no
aurora_standard.stpinvce	cash_fac_no
aurora_standard.stpopend	ap_fac_no
aurora_standard.stpopend	cash_fac_no
aurora_standard.stucntrc	cash_fac_no
aurora_standard.stuinvce	cash_fac_no
aurora_standard.stxfinsd	fin_fac_no
aurora_standard.styaccrr	liab_fac_no
aurora_standard.styaccrr	expense_fac_no
aurora_standard.styemplr	cash_fac_no
aurora_standard.stypayfd	cash_fac_no
aurora_standard.stypayod	bal_fac_no
aurora_standard.stypayre	cash_fac_no
aurora_standard.styrevsd	cash_fac_no
aurora_standard.stytyper	cash_fac_no

charge_1

Table	Column
aurora_standard.chmpricc	prev_charge_1

ub_rev_code

Table	Column
aurora_standard.chmstatc	def_ub_rev_code

department

Table	Column
aurora_standard.curs_temp	cash_department
aurora_standard.sticntrc	use_department
aurora_standard.stpcashd	dist_department
aurora_standard.stpcashd	disc_department
aurora_standard.stpcashe	cash_department
aurora_standard.stpcashe	oa_department
aurora_standard.stpinvce	disc_department
aurora_standard.stpinvce	ap_department
aurora_standard.stpinvce	cash_department
aurora_standard.stpopend	ap_department
aurora_standard.stpopend	cash_department
aurora_standard.stpvendr	cash_department
aurora_standard.stpvendr	exp_department
aurora_standard.strcashd	dist_department
aurora_standard.strcashd	disc_department
aurora_standard.strcashe	cash_department
aurora_standard.strcashe	oa_department
aurora_standard.strinvce	disc_department
aurora_standard.strinvce	tax_department
aurora_standard.strinvce	frght_department
aurora_standard.strinvce	misc_department
aurora_standard.strinvce	ar_department
aurora_standard.stropend	ar_department
aurora_standard.stucntrc	use_department
aurora_standard.styapckd	dist_department
aurora_standard.stydeddv	home_department
aurora_standard.stydeddv	gl_department
aurora_standard.styincdv	home_department
aurora_standard.styincdv	gl_department
aurora_standard.styobldv	home_department
aurora_standard.styobldv	gl_department
aurora_standard.styptodv	home_department
common.service_tickets	stc_department

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