Table Description
Assessment Definition Case Link : A relationship between a type of assessment and a type of case. When a case of a particular type is associated with an assessment definition, it enables a user to run the particular type of assessment on the associated case type e.g. family strength and needs assessment can be run from a Reunification outcome plan.

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 Reunification outcome plan. The Family Strengths and Needs Assessment (FSN) is run from the family's outcome plan by a case worker. This entity allows the FSN Assessment to be run from the family's Reunification outcome plan.
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::AssessmentDefinitionCaseLink::AssessmentDefinitionCaseLink
Controlling File: AssessmentPlanning\model\Packages\Administration\Entity\AssessmentDefinitionCaseLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
assessmentDefinitionCaseLnkIDkeynoUnique identifier for the Assessment Definition Case Link.ASSESSMENT_DEFINITION_CASE_LINK_ID SVR_INT64
assessmentDefinitionIDdetailsnoUnique Identifier for the Assessment Definition Case.ASSESSMENT_DEFINITION_ID SVR_INT64
caseTypeCodedetailsnoIdentifies they type of case stored on the Assessment Definition Case Link.CASE_TYPE_CODECaseTypeCodeSVR_STRING<10>
relatedCaseIDdetailsnoThe unique identifier of the admin case related to the Assessment Definition.INTERNAL_ID SVR_INT64
recordStatusdetailsnoStatus of the Assessment Definition Case Link.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
displayOnCasePagedetailsyesIdentifies if the Assessment has been configured to be displayed on the home page of the case this record is related to.ASSESSMENT_DEFINITION_SELECTED_CASE_DISPLAYAssessDefCaseDisplaySVR_STRING<10>
executionLocationdetailsyesIdentifies where the Assessment can be run from. Optional attribute added in release 6.0SP2 @since 6.0 SP2 ASSESSMENT_EXECUTION_LOCATIONAssessmentExecutionFromSVR_STRING<10>
Foreign Keys (1)
ChildParent
AssessmentDefinitionCaseLink.assessmentDefinitionIDAssessmentDefinition.assessmentDefinitionID
Indices (2)
Index NameAttributes
IND_257270870relatedCaseID
IND_1641151888assessmentDefinitionID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: assessmentDefinitionCaseLnkID
AUTO_ID_KEY: ASSMTBO
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByCaseTypeRelatedIDAndStatusreadmulti Returns a list of all Assessment Definition Case Links for the given case type, related ID and status. 
searchByAssessmentDefinitionAndStatusreadmulti Lists all Assessment Definition Case Link records based on the given Assessment Definition and status. 
searchByAssessmentDefinitionCaseTypeAndStatusreadmulti Lists all Assessment Definition Case Link records based on the given Assessment Definition, case type and status. 
searchByCaseTypeAndStatusreadmulti Returns a list of all Assessment Definition Case Links for the given case type and status. 
readByAssessmentDefinitionCaseTypeCodeRelatedIDAndStatusnsread Reads a Assessment Definition Case Link for the given assessment definition, case type, related ID and status. 
Related Pages (13)