Table Description
DAAssessment Status History: Assessment Status History holds details of the status of an Assessment Delivery.

Assessment Status History holds details of the status of an 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::Decision Assist::Service Layer::DAAssessment::Entity::AssessmentStatusHistory
Controlling File: DecisionAssist\model\Packages\Service Layer\DAAssessment\Entity\DAAssessment_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
assessmentStatusHistoryIDkeynoSystem generated unique identifier for an Assessment Status History.DA_ASSESSMENT_STATUS_HISTORY_ID SVR_INT64
assessmentCaseIDdetailsyesCase ID of the Assessment Delivery entity.CASE_ID SVR_INT64
actionDateTimedetails The date on which the Assessment Delivery was actioned and a status applies from .CURAM_DATETIME SVR_DATETIME
statusdetails The status of the Assessment Delivery.CASE_STATUS_CODECaseStatusSVR_STRING<10>
actionedBydetails The full name of the user who actioned the Assessment Delivery.DA_CREATED_BY_USER SVR_STRING<64>
recordStatusdetails  RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
AssessmentStatusHistory.assessmentCaseIDAssessmentDelivery.caseID
Indices (1)
Index NameAttributes
IND__29466740assessmentCaseID
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: assessmentStatusHistoryID
Standard Operation 
readread Standard Operation 
searchByAssessmentCaseIDnsmulti  SQL
Related Pages (5)