Table Description
Sub-Goal: A sub-goal is a measurable component of a service plan, with the ultimate aim of achieving a service plan goal.

This entity is focused on the administration of a sub-goal within the Service Planning Administration component. A sub-goal can be associated with one or more goals which in turn can be associated with one or more service plans. A sub-goal can have one or more plan items associated with it. Sub-goals are categorized into Achieve an Objective, Meet a Need and Overcome a Barrier.

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.

Linda Smith is unable to pay for transport to get to work, therefore a Transportation sub-goal is added to the service plan. A Mileage Reimbursement plan item is added to the service plan to allow Linda to overcome the barrier that she's currently facing.

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

This setup ensures that the Transportation sub-goal is available for selection when delivering a Return to Work service plan with a Sustainable Employment goal.

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::Entity::SubGoal
Controlling File: ServicePlans\model\Packages\Service Layer\Administration\SubGoal\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
subGoalIDkeynoUnique reference number assigned by the system to a sub-goal record.SUBGOAL_ID SVR_INT64
subGoalReferencedetails User entered reference number to represent this type of sub-goal. This can be used to reference this type of sub-goal from other areas of the system, e.g. the rules engine.REFERENCE_NUMBER SVR_STRING<20>
namedetailsnoName of the sub-goal. This is a code table value for translation purposes.SUBGOAL_NAME_CODESubGoalNameSVR_STRING<10>
typeCodedetails Type of sub-goal being created - Achieve an Objective, Meet a Need or Overcome a Barrier.SUBGOAL_TYPE_CODESubGoalTypeSVR_STRING<10>
dateCreateddetails Date on which the sub-goal definition was created.CURAM_DATE SVR_DATE
descriptiondetails Textual description of the sub-goal.DESCRIPTION SVR_STRING<300>
recordStatusdetails Status of the sub-goal record. The values are Active or Canceled. Logical deletion is supported.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
descriptionTextIDdetailsyesUnique Identifier corresponding to the localized text of sub goal description.LOCALIZABLE_TEXT_ID SVR_INT64
Foreign Keys (7)
ChildParent
SubGoal.descriptionTextIDLocalizableText.localizableTextID
GoalSubGoalLink.subGoalIDSubGoal.subGoalID
PlanTemplateSubGoal.subGoalIDSubGoal.subGoalID
PlannedSubGoal.subGoalIDSubGoal.subGoalID
SubGoalContractText.subGoalIDSubGoal.subGoalID
SubGoalOutcomeLink.subGoalIDSubGoal.subGoalID
SubGoalPlanItemLink.subGoalIDSubGoal.subGoalID
Indices (3)
Index NameAttributes
SubGoalDescTxtIDIdxdescriptionTextID
SGStatusNameIndexrecordStatus, name
SGReferenceIndexsubGoalReference
Operations (29)
OperationStereotypeOptionsDescriptionSQL
cancelnsmodifyPRE_DATA_ACCESS: yes
Cancels a sub goal. 
countByNameAndStatusns Counts the number of sub goals that have the specified name.SQL
countByReferencens Counts the number of sub goals that have the specified reference number.SQL
insertinsertAUTO_ID: subGoalID
AUTO_ID_KEY: SERCPLANBO
PRE_DATA_ACCESS: yes
Standard Operation 
readAllnkreadmulti Lists all sub goals. 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Modifies a sub goal. 
readread Reads the details of a sub goal. 
readCreationDatensread Reads the creation date of a sub goal. 
readNameAndReferencensread Reads the name and reference number of a sub goal. 
readRecordStatusnsread Reads the record status of a sub goal. 
searchPlanItemsnsmulti Searches for planItems associated with a sub goal.SQL
searchContractTextsnsmulti Searches for contract texts associated with a sub goal.SQL
searchOutcomesnsmulti Searches for outcomes associated with a sub goal.SQL
searchUnassociatedPlanItemsByStatusnsmulti Searches for planItems not associated with a sub goal and having a specific status.SQL
searchUnassociatedOutcomesByStatusnsmulti Searches for outcomes not associated with a sub goal and having a specific status.SQL
validateCancel  Validates that a sub goal can be canceled. 
validateDetails  Validates the sub goal details. 
validateInsert    
validateModify  Validates the modification of a sub goal. 
readNamensread Reads sub goal name. 
countGoalsBySubGoalAndStatusns Count goals that the sub goal is associated with.SQL
listTypesnsmulti Returns all type codes available for a subgoal.SQL
searchByTypeAndStatusnsmulti Returns all subgoals for a given typeSQL
searchPlanItemsForSubGoalnsmulti @deprecated since curam 6.0, replace by {@Link SubGoal#searchPlanItemsForSubGoal1()}. See release note : CR00247170 Searches for planItems associated with a sub goal, returns the planItemID, planItemName, planItemTypeCode and the description. SQL
searchAllPossibleOutcomesForSubGoalnsmulti lists all possible outcomes available for a sub-goal.SQL
insertSubGoalinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts sub goal record. This method expects the subGoalID to be set. It is preferred to call <font color="#000000">insertSubGoal</font> method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
modifyDescriptionTextIDnsmodifyOPTIMISTIC_LOCKING: yes
Modifies descriptionTextID. 
searchPlanItemsForSubGoal1nsmulti Searches for planItems associated with a sub goal, returns the planItemID, planItemName, planItemTypeCode and the description. SQL
modifySubGoalmodifyOPTIMISTIC_LOCKING: yes
This modify operation will be called while re-applying a change set in the target system. Entity level validations that will happen during a standard modify operation will not be applicable in this case. This modify operation will update all the attributes defined for this entity. 
Related Pages (20)