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 |
Relationships
Close relationships within degrees of separation
