_436_archive_testing.encounters_cpt_codes

Field	Type	Null	Default	Key	Extra	Comment
ecp_id	int(11)	NO		PRI	auto_increment
ecp_cus_id	int(11)	NO		MUL
ecp_cli_id	int(11)	NO		MUL
ecp_pat_id	int(11)	NO		MUL
ecp_enc_id	int(11)	NO		MUL
ecp_cp_id	int(11)	NO	0	MUL		Points to the corresponding chart procedure if it exists
ecp_cpt_id	int(11)	NO		MUL
ecp_spl_id	int(11)	NO		MUL
ecp_code	varchar(15)	NO
ecp_desc	varchar(40)	NO
ecp_rev_code	varchar(4)	NO
ecp_date_of_service	varchar(8)	NO		MUL
ecp_date_of_service_to	varchar(8)	NO
ecp_num_units	varchar(5)	NO	1
ecp_num_units_type	varchar(2)	NO	UN			Unit Type (UN, MJ, DA)
ecp_no_unit_multiply	char(1)	YES
ecp_mod1	varchar(2)	NO
ecp_mod2	varchar(2)	NO
ecp_mod3	varchar(2)	NO
ecp_mod4	varchar(2)	NO
ecp_dx1	char(1)	NO
ecp_dx2	char(1)	NO
ecp_dx3	char(1)	NO
ecp_dx4	char(1)	NO
ecp_dx5	char(1)	NO
ecp_dx6	char(1)	NO
ecp_dx7	char(1)	NO
ecp_dx8	char(1)	NO
ecp_dx9	char(1)	NO
ecp_dx10	char(1)	NO
ecp_note	varchar(80)	NO
ecp_ndc	char(1)	NO
ecp_ndc_unit_count	varchar(10)	NO
ecp_ndc_units_of_measure	varchar(2)	NO
ecp_noc	varchar(80)	NO
ecp_prescription_number	varchar(50)	NO
ecp_pan_id	int(11)	NO	0	MUL		Patient authorization number ID#
ecp_ins2_pan_id	int(11)	YES		MUL		Secondary Insurance Authorization ID#
ecp_ins3_pan_id	int(11)	YES		MUL		Tertiary Insurance Authorization ID#
ecp_authorization_num	varchar(60)	NO
ecp_ub04	char(1)	NO
ecp_billing_only	char(1)	NO	0	MUL
ecp_global_indicator	char(1)	NO	0			Flags this cpt as start of global period
ecp_global_days	int(11)	NO	0	MUL		Number of Days global period affects
ecp_global_flag	char(1)	NO	0	MUL		Flags this entry as within a global period
ecp_aging_ins1	date	YES				Primary Insurance Aging Date
ecp_aging_ins2	date	YES				Secondary Insurance Aging Date
ecp_aging_ins3	date	YES				Tertiary Insurance Aging Date
ecp_aging_patient	date	YES				Patient Aging Date
ecp_cc_gender_alert	tinyint(1)	NO	0			Code Check Gender Alert
ecp_cc_age_alert	tinyint(1)	NO	0			Code Check Age Alert
ecp_cc_ncd_alert	tinyint(1)	NO	0			Code Check National Coverage Determination Alert
ecp_cc_lcd_alert	tinyint(1)	NO	0			Code Check Local Coverage Determination Alert
ecp_cc_cci_alert	tinyint(1)	NO	0			Code Check Corrective Coding Initiative Alert
ecp_cc_cpt_mod_alert	tinyint(1)	NO	0			Code Check CPT Mod Alert
ecp_cc_expired_dx_alert	tinyint(1)	NO	0			Code Check Expired DX Alert
ecp_cc_expired_cpt_alert	tinyint(1)	NO	0			Code Check Expired CPT Alert
ecp_cc_abn_alert	tinyint(1)	NO	0			Code Check Advance Beneficiary Notice Alert
ecp_next_payer_bill_type	tinyint(4)	NO	0	MUL		Next payer bill type, not to be confused with led_bil_type. 2=insurance 3=patient
ecp_next_payer_level	tinyint(4)	NO	0	MUL		For next payer insurance, indicates which type
ecp_subtotal	decimal(12,2)	NO	0.00	MUL		Current total
ecp_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
ecp_created	timestamp	YES	CURRENT_TIMESTAMP
ecp_reverse_led_id	int(11)	YES				led_id for reversing ledger row

References

Local Column

References

ecp_id

