Table Description
Contract Status History: The status history of a contract.

The status of a contract will change through its lifecycle.

Example

The status for a contract is set to 'In Edit' upon initial creation, and then changed to 'Live' once activated.
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::CPM::Service Layer::Provider::Contracts::ContractStatusHistory::Entity::ContractStatusHistory
Controlling File: CPM\model\Packages\Service Layer\Provider\Contracts\ContractStatusHistory\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
contractStatusHistoryIDkeynoThe unique system generated identifier for the contract status history record.CONTRACT_STATUSHISTORYID SVR_INT64
contractVersionIDdetailsnoThe unique system generated identifier for the contract version record.CONTRACT_VERSION_ID SVR_INT64
statusDateTimedetails The date and time that the contract status is effective from.CURAM_DATETIME SVR_DATETIME
statusdetails The status of a contract.CONTRACT_STATUSContractStatusSVR_STRING<10>
lastModifiedBydetails The user name of the person who last modified the contract.USER_NAME SVR_STRING<64>
statusHistoryGenerationReasondetails This attribute records the Generation Reason for each status history record created upon generation.CONTRACT_GENREASONContractGenReasonSVR_STRING<10>
Foreign Keys (1)
ChildParent
ContractStatusHistory.contractVersionIDContractVersion.contractVersionID
Indices (1)
Index NameAttributes
ContrtStatHsCntractVersnIDIdxcontractVersionID
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: contractStatusHistoryID
Standard Operation 
readread Standard Operation 
searchByContractIDreadmultiORDER_BY: statusDateTime
WHERE: contractVersionID = :contractVersionID
  
Related Pages (31)
Activate Contract (ProviderManagement_activateContract)
Amend Utilization Contract (ProviderManagement_amendProviderGroupUtilizationContract)
Amend Contract (ProviderManagement_amendUtilizationContract)
Confirm Suspend Provider (ProviderManagement_confirmSuspendProvider)
Generate Contract (ProviderManagement_generateContract)
Services (ProviderManagement_listAmendedProviderOfferingsForProviderGroup)
Services (ProviderManagement_listUtilizationContractProviderOfferingsForProviderGroup)
Performance Measure (ProviderManagement_listUtilizationPerformanceMeasureForAmendHistory)
Services (ProviderManagement_listUtilizationProviderOfferingsForAmendHistory)
Edit Flat Rate Contract (ProviderManagement_modifyFlatRateContractForProvider)
Edit Flat Rate Contract (ProviderManagement_modifyFlatRateContractForProviderGroup)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProvider)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProviderGroup)
Preview Contract (ProviderManagement_previewContract)
Print Contract (ProviderManagement_printContract)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Suspend Provider (ProviderManagement_suspendProvider)
Terminate Contract (ProviderManagement_terminateContract)
Utilization Contract: (ProviderManagement_viewAmendedContract)
Home (ProviderManagement_viewAmendedUtilizationContractForProviderGroup)
Contract Status History (ProviderManagement_viewContractStatusHistory)
Flat-Rate Contract (ProviderManagement_viewFlatRateContractForProvider)
Flat-Rate Contract (ProviderManagement_viewFlatRateContractForProviderGroup)
Performance Measure (ProviderManagement_viewFlatRateContractPMForProvider)
ProviderManagement_viewFlatRateContractServicesForPG
Services (ProviderManagement_viewFlatRateContractServicesForProvider)
Utilization Contract: (ProviderManagement_viewUtilizationContractForProvider)
Utilization Contract (ProviderManagement_viewUtilizationContractForProviderGroup)
Performance Measure (ProviderManagement_viewUtilizationContractPerformanceMeasureForProvider)
Services (ProviderManagement_viewUtilizationContractProviderOfferings)