claimsummaryCounts


Description

Claim summary counts providing aggregated patient and financial totals by site, program, and payment source for high-level reporting. This summary table maintains total charged amounts and patient counts to support executive reporting, financial analysis, and operational metrics for healthcare billing and patient volume tracking.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
totalAmountcharged money 21,4 √ null

Total amount charged - Sum of all charged amounts for this grouping
totalPatient int 4 √ null

Total patients - Count of unique patients in this grouping
siteid int 4 √ null

Site reference - Links to AgencySite table for location-based grouping
programtypeid int 4 √ null

Program type reference - Links to program type for program-based analysis
paysourceid varchar 10 √ null

Payment source - Identifier for the payment source or payer

Relationships

Close relationships within degrees of separation