Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each custom authorization record |
|
| fkAuthID | int | 4 | null |
|
|
Authorization reference - Links to Authorize table for the base authorization |
||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date and time when the custom record was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this custom record |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date and time of the last modification |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified this record |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Soft delete timestamp for audit trail purposes |
|
| Comments | nvarchar | 1073741823 | √ | null |
|
|
Authorization comments - Additional comments and notes about the authorization |
|
| ReasonForDelay | nvarchar | 1073741823 | √ | null |
|
|
Delay reason - Detailed explanation for any delays in service delivery |
|
| CoVisitiswithandFreq | nvarchar | 510 | √ | null |
|
|
Co-visit configuration - Configuration details for co-visit sessions and frequency |
|
| ESID | nvarchar | 510 | √ | null |
|
|
Early Steps ID - Early Steps program identifier for tracking |
|
| IndividualorGroup | nvarchar | 510 | √ | null |
|
|
Service delivery type - Specification of individual or group service delivery |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AuthorizeCustom | Primary key | Asc | pkID |
Relationships
Close relationships within degrees of separation
