Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ReviewID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each IFSP review record |
|
| IFSPID | int | 4 | √ | null |
|
|
IFSP reference - Links to IFSP table for the Individualized Family Service Plan being reviewed |
|
| ReviewType | int | 4 | √ | null |
|
|
Review type reference - Links to review type classification (Annual, Interim, Six-month, etc.) |
|
| DateDue | smalldatetime | 16 | √ | null |
|
|
Review due date - Date when the IFSP review is scheduled to be completed |
|
| DateSubmitted | smalldatetime | 16 | √ | null |
|
|
Submission date - Date when the completed review was submitted |
|
| DateActual | smalldatetime | 16 | √ | null |
|
|
Actual review date - Date when the review meeting or assessment actually occurred |
|
| oldIFSPID | int | 4 | √ | null |
|
|
Legacy IFSP reference - Previous system identifier for data migration and historical tracking |
Relationships
Close relationships within degrees of separation
