Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ObjectiveID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each IFSP objective |
||||
| fkGoalID | int | 4 | √ | null |
|
|
Goal reference - Links to Goal table for the associated IFSP goal (foreign key to Goal.GoalID) |
||||
| Objective | text | 2147483647 | √ | null |
|
|
Objective description - Detailed description of the specific measurable objective |
||||
| fkConfigIDT | int | 4 | √ | null |
|
|
Teaching configuration reference - Links to CustomConfig table for teaching method configuration (foreign key to CustomConfig.configID) |
||||
| fkConfigIDA | int | 4 | √ | null |
|
|
Assessment configuration reference - Links to CustomConfig table for assessment method configuration (foreign key to CustomConfig.configID) |
||||
| fkConfigIDC | int | 4 | √ | null |
|
|
Criteria configuration reference - Links to CustomConfig table for success criteria configuration (foreign key to CustomConfig.configID) |
||||
| fkConfigIDP | int | 4 | √ | null |
|
|
Progress configuration reference - Links to CustomConfig table for progress tracking configuration (foreign key to CustomConfig.configID) |
||||
| Comments | text | 2147483647 | √ | null |
|
|
Objective comments - Additional comments, notes, or observations related to the objective |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Creator reference - Links to AccessUser table for the service coordinator who created this objective (foreign key to AccessUser.UserID) |
||||
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation timestamp - Date and time when the objective was created |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updater reference - Links to AccessUser table for the user who last updated this objective |
||||
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Update timestamp - Date and time when the objective was last modified |
||||
| StatusID | int | 4 | √ | null |
|
|
Status reference - Links to iCS2.dbo.StatusType for centralized status management and objective status classification |
||||
| DateSession | smalldatetime | 16 | √ | null |
|
|
Session date - Date of the session when the objective was addressed |
||||
| DeletedDate | Unknown | 0 | null |
|
|
Deletion timestamp - Date and time when the objective was soft deleted |
|||||
| fkObjID | int | 4 | √ | null |
|
|
Parent objective reference - Links to parent objective for hierarchical objective structure |
||||
| SupervisorComments | text | 2147483647 | √ | null |
|
|
Supervisor comments - Comments and feedback from supervisors regarding the objective |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Objective | Primary key | Asc | ObjectiveID |
Relationships
Close relationships within degrees of separation
