clearinghouse_response_events


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
location_business_line_id VARCHAR 36 null
provider VARCHAR 50 null
response_id VARCHAR 100 √ null
submission_claim_id VARCHAR 36 √ null
clearinghouse_submission_claims.id fk_ch_response_submission_claim R
claim_id VARCHAR 36 √ null
claims.id fk_ch_response_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
response_time DATETIME 19 √ null
sender_name VARCHAR 200 √ null
senderid VARCHAR 100 √ null
sender_icn VARCHAR 100 √ null
message_id VARCHAR 100 √ null
message_status VARCHAR 30 √ null
message_text TEXT 65535 √ null
fields TEXT 65535 √ null
raw_payload LONGTEXT 2147483647 √ null
processing_status VARCHAR 30 null
processing_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
fk_ch_response_submission_claim Performance Asc submission_claim_id
idx_ch_response_claim Performance Asc claim_id
idx_ch_response_claimmd Performance Asc claimmd_id
idx_ch_response_location Performance Asc location_business_line_id
idx_ch_response_pcn Performance Asc patient_control_number
uk_ch_response_event Must be unique Asc/Asc/Asc location_business_line_id + provider + response_id

Relationships

Close relationships within degrees of separation