Objective


Description

IFSP objective management storing detailed objectives linked to goals for Individualized Family Service Plans and early intervention services. This table manages objective descriptions, configuration settings, comments, and tracking information, supporting goal-based intervention planning, progress monitoring, and IFSP compliance for early intervention services and family-centered care planning.

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.GoalID FK_Objective_Goal R

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
CustomConfig.configID FK_Objective_CustomConfig R

Teaching configuration reference - Links to CustomConfig table for teaching method configuration (foreign key to CustomConfig.configID)

fkConfigIDA int 4 null
CustomConfig.configID FK_Objective_CustomConfig1 R

Assessment configuration reference - Links to CustomConfig table for assessment method configuration (foreign key to CustomConfig.configID)

fkConfigIDC int 4 null
CustomConfig.configID FK_Objective_CustomConfig2 R

Criteria configuration reference - Links to CustomConfig table for success criteria configuration (foreign key to CustomConfig.configID)

fkConfigIDP int 4 null
CustomConfig.configID FK_Objective_CustomConfig3 R

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
AccessUser.UserID FK_Objective_AccessUser R

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
AccessUser.UserID FK_Objective_AccessUser1 R

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