Table Description
Agreement Cancellation : Information relating to the cancellation of an agreement.

An agreement can be cancelled at any point in it's life cycle except when it is already cancelled.

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. At a later date additional activities are added to the plan. The original agreement is cancelled and a new agreement created and issued to James which includes the new activities. This entity stores the cancellation details for the initial agreement.

Technical Notes

For primary key of the agreement cancellation is the same identifier used by the agreement record it is related to. The cancellation date and cancelled by fields should be populated by the system using the current program user and current date on cancellation of an agreement.

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::AgreementCancellation
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery\Agreement.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
agreementCancellationIDkeynoUnique identifier of the agreementINTERNAL_ID SVR_INT64
cancellationDatedetailsnoThe cancellation date of the agreementCURAM_DATE SVR_DATE
cancelledBydetailsnoThe username of the user who cancelled the agreementUSER_NAME SVR_STRING<64>
cancellationCommentsdetailsyesThe comments entered by the user when cancelling an agreement.COMMENTS SVR_STRING<300>
cancellationReasondetailsnoThe reason why the agreement was cancelled. For example, entered in errorAGREEMENT_CANCEL_REASONAgreementCancelReasonSVR_STRING<10>
Foreign Keys (2)
ChildParent
AgreementCancellation.cancelledByUsers.userName
Agreement.agreementCancellationIDAgreementCancellation.agreementCancellationID
Indices (1)
Index NameAttributes
IND__743402410cancelledBy
Operations (2)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: agreementCancellationID
Standard Operation 
readread Standard Operation 
Related Pages (0)