Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| BillID | int | 4 | √ | null |
|
|
Billing batch reference - Links to Billing table for the associated batch |
|
| BillingType | varchar | 10 | √ | null |
|
|
Billing type - Type of billing (Electronic, Paper, etc.) |
|
| ClaimTypeName | varchar | 20 | √ | null |
|
|
Claim type name - Name of the claim type (Evaluation, Visit, Service Coordination, etc.) |
|
| ClaimCount | int | 4 | √ | null |
|
|
Claim count - Number of claims of this type in the batch |
|
| Unit | int | 4 | √ | null |
|
|
Unit count - Total number of service units for this claim type |
|
| Amountcharged | money | 21,4 | √ | null |
|
|
Amount charged - Total monetary amount charged for this claim type |
Relationships
Close relationships within degrees of separation
