aurora_standard.chmpsvcd

Field	Type	Null	Key
fac_name	varchar(30)	YES
visit_no	varchar(10)	NO	MUL
line_no	varchar(6)	NO
chg_code	varchar(10)	NO
bill_amt	varchar(16)	YES
paid_amt	varchar(16)	YES
adj_amt	varchar(16)	YES
cur_bal	varchar(16)	YES
chg_dte	varchar(10)	YES
cpt_code	varchar(10)	YES
mod1	varchar(2)	YES
mod2	varchar(2)	YES
mod3	varchar(2)	YES
mod4	varchar(2)	YES
dx1	varchar(40)	YES
dx2	varchar(40)	YES
dx3	varchar(40)	YES
dx4	varchar(40)	YES
dx5	varchar(40)	YES
dx6	varchar(40)	YES
dx7	varchar(40)	YES
dx8	varchar(40)	YES
dx9	varchar(40)	YES
dx10	varchar(40)	YES
dx11	varchar(40)	YES
dx12	varchar(40)	YES
pos	varchar(2)	YES
rend_phy	varchar(10)	YES
rend_fname	varchar(20)	YES
rend_mname	varchar(20)	YES
rend_lname	varchar(20)	YES
rend_title	varchar(10)	YES
ref_phy	varchar(10)	YES
ref_fname	varchar(20)	YES
ref_mname	varchar(20)	YES
ref_lname	varchar(20)	YES
ref_title	varchar(10)	YES
svc_note	varchar(30)	YES
procedure_1	varchar(40)	YES
spec_hand	varchar(2)	YES
cur_fc	varchar(2)	YES
new_or_upd	varchar(3)	YES
medicare_flag	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.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

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

mod3

