Table Description
Agreement Status History : A history of the status of an agreement over it's life time.

An agreement can have the following states: In-Edit: when the agreement is first created Submitted: when the case worker attempts to complete the agreement and approval is required Completed: when the case worker completes the agreement Issued: when the case worker issues the agreement to a signatory Signed: when all signatories associated with the agreement has signed it Cancelled: when the case worker cancels the agreement

Example

James Smith's strengths and needs were assessed and an outcome plan was created to address these needs. Multiple activities were added to the outcome plan. An agreement is created which ensures that James agrees to participate in all of the activities outlined in the outcome plan. The agreement is completed and issued to James for signing. This entity stores a status record of In-Edit, Completed and Issued.

Technical Notes

The date and userName fields should be populated by the system using the current program user and current date on creation of an agreement status history. The agreement status history only holds a record of the status changes for the parent agreement. It has no requirement for a status field.

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::Agreement::AgreementStatusHistory::AgreementStatusHistory
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery\StatusHistory.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
agreementStatusHistoryIDkeynoUnique identifier of the agreement status historyINTERNAL_ID SVR_INT64
userNamedetailsnoThe name of the user who effected the state changeUSER_NAME SVR_STRING<64>
creationDatedetailsnoThe date the agreement status history was createdCURAM_DATETIME SVR_DATETIME
agreementIDdetailsnoThe unique identifier of the agreement this Agreement Status History is part ofINTERNAL_ID SVR_INT64
statusdetailsnoThe status of the agreement the agreement status history record representsAGREEMENT_STATUSAgreementStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
AgreementStatusHistory.agreementIDAgreement.agreementID
AgreementStatusHistory.userNameUsers.userName
Indices (2)
Index NameAttributes
IND__1350611618agreementID
IND__1298296099userName
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: agreementStatusHistoryID
Standard Operation 
searchByAgreementreadmultiORDER_BY: creationDate
Returns a list of Agreement Status History records for the given agreement. The list is ordered by date. 
readread Standard Operation 
Related Pages (1)