Table Description
Sub-Goal Contract Text: A link between a sub-goal and contract text record.

This entity is focused on the administration of the relationship between sub-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 and the Find a Job sub-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.
  • The Sustainable Employment goal is associated with the service plan and a Find a Job sub-goal with this goal.
  • Contract text is associated with both the Sustainable Employment goal and the Find a Job sub-goal.
  • The administrator creates contract text in each language for the Sustainable Employment goal
This link entity enables the sharing of contract text across multiple sub-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::SubGoal::LinkTables::SubGoalContractText::Entity::SubGoalContractText
Controlling File: ServicePlans\model\Packages\Service Layer\Administration\SubGoal\LinkTables\SubGoalContractText\Entity\SubGoalContractText_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
subGoalContractTextIDkeynoUnique reference number assigned by the system to a goal contact text record.SUBGOAL_CONTRACT_TEXT_ID SVR_INT64
contractTextIDdetailsnoUnique reference number of the contract text which was created for the associated sub-goal.CONTRACT_TEXT_ID SVR_INT64
subGoalIDdetailsnoUnique reference number of the sub-goal for which the contract text is being created.SUBGOAL_ID SVR_INT64
Foreign Keys (2)
ChildParent
SubGoalContractText.contractTextIDContractText.contractTextID
SubGoalContractText.subGoalIDSubGoal.subGoalID
Indices (1)
Index NameAttributes
SGCTRemoveIdxsubGoalID, contractTextID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: subGoalContractTextID
AUTO_ID_KEY: SERCPLANBO
Standard Operation 
readread Standard Operation 
removeremove Standard Operation 
countBySubGoalIDContractLanguageAndStatusns Used to check if a sub goal has a related contract text in a specific language with a particular record status.SQL
removeBySubGoalIDAndContractTextIDnsremove Removes a contract text from a sub goal. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies a row of data from sub goal contract text table. 
searchBySubGoalIDreadmulti Returns all columns of sub goal contract text for the given sub goal ID. 
insertSubGoalContractTextinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts subgoal contract text record. This method expects the subGoalContractText to be set. It is preferred to call <font color="#000000">insertSubGoalContractText</font> method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
Related Pages (2)