Table Description
SubGoal Outcome Link: Links an SubGoal with an Outcome.
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::SubGoalOutcomeLink::Entity::SubGoalOutcomeLink
Controlling File: ServicePlans\model\Packages\Service Layer\Administration\SubGoal\LinkTables\SubGoalOutcomeLink\Entity\SubGoalOutcomeLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
subGoalOutcomeLinkIDkeynoSystem generated unique ID.SUBGOAL_OUTCOME_LINK_ID SVR_INT64
outcomeIDdetailsnoForeign key from Outcome entity.OUTCOME_ID SVR_INT64
subGoalIDdetailsnoForeign key from SubGoal entity.SUBGOAL_ID SVR_INT64
Foreign Keys (2)
ChildParent
SubGoalOutcomeLink.outcomeIDOutcome.outcomeID
SubGoalOutcomeLink.subGoalIDSubGoal.subGoalID
Indices (2)
Index NameAttributes
SGOLOutcomeIndexoutcomeID
SGOLSubGoalIndexsubGoalID, outcomeID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: subGoalOutcomeLinkID
AUTO_ID_KEY: SERCPLANBO
Standard Operation 
readread Standard Operation 
removeremove Standard Operation 
countBySubGoalIDAndOutcomeIDns Used to check if an outcome is associated with a sub goal.SQL
removeBySubGoalIDAndOutcomeIDnsremove Removes an outcome from a sub goal. 
searchBySubGoalIDreadmulti Returns all columns of sub goal outcome link for the given sub goal ID. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies a row of data from sub goal outcome link table. 
insertSubGoalOutcomeLinkinsert Inserts sub goal outcome link record. This method expects the subGoalOutcomeLinkID to be set. It is preferred to call insertSubGoalOutcomeLink method only in scenarios where calling method wants to set the value of primary key by itself. 
Related Pages (3)