Table Description
Outcome: The desired result of a plan item upon completion of the plan item.

This entity is focused on the administration of expected outcomes within the Service Planning Administration component. At least one expected outcome must be setup for each plan item.

Example

A case worker creates a Return to Work service plan for participant Linda Smith as she has recently become unemployed. A Sustainable Employment 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.

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

This setup ensures that the Full-time Employment expected outcome is available for selection when delivering a Full-time Job Search plan item within a Sustainable Employment goal.

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::Outcome::Entity::Outcome
Controlling File: ServicePlans\model\Packages\Service Layer\Administration\Outcome\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
outcomeIDkeynoUnique reference number assigned by the system to an outcome record.OUTCOME_ID SVR_INT64
outcomeReferencedetailsyesUser entered reference number to represent this type of outcome. This can be used to reference this type of outcome from other areas of the system, e.g. the rules engine.REFERENCE_NUMBER SVR_STRING<20>
descriptiondetails Textual description of the outcome.DESCRIPTION SVR_STRING<300>
namedetailsnoName of the outcome. This is a code table value for translation purposes.OUTCOME_NAME_CODEOutcomeNameSVR_STRING<10>
dateCreateddetails Date on which the outcome definition was created.CURAM_DATE SVR_DATE
recordStatusdetails Status of the outcome record. The values are 'Active' or 'Canceled'. Logical deletion is supported.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
descriptionTextIDdetailsyesUnique Identifier corresponding to localized description of OutcomeLOCALIZABLE_TEXT_ID SVR_INT64
Foreign Keys (6)
ChildParent
Outcome.descriptionTextIDLocalizableText.localizableTextID
CaseHeader.expectedOutcomeOutcome.outcomeID
GoalOutcomeLink.outcomeIDOutcome.outcomeID
OutcomeLink.outcomeIDOutcome.outcomeID
PlanItemOutcomeLink.outcomeIDOutcome.outcomeID
SubGoalOutcomeLink.outcomeIDOutcome.outcomeID
Indices (3)
Index NameAttributes
OutcomeDescriptionIDIndexdescriptionTextID
OutcomeStatusNameIndexrecordStatus, name
OutcomeRefNoIndexoutcomeReference
Operations (22)
OperationStereotypeOptionsDescriptionSQL
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Cancels Outcome. 
countByNameAndStatusns Counts all outcomes with the specified name and record status.SQL
countByReferencens Counts outcomes by reference.SQL
insertinsertAUTO_ID: outcomeID
AUTO_ID_KEY: SERCPLANBO
PRE_DATA_ACCESS: yes
Standard Operation 
listnsmulti Returns a list of all Outcome records.SQL
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
readNamensread Reads the outcome name. 
readNameAndReferencensread Reads outcome name and reference. 
readStatusnsread Reads record status for the specified outcome. 
validateCancel  This method validates outcome canceling. 
validateDetails  Validates outcome details. 
validateInsert  Validates details for insert. 
validateModify  Validates details for modify. 
countGoalsByOutcomeAndStatusns Counts goals that the outcome is associated with.SQL
countPlanItemsByOutcomeAndStatusns Count planItems that the outcome is associated with.SQL
countSubGoalsByOutcomeAndStatusns Counts sub goals that the outcome is associated with.SQL
listAllNamesAndIDsnsmulti Reads names and IDs of all existing outcomes.SQL
readAllnkreadmulti Retrieves a list of all Outcome entries. 
insertOutcomeinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts outcome record. This method expects the outcomeID to be set. It is preferred to call <font color="#000000">insertOutcome</font> method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
modifyDescriptionTextIDnsmodifyOPTIMISTIC_LOCKING: yes
Modifies descriptionTextID. 
modifyOutcomemodifyOPTIMISTIC_LOCKING: yes
This modify operation will be called while re-applying a change set in the target system. Entity level validations that will happen during a standard modify operation will not be applicable in this case. This modify operation will update all the attributes defined for this entity. 
Related Pages (74)
Modify Case Details (CHIPProductDelivery_modifyHeader)
New Product Delivery (DefaultIC_createProductDelivery)
Home (DefaultIC_home)
Edit Case (DefaultICProduct_modifyHeader)
Evidence Site Map (Evidence_siteMap)
Home (HCRIC_home)
Edit Case (ICProductSample_modifyHeader)
Create Delivery (ICSample_createProductDelivery)
Home (ICSample_home)
Site Map (ICSample_sportingGrantSiteMap)
Home (ICSampleSportingGrant_home)
Edit Case (ICSportingGrantSample_modifyHeader)
Edit Case Details (IntegratedCase_modifyHeader)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Expected Outcome Search (ProductDelivery_expectedOutcomeSearchPopup)
Edit Case Details (ProductDelivery_modifyHeader)
Edit Case (ProductDelivery_modifyHeader1)
Create Expected Outcome for Service (ProviderManagement_createOutcomeForServiceOffering)
Expected Outcomes for Service:# END, CR00260713 (ProviderManagement_listOutcomesForServiceOffering)
Site Map (Sample_sportingGrantProductSiteMap)
Add Existing Expected Outcomes to Plan Item (ServicePlanAdmin_addOutcomesToPlanItem)
Add Existing Expected Outcome to Sub Goal (ServicePlanAdmin_addOutcomesToSubGoal)
New Text Translation (ServicePlanAdmin_addServicePlanOutcomeDescriptionTextTranslation)
Delete Expected Outcome (ServicePlanAdmin_cancelOutcome)
Add Plan Item to Service Plan Template Sub Goal (ServicePlanAdmin_confirmAddTemplatePlanItem)
New Expected Outcome (ServicePlanAdmin_createOutcome)
New Expected Outcome for Goal (ServicePlanAdmin_createOutcomeForGoal)
New Expected Outcome for Plan Item (ServicePlanAdmin_createOutcomeForPlanItem)
New Expected Outcome for Sub Goal (ServicePlanAdmin_createOutcomeForSubGoal)
Expected Outcome Search (ServicePlanAdmin_expectedOutcomeSearchPopup)
View Localizable Text (ServicePlanAdmin_listLocalizableServicePlanOutcomeDescriptionText)
Expected Outcomes (ServicePlanAdmin_listOutcomes)
Expected Outcomes (ServicePlanAdmin_listOutcomes1)
Edit Text Translation (ServicePlanAdmin_modifyLocalizableServicePlanOutcomeDescriptionTextTranslation)
Edit Expected Outcome (ServicePlanAdmin_modifyOutcome)
Expected Outcome Home (ServicePlanAdmin_outcomeHome)
Add Plan Item (ServicePlanDelivery_addCustomServicePlanItem)
Add Plan Item (ServicePlanDelivery_addServicePlanItem)
Approve Service Plan (ServicePlanDelivery_approve)
Clone Service Plan (ServicePlanDelivery_clone)
New Baseline (ServicePlanDelivery_createBaseline)
Weekly Client Participation (ServicePlanDelivery_customPlanItemClientParticipationWeeklyList)
Weekly Participation (ServicePlanDelivery_customServicePlanItemClientParticipationWeeklyList)
Attachments (ServicePlanDelivery_listCustomPlannedItemAttachments)
Attachments (ServicePlanDelivery_listCustomServicePlannedItemAttachments)
Attachments (ServicePlanDelivery_listPlannedItemAttachments)
Attachments (ServicePlanDelivery_listServicePlannedItemAttachments)
Attachments (ServicePlanDelivery_listServiceUnitPlannedItemAttachments)
Edit Plan Item (ServicePlanDelivery_modifyCustomPlanItem)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyPlanItem_NameEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanBasicPlanItem)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyServiceUnitPlanItem)
Weekly Participation (ServicePlanDelivery_planItemClientParticipationWeeklyList)
- (ServicePlanDelivery_planItemTabDetails)
Delete Plan Item : (ServicePlanDelivery_removePlanItem)
Delete Plan Item (ServicePlanDelivery_removeServicePlanPlanItem)
Weekly Participation (ServicePlanDelivery_servicePlanItemClientParticipationWeeklyList)
Weekly Client Participation (ServicePlanDelivery_serviceUnitPlanItemClientParticipationWeeklyList)
Submit Service Plan (ServicePlanDelivery_submit)
Home (ServicePlanDelivery_viewCustomPlanItem)
Home (ServicePlanDelivery_viewCustomPlanItem_fromGantt)
Home (ServicePlanDelivery_viewCustomServicePlanItem)
View Custom Service Plan Item Details: (ServicePlanDelivery_viewCustomServicePlanItem_fromGantt)
Home (ServicePlanDelivery_viewServicePlanBasicPlanItem)
Home (ServicePlanDelivery_viewServicePlanBasicPlanItem_fromGantt)
Home (ServicePlanDelivery_viewServicePlanItem)
View Service Plan Item Details: (ServicePlanDelivery_viewServicePlanItem_fromGantt)
Home (ServicePlanDelivery_viewServiceUnitPlanItem)
Home (ServicePlanDelivery_viewServiceUnitPlanItem_fromGantt)
Modify Case Details (TBBCCProductDelivery_modifyHeader)