Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| IFSPID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each Individualized Family Service Plan record |
||||
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Links to the child receiving early intervention services under this IFSP |
||||
| IFSPdate | datetime | 16,3 | √ | null |
|
|
IFSP creation date - Date when the Individualized Family Service Plan was initially created or last updated |
||||
| IFSPTypeID | int | 4 | √ | null |
|
|
IFSP type reference - Links to IFSPType table for the specific type of IFSP (Initial, Annual, Interim, etc.) |
||||
| Comment | varchar | 255 | √ | null |
|
|
IFSP comments - General comments, notes, or observations related to the IFSP development and implementation |
||||
| ReviewPending | int | 4 | √ | null |
|
|
Review pending flag - Numeric indicator for pending review status or review type required |
||||
| oldid | int | 4 | √ | null |
|
|
Legacy identifier - Previous system identifier for data migration and historical reference |
||||
| IFSPConsent | datetime | 16,3 | √ | null |
|
|
Consent date - Date when family provided consent for IFSP services and implementation |
||||
| caseID | int | 4 | √ | null |
|
|
Case reference - Links to PatientAdministration table for the administrative case associated with this IFSP (foreign key to PatientAdministration.AdmitID) |
||||
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation timestamp - Date and time when IFSP record was initially created in the system |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Creator reference - Links to AccessUser table for the service coordinator or staff who created the IFSP |
||||
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Update timestamp - Date and time when IFSP record was last modified |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updater reference - Links to AccessUser table for the staff who last updated the IFSP |
||||
| Status | varchar | 10 | √ | null |
|
|
IFSP status - Current status of the IFSP (e.g., ‘Active’, ‘Closed’, ‘Pending’, ‘Draft’) |
||||
| ClosureDate | smalldatetime | 16 | √ | null |
|
|
Closure date - Date when IFSP was closed or services were terminated |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_IFSP | Primary key | Asc | IFSPID |
| IX_PatientID | Performance | Asc | PatientID |
Relationships
Close relationships within degrees of separation