Table	Column
_1.charts_cpt_codes	chcp_mod3
_1.charts_procedures	cp_mod3
_1.configured_encounters_templates_cpt_codes	cetcc_mod3
_1.encounters_cpt_codes	ecp_mod3
_1.encounters_cpt_codes_templates	ecpt_mod3
_1.patients_responsibility_estimates_services	prests_mod3
_1.precerts_cpt_codes	pcp_mod3
_1188.charts_cpt_codes	chcp_mod3
_1188.charts_procedures	cp_mod3
_1188.configured_encounters_templates_cpt_codes	cetcc_mod3
_1188.encounters_cpt_codes	ecp_mod3
_1188.encounters_cpt_codes_templates	ecpt_mod3
_1188.patients_responsibility_estimates_services	prests_mod3
_1188.precerts_cpt_codes	pcp_mod3
_1218.charts_cpt_codes	chcp_mod3
_1218.charts_procedures	cp_mod3
_1218.configured_encounters_templates_cpt_codes	cetcc_mod3
_1218.encounters_cpt_codes	ecp_mod3
_1218.encounters_cpt_codes_templates	ecpt_mod3
_1218.patients_responsibility_estimates_services	prests_mod3
_1218.precerts_cpt_codes	pcp_mod3
_1548.charts_cpt_codes	chcp_mod3
_1548.charts_procedures	cp_mod3
_1548.configured_encounters_templates_cpt_codes	cetcc_mod3
_1548.encounters_cpt_codes	ecp_mod3
_1548.encounters_cpt_codes_templates	ecpt_mod3
_1548.patients_responsibility_estimates_services	prests_mod3
_1548.precerts_cpt_codes	pcp_mod3
_435.charts_cpt_codes	chcp_mod3
_435.charts_procedures	cp_mod3
_435.configured_encounters_templates_cpt_codes	cetcc_mod3
_435.encounters_cpt_codes	ecp_mod3
_435.encounters_cpt_codes_templates	ecpt_mod3
_435.patients_responsibility_estimates_services	prests_mod3
_435.precerts_cpt_codes	pcp_mod3
_436.charts_cpt_codes	chcp_mod3
_436.charts_procedures	cp_mod3
_436.configured_encounters_templates_cpt_codes	cetcc_mod3
_436.encounters_cpt_codes	ecp_mod3
_436.encounters_cpt_codes_templates	ecpt_mod3
_436.patients_responsibility_estimates_services	prests_mod3
_436.precerts_cpt_codes	pcp_mod3
_436_archive_testing.charts_cpt_codes	chcp_mod3
_436_archive_testing.charts_procedures	cp_mod3
_436_archive_testing.configured_encounters_templates_cpt_codes	cetcc_mod3
_436_archive_testing.encounters_cpt_codes	ecp_mod3
_436_archive_testing.encounters_cpt_codes_templates	ecpt_mod3
_436_archive_testing.patients_responsibility_estimates_services	prests_mod3
_436_archive_testing.precerts_cpt_codes	pcp_mod3
_437.charts_cpt_codes	chcp_mod3
_437.charts_procedures	cp_mod3
_437.configured_encounters_templates_cpt_codes	cetcc_mod3
_437.encounters_cpt_codes	ecp_mod3
_437.encounters_cpt_codes_templates	ecpt_mod3
_437.patients_responsibility_estimates_services	prests_mod3
_437.precerts_cpt_codes	pcp_mod3
_8.charts_cpt_codes	chcp_mod3
_8.charts_procedures	cp_mod3
_8.configured_encounters_templates_cpt_codes	cetcc_mod3
_8.encounters_cpt_codes	ecp_mod3
_8.encounters_cpt_codes_templates	ecpt_mod3
_8.patients_responsibility_estimates_services	prests_mod3
_8.precerts_cpt_codes	pcp_mod3
_81.charts_cpt_codes	chcp_mod3
_81.charts_procedures	cp_mod3
_81.configured_encounters_templates_cpt_codes	cetcc_mod3
_81.encounters_cpt_codes	ecp_mod3
_81.encounters_cpt_codes_templates	ecpt_mod3
_81.patients_responsibility_estimates_services	prests_mod3
_81.precerts_cpt_codes	pcp_mod3
_999.charts_cpt_codes	chcp_mod3
_999.charts_procedures	cp_mod3
_999.configured_encounters_templates_cpt_codes	cetcc_mod3
_999.encounters_cpt_codes	ecp_mod3
_999.encounters_cpt_codes_templates	ecpt_mod3
_999.patients_responsibility_estimates_services	prests_mod3
_999.precerts_cpt_codes	pcp_mod3
template_library.encounters_cpt_codes_templates	ecpt_mod3

mod4

