Table Description
Factor Link : A link between a factor and an assessment or outcome plan.

When adding a factor to an assessment definition a record is created on this entity. A factor must be associated with an outcome plan in administration before it can be added to an outcome plan for a client. Associating a factor with an outcome plan results in the creation of a record on this table.

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 Definition FSN contains nine factors which are used to assess the family's functioning and a result is produced for each factor. This entity stores the links between the nine factors and the assessment which was run to assess the family's needs.

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::FactorLink::FactorLink
Controlling File: AssessmentPlanning\model\Packages\Administration\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
factorLinkIDkeynoUnique identifier for this factor link record.INTERNAL_ID SVR_INT64
factorIDdetailsnoUnique identifier of the factor associated with this factor link record.INTERNAL_ID SVR_INT64
relatedIDdetailsnoUnique identifier of the artifact that this factor link is associated with e.g. assessment definition, outcome plan.INTERNAL_ID SVR_INT64
relatedTypedetailsnoThe type of artifact that this factor link record is associated with e.g. assessment definition, outcome plan.FACTOR_RELATED_TYPEFactorRelatedTypeSVR_STRING<10>
recordStatusdetailsnoStatus of the factor link record i.e. Active and Cancelled.RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
FactorLink.factorIDFactor.factorID
Indices (2)
Index NameAttributes
IND__634938336factorID
IND__1183661104relatedID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: factorLinkID
AUTO_ID_KEY: FACTORBO
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByFactorAndStatusreadmulti Returns the record for the given Factor and status. 
searchByFactorRelatedTypeAndStatusreadmulti Returns the record for the given Factor, related type and status. 
searchByRelatedIDRelatedTypeAndStatusreadmulti Returns the record for the given related ID and type and status. 
readByFactorRelatedIDRelatedTypeAndStatusnsread Returns the record for the given Factor, related ID and type and status. 
Related Pages (33)
AssessmentDefinitionFactorAdmin_cancelAssessmentDefinitionFactorFromViewFactorFromAssessmentDefinition
Delete Assessment Factor (AssessmentDefinitionFactorAdmin_cancelAssessmentDefinitionFactorFromViewFactorFromList)
Classification (AssessmentDefinitionFactorAdmin_classifications)
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)
Home (AssessmentDefinitionFactorAdmin_viewFactorFromAssessmentDefinition)
Home (AssessmentDefinitionFactorAdmin_viewFactorFromList)
Assessment Results (AssessmentDelivery_listAssessmentResults)
New Factor (AssessmentPlanningAdmin_addAssessmentDefinitionFactorFromList)
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)
Remove Outcome Mapping (AssessmentPlanningAdmin_removeDAOutcomeLinkFromScoringFactor)
Remove Assessment Result Link: (AssessmentPlanningAdmin_removeDAOutcomeLinkFromViewFactorFromDefinition)
Remove Outcome Mapping (AssessmentPlanningAdmin_removeDAOutcomeLinkFromViewFactorFromList)
Set Factor Display Order (AssessmentPlanningAdmin_reorder)
Add Factor (OutcomePlan_addStandaloneFactor)
Add Factor (OutcomePlan_addStandaloneFactorRatingNotSet)
New Factor (OutcomePlanActionAdmin_createOutcomePlanFactorAdmin)
OutcomePlanActionAdmin_listOutcomePlanFactorAdmin
Edit Factor (OutcomePlanActionAdmin_modifyOutcomePlanFactorAdmin)
Add Factors (OutcomePlanAdmin_addOutcomePlanFactorsToOutcomePlan)
Factors (OutcomePlanAdmin_listOutcomePlanFactors)
Delete Factor (OutcomePlanAdmin_removeOutcomePlanFactor)
Remove Factor (OutcomePlanAdmin_removeOutcomePlanFactorFromOutcomePlan)