Table Description
Member Certification: Certifications that are achieved by a provider member, provider group member or unassigned provider member.

The information about certifications that are achieved by a provider member, provider group member or unassigned provider member.

Example

Level 1 Child Care certification is achieved when a member completes the required level of child care 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::Provider::MemberCertification::Entity::MemberCertification
Controlling File: CPM\model\Packages\Service Layer\Provider\MemberCertification\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
memberCertificationIDkeynoThe unique system generated identifier for the member certification record.INTERNAL_ID SVR_INT64
certificationIDdetailsnoThe unique system generated identifier for the certification record.CERTIFICATION_ID SVR_INT64
partyConcernRoleIDdetailsnoThe unique system generated identifier for the provider party.CONCERN_ROLE_ID SVR_INT64
dateOfIssuedetails The date on which the certification is issued to the provider member, provider group member or unassigned provider member.CURAM_DATE SVR_DATE
dateOfExpirydetails The date on which the certification for the provider member, provider group member or unassigned provider member expires.CURAM_DATE SVR_DATE
recordStatusdetails The status is used to indicate if the provider member certification has been logically deleted.RECORD_STATUSRecordStatusSVR_STRING<10>
commentsdetails Comments recorded by a user relating to the provider member, provider group member or unassigned provider member certification.COMMENTS SVR_STRING<300>
Foreign Keys (3)
ChildParent
MemberCertification.certificationIDCertification.certificationID
MemberCertification.partyConcernRoleIDConcernRole.concernRoleID
MemberCertChangeHistory.memberCertificationIDMemberCertification.memberCertificationID
Indices (2)
Index NameAttributes
MemberCertfCertifcatonIDIdxcertificationID
MemberCerPartyConcrnRoleIDIdxpartyConcernRoleID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: memberCertificationID
Creates a new row on MemberCertification table 
readread Reads a row of data from MemberCertification table 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on MemberCertification table. 
searchByPartyConcernRoleIDreadmulti   
searchByCertificationIDreadmulti   
Related Pages (13)