Table Description
Plan Item Good Cause Link: A link between a plan item and a good cause.

This entity is focused on the administration of the relationship between plan items and good cause within the Service Planning Administration component.

Example

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

Linda is unable to perform the Full-time Job Search plan item due to illness. The actual outcome of this plan item is set to Not Attained and a good cause of Certified Illness is selected for this plan item.

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

This link entity enables the sharing of good cause across multiple plan items.

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::PlanItem::LinkTables::PlanItemGoodCauseLink::Entity::PlanItemGoodCauseLink
Controlling File: ServicePlans\model\Packages\Service Layer\Administration\PlanItem\LinkTables\PlanItemGoodCauseLink\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
planItemGoodCauseLinkIDkeynoUnique reference number assigned by the system to a plan item good cause record.PLAN_ITEM_GOOD_CAUSE_LINK_ID SVR_INT64
planItemIDdetailsnoUnique reference number of the plan item for which the good cause was created.PLAN_ITEM_ID SVR_INT64
goodCauseIDdetailsnoUnique reference number of the good cause which was created for the associated plan itemGOOD_CAUSE_ID SVR_INT64
Foreign Keys (2)
ChildParent
PlanItemGoodCauseLink.goodCauseIDGoodCause.goodCauseID
PlanItemGoodCauseLink.planItemIDPlanItem.planItemID
Indices (2)
Index NameAttributes
PGCLGdCauseIDIdxgoodCauseID
PGCLGdCauseKeyIdxplanItemID, goodCauseID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: planItemGoodCauseLinkID
AUTO_ID_KEY: SERCPLANBO
Standard Operation 
removeByPlanItemIDAndGoodCauseIDnsremove Removes plan item good cause link record for specified plan item and good cause. 
searchByPlanItemIDreadmulti Returns all columns of plan item good cause link for the given plan item ID. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies a row of data from plan item good cause link table. 
readread Reads a row of data from plan item good cause link table. 
insertPlanItemGoodCauseLinkinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts plan Item good cause link record. This method expects the planItemGoodCauseLinkID to be set. It is preferred to call <font color="#000000">insertPlanItemGoodCauseLink</font> method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
Related Pages (3)