Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each custom gap analysis record |
||||
| fkGapID | int | 4 | null |
|
|
Gap reference - Links to Gaps table for the associated service gap analysis (foreign key to Gaps.pkGapID) |
|||||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - Date and time when custom gap record was created |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Creator reference - Links to AccessUser table for the user who created this custom gap record |
||||
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update timestamp - Date and time when custom gap record was last updated |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Update user reference - Links to AccessUser table for the user who last updated this custom gap record |
||||
| FromDate | datetime | 16,3 | √ | null |
|
|
Custom gap start date - Alternative or additional start date for gap analysis period |
||||
| ToDate | datetime | 16,3 | √ | null |
|
|
Custom gap end date - Alternative or additional end date for gap analysis period |
||||
| InformedOnDate | datetime | 16,3 | √ | null |
|
|
Family notification date - Date when family was informed about the service gap |
||||
| FamilyWillWait | nvarchar | 6 | √ | null |
|
|
Family waiting preference - Indicates whether family is willing to wait for current provider (Yes/No) |
||||
| FamilyNeedProvider | nvarchar | 6 | √ | null |
|
|
Provider replacement need - Indicates whether family needs a replacement provider (Yes/No) |
||||
| TestBitColumn | bit | 1 | √ | null |
|
|
Test boolean field - Testing or development boolean field for custom gap analysis features |
||||
| test_gap_column | nvarchar | 510 | √ | null |
|
|
Test custom field - Testing or development field for custom gap analysis data |
||||
| Reason | nvarchar | 4000 | √ | null |
|
|
Gap reason - Detailed reason or explanation for the service gap |
||||
| MakeupDate | datetime | 16,3 | √ | null |
|
|
Makeup date - Date when makeup services are scheduled to address the gap |
||||
| RestaffedOnDate | datetime | 16,3 | √ | null |
|
|
Restaffing date - Date when provider was replaced or restaffed for gap resolution |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_GapsCustom | Primary key | Asc | pkID |
Relationships
Close relationships within degrees of separation
