Table Description
Service Plan Goal Link: An association between a service plan and a goal.

This table allows the administration of the links between service plans and 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. Plan item Childcare Provision is added to the Childcare sub-goal.

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

This entity enables the sharing and reuse of goals across multiple service plans.

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::ServicePlan::LinkTables::ServicePlanGoalLink::Entity::ServicePlanGoalLink
Controlling File: ServicePlans\model\Packages\Service Layer\Administration\ServicePlan\LinkTables\ServicePlanGoalLink\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
servicePlanGoalLinkIDkeynoUnique reference number assigned by the system to a service plan goal record.SERVICE_PLAN_GOAL_LINK_ID SVR_INT64
servicePlanIDdetailsnoUnique reference number of the service plan with which the goal is associated.SERVICE_PLAN_ID SVR_INT64
goalIDdetailsnoUnique reference number of the goal with which the service plan is associated.GOAL_ID SVR_INT64
Foreign Keys (2)
ChildParent
ServicePlanGoalLink.goalIDGoal.goalID
ServicePlanGoalLink.servicePlanIDServicePlan.servicePlanID
Indices (2)
Index NameAttributes
SPGLGoalIndexgoalID
SPGLSPlanIndexservicePlanID, goalID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: servicePlanGoalLinkID
AUTO_ID_KEY: SERCPLANBO
Standard Operation 
readread Standard Operation 
removeremove Standard Operation 
countByGoalIDAndServicePlanIDns  SQL
removeByServicePlanIDAndGoalIDnsremove   
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies a row of data from service plan goal link table. 
searchByServicePlanIDreadmulti Returns all columns of service plan goal link for the given service plan ID. 
insertServicePlanGoalLinkinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts service plan goal link record. This method expects the servicePlanGoalLinkID to be set. It is preferred to call <font color="#000000">insertServicePlanGoalLink</font> method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
Related Pages (5)