Table Description
Outcome Plan Recommendation Update Time: Stores the recommendation generation time and status for an Outcome Plan and a recommendable entity type (activity, objective, etc).

This entity records the recommendation generation status (invalidated, calculated, etc) for a given outcome plan and recommendable entity type (activity, objective) combination. In addition to the generation state, this entity also stores the generation timestamp. The timestamp is used to determine if administration actions have invalidated previous recommendation generation runs.

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::OutcomePlanRecUpdateTime::OutcomePlanRecUpdateTime
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery\OutcomePlanRecUpdateTime.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
recommendationUpdatedTimedetailsyes

This value is used to help determine if the recommendations for an outcomeplan must be recalculated.

To accomplish this, this value is compared against the OutcomePlanAdmin.recommendationRelatedUpdateTm to ensure that no admin-side events - that may force a recommendation recalculation - have occurred since the given recommendations have been calculated. The admin value being newer than the delivery value, indicates that such an admin event has occurred.

The reason for the split is to reduce the number of DB records that must be updated as the result of admin side events. For example if there are 100k instances of a particular outcome plan admin type, modification of an admin object would not cause the modification of any of these records. As a result, admin side DB updates are well bounded in terms of the number of DB updates involved in a given transaction.

CURAM_DATETIME SVR_DATETIME
recommendationStatedetailsnoTracks the state (calculated, invalidated, calculating..) of the recommendation processing for this outcome plan.RECOMMENDATION_STATERecommendationStateSVR_STRING<10>
outcomePlanRecUpdateTimeIDkeynoUnique identified for the table.INTERNAL_ID SVR_INT64
outcomePlanIDdetailsnoThe ID of the Outcome Plan that the recommendation is for.INTERNAL_ID SVR_INT64
relatedTypedetailsnoThe type of the recommendation item, e.g. activty/objective.OUTCOMEPLAN_RECOMMENDABLE_TYPERecommendableTypeSVR_STRING<10>
recordStatusdetailsnoThe status of the expected outcome, i.e. active, cancelled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
OutcomePlanRecUpdateTime.outcomePlanIDOutcomePlan.outcomePlanID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: outcomePlanRecUpdateTimeID
Standard persistence insert. 
readread Standard persistence read. 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard persistence modify. 
searchByOutcomePlanIDreadmulti Read all values for an outcome plan. 
batchModifybatchmodify Batch modification operation to efficiently invalidate multiple values. 
readByOutcomePlanIDAndTypensread Read the recommendation update time by outcome plan and type. 
Related Pages (1)