Table Description
Outcome Plan Expected Outcome : An objective which a client or a number of clients are trying to achieve within an outcome plan.

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 'Remain Clean and Sober' objective 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::OutcomePlanExpectedOutcome::OutcomePlanExpectedOutcome
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery\OutcomePlanExpectedOutcome.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (15)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
outcomePlanExpectedOutcomeIDkeynoThe unique identifier for the record.INTERNAL_ID SVR_INT64
expectedOutcomeIDdetailsnoThe unique identifier for an expected outcome administration type.INTERNAL_ID SVR_INT64
expectedEndDatedetailsnoThe date the expected outcome is expected to be completed.CURAM_DATE SVR_DATE
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 expected outcome was created.CURAM_DATE SVR_DATE
createdBydetailsnoThe user name of the user who created the expected outcome.USER_NAME SVR_STRING<64>
completedBydetailsyesThe user name of the user who completed the expected outcome.USER_NAME SVR_STRING<64>
completionCommentsdetailsyesComments entered on the completion of the expected outcome. 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 expected outcome, e.g. Attained, Not Attained.EXPECTED_OUTCOME_ACHIEVEDExpectedOutcomeAchievedSVR_STRING<10>
outcomePlanIDdetailsnoThe unique identifier for the outcome plan this expected outcome is on.CASE_ID SVR_INT64
noteIDdetailsyesThe identifier for the related notes note record.NOTE_ID SVR_INT64
customNameTextIDdetailsyesThe custom localizable name of the Outcome Plan Expected Outcome.LOCALIZABLE_TEXT_ID SVR_INT64
Foreign Keys (8)
ChildParent
OutcomePlanExpectedOutcome.expectedOutcomeIDExpectedOutcome.expectedOutcomeID
OutcomePlanExpectedOutcome.customNameTextIDLocalizableText.localizableTextID
OutcomePlanExpectedOutcome.noteIDNote.noteID
OutcomePlanExpectedOutcome.outcomePlanIDOutcomePlan.outcomePlanID
OutcomePlanExpectedOutcome.createdByUsers.userName
OutcomePlanExpectedOutcome.completedByUsers.userName
ExpectedOutcomeClient.outcomePlanExpectedOutcomeIDOutcomePlanExpectedOutcome.outcomePlanExpectedOutcomeID
OPExpectedOutcomeActivity.outcomePlanExpectedOutcomeIDOutcomePlanExpectedOutcome.outcomePlanExpectedOutcomeID
Indices (6)
Index NameAttributes
IND__993199562outcomePlanID
IND__88528299expectedOutcomeID
IND_1109578116customNameTextID
IND_380186189noteID
IND__862753889createdBy
IND_715064898completedBy
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: outcomePlanExpectedOutcomeID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByOutcomePlanAndStatusreadmultiORDER_BY: expectedEndDate
Searches for active expected outcomes on the specified outcome plan. 
searchByStatusAndExpectedOutcomereadmulti   
Related Pages (57)
New Objective (AddExpectedOutcomeWizard_factors)
New Objective (ExpectedOutcomeSearchWizard_addObjective)
Home (MDTOutcomePlan_home)
New Outcome Plan (NewOutcomePlanWizard_planDetails)
New Outcome Plan (OutcomePlan_accessibleCreateFromPerson)
Add Clients (OutcomePlan_addClientsToExpectedOutcome)
New Note (OutcomePlan_addExpectedOutcomeNote)
Add Factors (OutcomePlan_addFactorsToExpectedOutcome)
Add Objectives (OutcomePlan_addObjectivesToAction)
Add Objectives (OutcomePlan_addObjectivesToReferral)
Add Objectives (OutcomePlan_addObjectivesToService)
Delete Action (OutcomePlan_cancelAction)
Delete Objective (OutcomePlan_cancelExpectedOutcome)
Complete Objective (OutcomePlan_completeExpectedOutcome)
Complete Objective (OutcomePlan_completeExpectedOutcome1)
New Outcome Plan (OutcomePlan_createForSingleClient)
New Objective (OutcomePlan_createOutcomePlanExpectedOutcome)
New Objective (OutcomePlan_createOutcomePlanExpectedOutcomeMultipleClients)
Edit Objective (OutcomePlan_editExpectedOutcome)
Update Completion Details (OutcomePlan_editExpectedOutcomeCompletionDetails)
New Outcome Plan (OutcomePlan_enhancedCreate)
New Outcome Plan (OutcomePlan_enhancedCreate1)
Home (OutcomePlan_home)
Objectives (OutcomePlan_listActionObjectives)
Activities (OutcomePlan_listActions)
Activities (OutcomePlan_listExpectedOutcomeCurrentActivities)
Activities (OutcomePlan_listExpectedOutcomeCurrentLinkedActivities)
Objectives (OutcomePlan_listExpectedOutcomes)
Reasons (OutcomePlan_listRecommendedActivitiesReasonDetails)
Activities (OutcomePlan_listReferrals)
Activities (OutcomePlan_listServices)
Remove Activity (OutcomePlan_removeActivityFromObjective)
Remove Client (OutcomePlan_removeClient)
Remove Client (OutcomePlan_removeClientsFromExpectedOutcome)
Remove Factors (OutcomePlan_removeFactorFromExpectedOutcome)
Remove Objective (OutcomePlan_removeObjectiveFromActivity)
Update Expected End Date (OutcomePlan_updateExpectedOutcomeExpectedEndDate)
) (OutcomePlan_viewExpectedOutcomeContextPanel)
Expected End Date History (OutcomePlan_viewExpectedOutcomeExpectedEndDateHistory)
Factor History (OutcomePlan_viewExpectedOutcomeFactorHistory)
Home (OutcomePlan_viewExpectedOutcomeHome)
OutcomePlan_viewExpectedOutcomeOverview
OutcomePlan_viewFactorRecommendationClientExpectedOutcomeDetails
Objective (OutcomePlan_viewObjectiveDetails)
End Date History (OutcomePlan_viewObjectiveEndDateHistory)
Latest Note (OutcomePlan_viewObjectiveLatestNote)
Notes (OutcomePlan_viewObjectiveNotes)
Delete Objective (OutcomePlanAdmin_cancelExpectedOutcome)
New Referral: (OutcomePlanCollaborationPreselectedReferralWizard_factors)
OutcomePlanCollaborationPreselectedReferralWizard_sharing
New Referral (OutcomePlanCollaborationReferralWizard_factors)
OutcomePlanCollaborationReferralWizard_sharing
New Referral: (OutcomePlanPreselectedReferralWizard_factors)
Objectives (OutcomePlanReferral_listObjectives)
New Referral (OutcomePlanReferralWizard_factors)
Objectives (OutcomePlanService_listObjectives)
SimpleCreateAction