Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each IFSP custom record |
|
| fkIFSPID | int | 4 | null |
|
|
IFSP reference - Links to IFSP table for the main Individualized Family Service Plan |
||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date when this custom IFSP record was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this record |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last update date - Date when this record was last updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this record |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when this record was deleted (soft delete for audit trail) |
|
| ConsentForServices | datetime | 16,3 | √ | null |
|
|
Consent date - Date when consent for services was obtained from family |
|
| Comments | nvarchar | 1073741823 | √ | null |
|
|
Custom comments - Additional comments and notes specific to this IFSP |
|
| ESID | nvarchar | 510 | √ | null |
|
|
Early intervention service ID - External identifier for early intervention services |
|
| PlanNumber | int | 4 | √ | null |
|
|
Plan number - Sequential or reference number for the IFSP plan |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__IFSPCust__40A359E32182C3AB | Primary key | Asc | pkID |
Relationships
Close relationships within degrees of separation
