AmountAppliedClaimsByCheckLog_vw


Description

Payment application analytics providing financial analysis of payment applications by check and claim type. This view supports accounts receivable reporting, payment analysis, and financial reconciliation by categorizing payment applications across different service types.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
checkLogID int 4 null

Check reference - Links to checkLog table for payment check

AmountAppliedEval money 21,4 null

Evaluation payments - Amount applied to evaluation claims

AmountAppliedVisit money 21,4 null

Visit payments - Amount applied to early intervention service claims

AmountAppliedSC money 21,4 null

Service coordination payments - Amount applied to service coordination claims

Relationships

View Definition


Possibly Referenced Tables/Views