Table Description
Outcome Plan Case Link : A link between an outcome plan and a case.

This entity allows any type of case to be linked to an outcome plan.

Example

An outcome plan is created for James Smith, Linda Smith and their child Robert to identify and address their issues. It is created from their Child Welfare integrated case. The Family Strengths and Needs Assessment (FSN) Assessment is run from this outcome plan by a case worker. Activities(services, actions and referrals are created to address the identified needs. This entity stores the link between the family's outcome plan and their Child Welfare case.

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::OutcomePlanCaseLink::OutcomePlanCaseLink
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery\OutcomePlanCaseLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
outcomePlanCaseLinkIDkeynoUnique identifier for the entity.INTERNAL_ID SVR_INT64
outcomePlanIDdetailsnoThe id of the outcome plan.CASE_ID SVR_INT64
relatedCaseIDdetailsnoThe id of the case that is linked to the outcome plan.CASE_ID SVR_INT64
startDatedetailsnoThe date the case was linked to the outcome plan. The attribute is automatically populated wit the current date when the record is created.CURAM_DATE SVR_DATE
endDatedetailsyesThe date the link record was ended. This attribute is automatically populated when the link record is cancelled.CURAM_DATE SVR_DATE
recordStatusdetailsnoThe status of the link record.RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
OutcomePlanCaseLink.relatedCaseIDCaseHeader.caseID
OutcomePlanCaseLink.outcomePlanIDOutcomePlan.outcomePlanID
Indices (2)
Index NameAttributes
caseAndStatusIdxoutcomePlanID, recordStatus
relatedCaseAndStatusIdxrelatedCaseID, recordStatus
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: outcomePlanCaseLinkID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByCaseAndStatusreadmultiORDER_BY: startDate
Searches for link record based on outcome plan and record status ordered by start date. Used to list all the related case link records with a particular record status for an outcome plan. 
searchByRelatedCaseAndStatusreadmultiORDER_BY: startDate
Searches for link record based on related case and record status ordered by start date. This operation can be used to list all the outcome plans linked to a particular case. 
readByRelatedCaseOutcomePlanAndStatusnsread Reads a case link record based on outcome plan, related case and record status. 
Related Pages (21)