Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Gaps_ClaimID1 | int | 4 | √ | null |
|
|
First claim reference - Links to the first claim in the service gap analysis for comparison and gap identification |
|
| Gaps_ClaimID2 | int | 4 | √ | null |
|
|
Second claim reference - Links to the second claim in the service gap analysis for comparison and gap identification |
|
| Gaps_pkGapID | int | 4 | null |
|
|
Gap primary key - Unique identifier for each service gap analysis record |
||
| GapsCustom_pkID | int | 4 | null |
|
|
Custom record primary key - Unique identifier for each custom gap analysis record |
||
| GapsCustom_fkGapID | int | 4 | null |
|
|
Gap reference - Links to Gaps table for the associated service gap analysis |
||
| GapsCustom_DateCreated | datetime | 16,3 | √ | null |
|
|
Custom record creation - Date and time when custom gap record was created |
|
| GapsCustom_CreatedBy | int | 4 | √ | null |
|
|
Custom record creator - User who created this custom gap record |
|
| GapsCustom_DateUpdated | datetime | 16,3 | √ | null |
|
|
Custom record update - Date and time when custom gap record was last updated |
|
| GapsCustom_UpdatedBy | int | 4 | √ | null |
|
|
Custom record updater - User who last updated this custom gap record |
|
| GapsCustom_FromDate | datetime | 16,3 | √ | null |
|
|
Custom gap start - Alternative or additional start date for gap analysis period |
|
| GapsCustom_ToDate | datetime | 16,3 | √ | null |
|
|
Custom gap end - Alternative or additional end date for gap analysis period |
|
| GapsCustom_InformedOnDate | datetime | 16,3 | √ | null |
|
|
Family notification - Date when family was informed about the service gap |
|
| GapsCustom_FamilyWillWait | nvarchar | 6 | √ | null |
|
|
Family waiting preference - Whether family is willing to wait for current provider |
|
| GapsCustom_FamilyNeedProvider | nvarchar | 6 | √ | null |
|
|
Provider replacement need - Whether family needs a replacement provider |
|
| GapsCustom_TestBitColumn | bit | 1 | √ | null |
|
|
Test boolean field - Testing boolean field for custom gap analysis features |
|
| GapsCustom_test_gap_column | nvarchar | 510 | √ | null |
|
|
Test custom field - Testing field for custom gap analysis data |
|
| GapsCustom_Reason | nvarchar | 4000 | √ | null |
|
|
Gap reason description - Detailed reason for the service gap occurrence |
|
| GapsCustom_MakeupDate | datetime | 16,3 | √ | null |
|
|
Makeup session date - Date when makeup session was scheduled or provided |
|
| GapsCustom_RestaffedOnDate | datetime | 16,3 | √ | null |
|
|
Restaffing date - Date when provider was replaced or restaffed for gap resolution |
Relationships
Close relationships within degrees of separation