Table	Column
_1.charts_cpt_codes	chcp_mod4
_1.charts_procedures	cp_mod4
_1.configured_encounters_templates_cpt_codes	cetcc_mod4
_1.encounters_cpt_codes	ecp_mod4
_1.encounters_cpt_codes_templates	ecpt_mod4
_1.patients_responsibility_estimates_services	prests_mod4
_1.precerts_cpt_codes	pcp_mod4
_1188.charts_cpt_codes	chcp_mod4
_1188.charts_procedures	cp_mod4
_1188.configured_encounters_templates_cpt_codes	cetcc_mod4
_1188.encounters_cpt_codes	ecp_mod4
_1188.encounters_cpt_codes_templates	ecpt_mod4
_1188.patients_responsibility_estimates_services	prests_mod4
_1188.precerts_cpt_codes	pcp_mod4
_1218.charts_cpt_codes	chcp_mod4
_1218.charts_procedures	cp_mod4
_1218.configured_encounters_templates_cpt_codes	cetcc_mod4
_1218.encounters_cpt_codes	ecp_mod4
_1218.encounters_cpt_codes_templates	ecpt_mod4
_1218.patients_responsibility_estimates_services	prests_mod4
_1218.precerts_cpt_codes	pcp_mod4
_1548.charts_cpt_codes	chcp_mod4
_1548.charts_procedures	cp_mod4
_1548.configured_encounters_templates_cpt_codes	cetcc_mod4
_1548.encounters_cpt_codes	ecp_mod4
_1548.encounters_cpt_codes_templates	ecpt_mod4
_1548.patients_responsibility_estimates_services	prests_mod4
_1548.precerts_cpt_codes	pcp_mod4
_435.charts_cpt_codes	chcp_mod4
_435.charts_procedures	cp_mod4
_435.configured_encounters_templates_cpt_codes	cetcc_mod4
_435.encounters_cpt_codes	ecp_mod4
_435.encounters_cpt_codes_templates	ecpt_mod4
_435.patients_responsibility_estimates_services	prests_mod4
_435.precerts_cpt_codes	pcp_mod4
_436.charts_cpt_codes	chcp_mod4
_436.charts_procedures	cp_mod4
_436.configured_encounters_templates_cpt_codes	cetcc_mod4
_436.encounters_cpt_codes	ecp_mod4
_436.encounters_cpt_codes_templates	ecpt_mod4
_436.patients_responsibility_estimates_services	prests_mod4
_436.precerts_cpt_codes	pcp_mod4
_436_archive_testing.charts_cpt_codes	chcp_mod4
_436_archive_testing.charts_procedures	cp_mod4
_436_archive_testing.configured_encounters_templates_cpt_codes	cetcc_mod4
_436_archive_testing.encounters_cpt_codes	ecp_mod4
_436_archive_testing.encounters_cpt_codes_templates	ecpt_mod4
_436_archive_testing.patients_responsibility_estimates_services	prests_mod4
_436_archive_testing.precerts_cpt_codes	pcp_mod4
_437.charts_cpt_codes	chcp_mod4
_437.charts_procedures	cp_mod4
_437.configured_encounters_templates_cpt_codes	cetcc_mod4
_437.encounters_cpt_codes	ecp_mod4
_437.encounters_cpt_codes_templates	ecpt_mod4
_437.patients_responsibility_estimates_services	prests_mod4
_437.precerts_cpt_codes	pcp_mod4
_8.charts_cpt_codes	chcp_mod4
_8.charts_procedures	cp_mod4
_8.configured_encounters_templates_cpt_codes	cetcc_mod4
_8.encounters_cpt_codes	ecp_mod4
_8.encounters_cpt_codes_templates	ecpt_mod4
_8.patients_responsibility_estimates_services	prests_mod4
_8.precerts_cpt_codes	pcp_mod4
_81.charts_cpt_codes	chcp_mod4
_81.charts_procedures	cp_mod4
_81.configured_encounters_templates_cpt_codes	cetcc_mod4
_81.encounters_cpt_codes	ecp_mod4
_81.encounters_cpt_codes_templates	ecpt_mod4
_81.patients_responsibility_estimates_services	prests_mod4
_81.precerts_cpt_codes	pcp_mod4
_999.charts_cpt_codes	chcp_mod4
_999.charts_procedures	cp_mod4
_999.configured_encounters_templates_cpt_codes	cetcc_mod4
_999.encounters_cpt_codes	ecp_mod4
_999.encounters_cpt_codes_templates	ecpt_mod4
_999.patients_responsibility_estimates_services	prests_mod4
_999.precerts_cpt_codes	pcp_mod4
template_library.encounters_cpt_codes_templates	ecpt_mod4

dx1

