Results for “igs_da_out_stdt_deg”

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

Overview

IGS_DA_OUT_STDT_DEG is a table within the IGS – Student System product module of Oracle E-Business Suite, owned by the IGS schema. It stores the outgoing degree information for a student as captured within a Degree Audit Request. In functional terms, the table acts as the persisted output layer for a degree audit run: when a Degree Audit Request is processed, the system writes each student's degree-related data into this table so that downstream consumers — reports, self-service pages, and integration feeds — can retrieve the audit results without recomputing them.

The table is documented with 12 columns in the ETRM 12.1.1 physical schema catalog and is marked VALID in the 12.1.1 / 12.2.2 reference environment. Its Data Vault classification, mined heuristically from the foreign-key structure, is satellite-leaning. This is a modeling suggestion rather than a product-declared attribute: the table carries descriptive, request-scoped attributes attached to a parent request context, and the primary key is a composite rather than a single surrogate identifier. In a Data Vault model, this pattern maps most naturally to a satellite hanging off the Degree Audit Request hub, keyed by the parent's business key plus a sequence discriminator.

Key Information Stored

The primary key is IGS_DA_OUT_STDT_DEG_PK, defined over BATCH_ID, PERSON_ID, and DEGREE_SEQ_NUM. These three columns form the row's unique identity and are also the columns published through the unique index IGS_DA_OUT_STDT_DEG_U1, which serves as the business-key candidate for the table. Because the primary key and the unique index share the same column list, the business key and the physical key are effectively identical here.

• BATCH_ID — identifies the Degree Audit batch/request run under which the row was produced; foreign key to IGS_DA_REQ_STDNTS.
• PERSON_ID — the student (person) for whom the degree information applies; part of the composite key and the join to the request student record.
• DEGREE_SEQ_NUM — sequence number that distinguishes multiple degree entries for the same student within a batch.
• PRIOR_ATTMPT_DEGREE — the prior degree attempted by the student, as carried into the audit output.
• PRIOR_DEGREE_EARNED — indicator/value describing the prior degree actually earned.
• PRIOR_DEGREE_INST — the institution associated with the prior degree.
• PRIOR_DEGREE_INST_NAME — descriptive name of that prior degree institution, stored denormalized for reporting convenience.
• AUDIT columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard Oracle EBS who-did-what auditability.

Common Use Cases and Queries

The principal use case is reporting on prior-degree data captured during a degree audit. Advisors and registrars typically query this table by person and batch to determine what prior degrees a student has declared. A representative query joins to the parent request table on the composite key:

• SELECT d.PERSON_ID, d.DEGREE_SEQ_NUM, d.PRIOR_DEGREE_EARNED, d.PRIOR_DEGREE_INST_NAME FROM IGS.IGS_DA_OUT_STDT_DEG d WHERE d.BATCH_ID = :batch_id AND d.PERSON_ID = :person_id ORDER BY d.DEGREE_SEQ_NUM;
• Batch reconciliation: count rows per BATCH_ID to validate that the audit output equals the number of student request records.
• Integration extracts: pull all rows for a completed BATCH_ID to feed external advising or transcript systems, filtering on LAST_UPDATE_DATE for incremental loads.
• Because the table holds outgoing results only, it should be treated as read-mostly; refresh typically occurs by re-running the Degree Audit process for a batch rather than by direct DML.

Related Objects

The documented foreign-key relationship anchors this table to the Degree Audit request-student parent. The most significant related objects are:

• IGS_DA_REQ_STDNTS — parent table; referenced by IGS_DA_OUT_STDT_DEG.BATCH_ID and PERSON_ID. This is the primary join path for any query requiring request context.
• IGS_DA_REQ_STDNTS primary key — the FK target that enforces referential integrity for the outgoing rows.
• IGS_DA_OUT_STDT_DEG_PK / _U1 — the primary key constraint and unique index, both on (BATCH_ID, PERSON_ID, DEGREE_SEQ_NUM), which govern row uniqueness and drive index access paths.
• Degree Audit Request / batch objects in the IGS_DA_% namespace — the wider family of tables that write into and read from this output table during audit processing.
• Student/person reference objects — PERSON_ID resolves to the standard person records used throughout the Student System, enabling joins to student and person views for name and identifier display.