Results for “no_of_completed_courses”

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

Overview

OTA_LP_ENROLLMENTS is a transactional table in the Oracle E-Business Suite Learning Management module (OTA). It records the enrollment of a person, contact, or learner into a Learning Path — a structured, sequenced collection of courses that must be completed to satisfy a curriculum or certification requirement. Whereas individual course enrollments are tracked elsewhere, this table captures the path-level enrollment, the learner's progress against the path, and the aggregate status of the mandatory courses that constitute the path.

The metadata classifies this object heuristically as standalone within a Data Vault model. Under that modeling suggestion, OTA_LP_ENROLLMENTS would be treated as an independent hub or reference table rather than a pure link. In practice its grain is one row per learner-per-learning-path enrollment, identified by the surrogate key LP_ENROLLMENT_ID and anchored to a learning path via LEARNING_PATH_ID.

Key Information Stored

The table is physically owned by the OTA schema and contains 50 documented columns. The most significant are:

• LP_ENROLLMENT_ID — the surrogate primary key (OTA_LP_ENROLLMENTS_PK); the sole unique index documented, making it the single business-key candidate.
• LEARNING_PATH_ID — foreign key to OTA_LEARNING_PATHS, identifying the path being enrolled into.
• PERSON_ID and CONTACT_ID — the learner or external contact being enrolled.
• PATH_STATUS_CODE — the current state of the path enrollment (active, complete, withdrawn, etc.).
• ENROLLMENT_SOURCE_CODE — how the enrollment originated (self-service, administrator, batch, or requirement-driven).
• NO_OF_MANDATORY_COURSES and NO_OF_COMPLETED_COURSES — counters used to derive completion percentage for the path.
• COMPLETION_TARGET_DATE and COMPLETION_DATE — the due date and the actual completion timestamp.
• CREATOR_PERSON_ID — the person who created the enrollment.
• IS_HISTORY_FLAG — distinguishes current records from historical/archived ones.
• OBJECT_VERSION_NUMBER — optimistic-locking versioning column.

The remaining columns consist of WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN), BUSINESS_GROUP_ID for multi-org filtering, ATTRIBUTE_CATEGORY plus ATTRIBUTE1–ATTRIBUTE30 for extensibility, and the IS_HISTORY_FLAG control field.

Common Use Cases and Queries

Typical reporting needs include identifying learners who have not met their path completion target, measuring enrollment volumes by source, and exporting status for compliance audits. Because COURSE counts drive progress, a frequent query computes completion ratio:

• SELECT LP_ENROLLMENT_ID, PERSON_ID, PATH_STATUS_CODE, NO_OF_COMPLETED_COURSES, NO_OF_MANDATORY_COURSES FROM OTA.OTA_LP_ENROLLMENTS WHERE IS_HISTORY_FLAG = 'N';
• Active paths past their target: ... WHERE PATH_STATUS_CODE NOT IN ('COMPLETE') AND COMPLETION_TARGET_DATE < SYSDATE AND IS_HISTORY_FLAG = 'N';
• Joining to OTA_LEARNING_PATHS on LEARNING_PATH_ID to report path names.
• Aggregating enrollment_source_code to analyse self-service versus administrative enrollment trends.

Existing releases (12.1.1 and 12.2.2) expose the same documented physical schema and primary key, so the same SQL applies to both.

Related Objects

• OTA_LEARNING_PATHS — parent table; joined on LEARNING_PATH_ID.
• OTA_LP_MEMBER_ENROLLMENTS — child table referencing LP_ENROLLMENT_ID; holds the per-course membership rows that roll up into the path.
• OTA_LP_ENROLLMENTS_PK — the primary key constraint enforcing LP_ENROLLMENT_ID uniqueness.
• PER_ALL_PEOPLE_F — joined on PERSON_ID to resolve learner identity (standard OTA integration).
• OTA_LEARNERS / OTA_DELEGATES — enrollment context around the same person.
• OTA_LEARNING_PATH_API and related public APIs — for programmatic path enrollment and maintenance.

Integrity constraints place OTA_LP_ENROLLMENTS as the header record for a learner's learning-path experience, with line-level detail cascading from OTA_LP_MEMBER_ENROLLMENTS.