Table Description
Goal Contract Text: A link between a plan goal and contract text.

This entity is focused on the administration of the relationship between goals and contract text within the Service Planning Administration component.

Example

A case worker creates a Return to Work service plan for participant Linda Smith as she has recently become unemployed. A goal of Sustainable Employment is selected for this service plan. A Find a Job sub-goal is added to the service plan. A Full-time Job Search plan item is added to the service plan as activity for Linda Smith to achieve the service plan Goal of Sustainable Employment. An expected outcome of Full-time Employment is selected for the Full-time Job Search plan item.

The service plan is approved and a contract is issued. The contract text displayed for the Sustainable Employment goal is in Spanish as it is the preferred language of the plan participant Linda Smith.

The following has been set up within the Curam Service Planning Administration component to achieve to this:

  • An administrator creates a Return to Work service plan.
  • He associates the Sustainable Employment goal to the Return to Work service plan.
  • The administrator creates contract text in each language for the Sustainable Employment goal.
This link entity enables the sharing of contract text 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::GoalContractText::Entity::GoalContractText
Controlling File: ServicePlans\model\Packages\Service Layer\Administration\Goal\LinkTables\GoalContractText\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
goalContractTextIDkeynoUnique reference number assigned by the system to a goal contact text record.GOAL_CONTRACT_TEXT_ID SVR_INT64
goalIDdetailsnoUnique reference number of the goal for which the contract text is being created.GOAL_ID SVR_INT64
contractTextIDdetailsnoUnique reference number of the contract text which was created for the associated goal.CONTRACT_TEXT_ID SVR_INT64
Foreign Keys (2)
ChildParent
GoalContractText.contractTextIDContractText.contractTextID
GoalContractText.goalIDGoal.goalID
Indices (1)
Index NameAttributes
goalContractTextIndexgoalID, contractTextID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: goalContractTextID
AUTO_ID_KEY: SERCPLANBO
Standard Operation 
readread Standard Operation 
removeByGoalIDAndContractTextIDnsremovePRE_DATA_ACCESS: no
Removes GoalContractText by goalID and contractTextID. 
searchByGoalIDreadmulti Returns all columns of goal contract text for the given goal ID. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies a row of data from goal contract text table. 
insertGoalContractTextinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts goal contract text record. This method expects the&nbsp;goalContractTextID&nbsp;to be set. It is preferred to call insertGoalContractText method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
Related Pages (2)