Table Description
Assessment Instance History : The history of the life cycle of an assessment instance.

When an assessment instance is run it can go through various states i.e. 'Submitted','Closed', 'Complete', 'Cancelled', 'Incomplete'. This entity stores a history of these states.

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. Approval checks have been defined for the FSN and as such it must be manually approved. The case worker submits the assessment for approval resulting in an assessment status of Submitted. Subsequently, the case workers supervisor approves the assessment which results in the assessment having a status of Approved. This entity stores the states of 'Submitted' and 'Complete'.

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::AssessmentInstanceHistory::AssessmentInstanceHistory
Controlling File: AssessmentPlanning\model\Packages\Delivery\Entity\AssessmentInstanceHistory_cat.efx
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
assessmentInstanceHistoryIDkeynoUnique identifier for the table.INTERNAL_ID SVR_INT64
assessmentInstanceIDdetailsnoForeign key to the parent assessment instance entity.INTERNAL_ID SVR_INT64
effectiveDatedetailsnoThe date and time the history record was created, i.e. the time the related assessment instance transitioned from one state to another.CURAM_DATETIME SVR_DATETIME
statusdetailsnoThe status of the assessment instance record at the time the history record was created. This holds the new state of the assessment instance record as it transitions from the old state.ASSESSMENT_INSTANCE_STATUSAssessmentInstanceStatusSVR_STRING<10>
usernamedetailsnoThe username of the user who performed the state transition of the related assessment instance record.USER_NAME SVR_STRING<64>
Foreign Keys (2)
ChildParent
AssessmentInstanceHistory.assessmentInstanceIDAssessmentInstance.assessmentInstanceID
AssessmentInstanceHistory.usernameUsers.userName
Indices (2)
Index NameAttributes
instanceAndHistoryIdxassessmentInstanceID, status
IND__260637736username
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: assessmentInstanceHistoryID
Standard Operation 
readread Standard Operation 
searchByAssessmentInstancereadmulti Lists assessment instance history records for a given assessment instance. 
searchByAssessmentInstanceAndStatusreadmulti Searches for assessment instance history records for an assessment instance based on status. 
Related Pages (11)