Table Description
Factor Delivery Link : Links a factor to a service, action, objective or a referral.

This entity allows for the identification of activities which are helping a client deal with a particular factor and also to identify activities which are helping a client achieve a particular objective.

Example

An outcome plan is created for James Smith, Linda Smith and their child Robert to identify and address their issues. The Family Strengths and Needs Assessment (FSN) Assessment is run from this outcome plan by a case worker. Activities(services, actions and referrals) are created to address the identified needs. During the creation of each of these activities Substance Abuse and Parenting Skills are selected as the activities are helping towards these factors. This entity stores the link between each activity the factors Substance Abuse and Parenting Skills.

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::OutcomePlanning::OutcomePlan::Entity::Delivery::FactorDeliveryLink::FactorDeliveryLink
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery\OutcomePlanActivityFactorLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
factorDeliveryLnkIDkeyno

Unique identifier for the factor delivery link.

INTERNAL_ID SVR_INT64
relatedIDdetailsnoUnique identifier for the related record.INTERNAL_ID SVR_INT64
factorDeliveryIDdetailsnoUnique identifier for the factor. This can refer to an assessment factor or an outcome plan factor.INTERNAL_ID SVR_INT64
recordStatusdetailsnoStatus of the record, i.e. Active or Cancelled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
relatedTypedetailsnoThe type of the related record, e.g. expected outcome, outcome plan activity.FACTOR_DELIVERY_LINK_RELATED_TYPEFactorDeliveryLinkRelTypeSVR_STRING<10>
addedBydetailsnoUser name of the user who added the factor to the related record.USER_NAME SVR_STRING<64>
addedReasondetailsyesComment added when a factor is added to the related record.COMMENTS SVR_STRING<300>
dateAddeddetailsnoDate the factor was added to the related record.CURAM_DATE SVR_DATE
dateRemoveddetailsyesDate the factor was removed from an related record.CURAM_DATE SVR_DATE
removalReasondetailsyesReason the factor was removed from the related record.REASON_TEXT SVR_STRING<200>
removedBydetailsyesUser name of the user who removed the factor from the related record.USER_NAME SVR_STRING<64>
outcomePlanActivityTypedetailsyesThe type of outcome plan activity of the related record, where the relatedType of the record is set as 'Outcome Plan Activity'.OUTCOME_PLAN_ACTIVITY_TYPEOutcomePlanActivityTypeSVR_STRING<10>
Foreign Keys (3)
ChildParent
FactorDeliveryLink.factorDeliveryIDFactorDelivery.factorDeliveryID
FactorDeliveryLink.addedByUsers.userName
FactorDeliveryLink.removedByUsers.userName
Indices (4)
Index NameAttributes
FactorDeliveryLinkRelatedIdxrelatedID
IND__705354336factorDeliveryID
IND__1717070763addedBy
IND__55167947removedBy
Operations (10)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: factorDeliveryLnkID
Standard Operation 
readread Standard Operation 
searchByRelatedRecordAndStatusreadmulti Returns a list of all FactorDeliveryLink records for the specified related ID and type and status. 
searchByRelatedRecordFactorDeliveryAndStatusreadmulti Returns a list of all FactorDeliveryLink records for the specified Factor Delivery, related ID and type and status. 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByFactorDeliveryRelatedTypeAndStatusreadmulti Returns a list of all FactorDeliveryLink records for the specified Factor Delivery, related type and status. 
searchByRelatedOutcomePlanActivityAndStatusreadmulti Returns a list of all FactorDeliveryLink records for the specified Outcome Plan Activitiy type, related ID and status. 
searchAllByRelatedRecordreadmulti Returns a list of all FactorDeliveryLink records for the specified related ID and type. 
searchAllByRelatedOutcomePlanActivityreadmulti Returns a list of all FactorDeliveryLink records for the specified OutcomePlanActivity type and related ID. 
searchByFactorDeliveryRelatedIDRelatedTypeAndStatusreadmulti Returns a list of all FactorDeliveryLink records for the specified Factor Delivery, related ID and type and status. 
Related Pages (53)
New Objective (AddExpectedOutcomeWizard_factors)
New Action (CreateActionWizard_owner)
Add Action (CreateActionWizard_sharing)
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)
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)
Factor History (OutcomePlan_listFactorsForAction)
Remove Client (OutcomePlan_removeClientFromAction)
Remove Client (OutcomePlan_removeClientsFromExpectedOutcome)
Remove Factors (OutcomePlan_removeFactorFromExpectedOutcome)
Remove Factors (OutcomePlan_removeFactorsFromAction)
Factor History (OutcomePlan_viewExpectedOutcomeFactorHistory)
OutcomePlan_viewExpectedOutcomeFactorHistoryDetails
Home (OutcomePlan_viewExpectedOutcomeHome)
OutcomePlan_viewExpectedOutcomeOverview
Home (OutcomePlan_viewFactor)
OutcomePlan_viewFactorRecommendationFactorDetails
OutcomePlan_viewOutcomePlanActivityFactorHistoryDetails
Home (OutcomePlan_viewServiceDetails)
OutcomePlan_viewServiceDetailsPreviewPanel
OutcomePlan_viewServiceLatestNotePreviewPanel
OutcomePlan_viewServiceSharingPreviewPanel
New Referral: (OutcomePlanCollaborationPreselectedReferralWizard_factors)
OutcomePlanCollaborationPreselectedReferralWizard_sharing
New Referral (OutcomePlanCollaborationReferralWizard_factors)
OutcomePlanCollaborationReferralWizard_sharing
Activities (OutcomePlanFactor_listActivities)
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