_8.encounters_payments_edi_logs

Field Type Null Default Key Extra Comment
epel_id int(11) NO PRI auto_increment
epel_cus_id int(11) NO MUL
epel_cli_id int(11) NO MUL
epel_epay_id int(11) YES MUL Encounter Payment ID#
epel_epg_grouping int(11) NO 0 Encounter Payment Grouping (deprecated)
epel_grouping int(11) NO 0 Encounter Payment Grouping (deprecated)
epel_enc_id int(11) NO MUL
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 timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
epel_created timestamp 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
TableColumn
_1.auditsaud_epel_id
_1.audits_archiveaud_epel_id
_1.encounters_cpt_denialsecd_epel_id
_1.encounters_edi_errorseee_epel_id
_1.encounters_payments_edi_logs_cpt_codesepelcc_epel_id
_1.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_epel_id
_1.encounters_payments_edi_logs_cpt_codes_remark_codesepelccrc_epel_id
_1.encounters_payments_override_formulaepof_epel_id
_1.ledgerled_epel_id
_1188.auditsaud_epel_id
_1188.audits_archiveaud_epel_id
_1188.encounters_cpt_denialsecd_epel_id
_1188.encounters_edi_errorseee_epel_id
_1188.encounters_payments_edi_logs_cpt_codesepelcc_epel_id
_1188.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_epel_id
_1188.encounters_payments_edi_logs_cpt_codes_remark_codesepelccrc_epel_id
_1188.encounters_payments_override_formulaepof_epel_id
_1188.ledgerled_epel_id
_1218.auditsaud_epel_id
_1218.audits_archiveaud_epel_id
_1218.encounters_cpt_denialsecd_epel_id
_1218.encounters_edi_errorseee_epel_id
_1218.encounters_payments_edi_logs_cpt_codesepelcc_epel_id
_1218.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_epel_id
_1218.encounters_payments_edi_logs_cpt_codes_remark_codesepelccrc_epel_id
_1218.encounters_payments_override_formulaepof_epel_id
_1218.ledgerled_epel_id
_1548.auditsaud_epel_id
_1548.audits_archiveaud_epel_id
_1548.encounters_cpt_denialsecd_epel_id
_1548.encounters_edi_errorseee_epel_id
_1548.encounters_payments_edi_logs_cpt_codesepelcc_epel_id
_1548.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_epel_id
_1548.encounters_payments_edi_logs_cpt_codes_remark_codesepelccrc_epel_id
_1548.encounters_payments_override_formulaepof_epel_id
_1548.ledgerled_epel_id
_435.auditsaud_epel_id
_435.audits_archiveaud_epel_id
_435.encounters_cpt_denialsecd_epel_id
_435.encounters_edi_errorseee_epel_id
_435.encounters_payments_edi_logs_cpt_codesepelcc_epel_id
_435.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_epel_id
_435.encounters_payments_edi_logs_cpt_codes_remark_codesepelccrc_epel_id
_435.ledgerled_epel_id
_436.auditsaud_epel_id
_436.audits_archiveaud_epel_id
_436.encounters_cpt_denialsecd_epel_id
_436.encounters_edi_errorseee_epel_id
_436.encounters_payments_edi_logs_cpt_codesepelcc_epel_id
_436.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_epel_id
_436.encounters_payments_edi_logs_cpt_codes_remark_codesepelccrc_epel_id
_436.ledgerled_epel_id
_436_archive_testing.auditsaud_epel_id
_436_archive_testing.audits_archiveaud_epel_id
_436_archive_testing.encounters_cpt_denialsecd_epel_id
_436_archive_testing.encounters_edi_errorseee_epel_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codesepelcc_epel_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_epel_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codes_remark_codesepelccrc_epel_id
_436_archive_testing.ledgerled_epel_id
_437.auditsaud_epel_id
_437.audits_archiveaud_epel_id
_437.encounters_cpt_denialsecd_epel_id
_437.encounters_edi_errorseee_epel_id
_437.encounters_payments_edi_logs_cpt_codesepelcc_epel_id
_437.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_epel_id
_437.encounters_payments_edi_logs_cpt_codes_remark_codesepelccrc_epel_id
_8.auditsaud_epel_id
_8.audits_archiveaud_epel_id
_8.encounters_cpt_denialsecd_epel_id
_8.encounters_edi_errorseee_epel_id
_8.encounters_payments_edi_logs_cpt_codesepelcc_epel_id
_8.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_epel_id
_8.encounters_payments_edi_logs_cpt_codes_remark_codesepelccrc_epel_id
_8.encounters_payments_override_formulaepof_epel_id
_8.ledgerled_epel_id
_81.auditsaud_epel_id
_81.audits_archiveaud_epel_id
_81.encounters_cpt_denialsecd_epel_id
_81.encounters_edi_errorseee_epel_id
_81.encounters_payments_edi_logs_cpt_codesepelcc_epel_id
_81.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_epel_id
_81.encounters_payments_edi_logs_cpt_codes_remark_codesepelccrc_epel_id
_81.encounters_payments_override_formulaepof_epel_id
_81.ledgerled_epel_id
_999.auditsaud_epel_id
_999.audits_archiveaud_epel_id
_999.encounters_cpt_denialsecd_epel_id
_999.encounters_edi_errorseee_epel_id
_999.encounters_payments_edi_logs_cpt_codesepelcc_epel_id
_999.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_epel_id
_999.encounters_payments_edi_logs_cpt_codes_remark_codesepelccrc_epel_id
_999.encounters_payments_override_formulaepof_epel_id
_999.ledgerled_epel_id
common.ahi_auditsaud_epel_id