Table Description
Factor Category : A measurement indicator of a clients progress for a factor.

A factor classification can be either a classification or classification subdivision. A classification is a portion of the scale that measures the actual progress of a client e.g. Need 0-5. A subdivision defines a portion of the range entered on the classification enabling a finer level of measurement e.g. a value of 1.

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. Ranges are defined for each factor classification, for example, Substance Abuse/Use is classified using Need (-5 to -1) and Strength (0 - 5). This entity stores the classification and ranges for all factors.

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::FactorClassification::FactorClassification
Controlling File: AssessmentPlanning\model\Packages\Administration\Entity\FactorClassification_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
factorClassificationIDkeynoUnique identifier for a factor classification. Can be in reference to a factor classification division, or factor classification subdivision.INTERNAL_ID SVR_INT64
minimumRangedetailsyesThe minimum range value for a classification division. For example, for the classification division 'In Crisis', 0 may be assigned as the minimum range value. This attribute should allow for negative values.CLASSIFICATION_MINIMUM_RANGE SVR_STRING<20>
maximumRangedetailsyesThe maximum range value for a classification division. For example, for the classification division In Crisis, 3 may be assigned as the maximum range value. This attribute should allow for negative values.CLASSIFICATION_MAXIMUM_RANGE SVR_STRING<20>
descriptionTextIDdetailsnoThe description of the factor classification division.LOCALIZABLE_TEXT_ID SVR_INT64
recordStatusdetailsnoThe record status, used to indicate if the factor classification division is logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
factorIDdetailsnoUnique identifier for an assessment definition factor.ASSESSMENT_DEFINITION_FACTOR_ID SVR_INT64
categoryClassificationIDdetailsnoUnique identifier of the corresponding category classification record.INTERNAL_ID SVR_INT64
hideFromPrioritiesInddetailsnoIndicates if assessment factor results for this factor classification division should be included in the list of results that may be set as priorities.CURAM_INDICATOR SVR_BOOLEAN
factorClassificationDivisionIDdetailsyesUnique identifier of a factor classification division. Is a foreign key to itself on this table and only populated when the factor classification table represents a classification subdivision. Nulls are allowed due to the possibility that a classification division may a exist with no subdivisions.INTERNAL_ID SVR_INT64
factorClassificationTypedetailsnoThe type of classification the record represents. Can be either a classification division or a classification subdivision.FACTOR_CLASSIFICATION_TYPEFactorClassificationTypeSVR_STRING<10>
Foreign Keys (7)
ChildParent
FactorClassification.categoryClassificationIDCategoryClassification.categoryClassificationID
FactorClassification.factorClassificationDivisionIDFactorClassification.factorClassificationID
FactorClassification.factorIDFactor.factorID
FactorClassification.descriptionTextIDLocalizableText.localizableTextID
ClassificationGuidance.factorClassificationIDFactorClassification.factorClassificationID
DAOutcomeFactorLink.factorClassificationIDFactorClassification.factorClassificationID
FactorClassification.factorClassificationDivisionIDFactorClassification.factorClassificationID
Indices (4)
Index NameAttributes
IND__81121164factorID
IND__285961623categoryClassificationID
IND__1032585785factorClassificationDivisionID
IND_455727002descriptionTextID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: factorClassificationID
AUTO_ID_KEY: FACTORBO
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByTypeAssessmentDefinitionFactorAndStatusreadmulti Returns a list of Factor Classification records of a particular status and type for a related assessment definition factor. 
readByTypeFactorCategoryClassificationAndStatusnsread Reads a classification by classification type, assessment definition, categoryClassification and record status. 
searchByFactorClassificationDivisionAndStatusreadmulti Returns a list of factor classification sub division records that are related to the passed in identifier of a factor classification division and have the same status value of the record status passed in.  
searchByTypeAndStatusreadmulti Retrieves a list of factor classification records based on the passed in classification type and record status. 
searchByAssessmentDefinitionFactorAndStatusreadmulti Returns a list of Factor Classification records of a particular status for a related assessment definition factor. 
Related Pages (67)
AssessmentDefinitionFactorAdmin_cancelAssessmentDefinitionFactorFromViewFactorFromAssessmentDefinition
Delete Assessment Factor (AssessmentDefinitionFactorAdmin_cancelAssessmentDefinitionFactorFromViewFactorFromList)
Classification (AssessmentDefinitionFactorAdmin_classifications)
AssessmentDefinitionFactorAdmin_contextPanel
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromListAssessmentDefinitionFactors)
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromListAssessmentDefinitionFactorsro)
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromAssessmentDefinition)
AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromAssessmentDefinitionro
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromList)
Edit Factor (AssessmentDefinitionFactorAdmin_editAssessmentDefinitionFactorFromViewFactorFromListro)
Home (AssessmentDefinitionFactorAdmin_viewFactorFromAssessmentDefinition)
Home (AssessmentDefinitionFactorAdmin_viewFactorFromList)
Assessment Results (AssessmentDelivery_listAssessmentResults)
Map CDA Outcome (AssessmentPlanningAdmin_addDAOutcomeFactorAssessmentLinkFromViewFactorFromDefinition)
Map CDA Outcome (AssessmentPlanningAdmin_addDAOutcomeFactorAssessmentLinkFromViewFactorFromList)
Map CDA Outcome (AssessmentPlanningAdmin_addDAOutcomeFactorClassificationAssessmentLinkFromViewFactorFromDefinition)
Map CDA Outcome (AssessmentPlanningAdmin_addDAOutcomeFactorClassificationAssessmentLinkFromViewFactorFromList)
Delete Assessment Definition (AssessmentPlanningAdmin_cancelAssessmentDefinition)
Delete Category Classification (AssessmentPlanningAdmin_cancelCategoryClassification)
Classification (FactorClassificationDivisionAdmin_viewClassificationDivision)
Subdivisions (FactorClassificationDivisionAdmin_viewSubdivisions)
Add Subdivision (FactorClassificationSubdivisionAdmin_createFactorClassificationSubdivision)
Add Subdivision (FactorClassificationSubdivisionAdmin_createFCSDFromAddFCDFromCreateADF)
Add Subdivision (FactorClassificationSubdivisionAdmin_createFCSDFromAddFCDFromListForFactor)
Add Subdivision (FactorClassificationSubdivisionAdmin_createFCSDFromCreateFCDFromViewFactor)
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)
Reasons (OutcomePlan_listRecommendedActivitiesReasonDetails)
Home (OutcomePlan_viewFactor)
OutcomePlan_viewFactorRecommendationFactorDetails
OutcomePlan_viewFactorRecommendationsFactorRatingsDetails
Add Classification (OutcomePlanActionAdmin_createFactorClassificationAdmin)
Edit Factor (OutcomePlanActionAdmin_modifyOutcomePlanFactorAdmin)
Edit Classification (OutcomePlanActionAdmin_updateFactorClassificationAdmin)
Delete Classification (OutcomePlanAdmin_removeClassification)
Delete Factor (OutcomePlanAdmin_removeOutcomePlanFactor)
Classification (OutcomePlanFactor_classifications)
Home (OutcomePlanFactor_home)
Recommendations (OutcomePlanFactor_recommendations)
Update Rating (OutcomePlanFactor_updateRating)
OutcomePlanFactor_viewFactorSummary
OutcomePlanFactor_viewStandAloneFactorSummary
OutcomePlanFactor_viewUserDefinedFactorSummary
Add Subdivision (OutcomePlanFactorAdmin_createClassificationSubdivision)
Classification (OutcomePlanFactorClassification_home)
Classification (OutcomePlanFactorClassification_recommendations)
Subdivisions (OutcomePlanFactorClassification_subdivisions)
Recommend Action (OutcomePlanningAdmin_createRecommendActionFromOutcomePlanFactor)
Recommend Action (OutcomePlanningAdmin_createRecommendActionFromViewFactorFromDefinition)
Recommend Action (OutcomePlanningAdmin_createRecommendActionFromViewFactorFromList)
Recommend Group (OutcomePlanningAdmin_createRecommendGroupFromOutcomePlanFactor)
Recommend Group (OutcomePlanningAdmin_createRecommendGroupFromViewFactorFromDefinition)
Recommend Group (OutcomePlanningAdmin_createRecommendGroupFromViewFactorFromList)
Recommend Referral (OutcomePlanningAdmin_createRecommendReferralFromOutcomePlanFactor)
Recommend Referral (OutcomePlanningAdmin_createRecommendReferralFromViewFactorFromDefinition)
Recommend Referral (OutcomePlanningAdmin_createRecommendReferralFromViewFactorFromList)
Recommend Service (OutcomePlanningAdmin_createRecommendServiceFromOutcomePlanFactor)
Recommend Service (OutcomePlanningAdmin_createRecommendServiceFromViewFactorFromDefinition)
Recommend Service (OutcomePlanningAdmin_createRecommendServiceFromViewFactorFromList)
Recommendations (OutcomePlanningAdmin_listRecommendationsFromClassification)
Recommendations: (OutcomePlanningAdmin_listRecommendationsFromFactorFromDefinition)
Recommendations (OutcomePlanningAdmin_listRecommendationsFromFactorFromList)
Recommend Objective (OutcomePlanningAdmin_recommendObjectiveFromAssessmentFactor)
Recommend Objective (OutcomePlanningAdmin_recommendObjectiveFromOutcomePlanFactor)