_1548.encounters_payments_edi_logs

Field	Type	Null	Default	Key	Extra	Comment
epel_id	int(11)	NO		PRI	auto_increment
epel_epay_id	int(11)	YES		MUL		Encounter Payment ID#
epel_enc_id	int(11)	NO		MUL
epel_cus_id	int(11)	NO		MUL
epel_cli_id	int(11)	NO		MUL
epel_epg_grouping	int(11)	NO	0			Encounter Payment Grouping (deprecated)
epel_grouping	int(11)	NO	0			Encounter Payment Grouping (deprecated)
epel_ins_id	int(11)	NO		MUL
epel_status	varchar(2)	NO
epel_rarc_code1	varchar(5)	NO
epel_rarc_code2	varchar(5)	NO
epel_rarc_code3	varchar(5)	NO
epel_rarc_code4	varchar(5)	NO
epel_rarc_code5	varchar(5)	NO
epel_completed	char(1)	NO	0	MUL
epel_modified	datetime	YES	CURRENT_TIMESTAMP
epel_created	datetime	YES	CURRENT_TIMESTAMP
epel_billed	decimal(10,2)	NO	0.00			Billed
epel_deduct	decimal(10,2)	NO	0.00			Deductible
epel_coins	decimal(10,2)	NO	0.00			CoInsurance
epel_ptresp	decimal(10,2)	NO	0.00			Patient Responsibility (CoPay)
epel_latefiling	decimal(10,2)	NO	0.00			Late Filing
epel_ins_take_back	decimal(10,2)	NO	0.00			Withholding
epel_ins_adj_rev	decimal(10,2)	NO	0.00			Insurance Adjustment Reversal
epel_adjust	decimal(10,2)	NO	0.00			Adjustments
epel_prov_paid	decimal(10,2)	NO	0.00			Provider Paid
epel_o_ride_pri	tinyint(1)	NO	0			Override Primary Insurance
epel_o_ride_sec	tinyint(1)	NO	0			Override Secondary Insurance
epel_o_ride_tert	tinyint(1)	NO	0			Override Tertiary Insurance

References

Local Column

References

epel_id

Table	Column
_1.audits	aud_epel_id
_1.audits_archive	aud_epel_id
_1.encounters_cpt_denials	ecd_epel_id
_1.encounters_edi_errors	eee_epel_id
_1.encounters_payments_edi_logs_cpt_codes	epelcc_epel_id
_1.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epel_id
_1.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epel_id
_1.encounters_payments_override_formula	epof_epel_id
_1.ledger	led_epel_id
_1188.audits	aud_epel_id
_1188.audits_archive	aud_epel_id
_1188.encounters_cpt_denials	ecd_epel_id
_1188.encounters_edi_errors	eee_epel_id
_1188.encounters_payments_edi_logs_cpt_codes	epelcc_epel_id
_1188.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epel_id
_1188.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epel_id
_1188.encounters_payments_override_formula	epof_epel_id
_1188.ledger	led_epel_id
_1218.audits	aud_epel_id
_1218.audits_archive	aud_epel_id
_1218.encounters_cpt_denials	ecd_epel_id
_1218.encounters_edi_errors	eee_epel_id
_1218.encounters_payments_edi_logs_cpt_codes	epelcc_epel_id
_1218.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epel_id
_1218.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epel_id
_1218.encounters_payments_override_formula	epof_epel_id
_1218.ledger	led_epel_id
_1548.audits	aud_epel_id
_1548.audits_archive	aud_epel_id
_1548.encounters_cpt_denials	ecd_epel_id
_1548.encounters_edi_errors	eee_epel_id
_1548.encounters_payments_edi_logs_cpt_codes	epelcc_epel_id
_1548.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epel_id
_1548.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epel_id
_1548.encounters_payments_override_formula	epof_epel_id
_1548.ledger	led_epel_id
_435.audits	aud_epel_id
_435.audits_archive	aud_epel_id
_435.encounters_cpt_denials	ecd_epel_id
_435.encounters_edi_errors	eee_epel_id
_435.encounters_payments_edi_logs_cpt_codes	epelcc_epel_id
_435.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epel_id
_435.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epel_id
_435.ledger	led_epel_id
_436.audits	aud_epel_id
_436.audits_archive	aud_epel_id
_436.encounters_cpt_denials	ecd_epel_id
_436.encounters_edi_errors	eee_epel_id
_436.encounters_payments_edi_logs_cpt_codes	epelcc_epel_id
_436.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epel_id
_436.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epel_id
_436.ledger	led_epel_id
_436_archive_testing.audits	aud_epel_id
_436_archive_testing.audits_archive	aud_epel_id
_436_archive_testing.encounters_cpt_denials	ecd_epel_id
_436_archive_testing.encounters_edi_errors	eee_epel_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codes	epelcc_epel_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epel_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epel_id
_436_archive_testing.ledger	led_epel_id
_437.audits	aud_epel_id
_437.audits_archive	aud_epel_id
_437.encounters_cpt_denials	ecd_epel_id
_437.encounters_edi_errors	eee_epel_id
_437.encounters_payments_edi_logs_cpt_codes	epelcc_epel_id
_437.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epel_id
_437.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epel_id
_8.audits	aud_epel_id
_8.audits_archive	aud_epel_id
_8.encounters_cpt_denials	ecd_epel_id
_8.encounters_edi_errors	eee_epel_id
_8.encounters_payments_edi_logs_cpt_codes	epelcc_epel_id
_8.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epel_id
_8.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epel_id
_8.encounters_payments_override_formula	epof_epel_id
_8.ledger	led_epel_id
_81.audits	aud_epel_id
_81.audits_archive	aud_epel_id
_81.encounters_cpt_denials	ecd_epel_id
_81.encounters_edi_errors	eee_epel_id
_81.encounters_payments_edi_logs_cpt_codes	epelcc_epel_id
_81.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epel_id
_81.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epel_id
_81.encounters_payments_override_formula	epof_epel_id
_81.ledger	led_epel_id
_999.audits	aud_epel_id
_999.audits_archive	aud_epel_id
_999.encounters_cpt_denials	ecd_epel_id
_999.encounters_edi_errors	eee_epel_id
_999.encounters_payments_edi_logs_cpt_codes	epelcc_epel_id
_999.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epel_id
_999.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epel_id
_999.encounters_payments_override_formula	epof_epel_id
_999.ledger	led_epel_id
common.ahi_audits	aud_epel_id