Table Description
Assessment: The details of an assessment for a given client.

Technical Notes

Please Note: This entity is no longer part of the default flow in the Curam Application, as such it is neither written to nor read from by the Curam Application. It continues to be shipped with the Curam model as customer may have custom logic which uses this entity, however it should be noted that if you are implementing custom logic which references this entity then you must also ensure that it is written to as needed. The information that was originally stored in this entity is now stored in assessment delivery.

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::Core::Reference Model::Case::Entity Objects::Assessment::Assessment
Controlling File: core\model\Packages\Case\Assessment_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
assessmentIDkeynoThe unique ID for each assessment recordASSESSMENT_ID SVR_INT64
caseIDdetailsnoThe Id of the case with which this assessment is associated.CASE_ID SVR_INT64
assessmentCreationDatedetails The date on which this assessment was created.CURAM_DATE SVR_DATE
assessmentResultdetails The result of this assessment. This is populated from the AssessmentResult code table.ASSESSMENT_RESULT_CODEAssessmentResultSVR_STRING<10>
assessmentResultTextdetails The text of the results from the rules engine of running this assessment.RESULT_TEXT SVR_STRING<1048576>
assessmentModedetails The mode of this assessment. This is populated from the AssessmentMode code table.ASSESSMENT_MODE_CODEAssessmentModeSVR_STRING<10>
concernRoleIDdetailsnoThe concernRoleID of the client for whom this assessment was carried out.CONCERN_ROLE_ID SVR_INT64
assessmentConfigurationIDdetailsnoThe ID of the Assessment Configuration record on which this assessment is based.ASSESSMENT_CONFIGURATION_ID SVR_INT64
sensitivitydetails The sensitivity of this assessmentSENSITIVITY_CODESensitivitySVR_STRING<10>
recordStatusdetails The status of this assessment record. This is populated from the RecordStatus code table.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
assessmentStatusdetails The status of this assessment. This is populated from the AssessmentStatus code table.ASSESSMENT_STATUS_CODEAssessmentStatusSVR_STRING<10>
assessmentLastRunDatedetails The date on which this assessment was last run.CURAM_DATE SVR_DATE
assessmentCreatedBydetails The name of the user who created this assessment.USER_NAME SVR_STRING<64>
Foreign Keys (8)
ChildParent
Assessment.assessmentConfigurationIDAssessmentConfiguration.assessmentConfigurationID
Assessment.caseIDCaseHeader.caseID
Assessment.concernRoleIDConcernRole.concernRoleID
AssessmentComponent.assessmentIDAssessment.assessmentID
AssessmentEvidence.assessmentIDAssessment.assessmentID
AssessmentObjective.assessmentIDAssessment.assessmentID
AssessmentObjectiveTag.assessmentIDAssessment.assessmentID
AssessmentQuestions.assessmentIDAssessment.assessmentID
Indices (2)
Index NameAttributes
AssConfigBeforeIdxassessmentConfigurationID, assessmentCreationDate
CasePpantIndexcaseID, concernRoleID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByCaseIDreadmulti Method to search for an assessment by Case ID. 
searchByCaseAndConcernIDreadmulti Operation to search the assessment entity for a specified case and concern role. 
countAssessmentsns Counts Assessment records for specified Case and Participant.SQL
countAssessmentsOfTypeBeforens Counts the amount of assessment of this type before the specified date.SQL
Related Pages (98)
Delete Hearing Representative (Appeal_cancelRepresentative)
Delete Witness (Appeal_cancelWitness)
Delete Witness (Appeal_cancelWitnessIC)
Delete Hearing Representative (Appeal_IC_cancelHearingReviewRepresentative)
Delete Hearing Representative (Appeal_IC_cancelRepresentative)
Match Client (Application_matchClientConfirmation)
Add Client (Application_registerPersonAndAddAsClient)
Register Person (Application_registerProspectPersonAsPerson)
Register Person (BenefitSample_registerPerson)
Delete Member (Case_cancelCaseMember)
Delete Client Role (Case_cancelClientRole)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCase)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCasePDC)
Add Client (CommonIntake_addClient)
Remove Client (CommonIntake_cancelApplicationClient)
Register Client (CommonIntake_registerClient)
Delete Assessment (DecisionAssistAdmin_cancelAssessment)
Edit Assessment (DecisionAssistAdmin_modifyAssessmentDetails)
Delete Company Relationship (Employer_cancelRelatedCompany)
Edit Company Relationship (Employer_modifyRelatedCompany)
New Household Relationship Evidence (EVD_addToCaseHouseholdRelationshipEvidence_sa)
New Household Relationship Evidence (EVD_addToCaseHouseholdRelationshipEvidence_wzSelAllCre)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
Edit Household Relationship Evidence (EVD_incomingModifyHouseholdRelationshipEvidence)
Edit Household Relationship Evidence (EVD_modifyHouseholdRelationshipEvidence)
Add Member (HCRAddMemberWizard_summary)
Register Person (ICSample_registerPerson)
Eligibility Result: (IncomeScreening_checkEligibility)
Capture Head of Household Details: (IncomeScreening_createCase)
Household Benefits: (IncomeScreening_enterBenefitEvidence)
Household Expenses: (IncomeScreening_enterExpenseEvidence)
Household Members: (IncomeScreening_enterHouseholdMembers)
Household Income: (IncomeScreening_enterIncomeEvidence)
Household Resources: (IncomeScreening_enterResourceEvidence)
Income Screening Home: (IncomeScreening_home)
Assessments (IncomeScreening_listAssessment)
Household Benefits: (IncomeScreening_listBenefitEvidence)
Household Expenses: (IncomeScreening_listExpenseEvidence)
Household Members: (IncomeScreening_listHouseholdMember)
Household Income: (IncomeScreening_listIncomeEvidence)
Household Resources: (IncomeScreening_listResourceEvidence)
Register Person (IncomeScreening_registerHouseholdMember)
Register Person (IncomeScreening_registerPerson)
Delete Household Evidence Details: (IncomeSupportScreening_cancelISHouseholdEvidence)
Register Person (IncomeSupportScreening_registerPerson)
Register Person (IncomeSupportScreening_registerPersonForHouseholdEvidence)
Register Prospect Person as Person (Individual_registerProspectAsPerson)
Related Persons (Intake_listRelatedPerson)
Register Person (Intake_personFullRegistration)
Person Search Results (Intake_personSearchResult)
Register Prospect Person as Person (Intake_registerProspectAsPerson)
Register Prospect Person as Person (Intake_registerProspectPersonAsPerson)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
Register Person (IntakeShortCuts_registerPerson)
Delete Case Member (InvestigationDelivery_cancelCaseMember)
Register Person (InvestigationSample_registerPerson)
Register Person (InvestigationSample_registerPersonForPDC)
Add Household Member (ISAddMemberWizard_summaryDetails)
Register Person (ISP_registerPerson)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Re-add a Member (ISReAddMemberWizard_submit)
Add Legal Action Participants (LegalAction_addParticipant)
Register Person (LiabilitySample_registerPerson)
Remove Client (OutcomePlan_removeClient)
Merge Duplicate (Participant_mergeRelationships)
Delete Relationship (Person_cancelRelationship)
Edit Relationship (Person_modifyRelationship)
Edit Relationship (Person_modifyRelationshipFromList)
Edit Relationship (Person_modifyRelationshipFromView)
Register Person (Person_register)
Register Person (Person_registerForPDC)
Confirm Registration (Prospect_registerPersonFromProspect)
Delete Company Relationship (ProspectEmployer_cancelRelatedCompany)
Edit Company Relationship (ProspectEmployer_modifyRelatedCompany)
Register Prospect Employer as Employer (ProspectEmployer_registerAsEmployer)
Register Prospect Employer as Employer (ProspectEmployer_registerAsEmployerWizard)
Delete Relationship (ProspectPerson_cancelRelationship)
Edit Relationship (ProspectPerson_modifyRelationshipFromList)
Edit Relationship (ProspectPerson_modifyRelationshipFromView)
Register Prospect Person as Person (ProspectPerson_registerAsPerson)
Register Prospect Person as Person (ProspectPerson_registerAsPersonForPDCWizard)
Register Prospect Person as Person (ProspectPerson_registerAsPersonWizard)
Step 5: Register Person (ProviderManagement_duplicateRegisterPersonAsProvider)
Step 5: Register Person (ProviderManagement_registerPersonAsProvider)
Register As Person (ProviderManagement_registerProviderAsPersonFrmProviderHome)
Register Person (RegisterPerson_registerForPDCWizard)
Register Person (RegisterPerson_registerWizard)
Delete Assessment (Resource_cancelAssessment)
Edit Assessment (Resource_modifyAssessmentFromList)
Edit Assessment (Resource_modifyAssessmentFromView)
Decision Details (Screening_viewDecision)
Decision Details (Screening_viewDecisionFromCheckEligibility)
Decision Details (Screening_viewDecisionFromHome)
Decision Details (Screening_viewDecisionPopup)
Remove Client (SocialEnterpriseFolder_removeClient)