Table Description
Factor Result : The result of assessing a factor.

Each time a factor is assessed and subsequently reassessed a record is stored on this table. A factor result is associated with a factor on an outcome plan or with an assessment instance.

Example

James Smith, Linda Smith and their child Robert must be assessed to identify the family's strengths and needs in an effort to help build an effective outcome plan. The Family Strengths and Needs Assessment (FSN) Assessment is run from the family's outcome plan by a case worker. Linda is selected as Roberts primary caregiver, James is his secondary caregiver and Robert is selected as the focus child. The FSN contains nine factors which are used to assess the family's functioning and a result is produced for each factor. This FSN assessment can be reassessed to assess the family's progress over time. This entity stores the result for each factor assessed, for example, James Smith scores a Need(-2) in Substance Abuse.

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::AssessmentPlanning::Delivery::Entity::FactorResult::FactorResult
Controlling File: AssessmentPlanning\model\Packages\Delivery\Entity\AssessmentFactorResult_cat.efx
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
factorResultIDkeynoThe unique identifier of the factor result.INTERNAL_ID SVR_INT64
relatedIDdetailsnoThe identifier for the related record, for example AssessmentInstance or OutcomePlan.INTERNAL_ID SVR_INT64
factorDeliveryIDdetailsnoUnique identifier of the factor delivery record this result is associated with.INTERNAL_ID SVR_INT64
assessmentDatedetailsnoThe date & time that this assessment was runCURAM_DATETIME SVR_DATETIME
scoredetailsyesThe result that a client achieved on running an assessment on a factor, for example, 5.ASSESSMENT_FACTOR_SCORE SVR_STRING<5>
categoryClassificationIDdetailsnoThe identifier for the category classification record from administration. Foreign key to CategoryClassification entity.INTERNAL_ID SVR_INT64
recordedByUserdetailsnoThe user who recorded this FactorResult.USER_NAME SVR_STRING<64>
recordedDateTimedetailsnoThe date and time this FactorResult was recorded.CURAM_DATETIME SVR_DATETIME
relatedTypedetailsnoThe type of record this FactorResult is related to. Denotes the type of relatedID.FACTOR_RESULT_RELATED_TYPEFactorResultRelatedTypeSVR_STRING<10>
roleIDdetailsyesThe assessment role this FactorResult was recorded for. This field is optional, and only applicable if the relatedID and type reference an AssessmentInstance.INTERNAL_ID SVR_INT64
Foreign Keys (5)
ChildParent
FactorResult.roleIDAssessmentDeliveryRole.assessmentDeliveryRoleID
FactorResult.categoryClassificationIDCategoryClassification.categoryClassificationID
FactorResult.recordedByUserUsers.userName
FactorDelivery.latestResultIDFactorResult.factorResultID
FactorDelivery.initialResultIDFactorResult.factorResultID
Indices (5)
Index NameAttributes
FactorResultRelatedIdxrelatedID
IND__366070735factorDeliveryID
IND__1557038318categoryClassificationID
IND__1424530108roleID
IND_103413701recordedByUser
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: factorResultID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchByRelatedIDAndRelatedTypereadmulti Returns a list of Factor Results for the given related ID and type. 
searchByRelatedIDRelatedTypeFactorIDreadmultiORDER_BY: assessmentDate
Returns a list of Factor Results for the given Factor Delivery, related ID and type. 
readByFactorDeliveryRelatedIDRelatedTypensread Returns the record with the given Factor Delivery, related ID and type. 
searchByFactorDeliveryreadmulti Returns a list of Factor Results for the given Factor Delivery. 
searchByClassificationIDAndRelatedTypereadmulti Returns a list of Factor Results for the given Category Classifiction and related type. 
Related Pages (81)
New Objective (AddExpectedOutcomeWizard_factors)
AssessmentDefinitionFactorAdmin_cancelAssessmentDefinitionFactorFromViewFactorFromAssessmentDefinition
Delete Assessment Factor (AssessmentDefinitionFactorAdmin_cancelAssessmentDefinitionFactorFromViewFactorFromList)
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromListAssessmentDefinitionFactors)
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromListAssessmentDefinitionFactorsro)
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromAssessmentDefinition)
AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromAssessmentDefinitionro
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromList)
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromListro)
Add Note: (AssessmentDelivery_addFactorNote)
Assessment Details (AssessmentDelivery_assessmentInstanceHome)
Compare (AssessmentDelivery_compareAssessments)
Compare (AssessmentDelivery_compareAssessmentsModal)
Home (AssessmentDelivery_home)
Assessment Results (AssessmentDelivery_listAssessmentResults)
AssessmentDelivery_resultPopupDetails
Home (AssessmentDelivery_summary)
Add Note: (AssessmentDelivery_updateFactorNote)
Answers (AssessmentDelivery_viewAssessmentAnswersFromAssessmentHome)
Home (AssessmentDelivery_viewAssessmentAnswersFromInstanceHome)
AssessmentDelivery_viewCombinedResultsForInstance
AssessmentDelivery_viewGuidanceDetails
Assessment Home: (AssessmentDelivery_viewGuidanceFromAssessmentHistory)
Guidance (AssessmentDelivery_viewGuidanceFromAssessmentHome)
AssessmentDelivery_viewResultsForInstance
Delete Assessment Definition (AssessmentPlanningAdmin_cancelAssessmentDefinition)
Delete Category Classification (AssessmentPlanningAdmin_cancelCategoryClassification)
New Action (CreateActionWizard_factors)
New Service (CreateServiceDeliveryWizard_factors)
Classification Division: (FactorClassificationDivisionAdmin_cancelClassificationDivision)
Delete Subdivision (FactorClassificationSubdivisionAdmin_cancelFactorClassificationSubdivisionFromViewDivision)
Delete Subdivision (FactorClassificationSubdivisionAdmin_cancelFactorClassificationSubdivisionFromViewSubdivision)
New Outcome Plan (NewOutcomePlanWizard_planDetails)
New Outcome Plan (OutcomePlan_accessibleCreateFromPerson)
Add Factors (OutcomePlan_addFactorsToAction)
Add Factors (OutcomePlan_addFactorsToExpectedOutcome)
Add Factor (OutcomePlan_addStandaloneFactor)
New Outcome Plan (OutcomePlan_createForSingleClient)
New Outcome Plan (OutcomePlan_enhancedCreate)
New Outcome Plan (OutcomePlan_enhancedCreate1)
Home (OutcomePlan_home)
Factors (OutcomePlan_listFactors)
Factor History (OutcomePlan_listFactorsForAction)
Recommendations (OutcomePlan_listPlanActivityRecommendations)
Reasons (OutcomePlan_listRecommendedActivitiesReasonDetails)
Recommendations (OutcomePlan_listSuggestedFactorActivityRecommendations)
Remove Factors (OutcomePlan_removeFactorFromExpectedOutcome)
Remove Factors (OutcomePlan_removeFactorsFromAction)
Set Priority Factors (OutcomePlan_setPriorityFactors)
Factor History (OutcomePlan_viewExpectedOutcomeFactorHistory)
Home (OutcomePlan_viewExpectedOutcomeHome)
OutcomePlan_viewExpectedOutcomeOverview
Home (OutcomePlan_viewFactor)
) (OutcomePlan_viewFactorContextPanel)
OutcomePlan_viewFactorRecommendationFactorDetails
OutcomePlan_viewFactorRecommendationsFactorGuidanceDetails
OutcomePlan_viewFactorRecommendationsFactorRatingsDetails
Home (OutcomePlan_viewServiceDetails)
OutcomePlan_viewServiceDetailsPreviewPanel
OutcomePlan_viewServiceLatestNotePreviewPanel
OutcomePlan_viewServiceSharingPreviewPanel
Edit Factor (OutcomePlanActionAdmin_modifyOutcomePlanFactorAdmin)
Delete Classification (OutcomePlanAdmin_removeClassification)
Delete Factor (OutcomePlanAdmin_removeOutcomePlanFactor)
New Referral: (OutcomePlanCollaborationPreselectedReferralWizard_factors)
New Referral (OutcomePlanCollaborationReferralWizard_factors)
Update Rating (OutcomePlanFactor_updateRating)
OutcomePlanFactor_viewFactorSummary
Guidance (OutcomePlanFactor_viewGuidanceDetails)
Guidance (OutcomePlanFactor_viewGuidanceModal)
OutcomePlanFactor_viewStandAloneFactorSummary
OutcomePlanFactor_viewUserDefinedFactorSummary
New Referral: (OutcomePlanPreselectedReferralWizard_factors)
Add Factors (OutcomePlanReferral_addFactors)
Remove Factors (OutcomePlanReferral_removeFactors)
Factor History (OutcomePlanReferral_viewFactorHistory)
New Referral (OutcomePlanReferralWizard_factors)
Add Factors (OutcomePlanService_addFactors)
OutcomePlanService_home
Remove Factors (OutcomePlanService_removeFactors)
Factors History (OutcomePlanService_viewFactorHistory)