Table Description
Certification: Certifications issued to a provider member, provider group member or unassigned provider member.

The information about certifications issued either by the organization or an external body, to a provider member, provider group member or unassigned provider member.

Example

Midway Child Care Services is responsible for issuing level 1 Child Care Certification to those individuals that complete the required training.
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::Certification
Controlling File: CPM\model\Packages\Service Layer\Certification\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
certificationIDkeynoThe unique system generated identifier for the certification record.CERTIFICATION_ID SVR_INT64
organisationUnitIDdetailsyesThe organization unit Identifier of the organization responsible for issuing the certification.ORGANISATION_UNIT_ID SVR_INT64
userNamedetailsnoThe name of the user who created the certification.USER_NAME SVR_STRING<64>
externalIssuerdetailsyesThe external body responsible for issuing the certification.EXTERNAL_ISSUERExternalIssuerSVR_STRING<10>
issuedByAgencyInddetailsyesIndicates whether the Certification Issuer is the organization.CURAM_INDICATOR SVR_BOOLEAN
certificationTypedetailsnoThe type of the certification.CERTIFICATION_TYPECertificationTypeSVR_STRING<10>
categorydetailsnoThe category of 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>
recordStatusdetailsnoThe status is used to indicate if the certification has been logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (5)
ChildParent
Certification.organisationUnitIDOrganisationUnit.organisationUnitID
Certification.userNameUsers.userName
CertificationChangeHistory.certificationIDCertification.certificationID
MemberCertChangeHistory.certificationIDCertification.certificationID
MemberCertification.certificationIDCertification.certificationID
Indices (2)
Index NameAttributes
CertificationOrgUnitIDIdxorganisationUnitID
IND__649185541userName
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: certificationID
AUTO_ID_KEY: CERTIF
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByCategoryTypeIssuernsmulti Reads the record depending on category,type and Issuer, which can either be the agency, organization unit or external issuer.SQL
readAllnkreadmultiORDER_BY: category
  
insertCerificationnsinsert Inserts record to certification entity. This method expects certification 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 (certification ID). It's preferred to call insertCertification only in scenario's where caller wants to set the value of primary key by itself. 
Related Pages (18)