Table Description
Outcome Plan Goal: An outcome plan goal represents the ultimate goal of a client on an outcome plan or the goal of an outcome plan.

A case worker can specify a goal for the outcome plan and/or a goal for each client on the outcome plan. An indicator exists on the outcome plan administration entity which dictates where the goal can be specified i.e. for the outcome plan only, for a client on the outcome plan only or for both.

Example

A case worker assesses James Smith's strengths and needs and identifies that he has problems finding work and is alcohol dependent. To address these issues the case worker creates an outcome plan. A plan goal of self sufficiency is added to the plan. An objective of 'Remain Clean and Sober' is selected and added to the plan. This entity stores the details of the self sufficiency goal added to the outcome plan.
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::OutcomePlanning::OutcomePlan::Entity::Delivery::OutcomePlanGoal::OutcomePlanGoal
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery\OutcomePlanGoal.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (15)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
outcomePlanGoalIDkeynoThe unique identifier for the record.INTERNAL_ID SVR_INT64
outcomePlanGoalAdminIDdetailsnoThe unique identifier for an outcome plan goal administration this outcome plan goal is related to.INTERNAL_ID SVR_INT64
reasondetailsnoThe reason why a user is adding this expected outcome to the outcome plan for a client.OUTCOME_PLAN_RICH_TEXT_SMALL SVR_STRING<2000>
reasonNotattaineddetailsyesThe reason why the outcome was not attained.REASON_OUTCOME_NOT_ATTAINEDReasonOutcomeUnattainedSVR_STRING<10>
completionDatedetailsyesThe date the expected outcome was completed.CURAM_DATE SVR_DATE
creationDatedetailsnoThe date the outcome goal was created.CURAM_DATE SVR_DATE
createdBydetailsnoThe name of the user who created the outcome plan goal.USER_NAME SVR_STRING<64>
completedBydetailsyesThe name of the user who completed the outcome plan goal.USER_NAME SVR_STRING<64>
completionCommentsdetailsyesComments added by a user when completing the outcome plan goal.OUTCOME_PLAN_RICH_TEXT_SMALL SVR_STRING<2000>
recordStatusdetailsnoThe status of the expected outcome, i.e. active, cancelled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
outcomedetailsnoThe outcome of the outcome plan goal, e.g. Attained, Not Attained.EXPECTED_OUTCOME_ACHIEVEDExpectedOutcomeAchievedSVR_STRING<10>
outcomePlanIDdetailsnoUnique identifier of the outcome plan the outcome plan goal has been created in relation to. INTERNAL_ID SVR_INT64
noteIDdetailsyesThe identifier for the related notes note record.NOTE_ID SVR_INT64
caseParticipantRoleIDdetailsyesThe case participant role of a client the outcome plan goal is in relation to.CASE_PARTICIPANT_ROLE_ID SVR_INT64
planGoalTypedetailsnoIdentifies the type of outcome plan goal i.e. outcome plan or client.OUTCOME_PLAN_GOAL_TYPEOPGoalTypeSVR_STRING<10>
Foreign Keys (6)
ChildParent
OutcomePlanGoal.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
OutcomePlanGoal.noteIDNote.noteID
OutcomePlanGoal.outcomePlanGoalAdminIDOutcomePlanGoalAdmin.outcomePlanGoalAdminID
OutcomePlanGoal.outcomePlanIDOutcomePlan.outcomePlanID
OutcomePlanGoal.createdByUsers.userName
OutcomePlanGoal.completedByUsers.userName
Indices (6)
Index NameAttributes
IND_1632319653outcomePlanID
IND_31995267caseParticipantRoleID
IND__45236546noteID
IND_1710118317outcomePlanGoalAdminID
IND__182961778createdBy
IND_1160254577completedBy
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: outcomePlanGoalID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByOutcomePlanCaseParticipantRoleGoalTypeAndStatusreadmultiORDER_BY: creationDate
Search the outcome plan goal entity and retrieves any records that are related to the given outcome plan identifier, case participatn role identifier, plan goal type, and record status.  
searchByOutcomePlanPlanGoalTypeAndStatusreadmultiORDER_BY: creationDate
Search the outcome plan goal entity and retrieves any records that are related to the given outcome plan identifier, plan goal type, and record status. 
readVersionNonsread Reads the version no value for an Outcome Plan Goal. 
Related Pages (29)