Table	Column
_1.encounters_cpt_codes	ecp_dx1
_1.encounters_cpt_codes	ecp_dx10
_1.precerts_cpt_codes	pcp_dx1
_1188.encounters_cpt_codes	ecp_dx1
_1188.encounters_cpt_codes	ecp_dx10
_1188.precerts_cpt_codes	pcp_dx1
_1218.encounters_cpt_codes	ecp_dx1
_1218.encounters_cpt_codes	ecp_dx10
_1218.precerts_cpt_codes	pcp_dx1
_1548.encounters_cpt_codes	ecp_dx1
_1548.encounters_cpt_codes	ecp_dx10
_1548.precerts_cpt_codes	pcp_dx1
_435.encounters_cpt_codes	ecp_dx1
_435.encounters_cpt_codes	ecp_dx10
_435.precerts_cpt_codes	pcp_dx1
_436.encounters_cpt_codes	ecp_dx1
_436.encounters_cpt_codes	ecp_dx10
_436.precerts_cpt_codes	pcp_dx1
_436_archive_testing.encounters_cpt_codes	ecp_dx1
_436_archive_testing.encounters_cpt_codes	ecp_dx10
_436_archive_testing.precerts_cpt_codes	pcp_dx1
_437.encounters_cpt_codes	ecp_dx1
_437.encounters_cpt_codes	ecp_dx10
_437.precerts_cpt_codes	pcp_dx1
_8.encounters_cpt_codes	ecp_dx1
_8.encounters_cpt_codes	ecp_dx10
_8.precerts_cpt_codes	pcp_dx1
_81.encounters_cpt_codes	ecp_dx1
_81.encounters_cpt_codes	ecp_dx10
_81.precerts_cpt_codes	pcp_dx1
_999.encounters_cpt_codes	ecp_dx1
_999.encounters_cpt_codes	ecp_dx10
_999.precerts_cpt_codes	pcp_dx1
aurora_standard.chmadmpr	admit_dx1
aurora_standard.chmcostrc	reason_dx1
aurora_standard.chmhid4c	reason_dx1
aurora_standard.chmmhast	other_dx1
aurora_standard.chmmhast	other_dx10
aurora_standard.chmmhast	other_dx11
aurora_standard.chmmhast	other_dx12
aurora_standard.chmmhast	poa_dx1
aurora_standard.chmmhast	poa_dx10
aurora_standard.chmmhast	poa_dx11
aurora_standard.chmmhast	poa_dx12

dx2

Table	Column
_1.encounters_cpt_codes	ecp_dx2
_1.precerts_cpt_codes	pcp_dx2
_1188.encounters_cpt_codes	ecp_dx2
_1188.precerts_cpt_codes	pcp_dx2
_1218.encounters_cpt_codes	ecp_dx2
_1218.precerts_cpt_codes	pcp_dx2
_1548.encounters_cpt_codes	ecp_dx2
_1548.precerts_cpt_codes	pcp_dx2
_435.encounters_cpt_codes	ecp_dx2
_435.precerts_cpt_codes	pcp_dx2
_436.encounters_cpt_codes	ecp_dx2
_436.precerts_cpt_codes	pcp_dx2
_436_archive_testing.encounters_cpt_codes	ecp_dx2
_436_archive_testing.precerts_cpt_codes	pcp_dx2
_437.encounters_cpt_codes	ecp_dx2
_437.precerts_cpt_codes	pcp_dx2
_8.encounters_cpt_codes	ecp_dx2
_8.precerts_cpt_codes	pcp_dx2
_81.encounters_cpt_codes	ecp_dx2
_81.precerts_cpt_codes	pcp_dx2
_999.encounters_cpt_codes	ecp_dx2
_999.precerts_cpt_codes	pcp_dx2
aurora_standard.chmadmpr	admit_dx2
aurora_standard.chmcostrc	reason_dx2
aurora_standard.chmhid4c	reason_dx2
aurora_standard.chmmhast	other_dx2
aurora_standard.chmmhast	poa_dx2

dx3

