Search Results objective_performance_id

Overview

The OTA_SCORM_OBJ_PERFS table is a core data structure within the Oracle E-Business Suite Learning Management (OTA) module, specifically for versions 12.1.1 and 12.2.2. It functions as the persistent store for tracking a learner's performance against specific learning objectives defined within SCORM (Sharable Content Object Reference Model) compliant online training content. This table is critical for enabling the detailed tracking and reporting of learner progress, capturing granular status and scoring data at the objective level, which is a fundamental requirement for standards-based e-learning administration and compliance reporting.

Key Information Stored

The table's primary purpose is to record a learner's current state for a given objective. While the full column list is not detailed in the provided metadata, its description and primary/foreign key structure indicate it will contain several critical data points. The primary key, OBJECTIVE_PERFORMANCE_ID, uniquely identifies each performance record. The foreign key column, OBJECTIVE_ID, links to the OTA_SCORM_OBJECTIVES table, defining which specific objective is being tracked. The table will logically store the learner's identifier (linking to a person/learner table), the associated lesson or activity attempt, the objective's current status (e.g., "passed", "failed", "incomplete", "browsed"), and the raw and/or scaled score achieved. It may also include timestamps for the first and latest score updates.

Common Use Cases and Queries

This table is central to generating detailed learner transcripts and performance analytics. Common use cases include reporting on objective completion rates for a specific course, diagnosing learner difficulties by identifying commonly failed objectives, and auditing training effectiveness. A typical reporting query would join this table to learner and objective definitions to list all performances for a given training activity.

SELECT osp.objective_id, osp.score, osp.lesson_status, o.objective_description
FROM ota_scorm_obj_perfs osp,
     ota_scorm_objectives o
WHERE osp.objective_id = o.objective_id
  AND osp.learning_activity_id = :p_activity_id
  AND osp.learner_id = :p_person_id;

Data from this table is also essential for the SCORM runtime environment's data model, allowing the Learning Management System to read and write objective status as a learner interacts with content.

Related Objects

The OTA_SCORM_OBJ_PERFS table exists within a defined hierarchy of SCORM tracking tables in Oracle EBS. As per the documented foreign key relationship:

• OTA_SCORM_OBJECTIVES: This is the primary parent table. The column OTA_SCORM_OBJ_PERFS.OBJECTIVE_ID is a foreign key referencing OTA_SCORM_OBJECTIVES. This relationship ensures that every recorded performance is for a valid, defined objective. A join between these tables is required to retrieve the objective's descriptive text or identifier.

While not listed in the provided metadata, this table would also typically have foreign key relationships to tables storing the learner's identity (e.g., PER_ALL_PEOPLE_F) and the specific SCORM activity attempt (likely OTA_SCORM_ACTIVITIES or a similar entity), forming a complete data model for tracking.