Table Description
Recommendation Administration : Stores service, action and referral recommendations for a factor classification or a factor classification subdivision.

Recommended activities are displayed to a case worker on the activity workspace and are based on a client scoring a particular classification/score when assessed for a factor.

Example

An outcome plan is created for James Smith, Linda Smith and their child Robert to identify and address their issues. The Family Strengths and Needs Assessment (FSN) Assessment is run from this outcome plan by a case worker. James Smith is classified as having a Need in Substance Abuse and as such a counseling service is recommended by the system. Linda Smith is classified as a Need in Parenting Skills and as such a Parenting Skills class is recommended by the system. This entity allows for these activities to be recommended.

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::Admin::RecommendationAdmin::RecommendationAdmin
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Admin\RecommendationAdmin_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
recordStatusdetailsnoThe record status of the recommendation.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
recommendationAdminIDkeynoUnique identifier for a recommendation.INTERNAL_ID SVR_INT64
relatedIDdetailsnoThe unique identifier of either the record the recommendation is in relation to. For example, an outcome plan.INTERNAL_ID SVR_INT64
activityTypedetailsnoThe type of entity being associated with the recommendation. For example, a service offering.OUTCOME_PLAN_ACTIVITY_TYPEOutcomePlanActivityTypeSVR_STRING<10>
activityIDdetailsnoThe unique identifier of the entity is being associated with. For example, a service offering.INTERNAL_ID SVR_INT64
reasonTextIDdetailsnoThe reason an recommendation is recommended for a client.LOCALIZABLE_TEXT_ID SVR_INT64
recommendationTypedetailsyesIndicates whether the recommendation is advised or discretionary.RECOMMENDATIONRecommendationSVR_STRING<10>
relatedTypedetailsnoDescribes the type of record the recommendation will be created in relation to. For example, an outcome plan.RECOMMENDATION_RELATED_TYPERecommendationRelatedTypeSVR_STRING<10>
Foreign Keys (3)
ChildParent
RecommendationAdmin.reasonTextIDLocalizableText.localizableTextID
RecommendationAdminCaseLink.recommendationAdminIDRecommendationAdmin.recommendationAdminID
RecommendationConditionLink.recommendationAdminIDRecommendationAdmin.recommendationAdminID
Indices (3)
Index NameAttributes
RecAdminIDTypeAndStatusIndexrelatedID, recordStatus, relatedType
IND__843551405activityID
IND__1864837867reasonTextID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: recommendationAdminID
AUTO_ID_KEY: OUTPLANBO
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByRelatedIDRelatedTypeAndStatusreadmulti Retrieves all recommendation records that are related to the passed in unique related identifer, related type and status. For example, the unique related identifer and type may represent an outcome plan admin. 
searchByRelatedIDRelatedTypeActivityIDActivityTypeAndStatusreadmulti Retrieves all recommendation records that are related to the passed in unique related identifier, related type, unqiue activity identifier, activity type and record status. 
searchByActivityIDActivityTypeAndStatusreadmulti Retrieves all recommendation records that are related to the passed in unique activity identifier, activity type and status. For example, the unique activity identifer and type may represent an outcome plan admin action. 
searchByRelatedIDRelatedTypeActivityTypeAndStatusreadmulti Retrieves all recommendation records that are related to the passed in unique related identifier, related type, activity type and record status. 
Related Pages (78)
AssessmentDefinitionFactorAdmin_contextPanel
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromListAssessmentDefinitionFactors)
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromListAssessmentDefinitionFactorsro)
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromAssessmentDefinition)
AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromAssessmentDefinitionro
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromList)
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromListro)
New Outcome Plan (NewOutcomePlanWizard_planDetails)
New Outcome Plan (OutcomePlan_accessibleCreateFromPerson)
New Outcome Plan (OutcomePlan_createForSingleClient)
New Outcome Plan (OutcomePlan_enhancedCreate)
New Outcome Plan (OutcomePlan_enhancedCreate1)
Recommendations (OutcomePlan_listPlanActivityRecommendations)
Reasons (OutcomePlan_listRecommendedActivitiesReasonDetails)
Recommendations (OutcomePlan_listSuggestedFactorActivityRecommendations)
Recommendation Details (OutcomePlan_viewPlanFactorRecommendationDetails)
Recommendation Details (OutcomePlan_viewPlanRecommendationDetails)
Edit Factor (OutcomePlanActionAdmin_modifyOutcomePlanFactorAdmin)
Edit Classification (OutcomePlanActionAdmin_updateFactorClassificationAdmin)
Classification (OutcomePlanFactor_classifications)
Home (OutcomePlanFactor_home)
Recommendations (OutcomePlanFactor_recommendations)
Classification (OutcomePlanFactorClassification_home)
Classification (OutcomePlanFactorClassification_recommendations)
Add Conditions (OutcomePlanningAdmin_addConditionToRecommendation)
Delete Recommendation (OutcomePlanningAdmin_cancelRecommendation)
Delete Recommendation (OutcomePlanningAdmin_cancelRecommendationFromClassification)
Delete Recommendation (OutcomePlanningAdmin_cancelRecommendationFromClassificationSubDivision)
Delete Recommendation (OutcomePlanningAdmin_cancelRecommendationFromFactorFromDefinition)
Delete Recommendation (OutcomePlanningAdmin_cancelRecommendationFromFactorFromList)
Delete Recommendation (OutcomePlanningAdmin_cancelRecommendationFromObjective)
Delete Recommendation (OutcomePlanningAdmin_cancelRecommendationFromOutcomePlanAdmin)
Delete Recommendation (OutcomePlanningAdmin_cancelRecommendationFromOutcomePlanFactor)
Delete Recommendation (OutcomePlanningAdmin_cancelRecommendationFromOutcomePlanFactorClassification)
Recommend Action (OutcomePlanningAdmin_createRecommendActionFromClassification)
Recommend Action (OutcomePlanningAdmin_createRecommendActionFromClassificationSubdivision)
Recommend Action (OutcomePlanningAdmin_createRecommendActionFromListRecommendationsFromOutcomePlanAdmin)
Recommend Action (OutcomePlanningAdmin_createRecommendActionFromObjective)
Recommend Action (OutcomePlanningAdmin_createRecommendActionFromOutcomePlanAdmin)
Recommend Action (OutcomePlanningAdmin_createRecommendActionFromOutcomePlanFactor)
Recommend Action (OutcomePlanningAdmin_createRecommendActionFromOutcomePlanFactorClassification)
Recommend Action (OutcomePlanningAdmin_createRecommendActionFromViewFactorFromDefinition)
Recommend Action (OutcomePlanningAdmin_createRecommendActionFromViewFactorFromList)
Recommend Referral (OutcomePlanningAdmin_createRecommendReferralFromClassification)
Recommend Referral (OutcomePlanningAdmin_createRecommendReferralFromClassificationSubdivision)
Recommend Referral (OutcomePlanningAdmin_createRecommendReferralFromListRecommendationsFromOutcomePlanAdmin)
Recommend Referral (OutcomePlanningAdmin_createRecommendReferralFromObjective)
Recommend Referral (OutcomePlanningAdmin_createRecommendReferralFromOutcomePlanAdmin)
Recommend Referral (OutcomePlanningAdmin_createRecommendReferralFromOutcomePlanFactor)
Recommend Referral (OutcomePlanningAdmin_createRecommendReferralFromOutcomePlanFactorClassification)
Recommend Referral (OutcomePlanningAdmin_createRecommendReferralFromViewFactorFromDefinition)
Recommend Referral (OutcomePlanningAdmin_createRecommendReferralFromViewFactorFromList)
Recommend Service (OutcomePlanningAdmin_createRecommendServiceFromClassification)
Recommend Service (OutcomePlanningAdmin_createRecommendServiceFromClassificationSubdivision)
Recommend Service (OutcomePlanningAdmin_createRecommendServiceFromListRecommendationsFromOutcomePlanAdmin)
Recommend Service (OutcomePlanningAdmin_createRecommendServiceFromObjective)
Recommend Service (OutcomePlanningAdmin_createRecommendServiceFromOutcomePlanAdmin)
Recommend Service (OutcomePlanningAdmin_createRecommendServiceFromOutcomePlanFactor)
Recommend Service (OutcomePlanningAdmin_createRecommendServiceFromOutcomePlanFactorClassification)
Recommend Service (OutcomePlanningAdmin_createRecommendServiceFromViewFactorFromDefinition)
Recommend Service (OutcomePlanningAdmin_createRecommendServiceFromViewFactorFromList)
Edit Recommendation (OutcomePlanningAdmin_editRecommendation)
Edit Recommendation (OutcomePlanningAdmin_editRecommendationFromClassification)
Edit Recommendation (OutcomePlanningAdmin_editRecommendationFromClassificationSubDivision)
Edit Recommendation (OutcomePlanningAdmin_editRecommendationFromFactorFromDefinition)
Edit Recommendation (OutcomePlanningAdmin_editRecommendationFromFactorFromList)
Edit Recommendation (OutcomePlanningAdmin_editRecommendationFromObjective)
Edit Recommendation (OutcomePlanningAdmin_editRecommendationFromOutcomePlanAdmin)
Edit Recommendation (OutcomePlanningAdmin_editRecommendationFromOutcomePlanFactor)
Edit Recommendation (OutcomePlanningAdmin_editRecommendationFromOutcomePlanFactorClassification)
Recommendations (OutcomePlanningAdmin_listRecommendationsFromClassification)
Recommendations (OutcomePlanningAdmin_listRecommendationsFromClassificationSubDivision)
Recommendations: (OutcomePlanningAdmin_listRecommendationsFromFactorFromDefinition)
Recommendations (OutcomePlanningAdmin_listRecommendationsFromFactorFromList)
Recommendations (OutcomePlanningAdmin_listRecommendationsFromObjective)
Recommendations (OutcomePlanningAdmin_listRecommendationsFromOutcomePlanAdmin)
Remove Condition (OutcomePlanningAdmin_removeConditionFromRecommendation)
OutcomePlanningAdmin_viewRecommendationListSummary