Table Description
Certification Change History: History of all changes to the certification details.

Details all changes applied to a certification. This includes changes to certification details (e.g. credits required) and status changes.

Example
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::Certification::Entity::CertificationChangeHistory
Controlling File: CPM\model\Packages\Service Layer\Certification\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (14)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
certificationChangeHistoryIDkeynoThe unique system generated identifier for the certification change history record.CERTIFICATION_CHANGE_HISTORY_ID SVR_INT64
certificationIDdetailsnoThe unique system generated identifier for the certification record.CERTIFICATION_ID SVR_INT64
dateTimedetailsnoThe date and time by which the change is effective.CURAM_DATETIME SVR_DATETIME
organisationUnitIDdetailsyesThe organization unit id of the organization responsible for issuing the certification.ORGANISATION_UNIT_ID SVR_INT64
userNamedetailsnoThe name of the user who changed the certificate record.USER_NAME SVR_STRING<64>
externalIssuerdetails The external body responsible for issuing the certification.EXTERNAL_ISSUERExternalIssuerSVR_STRING<10>
issuedByAgencyInddetails Indicates whether the Certification Issuer is the organizationCURAM_INDICATOR SVR_BOOLEAN
certificationTypedetailsnoThe type of the certification.CERTIFICATION_TYPECertificationTypeSVR_STRING<10>
categorydetailsnoThe category of the certification.CERTIFICATION_CATEGORYCertificationCategorySVR_STRING<10>
creditsRequireddetails The value of credits required to achieve the certification.CREDITS_REQUIRED SVR_INT16
creditTypedetails The type of credit that is required to achieve certification.CREDIT_TYPECreditTypeSVR_STRING<10>
validityPerioddetails Defines the period of validity for the certification.VALIDITY_PERIOD SVR_INT16
validityPeriodUnitdetails Unit of measure for period of validity for the certification.VALIDITY_PERIOD_UNITSValidityPeriodUnitsSVR_STRING<10>
recordStatusdetails The status is used to indicate if the certification has been logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (3)
ChildParent
CertificationChangeHistory.certificationIDCertification.certificationID
CertificationChangeHistory.organisationUnitIDOrganisationUnit.organisationUnitID
CertificationChangeHistory.userNameUsers.userName
Indices (3)
Index NameAttributes
CertificatnChngHisCertfIDIdxcertificationID
IND__1320232658organisationUnitID
IND__443774645userName
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: certificationChangeHistoryID
AUTO_ID_KEY: CERTIF
Standard Operation 
readread Standard Operation 
searchByCertificationIDreadmultiORDER_BY: dateTime
  
modifymodify <p> <font size="2">Modifies an existing row&nbsp;in CertificationChangeHistory table.</font> </p> 
insertCertificationChangeHistorynsinsert Inserts record to CertificationChangeHistory entity. This method expects CertificationChangeHistory ID to be set by the caller, if not set it delegates the call to insert() which is modeled to auto generate primary key field (CertificationChangeHistory ID). It's preferred to call insertCertificationChangeHistory only in scenario's where caller wants to set the value of primary key by itself.  
Related Pages (3)