Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| IFSPID | int | 4 | null |
|
|
IFSP identifier - Unique identifier for each Individualized Family Service Plan |
||
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Links to the child receiving early intervention services |
|
| caseID | int | 4 | √ | null |
|
|
Case reference - Links to administrative case associated with this IFSP |
|
| IFSPdate | datetime | 16,3 | √ | null |
|
|
IFSP date - Date when the IFSP was created or last updated |
|
| IFSPTypeID | int | 4 | √ | null |
|
|
IFSP type identifier - Links to IFSP type classification |
|
| IFSPConsent | datetime | 16,3 | √ | null |
|
|
Consent date - Date when family provided consent for IFSP services |
|
| Comment | varchar | 255 | √ | null |
|
|
IFSP comments - General comments and observations related to the IFSP |
|
| ClosureDate | smalldatetime | 16 | √ | null |
|
|
Closure date - Date when IFSP was closed or services terminated |
|
| ReviewID | int | 4 | √ | null |
|
|
Review identifier - Links to specific IFSP review record |
|
| ReviewDesc | varchar | 30 | √ | null |
|
|
Review description - Description of the review type (Annual, Interim, etc.) |
|
| DateDue | smalldatetime | 16 | √ | null |
|
|
Review due date - Date when IFSP review is scheduled to be completed |
|
| DateSubmitted | smalldatetime | 16 | √ | null |
|
|
Review submission date - Date when completed review was submitted |
|
| DateActual | smalldatetime | 16 | √ | null |
|
|
Actual review date - Date when review meeting actually occurred |
|
| IFSPTypeName | varchar | 50 | √ | null |
|
|
IFSP type name - Descriptive name of the IFSP type from configuration |
|
| ReviewType | int | 4 | √ | null |
|
|
Review type identifier - Numeric identifier for the type of review |
|
| Status | varchar | 10 | √ | null |
|
|
IFSP status - Current status of the IFSP (Active, Closed, Pending, etc.) |
Relationships
Close relationships within degrees of separation
