Gaps


Description

Service gap analysis and tracking for identifying and managing gaps in healthcare service delivery between scheduled and actual services. This table supports quality assurance by tracking service interruptions, missed sessions, and gaps in care delivery, enabling providers to identify patterns, ensure compliance with service requirements, and maintain continuity of care for early intervention and therapy services through systematic gap analysis and resolution tracking.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ClaimID1 int 4 √ null

First claim reference - Links to the first claim in the service gap analysis for comparison and gap identification
ClaimID2 int 4 √ null

Second claim reference - Links to the second claim in the service gap analysis for comparison and gap identification
pkGapID int identity 4 √ null
GapsCustom.fkGapID FK_GapsCustom_Gaps R

Primary key - Unique identifier for each service gap analysis record
DateUpdated datetime 16,3 √ null

Update timestamp - Date and time when gap analysis was last updated or reviewed
UpdatedBy int 4 √ null

Update user reference - Links to AccessUser table for the user who last updated the gap analysis
AuthId int 4 √ null

Authorization reference - Links to service authorization associated with the identified gap
Scenario varchar 500 √ null

Gap scenario description - Detailed description of the service gap scenario and circumstances
DateCreated datetime 16,3 √ null

Creation timestamp - Date and time when gap analysis record was initially created
StartDate datetime 16,3 √ null

Gap period start - Beginning date of the identified service gap period
EndDate datetime 16,3 √ null

Gap period end - Ending date of the identified service gap period
WeeksBetween int 4 √ null

Gap duration in weeks - Number of weeks between services in the identified gap
MonthsBetween int 4 √ null

Gap duration in months - Number of months between services in the identified gap
ExpectedSessions int 4 √ null

Expected session count - Number of sessions that should have occurred during the gap period
GapIdentified int 4 √ null

Gap identification flag - Numeric indicator for the type or severity of gap identified
MissedSessions int 4 √ null

Missed session count - Actual number of sessions missed during the gap period
Status varchar 100 √ null

Gap status - Current status of gap resolution (e.g., ‘Open’, ‘Resolved’, ‘Under Review’)

Indexes

Constraint Name Type Sort Column(s)
PK_Gaps Primary key Asc pkGapID
IX_ClaimID Must be unique Asc/Asc ClaimID1 + ClaimID2

Relationships

Close relationships within degrees of separation