Table	Column
_1.encounters_cpt_codes	ecp_dx3
_1.precerts_cpt_codes	pcp_dx3
_1188.encounters_cpt_codes	ecp_dx3
_1188.precerts_cpt_codes	pcp_dx3
_1218.encounters_cpt_codes	ecp_dx3
_1218.precerts_cpt_codes	pcp_dx3
_1548.encounters_cpt_codes	ecp_dx3
_1548.precerts_cpt_codes	pcp_dx3
_435.encounters_cpt_codes	ecp_dx3
_435.precerts_cpt_codes	pcp_dx3
_436.encounters_cpt_codes	ecp_dx3
_436.precerts_cpt_codes	pcp_dx3
_436_archive_testing.encounters_cpt_codes	ecp_dx3
_436_archive_testing.precerts_cpt_codes	pcp_dx3
_437.encounters_cpt_codes	ecp_dx3
_437.precerts_cpt_codes	pcp_dx3
_8.encounters_cpt_codes	ecp_dx3
_8.precerts_cpt_codes	pcp_dx3
_81.encounters_cpt_codes	ecp_dx3
_81.precerts_cpt_codes	pcp_dx3
_999.encounters_cpt_codes	ecp_dx3
_999.precerts_cpt_codes	pcp_dx3
aurora_standard.chmadmpr	admit_dx3
aurora_standard.chmcostrc	reason_dx3
aurora_standard.chmhid4c	reason_dx3
aurora_standard.chmmhast	other_dx3
aurora_standard.chmmhast	poa_dx3

dx4

Table	Column
_1.encounters_cpt_codes	ecp_dx4
_1.precerts_cpt_codes	pcp_dx4
_1188.encounters_cpt_codes	ecp_dx4
_1188.precerts_cpt_codes	pcp_dx4
_1218.encounters_cpt_codes	ecp_dx4
_1218.precerts_cpt_codes	pcp_dx4
_1548.encounters_cpt_codes	ecp_dx4
_1548.precerts_cpt_codes	pcp_dx4
_435.encounters_cpt_codes	ecp_dx4
_435.precerts_cpt_codes	pcp_dx4
_436.encounters_cpt_codes	ecp_dx4
_436.precerts_cpt_codes	pcp_dx4
_436_archive_testing.encounters_cpt_codes	ecp_dx4
_436_archive_testing.precerts_cpt_codes	pcp_dx4
_437.encounters_cpt_codes	ecp_dx4
_437.precerts_cpt_codes	pcp_dx4
_8.encounters_cpt_codes	ecp_dx4
_8.precerts_cpt_codes	pcp_dx4
_81.encounters_cpt_codes	ecp_dx4
_81.precerts_cpt_codes	pcp_dx4
_999.encounters_cpt_codes	ecp_dx4
_999.precerts_cpt_codes	pcp_dx4
aurora_standard.chmmhast	other_dx4
aurora_standard.chmmhast	poa_dx4

dx5

Table	Column
_1.encounters_cpt_codes	ecp_dx5
_1188.encounters_cpt_codes	ecp_dx5
_1218.encounters_cpt_codes	ecp_dx5
_1548.encounters_cpt_codes	ecp_dx5
_435.encounters_cpt_codes	ecp_dx5
_436.encounters_cpt_codes	ecp_dx5
_436_archive_testing.encounters_cpt_codes	ecp_dx5
_437.encounters_cpt_codes	ecp_dx5
_8.encounters_cpt_codes	ecp_dx5
_81.encounters_cpt_codes	ecp_dx5
_999.encounters_cpt_codes	ecp_dx5
aurora_standard.chmmhast	other_dx5
aurora_standard.chmmhast	poa_dx5

dx6

Table	Column
_1.encounters_cpt_codes	ecp_dx6
_1188.encounters_cpt_codes	ecp_dx6
_1218.encounters_cpt_codes	ecp_dx6
_1548.encounters_cpt_codes	ecp_dx6
_435.encounters_cpt_codes	ecp_dx6
_436.encounters_cpt_codes	ecp_dx6
_436_archive_testing.encounters_cpt_codes	ecp_dx6
_437.encounters_cpt_codes	ecp_dx6
_8.encounters_cpt_codes	ecp_dx6
_81.encounters_cpt_codes	ecp_dx6
_999.encounters_cpt_codes	ecp_dx6
aurora_standard.chmmhast	other_dx6
aurora_standard.chmmhast	poa_dx6

