_81.encounters_payments

Field	Type	Null	Default	Key	Extra	Comment
epay_id	int(11)	NO		PRI	auto_increment
epay_cus_id	int(11)	NO		MUL
epay_cli_id	int(11)	NO		MUL
epay_ins_id	int(11)	NO		MUL
epay_bil_id	int(11)	NO		MUL
epay_bil_id_payment	int(11)	NO		MUL
epay_bil_id_adjustment	int(11)	NO		MUL
epay_bil_id_withholding	int(11)	NO		MUL
epay_date	varchar(8)	NO
epay_bill_type	char(1)	NO
epay_note	varchar(40)	NO
epay_note_editable	varchar(40)	YES		MUL
epay_amount	varchar(10)	NO
epay_edi_payer	char(1)	NO	0	MUL
epay_status	int(11)	NO	0	MUL		Batch Payment Status
epay_edi_path	text	NO				s3 path for the edi file
epay_usr_id_created	int(11)	NO		MUL
epay_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
epay_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

epay_id

Table	Column
_1.audits	aud_epay_id
_1.audits_archive	aud_epay_id
_1.encounters_cpt_denials	ecd_epay_id
_1.encounters_edi_errors	eee_epay_id
_1.encounters_payments_documents_map	epdm_epay_id
_1.encounters_payments_edi_logs	epel_epay_id
_1.encounters_payments_edi_logs_cpt_codes	epelcc_epay_id
_1.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epay_id
_1.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epay_id
_1.encounters_payments_override_formula	epof_epay_id
_1.ledger	led_epay_id
_1.voided_payments	vp_epay_id
_1188.audits	aud_epay_id
_1188.audits_archive	aud_epay_id
_1188.encounters_cpt_denials	ecd_epay_id
_1188.encounters_edi_errors	eee_epay_id
_1188.encounters_payments_documents_map	epdm_epay_id
_1188.encounters_payments_edi_logs	epel_epay_id
_1188.encounters_payments_edi_logs_cpt_codes	epelcc_epay_id
_1188.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epay_id
_1188.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epay_id
_1188.encounters_payments_groupings	epg_epay_id
_1188.encounters_payments_override_formula	epof_epay_id
_1188.ledger	led_epay_id
_1188.voided_payments	vp_epay_id
_1218.audits	aud_epay_id
_1218.audits_archive	aud_epay_id
_1218.encounters_cpt_denials	ecd_epay_id
_1218.encounters_edi_errors	eee_epay_id
_1218.encounters_payments_documents_map	epdm_epay_id
_1218.encounters_payments_edi_logs	epel_epay_id
_1218.encounters_payments_edi_logs_cpt_codes	epelcc_epay_id
_1218.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epay_id
_1218.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epay_id
_1218.encounters_payments_groupings	epg_epay_id
_1218.encounters_payments_override_formula	epof_epay_id
_1218.ledger	led_epay_id
_1218.voided_payments	vp_epay_id
_1548.audits	aud_epay_id
_1548.audits_archive	aud_epay_id
_1548.encounters_cpt_denials	ecd_epay_id
_1548.encounters_edi_errors	eee_epay_id
_1548.encounters_payments_documents_map	epdm_epay_id
_1548.encounters_payments_edi_logs	epel_epay_id
_1548.encounters_payments_edi_logs_cpt_codes	epelcc_epay_id
_1548.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epay_id
_1548.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epay_id
_1548.encounters_payments_override_formula	epof_epay_id
_1548.ledger	led_epay_id
_1548.voided_payments	vp_epay_id
_435.audits	aud_epay_id
_435.audits_archive	aud_epay_id
_435.encounters_cpt_denials	ecd_epay_id
_435.encounters_edi_errors	eee_epay_id
_435.encounters_payments_documents_map	epdm_epay_id
_435.encounters_payments_edi_logs	epel_epay_id
_435.encounters_payments_edi_logs_cpt_codes	epelcc_epay_id
_435.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epay_id
_435.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epay_id
_435.encounters_payments_groupings	epg_epay_id
_435.encounters_payments_override_formula	epof_epay_id
_435.ledger	led_epay_id
_435.voided_payments	vp_epay_id
_436.audits	aud_epay_id
_436.audits_archive	aud_epay_id
_436.encounters_cpt_denials	ecd_epay_id
_436.encounters_edi_errors	eee_epay_id
_436.encounters_payments_documents_map	epdm_epay_id
_436.encounters_payments_edi_logs	epel_epay_id
_436.encounters_payments_edi_logs_cpt_codes	epelcc_epay_id
_436.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epay_id
_436.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epay_id
_436.encounters_payments_groupings	epg_epay_id
_436.encounters_payments_override_formula	epof_epay_id
_436.ledger	led_epay_id
_436.voided_payments	vp_epay_id
_436_archive_testing.audits	aud_epay_id
_436_archive_testing.audits_archive	aud_epay_id
_436_archive_testing.encounters_cpt_denials	ecd_epay_id
_436_archive_testing.encounters_edi_errors	eee_epay_id
_436_archive_testing.encounters_payments_documents_map	epdm_epay_id
_436_archive_testing.encounters_payments_edi_logs	epel_epay_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codes	epelcc_epay_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epay_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epay_id
_436_archive_testing.encounters_payments_groupings	epg_epay_id
_436_archive_testing.encounters_payments_override_formula	epof_epay_id
_436_archive_testing.ledger	led_epay_id
_436_archive_testing.voided_payments	vp_epay_id
_437.audits	aud_epay_id
_437.audits_archive	aud_epay_id
_437.encounters_cpt_denials	ecd_epay_id
_437.encounters_edi_errors	eee_epay_id
_437.encounters_payments_documents_map	epdm_epay_id
_437.encounters_payments_edi_logs	epel_epay_id
_437.encounters_payments_edi_logs_cpt_codes	epelcc_epay_id
_437.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epay_id
_437.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epay_id
_437.encounters_payments_groupings	epg_epay_id
_437.encounters_payments_override_formula	epof_epay_id
_437.ledger	led_epay_id
_437.voided_payments	vp_epay_id
_8.audits	aud_epay_id
_8.audits_archive	aud_epay_id
_8.daily_close_calculations	dcc_epay_id
_8.encounters_cpt_denials	ecd_epay_id
_8.encounters_edi_errors	eee_epay_id
_8.encounters_payments_documents_map	epdm_epay_id
_8.encounters_payments_edi_logs	epel_epay_id
_8.encounters_payments_edi_logs_cpt_codes	epelcc_epay_id
_8.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epay_id
_8.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epay_id
_8.encounters_payments_override_formula	epof_epay_id
_8.ledger	led_epay_id
_8.voided_payments	vp_epay_id
_81.audits	aud_epay_id
_81.audits_archive	aud_epay_id
_81.encounters_cpt_denials	ecd_epay_id
_81.encounters_edi_errors	eee_epay_id
_81.encounters_payments_documents_map	epdm_epay_id
_81.encounters_payments_edi_logs	epel_epay_id
_81.encounters_payments_edi_logs_cpt_codes	epelcc_epay_id
_81.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epay_id
_81.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epay_id
_81.encounters_payments_groupings	epg_epay_id
_81.encounters_payments_override_formula	epof_epay_id
_81.ledger	led_epay_id
_81.voided_payments	vp_epay_id
_999.audits	aud_epay_id
_999.audits_archive	aud_epay_id
_999.encounters_cpt_denials	ecd_epay_id
_999.encounters_edi_errors	eee_epay_id
_999.encounters_payments_documents_map	epdm_epay_id
_999.encounters_payments_edi_logs	epel_epay_id
_999.encounters_payments_edi_logs_cpt_codes	epelcc_epay_id
_999.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_epay_id
_999.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_epay_id
_999.encounters_payments_override_formula	epof_epay_id
_999.ledger	led_epay_id
_999.voided_payments	vp_epay_id
common.ahi_audits	aud_epay_id