clearinghouse_submission_claims


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
clearinghouse_response_events.submission_claim_id fk_ch_response_submission_claim R
submission_id VARCHAR 36 null
clearinghouse_submissions.id fk_ch_sub_claim_submission C
location_business_line_id VARCHAR 36 null
billing_batch_id VARCHAR 36 null
billing_batches.id fk_ch_sub_claim_batch R
claim_id VARCHAR 36 null
claims.id fk_ch_sub_claim_claim R
patient_control_number VARCHAR 50 null
provider_claim_id VARCHAR 100 √ null
remote_claim_id VARCHAR 100 √ null
claimmd_id VARCHAR 100 √ null
remote_batch_id VARCHAR 100 √ null
fileid VARCHAR 100 √ null
payerid VARCHAR 50 √ null
status VARCHAR 30 null
messages LONGTEXT 2147483647 √ null
last_error TEXT 65535 √ null
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 √ null
created_by VARCHAR 36 √ null
updated_by VARCHAR 36 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_ch_sub_claim_batch Performance Asc billing_batch_id
idx_ch_sub_claim_claim Performance Asc claim_id
idx_ch_sub_claim_claimmd Performance Asc claimmd_id
idx_ch_sub_claim_location Performance Asc location_business_line_id
idx_ch_sub_claim_pcn Performance Asc patient_control_number
idx_ch_sub_claim_submission Performance Asc submission_id

Relationships

Close relationships within degrees of separation