ClaimNotes


Description

Clinical documentation and notes for healthcare service claims providing comprehensive note-taking capabilities for clinical documentation, billing support, and compliance requirements. This table stores multiple types of notes including clinical observations, session progress, billing justifications, and draft documentation to support healthcare service delivery, billing compliance, and clinical record-keeping for early intervention and therapy services.

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.ClaimID FK_ClaimNotes_Claim R

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

Relationships