Table Description
Outcome Plan Favourite : Stores the details of an objective or activity that the user marks as a favorite on an outcome plan.

Users have the ability to mark objectives/activities as favorites from the workspace on an outcome plan. Activities/objectives that have been marked as favorites are available for the user to view from the Favorites list on the workspace. Favorites are stored on a per user basis, and they can be viewed by the user across plans and plan types.

Example

A user in the organization regularly adds an objective of Improve Mental Health to client outcome plans. The user marks the Improve Mental Health objective as a favorite so that she can easily access it from her Favorites list.

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::OutcomePlanFavourite::OutcomePlanFavourite
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery\OutcomePlanFavourite.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
outcomePlanFavouriteIDkeynoUnique identifier of the outcome plan favorite record.INTERNAL_ID SVR_INT64
usernamedetailsnoThe name of the user who marked the objective/activity as a favorite.USER_NAME SVR_STRING<64>
relatedIDdetailsnoThe ID of the objective/activity that has been marked as a favorite.INTERNAL_ID SVR_INT64
recordStatusdetailsnoStatus of the favorite record i.e. Active, Cancelled. RECORD_STATUS_CODERecordStatusSVR_STRING<10>
relatedTypedetailsnoThe type of plan item that has been marked as a favorite, i.e., Objective or Acivity.OUTCOME_PLAN_ITEM_TYPEOPItemTypeSVR_STRING<10>
activityTypedetailsyesThe type of activity that has been marked as a favorite, i.e., Action, Service or Referral. OUTCOME_PLAN_ACTIVITY_TYPEOutcomePlanActivityTypeSVR_STRING<10>
relatedNameTextIDdetailsnoThe identifier of the localizable name of the plan item that has been marked as a favorite. LOCALIZABLE_TEXT_ID SVR_INT64
Foreign Keys (1)
ChildParent
OutcomePlanFavourite.relatedNameTextIDLocalizableText.localizableTextID
Indices (3)
Index NameAttributes
OPFavouriteUserIndxusername
IND_795202805relatedID
IND__875301011relatedNameTextID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: outcomePlanFavouriteID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByUserRelatedTypeAndStatusreadmulti Returns a list of Outcome Plan Favourite records for the given user, related type, and status. 
readByUserRelatedIDTypesAndStatusnsread Returns an Outcome Plan Favourite record for the given user, related ID, related type, activity type and status. 
readByUserRelatedIDRelatedTypeAndStatusnsread Returns an Outcome Plan Favourite record for the given user, related ID, related type, and status. 
searchByUserRelatedTypeStatusAndPlannsmulti  SQL
searchByUserRelatedTypeStatusAndPlannsmulti  SQL
Related Pages (0)