Table Description
Expected Outcome Client : A client associated with an objective on 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 links James Smith to the objective.

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::ExpectedOutcomeClient
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery\OutcomePlanExpectedOutcome.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
expectedOutcomeClientIDkeynoUnique identifier of the expected outcome client record.INTERNAL_ID SVR_INT64
caseParticipantRoleIDdetailsnoUnique identifier of the concern role for the client on the expected outcome.CASE_PARTICIPANT_ROLE_ID SVR_INT64
outcomePlanExpectedOutcomeIDdetailsnoUnique identifier of the related outcome plan expected outcome.INTERNAL_ID SVR_INT64
recordStatusdetailsnoThe status of the expected outcome client link record, which can be Active or Cancelled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
ExpectedOutcomeClient.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
ExpectedOutcomeClient.outcomePlanExpectedOutcomeIDOutcomePlanExpectedOutcome.outcomePlanExpectedOutcomeID
Indices (2)
Index NameAttributes
searchByExpectedOutcomeStsIdxoutcomePlanExpectedOutcomeID, recordStatus
searchByCaseParticipantRoleIdxcaseParticipantRoleID, recordStatus
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: expectedOutcomeClientID
Standard Operation 
searchByOutcomePlanExpectedOutcomeAndStatusreadmulti Returns a list of records for the specified OutcomePlanExpectedOutcome. 
searchByCaseParticipantRoleAndStatusreadmulti Returns a list of records for the specified Case Participant Role and status.  
modifymodifyOPTIMISTIC_LOCKING: no
Standard Operation 
readByCaseParticipantRoleExpectedOutcomeAndStatusnsread Returns the record for the given Case Participant Role, Outcome Plan Expected Outcome and Status. 
Related Pages (22)