Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ClaimID | int | 4 | null |
|
|
Claim identifier - Unique identifier for the service claim |
||
| StartTime | datetime | 16,3 | √ | null |
|
|
Visit start time - Date and time when the service visit began |
|
| EndTime | datetime | 16,3 | √ | null |
|
|
Visit end time - Date and time when the service visit ended |
|
| Minutes | int | 4 | √ | null |
|
|
Visit duration - Total minutes of service provided during the visit |
|
| Contactcode | char | 15 | √ | null |
|
|
Contact code - Code indicating the type of contact or service provided |
|
| QuickNoteID | int | 4 | √ | null |
|
|
Quick note reference - Links to predefined quick notes for efficient documentation |
|
| DateService | datetime | 16,3 | √ | null |
|
|
Service date - Date when the service was provided |
|
| Comments | varchar | 500 | √ | null |
|
|
Service comments - Detailed notes and comments about the service provided |
|
| SiteID | int | 4 | √ | null |
|
|
Service site - Location where the service was provided |
|
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Links to the patient who received the service |
Relationships
Close relationships within degrees of separation
