Goal


Description

Treatment goals and objectives - Core table managing therapeutic goals, treatment objectives, and outcome measures for patient care plans. This table stores detailed goal descriptions, configuration settings, progress tracking, and administrative information to support individualized treatment planning, progress monitoring, and outcome measurement for healthcare service delivery.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
GoalID int identity 4 √ null
Objective.fkGoalID FK_Objective_Goal R
ObjectiveInGoal.fkGoalID FK__Objective__fkGoa__50F27938 R

Goal primary key - Unique identifier for each treatment goal
fkAuthID int 4 √ null
Authorize.AuthID FK_Goal_Authorize R

Authorization reference - Links to Authorize table for the associated service authorization
Goal text 2147483647 √ null

Goal description - Detailed description of the therapeutic goal or treatment objective
fkConfigIDM int 4 √ null
CustomConfig.configID FK_Goal_CustomConfig R

Measurement config reference - Links to CustomConfig for measurement configuration
fkConfigIDR int 4 √ null
CustomConfig.configID FK_Goal_CustomConfig1 R

Reporting config reference - Links to CustomConfig for reporting configuration
fkConfigIDP int 4 √ null
CustomConfig.configID FK_Goal_CustomConfig2 R

Progress config reference - Links to CustomConfig for progress tracking configuration
fkConfigIDA int 4 √ null
CustomConfig.configID FK_Goal_CustomConfig3 R

Assessment config reference - Links to CustomConfig for assessment configuration
Comments text 2147483647 √ null

Goal comments - Additional notes and comments about the goal
CreateBy int 4 √ null
AccessUser.UserID FK_Goal_AccessUser R

Created by user - UserID of the person who created this goal
DateCreated smalldatetime 16 √ null

Creation date - Date when this goal was created
UpdatedBy int 4 √ null
AccessUser.UserID FK_Goal_AccessUser1 R

Updated by user - UserID of the person who last updated this goal
DateUpdated smalldatetime 16 √ null

Last update date - Date when this goal was last modified
StatusID int 4 √ null

Goal status - Current status of the goal referencing iCS2.dbo.StatusType for centralized status management

Indexes

Constraint Name Type Sort Column(s)
PK_Goal Primary key Asc GoalID

Relationships

Close relationships within degrees of separation