Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ReviewID | int identity | 4 | null |
|
|
Review primary key - Unique identifier for each IFSP review |
||
| IFSPID | int | 4 | √ | null |
|
|
IFSP reference - Links to IFSP table for the associated individualized family service plan |
|
| ReviewType | int | 4 | √ | null |
|
|
Review type - Type classification of the IFSP review (Annual, Semi-annual, etc.) |
|
| DateDue | smalldatetime | 16 | √ | null |
|
|
Due date - Date when the IFSP review is due |
|
| DateSubmitted | smalldatetime | 16 | √ | null |
|
|
Submission date - Date when the IFSP review was submitted |
|
| DateActual | smalldatetime | 16 | √ | null |
|
|
Actual completion date - Date when the IFSP review was actually completed |
|
| Pre-Due Date | smalldatetime | 16 | √ | null |
|
|
Pre-due notification date - Calculated date 35 days before due date for early notification |
|
| Post-Submitted Date | smalldatetime | 16 | √ | null |
|
|
Post-submission date - Calculated date one month after submission for follow-up tracking |
Relationships
Close relationships within degrees of separation
