Table Description
License Status History: The status history of a license. The status of a license will change through its lifecycle.

The status history of a license. The status of a license will change through its lifecycle.

Example

The status is set to 'In Progress' upon initial creation, and then changed to 'Approved' following approval.

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::LicenseStatusHistory::Entity::LicenseStatusHistory
Controlling File: CPM\model\Packages\Service Layer\Provider\LicenseStatusHistory\Entity\Entity_cat.efx
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
licenseStatusHistoryIDkeynoThe unique system generated identifier for the license status history record.LICENSE_STATUS_HISTORY_ID SVR_INT64
licenseIDdetailsnoThe unique system generated identifier for the license.LICENSE_ID SVR_INT64
licenseStatusdetails The status of a license. The status of a license will change through it's lifecycle for example, the status is set to 'In Progress' upon initial creation, and then changed to 'Approved' following approval.LICENSE_STATUSLicenseStatusSVR_STRING<10>
createdBydetails Name of the user who caused the license status history to change.USER_NAME SVR_STRING<64>
suspensionReasondetails The reason the license was suspended.LICENSE_SUSPENSION_REASONLicenseSuspensionReasonSVR_STRING<10>
effectiveDateTimedetails The date and time that the license status is effective from.CURAM_DATETIME SVR_DATETIME
rejectionReasondetails The reason the license was rejected.LICENSE_REJECTION_REASONLicenseRejectionReasonSVR_STRING<10>
commentsdetails Comments recorded by the user relating to a license status history.COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
LicenseStatusHistory.licenseIDLicense.licenseID
Indices (1)
Index NameAttributes
LicenseStatusHistoryIndex1licenseID
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: licenseStatusHistoryID
Standard Operation 
readread Standard Operation 
searchByLicenseIDnsmulti This method returns a list of license status history records for a license in descending order.SQL
Related Pages (12)