Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| OutcomeID | int identity | 4 | null |
|
|
Outcome primary key - Unique identifier for each IFSP outcome |
||
| fkIFSPID | int | 4 | √ | null |
|
|
IFSP reference - Links to IFSP table for the associated individualized family service plan |
|
| Outcome | nvarchar | 1073741823 | √ | null |
|
|
Outcome description - Detailed description of the expected outcome or goal |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this outcome |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when this outcome was created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this outcome |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last update date - Date when this outcome was last modified |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when this outcome was soft deleted (null for active outcomes) |
|
| Order | bigint | 8 | √ | null |
|
|
Display order - Sequential row number for consistent ordering in displays |
Relationships
Close relationships within degrees of separation
