Results for “teaching_period”

9 results




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

Overview

IGS_DA_OUT_UNT_EN is a table within the IGS (Student System) product family of Oracle E-Business Suite, documented in ETRM for releases 12.1.1 and 12.2.2. The object belongs to a module that Oracle has classified as obsolete, and the ETRM metadata records it as "Not implemented in this database," meaning that in a standard installation the physical table is not created. Its documented purpose is to store the outgoing Enrollment units for a student within a Degree Audit Request. In functional terms, the table captures the enrollment unit records that are extracted from the student system and exported to an external degree audit engine, so that an external evaluation of a student's academic progress can be performed against the institution's program requirements.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is satellite-leaning. The table is keyed primarily by an association rather than by a standalone business entity, and it carries a wide set of descriptive, context-bearing attributes. This suggests it is best modeled as a satellite attached to a parent link or hub representing the degree audit request for a student, rather than as an independent hub in its own right.

Key Information Stored

The physical schema documented for 12.1.1 records 88 columns owned by the IGS schema. The primary key is IGS_DA_OUT_UNT_EN_PK, composed of BATCH_ID, PERSON_ID, and UNIT_SEQ_NUM. A unique index, IGS_DA_OUT_UNT_EN_U1, is defined on the identical column set, making it the documented business-key candidate for the row.

Common Use Cases and Queries

The primary use case is extracting a student's enrollment history for transmission to an external degree audit processor. A typical query retrieves all outgoing units for a given batch and person:

SELECT BATCH_ID, PERSON_ID, UNIT_SEQ_NUM, UNIT_CODE, UNIT_TITLE,
      UNIT_GRADE, UNIT_CREDIT_PTS, UNIT_PTS_EARN_ACHIEVED
FROM IGS_DA_OUT_UNT_EN
WHERE BATCH_ID = :batch_id
  AND PERSON_ID = :person_id
ORDER BY UNIT_SEQ_NUM;

Reporting scenarios include totalling earned credit points per student per period, identifying units flagged as repeat attempts, and reconciling achievable against earned points for a batch. Joining to IGS_DA_REQ_STDNTS on BATCH_ID and PERSON_ID restricts the result set to students actually registered within the degree audit request. Because the table is documented as not implemented, any such statement should be validated against the actual installation before deployment.

Related Objects

The documented foreign key relationship is the principal dependency. IGS_DA_OUT_UNT_EN.BATCH_ID and PERSON_ID together reference IGS_DA_REQ_STDNTS, the table holding the degree audit request students. This parent-child relationship means the enrollment units cannot exist without the corresponding request student record. Practically, queries and reports will typically join these two tables, and the parent table should be considered required for any meaningful extraction of the outgoing unit data. Beyond this documented relationship, other objects in the IGS degree audit area — such as incoming unit tables and the batch control records that govern the audit run — form the surrounding context in which this table operates.