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

Details all changes applied to a provider member, provider group member or unassigned provider member certification. This includes changes to member certification details and status changes.

Example

Changes to Date of Issue of the member certification.
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::MemberCertChangeHistory
Controlling File: CPM\model\Packages\Service Layer\Provider\MemberCertification\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
memberCertChangeHistoryIDkeynoThe unique system generated identifier for the member certification change history record.INTERNAL_ID SVR_INT64
memberCertificationIDdetailsnoThe unique system generated identifier for the member certification record.INTERNAL_ID SVR_INT64
certificationIDdetailsnoThe unique system generated identifier for the certification record.INTERNAL_ID SVR_INT64
userNamedetailsyesThe name of the user who changed the member certificate record.USER_NAME SVR_STRING<64>
partyConcernRoleIDdetailsnoThe unique system generated identifier for the provider party.CONCERN_ROLE_ID SVR_INT64
dateTimedetails The date and time by which the change is effective.CURAM_DATETIME SVR_DATETIME
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>
Foreign Keys (4)
ChildParent
MemberCertChangeHistory.certificationIDCertification.certificationID
MemberCertChangeHistory.partyConcernRoleIDConcernRole.concernRoleID
MemberCertChangeHistory.memberCertificationIDMemberCertification.memberCertificationID
MemberCertChangeHistory.userNameUsers.userName
Indices (4)
Index NameAttributes
MemCrtCHMembrCertifcatonIDIdxmemberCertificationID
MemberCertChHCertifcatonIDIdxcertificationID
IND__690878716partyConcernRoleID
IND__1717753425userName
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: memberCertChangeHistoryID
Creates a new row on member Certification Change History 
readread Reads a row of data from certificationChangeHistory table 
searchByMemberCertificationIDreadmulti   
Related Pages (1)