Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| fkClaimID | int | 4 | null |
|
|
Claim reference - Links to Claim table as the primary claim record |
|||||
| fkPlaceService | int | 4 | √ | null |
|
|
Place of service - Links to place of service classification for billing |
||||
| fkRateCodeID | int | 4 | √ | null |
|
|
Primary rate code - Links to rate code for billing calculations |
||||
| MakeupDate | smalldatetime | 16 | √ | null |
|
|
Makeup session date - Date for makeup sessions when original session was missed |
||||
| NumInGroup | int | 4 | √ | null |
|
|
Group size - Number of participants in group therapy sessions |
||||
| fkRateCode2ID | int | 4 | √ | null |
|
|
Secondary rate code - Additional rate code for complex billing scenarios |
||||
| fkRateCode3ID | int | 4 | √ | null |
|
|
Tertiary rate code - Third rate code for specialized billing requirements |
||||
| Notes5 | ntext | 1073741823 | √ | null |
|
|
Extended notes - Additional detailed notes about the service or claim |
||||
| ServiceSetting | nvarchar | 400 | √ | null |
|
|
Service setting - Description of the setting where services were provided |
||||
| CancelledVisitId | int | 4 | √ | null |
|
|
Cancelled visit reference - Links to cancelled visit if this is a makeup session |
||||
| Address | nvarchar | 1000 | √ | null |
|
|
Service address - Street address where services were provided |
||||
| City | nvarchar | 400 | √ | null |
|
|
Service city - City where services were provided |
||||
| ZipCode | nvarchar | 100 | √ | null |
|
|
Service ZIP code - Postal code for service location |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Claim2 | Primary key | Asc | fkClaimID |
| IX_Location | Performance | Asc | fkPlaceService |
Relationships
Close relationships within degrees of separation
