Results for “unit_set_earned_cr_pts”

3 results




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

Overview

IGS_DA_IN_USET is a staging and storage table within the Oracle E-Business Suite Student System (IGS) module, which is documented as obsolete in release 12.1.1 and 12.2.2. The table holds incoming Unit Set information received from a third-party degree audit engine on behalf of students associated with a Degree Audit Request. Unit Sets represent collections of related coursework, competencies, or requirements that a student has satisfied, and this table captures the returned evaluation data before or alongside downstream processing within the Degree Audit workflow.

The object is owned by the IGS schema and contains 40 documented columns. It is classified heuristically as satellite-leaning under a Data Vault modeling convention, which suggests it functions as a descriptive, attribute-bearing structure attached to a parent business key rather than as an independent hub or a pure linking table. Its primary dependency is the parent record in IGS_DA_IN_PRG, referenced through the PRGM_SEQ_IN_ID column.

Key Information Stored

The table's primary key, IGS_DA_IN_USET_PK, is a composite surrogate defined over PRGM_SEQ_IN_ID, UNIT_SET_CODE, and UNIT_SET_VERSION. Two unique indexes act as business-key candidates: IGS_DA_IN_USET_U1 mirrors the primary key columns, while IGS_DA_IN_USET_U2 provides a broader natural key spanning BATCH_ID, PERSON_ID, PROG_CODE, PROG_VERSION, UNIT_SET_CODE, and UNIT_SET_VERSION. The most significant columns include:

Common Use Cases and Queries

Typical usage centers on reconciling inbound degree audit responses and reporting student progress against Unit Set requirements. A common pattern joins the table back to its parent program record and filters by batch or student:

  • Retrieving all Unit Set evaluations for a given student: SELECT * FROM IGS_DA_IN_USET WHERE PERSON_ID = :person_id;
  • Joining to the parent program: SELECT u.*, p.* FROM IGS_DA_IN_USET u JOIN IGS_DA_IN_PRG p ON u.PRGM_SEQ_IN_ID = p.PRGM_SEQ_IN_ID;
  • Auditing a specific inbound transmission: SELECT * FROM IGS_DA_IN_USET WHERE BATCH_ID = :batch_id;
  • Identifying completed Unit Sets: SELECT UNIT_SET_CODE, UNIT_SET_EARNED_CR_PTS FROM IGS_DA_IN_USET WHERE UNIT_SET_COMPL_IND = 'Y';

Reporting use cases include credit-point aggregation, completion tracking, and GPA reconciliation across programs and batches.

Related Objects

The most significant related object is the parent table referenced by the documented foreign key:

  • IGS_DA_IN_PRG — referenced via IGS_DA_IN_USET.PRGM_SEQ_IN_ID, the parent inbound program record.

Additional dependencies implied by the schema include the Student System person and program reference tables (via PERSON_ID, PROG_CODE, and PROG_VERSION) and the batch tracking structures implied by BATCH_ID. Because the object is documented as not implemented in the reference database and the module is obsolete, these relationships should be verified against the target instance's actual schema before use.