Table Description
Expected End Date History: A history of changes to the expected end date of an expected outcome, a plan goal or a plan review

Example

A case worker assesses James Smith's strengths and needs and identifies that he has problems finding work and is alcohol dependent. To address these issues the case worker creates an outcome. A plan goal of self sufficiency is added to the plan. An expected end date of 01/01/2012 is specified. 6 months later James is reassessed and it is identified that his substance abuse problems have got worse. Based on this the expected end date of the plan goal is extended by 6 months to 06/01/2012. This entity stores a history of the changes to the expected end date.

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::OutcomePlanning::OutcomePlan::Entity::Delivery::ExpectedEndDateHistory::ExpectedEndDateHistory
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery\ExpectedEndDateHistory.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
expectedEndDateHistoryIDkeynoUnique identifier of the record.INTERNAL_ID SVR_INT64
relatedIDdetailsnoUnique identifier of the related record,.e.g. Plan Goal or Expected Outcome identifier.INTERNAL_ID SVR_INT64
relatedTypedetailsnoType of the related record, e.g. Plan Goal or Expected Outcome.EXPECTED_END_DATE_HISTORY_RELATED_TYPEExpectEndDateHistoryTypeSVR_STRING<10>
expectedEndDatedetailsnoThe expected end date of the related record.CURAM_DATE SVR_DATE
createdBydetailsnoThe user name of the user who set the expected end date.USER_NAME SVR_STRING<64>
creationDatedetailsnoThe date the expected end date was set.CURAM_DATETIME SVR_DATETIME
reasondetailsyesThe reason why the end date was changedREASON_TEXT SVR_STRING<200>
Foreign Keys (1)
ChildParent
ExpectedEndDateHistory.createdByUsers.userName
Indices (2)
Index NameAttributes
ExpEndDateHistRelIDTypeIdxrelatedID, relatedType
IND__1264272829createdBy
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: expectedEndDateHistoryID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByRelatedRecordreadmultiORDER_BY: creationDate DESC
Returns a list of records for the specified related record. The list is sorted in order of creation date. 
Related Pages (27)