Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| siteid | int | 4 | √ | null |
|
|
Site reference - Links to AgencySite table for location-based grouping |
|
| claimtypeName | varchar | 20 | √ | null |
|
|
Claim type name - Name of the claim type for categorization |
|
| statusid | int | 4 | √ | null |
|
|
Status reference - Links to iCS2.dbo.StatusType for centralized status definitions and status-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 |
|
| total | money | 21,4 | √ | null |
|
|
Total charged - Total amount charged for this grouping |
|
| paidTotal | money | 21,4 | √ | null |
|
|
Total paid - Total amount paid for this grouping |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Update date - Date when the summary was last updated |
|
| onhold | int | 4 | √ | null |
|
|
On hold count - Number of claims on hold in this grouping |
|
| source | varchar | 2 | √ | null |
|
|
Data source - Source of the claim data |
|
| ClaimCount | int | 4 | √ | null |
|
|
Claim count - Number of claims in this grouping |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_CTname | Performance | Asc | claimtypeName |
| IX_status | Performance | Asc | statusid |
Relationships
Close relationships within degrees of separation
