Table Description
Outcome Plan Recommendation Reason: Stores the reasons for a Recommendation.

When an activity or objective is recommended for an Outcome Plan, all the reasons for the recommendation are recorded on this table.

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::PlanRecommendationReason
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery\OutcomePlanRecommendation.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
planRecommendationReasonIDkeynoUnique identifier for the table.INTERNAL_ID SVR_INT64
outcomePlanRecommendationIDdetailsnoId of the related Outcome Plan Recommendation record.INTERNAL_ID SVR_INT64
relatedTypedetailsnoThe type of the related object that the recommendation reason was derived from, e.g. plan, objective, factor classification, etc...RECOMMENDATION_RELATED_TYPERecommendationRelatedTypeSVR_STRING<10>
relatedRecommendationAdminIDdetailsyesThe unique identified for the related recommendation admin that produced the recommendation reason (e.g. recommendationAdminID, recommendExpectedOutcomeAdminID, etc). For ruleset recommendations, this ID will be blank.INTERNAL_ID SVR_INT64
rulesResourceNamedetailsyesThe name of the app resource record that holds the ruleset reason text. For non-ruleset recommendations, this field will be blank.APP_RESOURCE_NAME SVR_STRING<256>
rulesHeaderResourceKeydetailsyesThe app resource property key that contains the reason header text. For non-ruleset recommendations, this field will be blank.APP_RESOURCE_KEY SVR_STRING<200>
rulesReasonResourceKeydetailsyesThe app resource property key that contains the reason text. For non-ruleset recommendations, this field will be blank.APP_RESOURCE_KEY SVR_STRING<200>
factorDeliveryIDdetailsyesId of the related factor delivery.INTERNAL_ID SVR_INT64
recordStatusdetailsnoThe status of the expected outcome, i.e. active, cancelled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
PlanRecommendationReason.factorDeliveryIDFactorDelivery.factorDeliveryID
PlanRecommendationReason.outcomePlanRecommendationIDOutcomePlanRecommendation.outcomePlanRecommendationID
Indices (2)
Index NameAttributes
PlanRecommendationReasonIdxoutcomePlanRecommendationID, recordStatus
IND__547001961factorDeliveryID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: planRecommendationReasonID
Standard persistence insert. 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard persistence modify. 
readread Standard persistence read. 
searchRecommendationAndRecordStatusreadmulti Searches by outcome plan recommendation and record status. 
Related Pages (1)