Table Description
Factor Category : The categories that can be used to categorize a factor, for example, Need and Barrier.

Categories can have associated category classifications, for example a category of Need can have classifications of Need and Strength. Associating category classifications with categories means that these classifications can be reused across multiple factors which are categorized in the same way. One or more categories can be specified for an assessment definition. An assessment is made up of one or more factors. The factors are categorized in order to determine the applicable classifications for the factors within the assessment. For example, a category of Barrier may be classified using classifications of Dependent, Progressing, Independent whereas a category of Need may be classified using classifications of In Crisis, At Risk, Safe, Stable, Thriving. Any factor categorized as a Need will use the classifications of In Crisis, At Risk, Safe, Stable, Thriving. Any factor categorized as Barrier will use the classifications of Dependent, Progressing, Independent.

Example

An administrator creates a Family Strength and Needs Assessment(FSN). A category of Need is defined for this assessment. Classifications of Need and Strength are specified for this category. Nine factors are defined for the FSN assessment and are categorized as Need and will therefore be classified using the classifications Need and Strength. This entity stores the category of Need which is used to categorize the factors in the assessment.

Technical Notes

A category is mandatory when creating a factor so when a user defined factor is added to an outcome plan delivery a record must be created 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::AssessmentPlanning::Administration::Entity::AssessmentDefinitionCategory::FactorCategory
Controlling File: AssessmentPlanning\model\Packages\Administration\Entity\AssessmentDefinitionCategory_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
categoryIDkeynoUnique identifier for factor category.INTERNAL_ID SVR_INT64
relatedIDdetailsyesThe unique identifier of item that the category is associated with i.e. assessment definition, outcome plan or standalone factor.INTERNAL_ID SVR_INT64
recordStatusdetailsnoThe status of this factor category record i.e. Active or Cancelled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
categorydetailsnoThe category this record refers to e.g. Need, Barrier.ASSESSMENT_DEFINITION_FACTOR_TYPEAssessDefFactorTypeSVR_STRING<10>
categoryOrderdetailsyesThe order in which this category will be displayed, relative to the other categories that exist on an assessment definition.ASSESSMENT_DEFINITION_ORDER SVR_INT32
relatedTypedetailsyesThe type of item that this category is associated with i.e. assessment definition, stand alone factor or outcome plan deliveryFACTOR_RELATED_TYPEFactorRelatedTypeSVR_STRING<10>
Foreign Keys (2)
ChildParent
CategoryClassification.categoryIDFactorCategory.categoryID
Factor.categoryIDFactorCategory.categoryID
Indices (1)
Index NameAttributes
IND_814292052relatedID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: categoryID
AUTO_ID_KEY: FACTORBO
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByRelatedIDTypeAndStatusreadmultiORDER_BY: categoryOrder
Returns a list of Assessment Definition Categories, based on the provided Assessment Definition & status. 
Related Pages (36)
AssessmentDefinitionFactorAdmin_cancelAssessmentDefinitionFactorFromViewFactorFromAssessmentDefinition
Delete Assessment Factor (AssessmentDefinitionFactorAdmin_cancelAssessmentDefinitionFactorFromViewFactorFromList)
New Factor (AssessmentDefinitionFactorAdmin_createAssessmentDefinitionFactor)
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromListAssessmentDefinitionFactors)
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromListAssessmentDefinitionFactorsro)
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromAssessmentDefinition)
AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromAssessmentDefinitionro
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromList)
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromListro)
Factors (AssessmentDefinitionFactorAdmin_listAssessmentDefinitionFactors)
Assessment Details (AssessmentDelivery_assessmentInstanceHome)
Compare (AssessmentDelivery_compareAssessments)
Compare (AssessmentDelivery_compareAssessmentsModal)
Home (AssessmentDelivery_home)
Assessment Results (AssessmentDelivery_listAssessmentResults)
Home (AssessmentDelivery_summary)
AssessmentDelivery_viewCombinedResultsForInstance
Assessment Home: (AssessmentDelivery_viewGuidanceFromAssessmentHistory)
Guidance (AssessmentDelivery_viewGuidanceFromAssessmentHome)
AssessmentDelivery_viewResultsForInstance
New Factor (AssessmentPlanningAdmin_addAssessmentDefinitionFactorFromList)
Delete Assessment Definition (AssessmentPlanningAdmin_cancelAssessmentDefinition)
Remove Categories (AssessmentPlanningAdmin_cancelCategory)
New Assessment Definition (AssessmentPlanningAdmin_createAssessmentDefinition)
Add Categories (AssessmentPlanningAdmin_createCategory)
New Category Classification (AssessmentPlanningAdmin_createCategoryClassification)
Edit Assessment Definition (AssessmentPlanningAdmin_editAssessmentDefinitionFromList)
Edit Assessment Definition (AssessmentPlanningAdmin_editAssessmentDefinitionFromView)
Categories (AssessmentPlanningAdmin_listCategoryClassifications)
Set Factor Display Order (AssessmentPlanningAdmin_reorder)
Home (OutcomePlan_viewFactor)
OutcomePlan_viewFactorRecommendationFactorDetails
OutcomePlan_viewFactorRecommendationsFactorRatingsDetails
New Factor (OutcomePlanActionAdmin_createOutcomePlanFactorAdmin)
OutcomePlanFactor_viewStandAloneFactorSummary
OutcomePlanFactor_viewUserDefinedFactorSummary