remittance_lines


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
remittance_advice_id VARCHAR 36 null
remittance_advices.id fk_remittance_lines_advice C
location_business_line_id VARCHAR 36 null
claim_id VARCHAR 36 null
claims.id fk_remittance_lines_claim R
client_id VARCHAR 36 √ null
service_date DATE 10 √ null
billed_amount DECIMAL 12,2 0.00
allowed_amount DECIMAL 12,2 0.00
DECIMAL 12,2 0.00
adjustment_amount DECIMAL 12,2 0.00
adjudication_status VARCHAR 30 null
adjustment_reason_code VARCHAR 20 √ null
denial_reason TEXT 65535 √ null
payer_claim_control_number VARCHAR 100 √ null
applied_at DATETIME 19 √ null
application_note 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_remittance_lines_advice Performance Asc remittance_advice_id
idx_remittance_lines_applied_at Performance Asc applied_at
idx_remittance_lines_claim Performance Asc claim_id
idx_remittance_lines_location Performance Asc location_business_line_id
idx_remittance_lines_status Performance Asc adjudication_status

Relationships

Close relationships within degrees of separation