Table	Column
_1.encounters_cpt_denials	ecd_ecp_id
_1.encounters_dx_pointers	edp_ecp_id
_1.encounters_edi_errors	eep_ecp_id
_1.encounters_payments_edi_logs_cpt_codes	epelcc_ecp_id
_1.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_ecp_id
_1.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_ecp_id
_1.ledger	led_ecp_id
_1.ledger	led_apply_to_ecp_id
_1.procedures_results	pres_ecp_id
_1.voided_payments	vp_ecp_id
_1.voided_payments	vp_apply_to_ecp_id
_1188.encounters_cpt_denials	ecd_ecp_id
_1188.encounters_dx_pointers	edp_ecp_id
_1188.encounters_edi_errors	eep_ecp_id
_1188.encounters_payments_edi_logs_cpt_codes	epelcc_ecp_id
_1188.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_ecp_id
_1188.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_ecp_id
_1188.ledger	led_ecp_id
_1188.ledger	led_apply_to_ecp_id
_1188.procedures_results	pres_ecp_id
_1188.voided_payments	vp_ecp_id
_1188.voided_payments	vp_apply_to_ecp_id
_1218.encounters_cpt_denials	ecd_ecp_id
_1218.encounters_dx_pointers	edp_ecp_id
_1218.encounters_edi_errors	eep_ecp_id
_1218.encounters_payments_edi_logs_cpt_codes	epelcc_ecp_id
_1218.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_ecp_id
_1218.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_ecp_id
_1218.led_temporary_ledger_table_ANM	led_ecp_id
_1218.led_temporary_ledger_table_ANM	led_apply_to_ecp_id
_1218.ledger	led_ecp_id
_1218.ledger	led_apply_to_ecp_id
_1218.procedures_results	pres_ecp_id
_1218.voided_payments	vp_ecp_id
_1218.voided_payments	vp_apply_to_ecp_id
_1548.encounters_cpt_denials	ecd_ecp_id
_1548.encounters_dx_pointers	edp_ecp_id
_1548.encounters_edi_errors	eep_ecp_id
_1548.encounters_payments_edi_logs_cpt_codes	epelcc_ecp_id
_1548.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_ecp_id
_1548.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_ecp_id
_1548.ledger	led_ecp_id
_1548.ledger	led_apply_to_ecp_id
_1548.procedures_results	pres_ecp_id
_1548.voided_payments	vp_ecp_id
_1548.voided_payments	vp_apply_to_ecp_id
_435.encounters_cpt_denials	ecd_ecp_id
_435.encounters_dx_pointers	edp_ecp_id
_435.encounters_edi_errors	eep_ecp_id
_435.encounters_payments_edi_logs_cpt_codes	epelcc_ecp_id
_435.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_ecp_id
_435.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_ecp_id
_435.ledger	led_ecp_id
_435.ledger	led_apply_to_ecp_id
_435.ledger_running_balance	lrb_ecp_id
_435.procedures_results	pres_ecp_id
_435.voided_payments	vp_ecp_id
_435.voided_payments	vp_apply_to_ecp_id
_436.encounters_cpt_denials	ecd_ecp_id
_436.encounters_dx_pointers	edp_ecp_id
_436.encounters_edi_errors	eep_ecp_id
_436.encounters_payments_edi_logs_cpt_codes	epelcc_ecp_id
_436.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_ecp_id
_436.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_ecp_id
_436.ledger	led_ecp_id
_436.ledger	led_apply_to_ecp_id
_436.ledger_running_balance	lrb_ecp_id
_436.procedures_results	pres_ecp_id
_436.voided_payments	vp_ecp_id
_436.voided_payments	vp_apply_to_ecp_id
_436_archive_testing.encounters_cpt_denials	ecd_ecp_id
_436_archive_testing.encounters_dx_pointers	edp_ecp_id
_436_archive_testing.encounters_edi_errors	eep_ecp_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codes	epelcc_ecp_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_ecp_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_ecp_id
_436_archive_testing.ledger	led_ecp_id
_436_archive_testing.ledger	led_apply_to_ecp_id
_436_archive_testing.ledger_running_balance	lrb_ecp_id
_436_archive_testing.procedures_results	pres_ecp_id
_436_archive_testing.voided_payments	vp_ecp_id
_436_archive_testing.voided_payments	vp_apply_to_ecp_id
_437.encounters_cpt_denials	ecd_ecp_id
_437.encounters_dx_pointers	edp_ecp_id
_437.encounters_edi_errors	eep_ecp_id
_437.encounters_payments_edi_logs_cpt_codes	epelcc_ecp_id
_437.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_ecp_id
_437.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_ecp_id
_437.ledger	led_ecp_id
_437.ledger	led_apply_to_ecp_id
_437.ledger_running_balance	lrb_ecp_id
_437.procedures_results	pres_ecp_id
_437.voided_payments	vp_ecp_id
_437.voided_payments	vp_apply_to_ecp_id
_8.daily_close_calculations	dcc_ecp_id
_8.encounters_cpt_denials	ecd_ecp_id
_8.encounters_dx_pointers	edp_ecp_id
_8.encounters_edi_errors	eep_ecp_id
_8.encounters_payments_edi_logs_cpt_codes	epelcc_ecp_id
_8.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_ecp_id
_8.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_ecp_id
_8.ledger	led_ecp_id
_8.ledger	led_apply_to_ecp_id
_8.procedures_results	pres_ecp_id
_8.voided_payments	vp_ecp_id
_8.voided_payments	vp_apply_to_ecp_id
_81.encounters_cpt_denials	ecd_ecp_id
_81.encounters_dx_pointers	edp_ecp_id
_81.encounters_edi_errors	eep_ecp_id
_81.encounters_payments_edi_logs_cpt_codes	epelcc_ecp_id
_81.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_ecp_id
_81.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_ecp_id
_81.ledger	led_ecp_id
_81.ledger	led_apply_to_ecp_id
_81.procedures_results	pres_ecp_id
_81.voided_payments	vp_ecp_id
_81.voided_payments	vp_apply_to_ecp_id
_999.encounters_cpt_denials	ecd_ecp_id
_999.encounters_dx_pointers	edp_ecp_id
_999.encounters_edi_errors	eep_ecp_id
_999.encounters_payments_edi_logs_cpt_codes	epelcc_ecp_id
_999.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_ecp_id
_999.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_ecp_id
_999.ledger	led_ecp_id
_999.ledger	led_apply_to_ecp_id
_999.procedures_results	pres_ecp_id
_999.voided_payments	vp_ecp_id
_999.voided_payments	vp_apply_to_ecp_id

ecp_code

Table	Column
_8.daily_close_calculations	dcc_ecp_code

ecp_desc

Table	Column
_8.daily_close_calculations	dcc_ecp_desc

ecp_date_of_service

Table	Column
_8.daily_close_calculations	dcc_ecp_date_of_service

ecp_num_units

Table	Column
_8.daily_close_calculations	dcc_ecp_num_units

ecp_created

Table	Column
_8.daily_close_calculations	dcc_ecp_created