Table Description
Assessment Definition : A type of assessment which can be used to assess a client across a set of defined factors.

An assessment is used to identify a clients needs and enable the development of a outcome plan whereby the most appropriate activities may be scheduled to address any needs identified. An agency may have many different types of assessments, for example, Risk Assessment, Safety Assessment, Self Sufficiency Assessment. This entity is focused on the definition of different types of assessment within the administration component. An assessment can be run for a group of clients which results in one result for the group or it may be run for one or more clients producing results for each client. A user must specify whether an assessment is group based or individual client based when creating an assessment definition. An assessment may be executed using C\u00FAram Decision Assist (CDA) or C\u00FAram Express Rules (CER), this must be defined when creating an assessment definition.

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) 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 FSN assessment can be reassessed to assess the family's progress over time. This entity stores the types of assessments available to a caseworker to assess a family - in this case it stores the details of the FSN Assessment.
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::AssessmentDefinition::AssessmentDefinition
Controlling File: AssessmentPlanning\model\Packages\Administration\Entity\AssessmentDefinition_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (37)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
assessmentDefinitionIDkeynoUnique identifier for the Assessment Definition.ASSESSMENT_DEFINITION_ID SVR_INT64
assessmentTypedetailsnoThe type of assessment being executed, e.g. role based assessments or group based assessments. For role based assessments the questions are asked of each role, for group based assessments the questions are asked for the group.ASSESSMENT_DEFINITION_TYPE_CODEAssessmentDefinitionTypeSVR_STRING<10>
nameTextIDdetailsnoThe localizable name of the assessment definition.LOCALIZABLE_TEXT_ID SVR_INT64
descriptionTextIDdetailsnoThe localizable description of the assessment definition.LOCALIZABLE_TEXT_ID SVR_INT64
groupNameIDdetailsnoThe ID for the localizable name of the group to be displayed when running the group based assessments.LOCALIZABLE_TEXT_ID SVR_INT64
startDatedetailsnoThe date that the assessment is effective from.CURAM_DATE SVR_DATE
endDatedetailsyesThe last date that the assessment is effective.CURAM_DATE SVR_DATE
assessmentIntervaldetailsnoThis indicates the interval (in days) at which the assessments may be run.NUMBER_OF_DAYS SVR_INT32
reassessmentWarningDaysdetailsnoThe number of days before reassessment is due that a workflow event is raised. This event could be used to notify a caseworker prior to reassessment that reassessment is due on a particular date.NUMBER_OF_DAYS SVR_INT32
creationDatedetailsnoThe date of creation of the assessment.CURAM_DATE SVR_DATE
createdBydetailsnoThe username of the user who created the Assessment Definition.USER_NAME SVR_STRING<64>
assessmentRolesUpdateInddetailsnoIndicates whether assessment role(s) can be be updated for reassessment.CURAM_INDICATOR SVR_BOOLEAN
referencedetailsyesA reference field so that assessment definitions can be referenced within code. The reference field is unique across all active assessment definitions.ASSESSMENT_PLANNING_CODE_REFERENCE SVR_STRING<50>
reassessmentAllowedInddetailsnoIndicates if reassessments are allowed for the assessment. This controls if a Reassess button is displayed on the assessment home page.CURAM_INDICATOR SVR_BOOLEAN
prioritiesApplicableInddetailsnoIndicates if priorities apply to this assessment.CURAM_INDICATOR SVR_BOOLEAN
recordStatusdetailsnoStatus of the Assessment Definition.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
summaryScriptIDdetailsyes@since 6.0 SP2. This attribute is no longer used as the IEG information is retrieved directly from the IEG Script. The ID of the IEG script used to display a summary of the answers captured for an assessment.IEG_SCRIPT_ID SVR_STRING<100>
summaryScriptTypedetailsyes@since 6.0 SP2. This attribute is no longer used as the IEG information is retrieved directly from the IEG Script. The script type used to display a summary of the answers captured for an assessment.IEG_USERDEFINIED_TYPE SVR_STRING<128>
summaryScriptVersiondetailsyes@since 6.0 SP2. This attribute is no longer used as the IEG information is retrieved directly from the IEG Script. The version of the script used to display a summary of the answers captured during a script execution.IEG_SCRIPT_VERSION SVR_STRING<50>
displayGraphsdetailsnoIndicates whether or not graphs should be displayed for this assessmentDefinition. If this is set to true, the assessment results will be graphed. If this is set to false, lists will be displayed instead of the graph.CURAM_INDICATOR SVR_BOOLEAN
graphBydetailsyesDictates whether the graphs for this assessmentDefinition are based on classifications, or scores. This is only applicable in the instance where the displayGraph indicator is set to true.ASSESSMENT_DEFINITION_GRAPH_BYAssessmentDefGraphBySVR_STRING<10>
displayResultsByCategoryInddetailsnoIndicates whether the results of an assessment should be displayed by category, or by classification. This is only applicable in the instance where there is only one category configured for the assessment definition, and only applies to the priority results list.CURAM_INDICATOR SVR_BOOLEAN
assessmentIDdetailsyesUnique identifier of the assessment to be used, i.e. the CDA assessment identifier, or the CER assessment identifier.INTERNAL_ID SVR_INT64
assessmentCategoryTypedetailsyesCodetable identifier for the category of this assessment, i.e. CDA or CER.ASSESSMENT_CATEGORY_TYPEAssessmentCategoryTypeSVR_STRING<10>
displayScoredetailsnoIndicates whether the score should be displayed for this assessment definition.CURAM_INDICATOR SVR_BOOLEAN
displayGuidancedetailsnoIndicates whether or not guidance should be displayed for this assessmentDefinition. If this is set to true, the guidance will be displayed for the assessed factors. If this is set to false, no guidance will be displayed.CURAM_INDICATOR SVR_BOOLEAN
guidanceResultClusterdetailsnoHolds the identifier indicating if the guidance result cluster is to be displayed by default as open or closed.GUIDANCE_RESULT_CLUSTER_DISPLAYGuidanceResultClusterSVR_STRING<10>
factorDisplayTextIDdetailsyesThe text to be displayed for the assessment results factor column, which will default to 'Factor' if no text is specified.LOCALIZABLE_TEXT_ID SVR_INT64
classificationDisplayTextIDdetailsyesThe text to be displayed for the assessment results column, which will default to 'Classification' if no text is specified.LOCALIZABLE_TEXT_ID SVR_INT64
graphTypedetailsyesDictates the type of graph to be displayed for this assessmentDefinition. For example, a bar chart or spider graph. This is only applicable in the instance where the displayGraph indicator is set to true.ASSESSMENT_DEFINITION_GRAPH_TYPEAssessmentDefGraphTypeSVR_STRING<10>
countSameScoreAsOnePriorityInddetailsnoIndicates whether or not the same factor score achieved by more than one client can be counted as a single priority factor.CURAM_INDICATOR SVR_BOOLEAN
createRightsdetailsyesThe security identifier associated with the creation rights for the assessment.ASSESSMENT_DEFINITION_SECURITY_IDENTIFIER SVR_STRING<100>
closeRightsdetailsyesThe security identifier associated with the closure rights for the assessment.ASSESSMENT_DEFINITION_SECURITY_IDENTIFIER SVR_STRING<100>
viewAnswerRightsdetailsyesThe security identifier associated with the right to view assessment answers.ASSESSMENT_DEFINITION_SECURITY_IDENTIFIER SVR_STRING<100>
approveAndRejectRightsdetailsyesThe security identifier associated with the approval and rejection rights for the assessment.ASSESSMENT_DEFINITION_SECURITY_IDENTIFIER SVR_STRING<100>
assessmentResultsPagedetailsyesThe name of the page used to display the assessment results. This is only applicable if graphs are not displayed.ASSESSMENT_RESULTS_URI SVR_STRING<250>
assessmentGroupingdetailsyesCodetable identifier for the assessment grouping, i.e. SDM.ASSESSMENT_DEFINITION_GROUPINGAssessmentGroupingSVR_STRING<10>
Foreign Keys (8)
ChildParent
AssessmentDefinition.summaryScriptIDIEGScriptInfo.scriptID
AssessmentDefinition.nameTextIDLocalizableText.localizableTextID
AssessmentDefinition.descriptionTextIDLocalizableText.localizableTextID
AssessmentDefinition.groupNameIDLocalizableText.localizableTextID
AssessmentCase.assessmentDefinitionIDAssessmentDefinition.assessmentDefinitionID
AssessmentDefinitionCaseLink.assessmentDefinitionIDAssessmentDefinition.assessmentDefinitionID
AssessmentRole.assessmentDefinitionIDAssessmentDefinition.assessmentDefinitionID
DAOutcomeFactorLink.assessmentDefinitionIDAssessmentDefinition.assessmentDefinitionID
Indices (8)
Index NameAttributes
IND__1740429983reference
IND_1110503815assessmentID
IND_1791710850summaryScriptID
IND__447376639summaryScriptType
IND_690859953summaryScriptVersion
IND__236607971nameTextID
IND_1200335418descriptionTextID
IND__1196258085groupNameID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: assessmentDefinitionID
AUTO_ID_KEY: ASSMTBO
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByStatusreadmulti Returns a list of Assessment Definitions for the given status. 
readByStatusAndReferencensread Reads an assessment definition record based on reference and record status. 
searchByAssessmentIDreadmulti Returns a list of Assessment Definitions that are relatd to the given assessment identifier. 
searchByAssessmentIDTypeAndStatusreadmulti   
Related Pages (108)
New Condition (AssessmentAnswerCondition_detailsWizard)
Edit Assessment Question and Answer Condition (AssessmentAnswerCondition_edit)
AssessmentAnswerCondition_listSummary
Remove Case (AssessmentDefinition_cancelCaseLink)
Add Cases (AssessmentDefinition_createCaseLink)
AssessmentDefinition_details
Display on Home Page (AssessmentDefinition_displayOnCaseHome)
Cases (AssessmentDefinition_listCaseLinks)
Edit Assessment Availability (AssessmentDefinition_modifyAssessmentExecutionLocation)
Remove From Home Page (AssessmentDefinition_removeFromCaseHome)
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 Details (AssessmentDelivery_assessmentInstanceHome)
Compare (AssessmentDelivery_compareAssessments)
Compare (AssessmentDelivery_compareAssessmentsModal)
AssessmentDelivery_details
Home (AssessmentDelivery_home)
Approval Requests (AssessmentDelivery_listApprovalRequests)
History (AssessmentDelivery_listAssessmentInstance)
Assessment Results (AssessmentDelivery_listAssessmentResults)
Reject Assessment (AssessmentDelivery_reject)
New Assessment (AssessmentDelivery_selectAssessmentDefinition)
New Assessment (AssessmentDelivery_selectClientAndRoles)
Home (AssessmentDelivery_summary)
Add Note: (AssessmentDelivery_updateFactorNote)
Answers (AssessmentDelivery_viewAssessmentAnswersFromAssessmentHome)
Home (AssessmentDelivery_viewAssessmentAnswersFromInstanceHome)
AssessmentDelivery_viewCombinedResultsForInstance
Assessment Home: (AssessmentDelivery_viewGuidanceFromAssessmentHistory)
Guidance (AssessmentDelivery_viewGuidanceFromAssessmentHome)
AssessmentDelivery_viewResultsForInstance
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 Categories (AssessmentPlanningAdmin_cancelCategory)
Delete CER Assessment Configuration (AssessmentPlanningAdmin_cancelCERTSpecification)
New Assessment Definition (AssessmentPlanningAdmin_createAssessmentDefinition)
Add Categories (AssessmentPlanningAdmin_createCategory)
New Category Classification (AssessmentPlanningAdmin_createCategoryClassification)
Edit Assessment Definition (AssessmentPlanningAdmin_editAssessmentDefinitionFromList)
Edit Assessment Definition (AssessmentPlanningAdmin_editAssessmentDefinitionFromView)
Assessment Approval Checks: (AssessmentPlanningAdmin_listApprovalChecks)
AssessmentPlanningAdmin_listAssessmentDefinitions
Roles (AssessmentPlanningAdmin_listAssessmentRoles)
Categories (AssessmentPlanningAdmin_listCategoryClassifications)
Modify Assessment Approval Check: (AssessmentPlanningAdmin_modifyAssessmentApprovalCheckFromList)
Modify Assessment Approval Check: (AssessmentPlanningAdmin_modifyAssessmentApprovalCheckFromView)
Remove Outcome Mapping (AssessmentPlanningAdmin_removeDAOutcomeLinkFromScoringFactor)
Remove Assessment Result Link: (AssessmentPlanningAdmin_removeDAOutcomeLinkFromViewFactorFromDefinition)
Remove Outcome Mapping (AssessmentPlanningAdmin_removeDAOutcomeLinkFromViewFactorFromList)
Set Factor Display Order (AssessmentPlanningAdmin_reorder)
Set Category and Classification Display Order (AssessmentPlanningAdmin_reorderCategoriesAndClassifications)
Set Classification Display Order (AssessmentPlanningAdmin_reorderClassifications)
Set Role Display Order (AssessmentPlanningAdmin_reorderRoles)
Assessment Approval Check: (AssessmentPlanningAdmin_viewAssessmentApprovalCheck)
Home (AssessmentPlanningAdmin_viewAssessmentDefinition)
Home (ATOutcomesPlan_home)
Assessments: (Case_listAssessmentDeliveries)
Delete CDA Assessment Configuration (DAAssessmentConfiguration_cancel)
DAAssessmentConfiguration_list
Assessments: (ICProductSample_listAssessmentDeliveries)
Create Assessment Approval Check: (Organization_createAssessmentApprovalCheckForOrgUnit)
Create Assessment Approval Check: (Organization_createAssessmentApprovalCheckForUser)
Assessment Approval Checks: (Organization_listAssessmentApprovalChecksForOrgUnit)
Assessment Approval Checks (Organization_listAssessmentApprovalChecksForUser)
Edit Assessment Approval Check (Organization_modifyOrgUnitAssessmentApprovalFromList)
Edit Assessment Approval Check (Organization_modifyOrgUnitAssessmentApprovalFromView)
Edit Assessment Approval Check (Organization_modifyUserAssessmentApprovalFromList)
Edit Assessment Approval Check (Organization_modifyUserAssessmentApprovalFromView)
Organization_viewInlineUserAssessmentApproval
Assessment Approval Check: (Organization_viewOrgUnitAssessmentApproval)
Assessment Approval Check: (Organization_viewUserAssessmentApproval)
Home (OutcomePlan_home)
Assessments (OutcomePlan_listAssessments)
Assessments (OutcomePlan_listAssessmentsForReview)
Factors (OutcomePlan_listFactors)
Assessments (OutcomePlan_listOutcomePlanAssessments)
New Assessment (OutcomePlan_selectAssessmentDefinition)
New Assessment (OutcomePlan_selectPlanReviewAssessmentDefinition)
Set Priority Factors (OutcomePlan_setPriorityFactors)
Home (OutcomePlan_viewFactor)
) (OutcomePlan_viewFactorContextPanel)
OutcomePlan_viewFactorRecommendationFactorDetails
OutcomePlan_viewFactorRecommendationsFactorRatingsDetails
New Factor (OutcomePlanActionAdmin_createOutcomePlanFactorAdmin)
Edit Factor (OutcomePlanActionAdmin_modifyOutcomePlanFactorAdmin)
New Note (OutcomePlanFactor_addNote)
OutcomePlanFactor_viewStandAloneFactorSummary
OutcomePlanFactor_viewUserDefinedFactorSummary
OutcomesSupervisor_assessmentsDue
OutcomesWorker_assessmentsDue
Assessments: (SocialEnterpriseFolder_listAssessment)
Visits (VisitationEvaluation_listByPlanReviewNonSDM)
Visits (VisitationEvaluation_listByPlanReviewSDM)