_436_archive_testing.cpt

Field	Type	Null	Default	Key	Extra
cpt_id	int(11)	NO		PRI	auto_increment
cpt_cus_id	int(11)	NO	0	MUL
cpt_cli_id	int(11)	NO	0	MUL
cpt_revc_id	int(11)	YES	0	MUL
cpt_code	varchar(15)	NO		MUL
cpt_desc	varchar(40)	NO		MUL
cpt_desc_long	text	NO
cpt_noc	varchar(80)	YES
cpt_desc_consumer	text	NO
cpt_rev_code	varchar(4)	NO
cpt_modifier	varchar(2)	NO
cpt_modifier2	varchar(2)	NO
cpt_modifier3	varchar(2)	NO
cpt_modifier4	varchar(2)	NO
cpt_ndc_code	varchar(30)	NO
cpt_ndc_unit_count	varchar(10)	NO
cpt_ndc_units_of_measure	varchar(2)	NO
cpt_rvu_work	varchar(6)	NO	0
cpt_billing_only	char(1)	NO	0	MUL
cpt_disabled	char(1)	NO	0
cpt_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
cpt_created	timestamp	YES	CURRENT_TIMESTAMP

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

cpt_id

Table	Column
Loinc.loinc_codes	lc_cpt_id
_1.audits	aud_cpt_id
_1.audits_archive	aud_cpt_id
_1.charts_cpt_codes	chcp_cpt_id
_1.clients_fee_schedules_map	cfsm_cpt_id
_1.clients_test_codes_cpt_map	ctccm_cpt_id
_1.configured_encounters_templates_cpt_codes	cetcc_cpt_id
_1.encounters_cpt_codes	ecp_cpt_id
_1.encounters_cpt_codes_stats	ecps_cpt_id
_1.encounters_cpt_codes_templates	ecpt_cpt_id
_1.insurances_allowed_amounts	iam_cpt_id
_1.radiology_orders_test_codes_map	rtcm_cpt_id
_1.radiology_results_test_codes_map	rrtcm_cpt_id
_1188.audits	aud_cpt_id
_1188.audits_archive	aud_cpt_id
_1188.charts_cpt_codes	chcp_cpt_id
_1188.clients_fee_schedules_map	cfsm_cpt_id
_1188.clients_test_codes_cpt_map	ctccm_cpt_id
_1188.configured_encounters_templates_cpt_codes	cetcc_cpt_id
_1188.encounters_cpt_codes	ecp_cpt_id
_1188.encounters_cpt_codes_stats	ecps_cpt_id
_1188.encounters_cpt_codes_templates	ecpt_cpt_id
_1188.insurances_allowed_amounts	iam_cpt_id
_1188.radiology_orders_test_codes_map	rtcm_cpt_id
_1188.radiology_results_test_codes_map	rrtcm_cpt_id
_1218.audits	aud_cpt_id
_1218.audits_archive	aud_cpt_id
_1218.charts_cpt_codes	chcp_cpt_id
_1218.clients_fee_schedules_map	cfsm_cpt_id
_1218.clients_test_codes_cpt_map	ctccm_cpt_id
_1218.configured_encounters_templates_cpt_codes	cetcc_cpt_id
_1218.encounters_cpt_codes	ecp_cpt_id
_1218.encounters_cpt_codes_stats	ecps_cpt_id
_1218.encounters_cpt_codes_templates	ecpt_cpt_id
_1218.insurances_allowed_amounts	iam_cpt_id
_1218.radiology_orders_test_codes_map	rtcm_cpt_id
_1218.radiology_results_test_codes_map	rrtcm_cpt_id
_1548.audits	aud_cpt_id
_1548.audits_archive	aud_cpt_id
_1548.charts_cpt_codes	chcp_cpt_id
_1548.clients_fee_schedules_map	cfsm_cpt_id
_1548.clients_test_codes_cpt_map	ctccm_cpt_id
_1548.configured_encounters_templates_cpt_codes	cetcc_cpt_id
_1548.encounters_cpt_codes	ecp_cpt_id
_1548.encounters_cpt_codes_stats	ecps_cpt_id
_1548.encounters_cpt_codes_templates	ecpt_cpt_id
_1548.insurances_allowed_amounts	iam_cpt_id
_1548.radiology_orders_test_codes_map	rtcm_cpt_id
_1548.radiology_results_test_codes_map	rrtcm_cpt_id
_435.audits	aud_cpt_id
_435.audits_archive	aud_cpt_id
_435.charts_cpt_codes	chcp_cpt_id
_435.clients_fee_schedules_map	cfsm_cpt_id
_435.clients_test_codes_cpt_map	ctccm_cpt_id
_435.configured_encounters_templates_cpt_codes	cetcc_cpt_id
_435.encounters_cpt_codes	ecp_cpt_id
_435.encounters_cpt_codes_stats	ecps_cpt_id
_435.encounters_cpt_codes_templates	ecpt_cpt_id
_435.insurances_allowed_amounts	iam_cpt_id
_435.radiology_orders_test_codes_map	rtcm_cpt_id
_435.radiology_results_test_codes_map	rrtcm_cpt_id
_436.audits	aud_cpt_id
_436.audits_archive	aud_cpt_id
_436.charts_cpt_codes	chcp_cpt_id
_436.clients_fee_schedules_map	cfsm_cpt_id
_436.clients_test_codes_cpt_map	ctccm_cpt_id
_436.configured_encounters_templates_cpt_codes	cetcc_cpt_id
_436.encounters_cpt_codes	ecp_cpt_id
_436.encounters_cpt_codes_stats	ecps_cpt_id
_436.encounters_cpt_codes_templates	ecpt_cpt_id
_436.insurances_allowed_amounts	iam_cpt_id
_436.radiology_orders_test_codes_map	rtcm_cpt_id
_436.radiology_results_test_codes_map	rrtcm_cpt_id
_436_archive_testing.audits	aud_cpt_id
_436_archive_testing.audits_archive	aud_cpt_id
_436_archive_testing.charts_cpt_codes	chcp_cpt_id
_436_archive_testing.clients_fee_schedules_map	cfsm_cpt_id
_436_archive_testing.clients_test_codes_cpt_map	ctccm_cpt_id
_436_archive_testing.configured_encounters_templates_cpt_codes	cetcc_cpt_id
_436_archive_testing.encounters_cpt_codes	ecp_cpt_id
_436_archive_testing.encounters_cpt_codes_stats	ecps_cpt_id
_436_archive_testing.encounters_cpt_codes_templates	ecpt_cpt_id
_436_archive_testing.insurances_allowed_amounts	iam_cpt_id
_436_archive_testing.radiology_orders_test_codes_map	rtcm_cpt_id
_436_archive_testing.radiology_results_test_codes_map	rrtcm_cpt_id
_437.audits	aud_cpt_id
_437.audits_archive	aud_cpt_id
_437.charts_cpt_codes	chcp_cpt_id
_437.clients_fee_schedules_map	cfsm_cpt_id
_437.clients_test_codes_cpt_map	ctccm_cpt_id
_437.configured_encounters_templates_cpt_codes	cetcc_cpt_id
_437.encounters_cpt_codes	ecp_cpt_id
_437.encounters_cpt_codes_stats	ecps_cpt_id
_437.encounters_cpt_codes_templates	ecpt_cpt_id
_437.insurances_allowed_amounts	iam_cpt_id
_437.radiology_orders_test_codes_map	rtcm_cpt_id
_437.radiology_results_test_codes_map	rrtcm_cpt_id
_8.audits	aud_cpt_id
_8.audits_archive	aud_cpt_id
_8.charts_cpt_codes	chcp_cpt_id
_8.clients_fee_schedules_map	cfsm_cpt_id
_8.clients_test_codes_cpt_map	ctccm_cpt_id
_8.configured_encounters_templates_cpt_codes	cetcc_cpt_id
_8.daily_close_calculations	dcc_cpt_id
_8.encounters_cpt_codes	ecp_cpt_id
_8.encounters_cpt_codes_stats	ecps_cpt_id
_8.encounters_cpt_codes_templates	ecpt_cpt_id
_8.insurances_allowed_amounts	iam_cpt_id
_8.radiology_orders_test_codes_map	rtcm_cpt_id
_8.radiology_results_test_codes_map	rrtcm_cpt_id
_81.audits	aud_cpt_id
_81.audits_archive	aud_cpt_id
_81.charts_cpt_codes	chcp_cpt_id
_81.clients_fee_schedules_map	cfsm_cpt_id
_81.clients_test_codes_cpt_map	ctccm_cpt_id
_81.configured_encounters_templates_cpt_codes	cetcc_cpt_id
_81.encounters_cpt_codes	ecp_cpt_id
_81.encounters_cpt_codes_stats	ecps_cpt_id
_81.encounters_cpt_codes_templates	ecpt_cpt_id
_81.insurances_allowed_amounts	iam_cpt_id
_81.radiology_orders_test_codes_map	rtcm_cpt_id
_81.radiology_results_test_codes_map	rrtcm_cpt_id
_999.audits	aud_cpt_id
_999.audits_archive	aud_cpt_id
_999.charts_cpt_codes	chcp_cpt_id
_999.clients_fee_schedules_map	cfsm_cpt_id
_999.clients_test_codes_cpt_map	ctccm_cpt_id
_999.configured_encounters_templates_cpt_codes	cetcc_cpt_id
_999.encounters_cpt_codes	ecp_cpt_id
_999.encounters_cpt_codes_stats	ecps_cpt_id
_999.encounters_cpt_codes_templates	ecpt_cpt_id
_999.insurances_allowed_amounts	iam_cpt_id
_999.radiology_orders_test_codes_map	rtcm_cpt_id
_999.radiology_results_test_codes_map	rrtcm_cpt_id
aurora_standard.schprocedurc	cqm_encounter_type_cpt_id
common.ahi_audits	aud_cpt_id
common.loinc_codes	lc_cpt_id
common.test_codes_results_cpts	tcrc_cpt_id
template_library.encounters_cpt_codes_templates	ecpt_cpt_id

cpt_desc

Table	Column
_1.clients_fee_schedules_map	cfsm_cpt_desc
_1188.clients_fee_schedules_map	cfsm_cpt_desc
_1218.clients_fee_schedules_map	cfsm_cpt_desc
_1548.clients_fee_schedules_map	cfsm_cpt_desc
_435.clients_fee_schedules_map	cfsm_cpt_desc
_436.clients_fee_schedules_map	cfsm_cpt_desc
_436_archive_testing.clients_fee_schedules_map	cfsm_cpt_desc
_437.clients_fee_schedules_map	cfsm_cpt_desc
_8.clients_fee_schedules_map	cfsm_cpt_desc
_81.clients_fee_schedules_map	cfsm_cpt_desc
_999.clients_fee_schedules_map	cfsm_cpt_desc