Table Description
Outcome Plan Recommendation: Stores the current recommendations for an Outcome Plan.

When an activity or objective is recommended for an Outcome Plan a record is stored on this table to avoid the re-calculation of recommendations each time the workspace is opened. Recommendations are refreshed at various points in the life cycle of a plan, e.g. plan creation, assessment execution, new client, etc...

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::OutcomePlanRecommendation::OutcomePlanRecommendation
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery\OutcomePlanRecommendation.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
outcomePlanRecommendationIDkeynoUnique identified for the table.INTERNAL_ID SVR_INT64
caseParticipantRoleIDdetailsnoThe ID of the Outcome Plan Participant that the recommendation is for.CASE_PARTICIPANT_ROLE_ID SVR_INT64
relatedTypedetailsnoThe type of the recommendation item, e.g. activty/objective.OUTCOMEPLAN_RECOMMENDABLE_TYPERecommendableTypeSVR_STRING<10>
relatedIDdetailsnoThe id of the item being recommended, e.g. objectiveID, actionID, etc...INTERNAL_ID SVR_INT64
activityTypedetailsyesIf the item being recommended is an activity, this fields contains the type of activity being recommended.OUTCOME_PLAN_ACTIVITY_TYPEOutcomePlanActivityTypeSVR_STRING<10>
nameTextIDdetailsyesThe identifier for the localizable name of the recommended item. May be null if the item doesn't have a localizable name record.LOCALIZABLE_TEXT_ID SVR_INT64
recordStatusdetailsnoThe status of the expected outcome, i.e. active, cancelled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
outcomePlanIDdetailsnoThe ID of the Outcome Plan that the recommendation is for.INTERNAL_ID SVR_INT64
lapseDatedetailsyesFor recommendations contributed only by assessment factors which have reassessment dates set, this contains the date at which this recommendation will expire. If the a non-lapsable reason also contributes to this recommendation, this value will be null. For multiple assessment factors only, the furthest factor is used to determine the lapse date for the recommendation.CURAM_DATE SVR_DATE
Foreign Keys (4)
ChildParent
OutcomePlanRecommendation.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
OutcomePlanRecommendation.nameTextIDLocalizableText.localizableTextID
OutcomePlanRecommendation.outcomePlanIDOutcomePlan.outcomePlanID
PlanRecommendationReason.outcomePlanRecommendationIDOutcomePlanRecommendation.outcomePlanRecommendationID
Indices (4)
Index NameAttributes
PlanRecommendationIdxoutcomePlanID, relatedType, recordStatus
PlanRecommendationActivityIdxoutcomePlanID, caseParticipantRoleID, relatedType, activityType, relatedID, recordStatus
PlanRecommendationByRelIdxoutcomePlanID, caseParticipantRoleID, relatedType, relatedID, recordStatus
IND__11191170nameTextID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: outcomePlanRecommendationID
Standard persistence insert. 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard persistence modify. 
readread Standard persistence read. 
searchByOutcomePlanRelatedTypeAndStatusreadmulti Search by outcome plan, related type and record status. 
searchByOutcomePlanParticipantRelatedTypeActivityAndStatusreadmulti Search by outcome plan, related type, related ID and record status. 
searchByOutcomePlanParticipantRelatedTypeAndStatusreadmulti Search by outcome plan, related type, participant and record status. 
searchByOutcomePlanRelatedTypeStatusLimitAndNotAlreadyAddednsmulti Search by outcome plan, related type, record status and not already added to plan. Also limits the result set. SQL
searchByOutcomePlanRelatedTypeStatusLimitAndNotAlreadyAddednsmulti Search by outcome plan, related type, record status and not already added to plan. Also limits the result set. SQL
Related Pages (1)