dx7

Table	Column
_1.encounters_cpt_codes	ecp_dx7
_1188.encounters_cpt_codes	ecp_dx7
_1218.encounters_cpt_codes	ecp_dx7
_1548.encounters_cpt_codes	ecp_dx7
_435.encounters_cpt_codes	ecp_dx7
_436.encounters_cpt_codes	ecp_dx7
_436_archive_testing.encounters_cpt_codes	ecp_dx7
_437.encounters_cpt_codes	ecp_dx7
_8.encounters_cpt_codes	ecp_dx7
_81.encounters_cpt_codes	ecp_dx7
_999.encounters_cpt_codes	ecp_dx7
aurora_standard.chmmhast	other_dx7
aurora_standard.chmmhast	poa_dx7

dx8

Table	Column
_1.encounters_cpt_codes	ecp_dx8
_1188.encounters_cpt_codes	ecp_dx8
_1218.encounters_cpt_codes	ecp_dx8
_1548.encounters_cpt_codes	ecp_dx8
_435.encounters_cpt_codes	ecp_dx8
_436.encounters_cpt_codes	ecp_dx8
_436_archive_testing.encounters_cpt_codes	ecp_dx8
_437.encounters_cpt_codes	ecp_dx8
_8.encounters_cpt_codes	ecp_dx8
_81.encounters_cpt_codes	ecp_dx8
_999.encounters_cpt_codes	ecp_dx8
aurora_standard.chmmhast	other_dx8
aurora_standard.chmmhast	poa_dx8

dx9

Table	Column
_1.encounters_cpt_codes	ecp_dx9
_1188.encounters_cpt_codes	ecp_dx9
_1218.encounters_cpt_codes	ecp_dx9
_1548.encounters_cpt_codes	ecp_dx9
_435.encounters_cpt_codes	ecp_dx9
_436.encounters_cpt_codes	ecp_dx9
_436_archive_testing.encounters_cpt_codes	ecp_dx9
_437.encounters_cpt_codes	ecp_dx9
_8.encounters_cpt_codes	ecp_dx9
_81.encounters_cpt_codes	ecp_dx9
_999.encounters_cpt_codes	ecp_dx9
aurora_standard.chmmhast	other_dx9
aurora_standard.chmmhast	poa_dx9

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

cur_bal

Table	Column
aurora_standard.avtots	tot_cur_bal
aurora_standard.catots	tot_cur_bal

paid_amt

Table	Column
aurora_standard.bmins	ins_paid_amt

pos

Table	Column
aurora_standard.cgmmposr	x_pos
aurora_standard.cgmmposr	y_pos
aurora_standard.chmabstr	hidi_pos
aurora_standard.chmstatc	hidi_pos
aurora_standard.chmstatc	def_pos

spec_hand

Table	Column
aurora_standard.chmcolac	cur_spec_hand
aurora_standard.chmcolac	new_spec_hand
aurora_standard.chmstatc	def_spec_hand

line_no

Table	Column
aurora_standard.chmmbc41	service_line_no
aurora_standard.sticstvr	rec_line_no
aurora_standard.stmnoted	note_line_no
aurora_standard.stmwarrd	warr_line_no
aurora_standard.stoordrd	kit_line_no
aurora_standard.stuinvcd	inv_line_no
aurora_standard.stuinvcd	po_line_no
aurora_standard.stuordrd	order_line_no
aurora_standard.stuprche	inv_line_no
aurora_standard.sturectd	rec_line_no
aurora_standard.sturectd	po_line_no
aurora_standard.sturqstd	po_line_no
aurora_standard.sturqstd	ref_line_no
aurora_standard.sturtrnd	ret_line_no
aurora_standard.sturtrnd	po_line_no
aurora_standard.sturtrnd	rec_line_no
aurora_standard.sturtrnd	inv_line_no

fac_name

Table	Column
aurora_standard.chscustd	dept_fac_name