Table Description
Goal Sub-Goal Link: A relationship between a service plan goal and a service plan sub-goal.

This table allows the administration of the links between goals and sub-goals within Service Planning Administration.

Example

A case worker creates a Return to Work service plan for participant Linda Smith who has recently become unemployed. A goal of Sustainable Employment is selected for this service plan. A Transportation sub-goal is added to the service plan as she is unable to pay for transport to get to work. A Mileage Reimbursement Plan item is added to the service plan to achieve the service plan sub-goal.

She also needs assistance with paying for childcare and as such a Childcare sub-goal is added to the service plan. A Childcare Provision plan item is added to the Childcare sub-goal.

The following has been set up in the Administration component to achieve to this:

  • An administrator creates a Return to Work service plan.
  • A Sustainable Employment goal is then added.
  • Transportation and Childcare sub-goals are linked to the goal, and Mileage Reimbursement and Childcare Provision plan items are linked to the Transportation and Childcare sub-goals respectively.
This entity enables the sharing and reuse of sub-goals across multiple goals.

Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::ServicePlans::Administration::Goal::LinkTables::GoalSubGoalLink::Entity::GoalSubGoalLink
Controlling File: ServicePlans\model\Packages\Service Layer\Administration\Goal\LinkTables\GoalSubGoalLink\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
goalSubGoalLinkIDkeynoUnique reference number assigned by the system to a goal sub-goal record.GOAL_SUBGOAL_LINK_ID SVR_INT64
goalIDdetailsnoUnique reference number of the goal with which the sub-goal is associated.GOAL_ID SVR_INT64
subGoalIDdetailsnoUnique reference number of the sub-goal with which the goal is associated.SUBGOAL_ID SVR_INT64
Foreign Keys (2)
ChildParent
GoalSubGoalLink.goalIDGoal.goalID
GoalSubGoalLink.subGoalIDSubGoal.subGoalID
Indices (2)
Index NameAttributes
GoalSubGoalIndexgoalID, subGoalID
GSGLSubGoalIndexsubGoalID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: goalSubGoalLinkID
AUTO_ID_KEY: SERCPLANBO
Standard Operation 
readread Standard Operation 
removeByGoalIDAndSubGoalIDnsremove Removes link record for the specified Goal and SubGoal. 
searchSubGoalsByGoalAndTypensmulti Lists all sub goals of the particular type assigned to a goal.SQL
searchByGoalIDreadmulti Returns all columns of goal sub goal link for the given goal ID. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies a row of data from goal sub goal link table. 
insertGoalSubGoalLinkinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts goal subgoal link record. This method expects the goalSubGoalLinkID to be set. It is preferred to call <font color="#000000">insertGoalSubGoalLink</font> method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
Related Pages (5)