Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkClaimNoteID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each claim note record |
||||
| fkClaimID | int | 4 | √ | null |
|
|
Claim reference - Links to the primary service claim for which notes are being documented (foreign key to Claim.ClaimID) |
||||
| Notes1 | ntext | 1073741823 | √ | null |
|
|
Primary clinical notes - Main clinical documentation field for session notes, treatment observations, and service delivery documentation |
||||
| Notes2 | ntext | 1073741823 | √ | null |
|
|
Secondary notes - Additional clinical notes field for extended documentation, follow-up observations, or specialized notes |
||||
| Notes3 | ntext | 1073741823 | √ | null |
|
|
Tertiary notes - Third notes field for supplementary documentation, caregiver notes, or additional clinical observations |
||||
| Notes4 | ntext | 1073741823 | √ | null |
|
|
Quaternary notes - Fourth notes field for comprehensive documentation, outcome notes, or specialized clinical information |
||||
| fkSubClaimID | int | 4 | √ | null |
|
|
Subclaim reference - Links to service coordination subclaim when notes are specific to subclaim activities |
||||
| UserID | int | 4 | √ | null |
|
|
Note author - Healthcare provider who created or last modified the notes for accountability and clinical responsibility |
||||
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Direct patient identifier for quick patient association and note organization |
||||
| DraftDate | datetime | 16,3 | √ | null |
|
|
Draft timestamp - Date and time when notes were saved as draft for tracking documentation workflow and completion status |
||||
| ClaimBy | int | 4 | √ | null |
|
|
Claim creator - User who originally created the claim associated with these notes for tracking claim ownership |
||||
| DraftInfo | ntext | 1073741823 | √ | null |
|
|
Draft metadata - Additional information about draft status, workflow state, and documentation completion tracking |
||||
| EntryID | varchar | 255 | √ | null |
|
|
Entry identifier - Unique entry ID linking notes to specific form submissions or documentation entries |
||||
| Location | int | 4 | √ | null |
|
|
Service location - Physical location where services were provided and notes were documented for location-based reporting |
||||
| CustomNotes | ntext | 1073741823 | √ | null |
|
|
Custom documentation - Flexible notes field for organization-specific documentation requirements, custom forms, or specialized clinical information |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ClaimNotes | Primary key | Asc | pkClaimNoteID |
| ClaimNotesClaimID | Performance | Asc | fkClaimID |
| IX_ScClaim | Performance | Asc | fkSubClaimID |
