Results for “cert_mbr_enrollment_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OTA_CERT_MBR_ENROLLMENTS is a transactional table in the Oracle E-Business Suite Learning Management module (product code OTA), owned by the OTA schema. It functions as a child of both certification enrollment and certification period enrollment. When a learner enrolls in a certification, a row is created for each member that belongs to that certification. The table therefore maintains the per-member enrollment records that underpin certification tracking at the individual member level, allowing the application to monitor completion and status for every member associated with a certification.

Under the heuristic Data Vault classification mined from its foreign key structure, this table is best modeled as a link. It resolves the many-to-many relationship between certification period enrollments and certification members, carrying its own descriptive attributes (such as member status and completion date) alongside the relationships it records.

Key Information Stored

The table contains 33 documented columns. The most significant are the following.

• CERT_MBR_ENROLLMENT_ID — the surrogate primary key, defined by the unique index OTA_CERT_MBR_ENROLLMENTS_PK. This is the sole documented business-key candidate and uniquely identifies each member enrollment row.
• CERT_PRD_ENROLLMENT_ID — foreign key to OTA_CERT_PRD_ENROLLMENTS; links this member record to the parent certification period enrollment.
• CERT_MEMBER_ID — foreign key to OTA_CERTIFICATION_MEMBERS; identifies the certification member to whom this enrollment row belongs.
• MEMBER_STATUS_CODE — the status of the member's enrollment (for example, active, completed, or withdrawn).
• COMPLETION_DATE — the date on which the member completed the certification requirement, where applicable.
• BUSINESS_GROUP_ID — the business group (HR operating unit) to which the row belongs, supporting multi-organization data partitioning.
• OBJECT_VERSION_NUMBER — the optimistic locking column used by the application to detect concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns recording row creation and modification.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — the standard Oracle EBS descriptive flexfield (DFF) columns reserved for customer-defined extensions.

Common Use Cases and Queries

Reporting on member-level certification progress is the primary use case. Analysts join this table upward to the certification period enrollment and across to the certification member to produce learner progress reports, completion audits, and compliance dashboards.

A typical query retrieves all members for a given certification period enrollment:

• SELECT m.CERT_MBR_ENROLLMENT_ID, m.CERT_MEMBER_ID, m.MEMBER_STATUS_CODE, m.COMPLETION_DATE FROM OTA_CERT_MBR_ENROLLMENTS m WHERE m.CERT_PRD_ENROLLMENT_ID = :cert_prd_enrollment_id;

To identify completed members, filter on MEMBER_STATUS_CODE or COMPLETION_DATE:

• SELECT CERT_MEMBER_ID, COMPLETION_DATE FROM OTA_CERT_MBR_ENROLLMENTS WHERE MEMBER_STATUS_CODE = 'COMPLETED' AND COMPLETION_DATE IS NOT NULL;

Because the table carries BUSINESS_GROUP_ID and the OBJECT_VERSION_NUMBER locking column, it is also queried in integration and data-migration routines where member enrollments are loaded or reconciled programmatically. The DFF attribute columns support customer-specific reporting whenever standard columns are insufficient.

Related Objects

• OTA_CERT_PRD_ENROLLMENTS — parent certification period enrollment; joined via CERT_PRD_ENROLLMENT_ID.
• OTA_CERTIFICATION_MEMBERS — the certification member master; joined via CERT_MEMBER_ID.
• OTA_CERTIFICATIONS — the certification definition reached transitively through the period enrollment and member relationships.
• OTA_CERTIFICATION_ENROLLMENTS — the enrollment header from which period enrollments descend.
• OTA_CERT_MBR_ENROLLMENTS_PK — the unique index on CERT_MBR_ENROLLMENT_ID that enforces the primary key.
• HR_OPERATING_UNITS / business group reference — via BUSINESS_GROUP_ID for multi-organization filtering.

Collectively, these objects define the certification tracking data model in Oracle Learning Management across EBS 12.1.1 and 12.2.2.