Table Description
Case Contract: A formal agreement (within a case) between one or more participants and the organization.

Templates can be defined that contain the contract text.

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::Core::Reference Model::Case::Entity Objects::Case Contract::CaseContract
Controlling File: core\model\Packages\Case\Case Contract_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseContractIDkeynoThe unique identifier for the Case Contract EntityCASE_CONTRACT_ID SVR_INT64
fromDatedetails The start date of the case contractCURAM_DATE SVR_DATE
toDatedetails The end date of the case contractCURAM_DATE SVR_DATE
caseIDdetails The id of the case for which the contract is created.CASE_ID SVR_INT64
concernRoleIDdetails The id of the primary concern of the caseCONCERN_ROLE_ID SVR_INT64
documentIDdetails Unique identifier of a case contract document.PRO_FORMA_ID SVR_INT64
documentVersionNodetails Version number of the case contract document.TEMPLATE_VERSION SVR_INT32
isPrintedInddetails To indicate if the contract has been printedCURAM_INDICATOR SVR_BOOLEAN
contractTypedetails The type of contract createdTEMPLATE_NAME SVR_STRING<100>
contractDatedetails The date on which the contract was createdCURAM_DATE SVR_DATE
ownerIDdetails The owner of the case for which the contract was createdUSER_NAME SVR_STRING<64>
recordStatusCodedetails The record status of the recordRECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
CaseContractContents.caseContractIDCaseContract.caseContractID
Indices (2)
Index NameAttributes
indexCaseIDcaseID
IND_1640435156concernRoleID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByCaseIDreadmultiORDER_BY: fromDate
Reads all the case contracts for a specified case. 
searchByCaseIDAndConcernRolereadmultiORDER_BY: fromDate
Reads all the case contracts for a specified case and concern role 
Related Pages (19)