Table Description
Factor Delivery : The addition of a factor to a case or outcome plan.

A factor can be added to an outcome plan in three ways: by running an assessment, by adding a factor which has been configured in the administration application or by the addition of a user defined factor.

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 a record for each of the nine factors which have been used to assess the family.

Technical Notes

A factor delivery has a relatedID and type which allow it to be related to any parent record, and a concernRoleID which should be populated with the concernRole this FactorDelivery is added for.
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::FactorDelivery::FactorDelivery
Controlling File: AssessmentPlanning\model\Packages\Delivery\Entity\FactorDelivery_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
factorDeliveryIDkeynoUnique identifier for a Factor Delivery.INTERNAL_ID SVR_INT64
factorIDdetailsyesUnique identifier of the factor from administration that this Factor Delivey is related to. Either factorID or factorNameID must be specified, but not both.INTERNAL_ID SVR_INT64
relatedIDdetailsnoThe relatedID of this Factor Delivery, for example the unique identifer of a related Assessment.INTERNAL_ID SVR_INT64
relatedTypedetailsnoThe type, which denotes what type of record the relatedID represents.FACTOR_DELIVERY_RELATED_TYPEFactorDeliveryRelatedTypeSVR_STRING<10>
caseParticipantRoleIDdetailsyesThe concernRole that this Factor Delivery has been added for.INTERNAL_ID SVR_INT64
factorNamedetailsyesA localizable name for this Factor Delivery. This is only specified when the Factor Delivery is not being associated with a factor from administration.FACTOR_DELIVERY_FACTOR_NAME SVR_STRING<100>
reasonAddeddetailsyesThe reason this Factor Delivery was added.OUTCOME_PLAN_RICH_TEXT_SMALL SVR_STRING<2000>
recordedByUserdetailsnoThe user who recorded this Factor Delivery.USER_NAME SVR_STRING<64>
recordedDateTimedetailsnoThe date and time this Factor Delivery was recorded.CURAM_DATETIME SVR_DATETIME
latestResultIDdetailsyesThe latestResult for this FactorDelivery. Present for performance optimisation.INTERNAL_ID SVR_INT64
initialResultIDdetailsyesThe initialResult for this FactorDelivery. Present for performance optimisation.INTERNAL_ID SVR_INT64
recordStatusdetailsnoThe recordStatus of this Factor Delivery. Allows for logical deletion.RECORD_STATUSRecordStatusSVR_STRING<10>
planningInddetailsyesIndicates that this factor will appear in the workspace with recommendations etc, and will appear on other planning screens such as objectives and goals etc. This is only applicable to user defined factors.FACTOR_PLANNING_INDICATORFactorPlanningIndicatorSVR_STRING<10>
Foreign Keys (9)
ChildParent
FactorDelivery.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
FactorDelivery.factorIDFactor.factorID
FactorDelivery.latestResultIDFactorResult.factorResultID
FactorDelivery.initialResultIDFactorResult.factorResultID
FactorDelivery.recordedByUserUsers.userName
FactorDeliveryLink.factorDeliveryIDFactorDelivery.factorDeliveryID
FactorNoteLink.factorDeliveryIDFactorDelivery.factorDeliveryID
PlanRecommendationReason.factorDeliveryIDFactorDelivery.factorDeliveryID
PriorityFactor.factorDeliveryIDFactorDelivery.factorDeliveryID
Indices (8)
Index NameAttributes
FactorDeliveryThreeIdxrelatedID, relatedType, recordStatus
FactorDeliveryTwoIdxrelatedID, relatedType, factorID
FactorDeliveryOneIdxfactorID, caseParticipantRoleID, relatedID, relatedType, recordStatus
FactorDeliveryFourIdxcaseParticipantRoleID, relatedID, recordStatus, relatedType
FactorDeliveryRelatedIdxrelatedID
IND_725314523latestResultID
IND_1509944224initialResultID
IND_1936550606recordedByUser
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: factorDeliveryID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readByFactorCaseParticipantRoleRelatedIDRelatedTypeAndStatusnsread Reads the record with the given Factor, Case Participant Role, related ID and type and status. 
searchByRelatedIDRelatedTypeAndStatusreadmulti Returns a list of records with the given related ID, type and status. 
searchByRelatedIDRelatedTypeAndFactorreadmulti Returns a list of records with the given Factor, related ID and type. 
searchByRelatedIDRelatedTypeCaseParticipantRoleAndStatusreadmulti Returns a list of records with the given Case Participant Role, related ID and type and status 
searchByFactorCaseParticipantRoleRelatedIDAndRelatedTypereadmulti Returns a list of records with the given Factor, Case Participant Role, related ID and type. 
searchByFactorAndRelatedTypereadmulti Returns a list of records with the given Factor and related type. 
Related Pages (100)
New Objective (AddExpectedOutcomeWizard_factors)
AssessmentDefinitionFactorAdmin_cancelAssessmentDefinitionFactorFromViewFactorFromAssessmentDefinition
Delete Assessment Factor (AssessmentDefinitionFactorAdmin_cancelAssessmentDefinitionFactorFromViewFactorFromList)
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
Assessment Home: (AssessmentDelivery_viewGuidanceFromAssessmentHistory)
Guidance (AssessmentDelivery_viewGuidanceFromAssessmentHome)
AssessmentDelivery_viewResultsForInstance
Delete Assessment Definition (AssessmentPlanningAdmin_cancelAssessmentDefinition)
New Action (CreateActionWizard_factors)
New Action (CreateActionWizard_owner)
Add Action (CreateActionWizard_sharing)
New Service (CreateServiceDeliveryWizard_factors)
New Objective (ExpectedOutcomeSearchWizard_addObjective)
Home (MDTOutcomePlan_home)
New Outcome Plan (NewOutcomePlanWizard_planDetails)
New Outcome Plan (OutcomePlan_accessibleCreateFromPerson)
Add Factors (OutcomePlan_addFactorsToAction)
Add Factors (OutcomePlan_addFactorsToExpectedOutcome)
Add Factor (OutcomePlan_addStandaloneFactor)
Add Factor (OutcomePlan_addStandaloneFactorRatingNotSet)
New Factor (OutcomePlan_addUserDefinedFactor)
Delete Action (OutcomePlan_cancelAction)
Remove Factor (OutcomePlan_cancelFactorLink)
New Outcome Plan (OutcomePlan_createForSingleClient)
New Objective (OutcomePlan_createOutcomePlanExpectedOutcome)
New Objective (OutcomePlan_createOutcomePlanExpectedOutcomeMultipleClients)
New Outcome Plan (OutcomePlan_enhancedCreate)
New Outcome Plan (OutcomePlan_enhancedCreate1)
Home (OutcomePlan_home)
Activities (OutcomePlan_listActions)
Activities (OutcomePlan_listExpectedOutcomeCurrentActivities)
Objectives (OutcomePlan_listExpectedOutcomes)
Factors (OutcomePlan_listFactors)
Factor History (OutcomePlan_listFactorsForAction)
Recommendations (OutcomePlan_listPlanActivityRecommendations)
Reasons (OutcomePlan_listRecommendedActivitiesReasonDetails)
Recommendations (OutcomePlan_listSuggestedFactorActivityRecommendations)
Remove Client (OutcomePlan_removeClientFromAction)
Remove Client (OutcomePlan_removeClientsFromExpectedOutcome)
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_viewFactorRecommendationsFactorLatestNoteDetails
OutcomePlan_viewFactorRecommendationsFactorProgressDetails
OutcomePlan_viewFactorRecommendationsFactorRatingsDetails
Home (OutcomePlan_viewServiceDetails)
OutcomePlan_viewServiceDetailsPreviewPanel
OutcomePlan_viewServiceLatestNotePreviewPanel
OutcomePlan_viewServiceSharingPreviewPanel
Delete Factor (OutcomePlanAdmin_removeOutcomePlanFactor)
Remove Factor (OutcomePlanAdmin_removeOutcomePlanFactorFromOutcomePlan)
New Referral: (OutcomePlanCollaborationPreselectedReferralWizard_factors)
OutcomePlanCollaborationPreselectedReferralWizard_sharing
New Referral (OutcomePlanCollaborationReferralWizard_factors)
OutcomePlanCollaborationReferralWizard_sharing
New Attachment (OutcomePlanFactor_addAttachment)
New Note (OutcomePlanFactor_addNote)
Delete Factor (OutcomePlanFactor_cancel)
Activities (OutcomePlanFactor_listActivities)
Attachments (OutcomePlanFactor_listAttachments)
Notes (OutcomePlanFactor_listNotes)
Priority (OutcomePlanFactor_listPriorityHistory)
Set as Priority (OutcomePlanFactor_setAsPriority)
Unset as Priority (OutcomePlanFactor_unsetAsPriority)
Edit Factor Name (OutcomePlanFactor_updateFactorName)
Update Rating (OutcomePlanFactor_updateRating)
Edit Reason (OutcomePlanFactor_updateReason)
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)
SimpleCreateAction