Table Description
Assessment Case : Details of the execution of an assessment.

An assessment instance is created when an assessment is initially run and each time that assessment is reassessed.

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 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 details of the initial assessment run for the family and the details of each reassessment.

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::AssessmentInstance::AssessmentInstance
Controlling File: AssessmentPlanning\model\Packages\Delivery\Entity\AssessmentInstance_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
assessmentInstanceIDkeynoUnique identifier for an assessment instance record.INTERNAL_ID SVR_INT64
assessmentCaseIDdetailsnoThe identifier of the parent assessment case record. Foreign key to the AssessmentCase entity.INTERNAL_ID SVR_INT64
assessmentDatedetailsnoThe date & time the assessment was run.CURAM_DATETIME SVR_DATETIME
assessmentInstanceStatusdetailsnoThe status of the assessment executionASSESSMENT_INSTANCE_STATUSAssessmentInstanceStatusSVR_STRING<10>
iegExecutionIDdetailsyesThe identifier of the IEG script execution linked to this assessment instance.IEG_EXECUTION_ID SVR_INT64
assessmentIDdetailsnoThe unique identifier of the assessment being executed.INTERNAL_ID SVR_INT64
usernamedetailsnoThe username of the user who executed the assessment.USER_NAME SVR_STRING<64>
commentsdetailsyesComments captured during the execution of an assessment.COMMENTS SVR_STRING<300>
answerIEGExecutionIDdetailsyesThe identifier of the IEG script execution linked to the script used for displaying the answers for this assessment instance.IEG_EXECUTION_ID SVR_INT64
Foreign Keys (6)
ChildParent
AssessmentInstance.assessmentCaseIDAssessmentCase.assessmentCaseID
AssessmentInstance.iegExecutionIDIEGExecutionState.executionID
AssessmentInstance.answerIEGExecutionIDIEGExecutionState.executionID
AssessmentInstance.usernameUsers.userName
AssessmentDeliveryRole.assessmentInstanceIDAssessmentInstance.assessmentInstanceID
AssessmentInstanceHistory.assessmentInstanceIDAssessmentInstance.assessmentInstanceID
Indices (4)
Index NameAttributes
IND__2123900075assessmentCaseID
IND_1168393744iegExecutionID
IND_1796150126answerIEGExecutionID
IND_1615628926username
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: assessmentInstanceID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
searchByAssessmentCasereadmultiORDER_BY: assessmentDate
Lists assessment instance records based on assessment case identifier. 
readByIEGExecutionnsread Reads the Assessment Instance details based on IEG Execution ID. 
Related Pages (38)
Approve Assessment (AssessmentApproval_confirmApproval)
Assessment Details (AssessmentDelivery_assessmentInstanceHome)
Delete Assessment (AssessmentDelivery_cancel)
Close Assessment (AssessmentDelivery_close)
Compare (AssessmentDelivery_compareAssessments)
Compare (AssessmentDelivery_compareAssessmentsModal)
AssessmentDelivery_details
Home (AssessmentDelivery_home)
History (AssessmentDelivery_listAssessmentInstance)
Assessment Results (AssessmentDelivery_listAssessmentResults)
Reject Assessment (AssessmentDelivery_reject)
New Assessment (AssessmentDelivery_selectClientAndRoles)
Home (AssessmentDelivery_summary)
Answers (AssessmentDelivery_viewAssessmentAnswersFromAssessmentHome)
Home (AssessmentDelivery_viewAssessmentAnswersFromInstanceHome)
AssessmentDelivery_viewCombinedResultsForInstance
Assessment Home: (AssessmentDelivery_viewGuidanceFromAssessmentHistory)
Guidance (AssessmentDelivery_viewGuidanceFromAssessmentHome)
AssessmentDelivery_viewResultsForInstance
Home (ATOutcomesPlan_home)
Assessments: (Case_listAssessmentDeliveries)
Assessments: (ICProductSample_listAssessmentDeliveries)
Home (OutcomePlan_home)
Assessments (OutcomePlan_listAssessments)
Assessments (OutcomePlan_listAssessmentsForReview)
Assessments (OutcomePlan_listOutcomePlanAssessments)
Home (OutcomePlan_viewFactor)
) (OutcomePlan_viewFactorContextPanel)
OutcomePlan_viewFactorRecommendationFactorDetails
OutcomePlan_viewFactorRecommendationsFactorGuidanceDetails
OutcomePlan_viewFactorRecommendationsFactorRatingsDetails
Guidance (OutcomePlanFactor_viewGuidanceDetails)
Guidance (OutcomePlanFactor_viewGuidanceModal)
OutcomePlanFactor_viewStandAloneFactorSummary
OutcomePlanFactor_viewUserDefinedFactorSummary
OutcomesSupervisor_assessmentsDue
OutcomesWorker_assessmentsDue
Assessments: (SocialEnterpriseFolder_listAssessment)