Search Results ref_inst_code

Overview

IGS_DA_OUT_AUDT_DTL is a legacy Oracle EBS table belonging to the IGS (Student System) product family, a module that is now obsolete in EBS releases 12.1.1 and 12.2.2. The table stores detail-level records for the Degree Audit output process, specifically the individual units (courses, requirements, or pseudo-units) identified for a student during a Degree Audit Request. When a degree audit is executed, the system resolves which academic units satisfy, fail, or remain pending against a student's program requirements, and the resulting per-unit details are persisted in this table for subsequent review, reporting, and audit trail purposes.

The ETRM metadata classifies this object, via a heuristic data-vault analysis of its foreign-key structure, as standalone — meaning it is modeled as neither a hub, link, nor satellite in a strict data-vault sense. This should be read as a modeling suggestion only: the table aggregates both identifying business keys and descriptive attributes in a single structure, so a formal data-vault redesign would likely decompose it into a hub keyed on the audit request/student/unit combination and one or more satellites carrying the descriptive audit flags and comments. The metadata states plainly that the object is "Not implemented in this database" for the current release, so it should be treated as an archived or historical definition rather than an actively instantiated physical table.

Key Information Stored

The table is defined with 42 documented columns. The most significant are the following:

• BATCH_ID — identifier for the batch of the degree audit request run; part of the composite primary key.
• PERSON_ID — the student (person) for whom the audit was produced; part of the primary key.
• UNIT_SEQ_NUM — the sequential number of the unit within the audit output; part of the primary key and the column the user searched for.
• OSS_UNIT_LOCATOR — the locator that identifies the specific unit (often sourced from an external degree-audit engine); part of the primary key.
• UNIT_SEQ_CODE — code qualifying the unit sequence entry.
• DA_COUNT — count value associated with the degree-audit unit tally.
• UNIT_PSEUDO_UNIT_FLG — flag indicating whether the unit is a pseudo-unit rather than a real course.
• UNIT_EVAL_LOCK — lock/evaluation indicator controlling whether the unit result can be re-evaluated.
• DA_GROUP — the degree-audit requirement group to which the unit belongs.
• DPMASK — mask value used in the audit evaluation logic.
• ALT_UNIT_ID1 / ALT_UNIT_ID2 / ALT_UNIT_ID3 — alternate unit identifiers and their corresponding ALT_UNIT_PSEUDOUNIT_FLAG1/2/3 flags.
• UNIT_FLAG1 through UNIT_FLAG5 — general-purpose status flags for the unit record.
• DEG_AUD_UNIT_CODE1 through DEG_AUD_UNIT_CODE12 — a repeating set of twelve degree-audit unit codes capturing the detailed outcome codes for the unit.
• DEG_AUD_COMMENTS — free-text comments recorded against the unit result.
• REF_INST_ID, REF_INST_CODE, REF_TITLE — reference institution and title information for the unit.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit-who columns.

The surrogate primary key is IGS_DA_OUT_AUDT_DTL_PK, defined over (BATCH_ID, PERSON_ID, UNIT_SEQ_NUM, OSS_UNIT_LOCATOR). The unique index IGS_DA_OUT_AUDT_DTL_U1 carries the identical column set, so the business key and the primary key coincide here; there is no separate surrogate column beyond the composite key. UNIT_SEQ_NUM therefore serves both as part of the row identity and as an ordering mechanism within a given student/batch.

Common Use Cases and Queries

The principal use case is reconstructing the degree-audit result for a student — determining which units were applied to which requirement groups at the time the audit ran. Because UNIT_SEQ_NUM orders the detail rows, it is central to any query that lists units in audit order.

• Retrieve all units for a student's audit: SELECT unit_seq_num, oss_unit_locator, da_group, deg_aud_comments FROM igs_da_out_audt_dtl WHERE batch_id = :batch_id AND person_id = :person_id ORDER BY unit_seq_num;
• Identify pseudo-units: SELECT * FROM igs_da_out_audt_dtl WHERE unit_pseudo_unit_flg = 'Y';
• Find units pending or locked evaluation: filter on UNIT_EVAL_LOCK to surface units withheld from re-evaluation.
• Reporting: join on BATCH_ID and PERSON_ID to correlate with the parent degree-audit request header, and group by DA_GROUP to summarize requirement-group coverage.

Note that since the object is not implemented in the current release, these queries apply to historical or upgraded instances where the table persists.

Related Objects

Given the heuristic "standalone" classification and the absence of enforced foreign keys in the metadata, the following relationships are inferred from the key columns rather than documented FK constraints:

• Degree Audit Request header — the parent object supplying BATCH_ID and PERSON_ID; joins on (BATCH_ID, PERSON_ID).
• IGS_DA_OUT_AUDT master/output tables — related degree-audit output storage sharing the same batch and student keying.
• Person/student records (PER_ALL_PEOPLE_F) — linked via PERSON_ID.
• Unit/course catalog views — resolved via OSS_UNIT_LOCATOR and ALT_UNIT_ID1/2/3.
• Institution reference tables — resolved via REF_INST_ID and REF_INST_CODE.

Because the table is obsolete in EBS 12.1.1 and 12.2.2, implementers should confirm its presence before relying on it and treat the definition as historical reference material.