_1.encounters_batches

Field Type Null Default Key Extra Comment
ebat_id int(11) NO PRI auto_increment
ebat_cus_id int(11) NO MUL
ebat_cli_id int(11) NO MUL
ebat_type char(1) NO MUL
ebat_pst_id int(11) NO 0 MUL Patient Statement ID
ebat_ecf_id int(11) NO 0 MUL Encounters Claims File ID
ebat_count int(11) NO
ebat_patient_count int(11) NO 0 Count of unique included patient payers
ebat_modified datetime YES CURRENT_TIMESTAMP
ebat_created datetime YES CURRENT_TIMESTAMP

References

Local Column References
ebat_id
TableColumn
_1.encounters_claims_filesecf_ebat_id
_1.ledgerled_ebat_id
_1.voided_paymentsvp_ebat_id
_1188.encounters_claims_filesecf_ebat_id
_1188.ledgerled_ebat_id
_1188.voided_paymentsvp_ebat_id
_1218.encounters_claims_filesecf_ebat_id
_1218.ledgerled_ebat_id
_1218.voided_paymentsvp_ebat_id
_1548.encounters_claims_filesecf_ebat_id
_1548.ledgerled_ebat_id
_1548.voided_paymentsvp_ebat_id
_435.encounters_claims_filesecf_ebat_id
_435.ledgerled_ebat_id
_435.voided_paymentsvp_ebat_id
_436.encounters_claims_filesecf_ebat_id
_436.ledgerled_ebat_id
_436.voided_paymentsvp_ebat_id
_436_archive_testing.encounters_claims_filesecf_ebat_id
_436_archive_testing.ledgerled_ebat_id
_436_archive_testing.voided_paymentsvp_ebat_id
_437.encounters_claims_filesecf_ebat_id
_437.ledgerled_ebat_id
_437.voided_paymentsvp_ebat_id
_8.encounters_claims_filesecf_ebat_id
_8.ledgerled_ebat_id
_8.voided_paymentsvp_ebat_id
_81.encounters_claims_filesecf_ebat_id
_81.ledgerled_ebat_id
_81.voided_paymentsvp_ebat_id
_999.encounters_claims_filesecf_ebat_id
_999.ledgerled_ebat_id
_999.voided_paymentsvp_ebat_id