Table Description
Outcome Plan Recent Item : Details of an activity (service,referral, actions) that was added to an outcome plan to address a factor classification of a factor.

A record is created on this table whenever an activity is added to an outcome plan. These recent items are then displayed along with recommended activities in the Recommendations panel on the Outcome Plan Workspace. The intention is to show the user, along with the current recommendations, other activities have recently been added for the same factor classification but currently are not recommended. The m most recent activities for the last n days, where m & n are configurable values, will be displayed and these activities will be calculated using the dateAdded field.

Example

On Day 1, an assessment identifies that James Smith is classified as Low in the Substance Abuse factor. The caseworker adds an activity to address this, Activity 1. On Day 2, an assessment identifies that Linda Smith is classified as Low in the Education factor, and that Robert Smith is rated as High in the Education factor. Activity 2 is added for Linda, and Activity 3 for Robert. On Day 3, an assessment identifies that Margaret Smith is rated as Low in the Substance Abuse factor, and Medium in the Education factor. On the Outcome Plan Workspace, the caseworker is presented with Recommendations for Maragret Smith for both the Education & Substance Abuse Factors. Under Substance Abuse, the system shall present Activity 1 as a recent item. Activity 1 is not currently recommended but it was added for another client with the same rating for the Substance Abuse Factor. Under Education, the system shall not present any recent items, because no items have been added for other clients rated Medium in the education factor. Note that the configurations M & N will influence what is displayed. (The M most recent activities for the last N days). If N=0 then no recent items would be displayed despite items having been added for the same factor and rating.

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::OutcomePlanRecentItem::OutcomePlanRecentItem
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
outcomePlanRecentItemIDkeynoUnique identifier of the Recent ItemINTERNAL_ID SVR_INT64
activityIDdetailsnoUnique identifier of the Outcome Plan Activity from administration, whose addition precipitated the creation of this Recent Item record.INTERNAL_ID SVR_INT64
activityTypedetailsnoThe type of activity from administration which the outcomePlanActivityID field refers to.OUTCOME_PLAN_ACTIVITY_TYPEOutcomePlanActivityTypeSVR_STRING<10>
factorIDdetailsnoThe Factor for which the Activity added was flagged as contributing to improving the rating of that Factor, as part of the process of adding this Activity to the Outcome Plan. A combination of this field, along with classificationID is used to determine if a recent item has been added for a particular criteria, ie same Factor, same Rating.INTERNAL_ID SVR_INT64
classificationIDdetailsnoThe Classification for which the Activity added was flagged as contributing to improving the rating of the corresponding Factor, as part of the process of adding this Activity to the Outcome Plan. A combination of this field, along with factorID is used to determine if a recent item has been added for a particular criteria, ie same Factor, same Rating.INTERNAL_ID SVR_INT64
dateAddeddetailsnoThe date this Recent Item was created. This is captured to allow retrieval of recent items for the past N days.CURAM_DATE SVR_DATE
outcomePlanActivityIDdetailsyesUnique identifier of the Outcome Plan Activity from the delivery side, whose addition precipitated the creation of this Recent Item record.INTERNAL_ID SVR_INT64
addedBydetailsnoThe user who added this recent item. (ie the user who added the acitivity which precipitated the creation of this record.)USER_NAME SVR_STRING<64>
Foreign Keys (3)
ChildParent
OutcomePlanRecentItem.classificationIDCategoryClassification.categoryClassificationID
OutcomePlanRecentItem.factorIDFactor.factorID
OutcomePlanRecentItem.addedByUsers.userName
Indices (5)
Index NameAttributes
OutcomePlanRecItemDateAddIdxdateAdded
OutcomePlanRecItemActivityIdxactivityID
IND__1857443561classificationID
IND_403811904factorID
IND__320267487addedBy
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: outcomePlanRecentItemID
Standard Operation 
searchActivitiesByFactorClassificationAndDatensmulti Returns a list of recent items for the given Classification and Factor where the date added is later than the given date. The returned list is grouped by Activity, and ordered by the most frequently added Activity for the given Factor and Classification SQL
searchByActivityIDActivityTypereadmultiWHERE: activityID=:activityID AND activityType=:activityType AND factorID=:factorID AND classificationID=:classificationID AND dateAdded > :date
Returns a list of recent items for the given Activity ID and type, Classification and Factor where the date added is later than the given date. 
Related Pages (3)