Results for “unit_term”

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

Overview

The IGS_DA_DETAILS table is a core storage object within the Oracle E-Business Suite Student System (IGS) product family, holding the detail records that constitute a Degree Audit evaluation. In Oracle EBS 12.1.1 and 12.2.2, the IGS schema governs academic records for institutions running Oracle Student System, and IGS_DA_DETAILS represents the granular level at which individual unit (course) evaluations are persisted against a degree audit run. Each row captures the result of evaluating a specific academic unit against a student's program requirements, including applicability flags, pseudo-unit handling, and audit-specific commentary.

Based on the mined foreign-key structure, the Data Vault classification heuristic suggests this object behaves as a standalone table — it does not sit as a conventional hub, link, or satellite, since no inbound FK chain links it to a broader parent. The PK IGS_DA_DETAILS_PK on DEG_AUD_DETAIL_ID provides unique row identity, and a unique index IGS_DA_DETAILS_U1 defines the same column as the business-key candidate. The table is documented with 65 columns in the ETRM 12.1.1 physical schema under owner IGS.

Key Information Stored

The most significant columns partition into identification, unit evaluation attributes, and audit metadata:

• DEG_AUD_DETAIL_ID — surrogate primary key and unique business-key candidate; the row identifier referenced by child tables.
• OSS_UNIT_LOCATOR, UNIT_CD, UNIT_VERSION — identify the academic unit being audited, including its version context.
• UNIT_LEVEL_CD, UNIT_TERM — the academic level and term to which the unit detail applies.
• UNIT_SEQ_CODE, DA_COUNT, DA_GROUP, DPMASK — sequencing, count, grouping, and DataPump-style masking attributes for the audit row.
• UNIT_PSEUDO_UNIT_FLG, UNIT_EVAL_LOCK — flags controlling pseudo-unit treatment and evaluation locking.
• ALT_UNIT_ID1..3, ALT_UNIT_PSEUDOUNIT_FLAG1..3, UNIT_FLAG1..5 — alternate unit identifiers, their pseudo flags, and general-purpose unit flags.
• DEG_AUD_UNIT_CODE1..12 — degree-audit unit codes used for requirement matching.
• DEG_AUD_COMMENTS — free-text commentary attached to the audit detail.
• REF_INST_ID, REF_INST_CODE, REF_TITLE — reference institution and title for transfer/articulated credit contexts.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1..20 — the standard EBS descriptive flexfield (DFF) columns.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS who-columns for auditing row changes.

Common Use Cases and Queries

Typical uses include degree audit result reporting, transfer-credit articulation tracing, and requirement-satisfaction analysis. A common pattern joins the detail to the standing unit and attempt tables to reconstruct how a unit counted toward a program:

SELECT d.DEG_AUD_DETAIL_ID, d.UNIT_CD, d.UNIT_TERM,
       d.DA_GROUP, d.DEG_AUD_UNIT_CODE1, d.DEG_AUD_COMMENTS
  FROM IGS.IGS_DA_DETAILS d
 WHERE d.UNIT_CD = :unit_code
   AND d.UNIT_TERM = :term;

Reporting scenarios frequently pivot on DA_GROUP and UNIT_FLAG1..5 to summarize which requirements were satisfied, and administrators query DEG_AUD_COMMENTS for advisor-facing notes. DFF-driven analytics query ATTRIBUTE_CATEGORY and the ATTRIBUTE1..20 columns.

Related Objects

The following tables reference the PK column DEG_AUD_DETAIL_ID, forming the dependent record set:

• IGS_EN_SU_ATTEMPT_ALL / IGS_EN_SU_ATTEMPT_H_ALL — student unit attempt rows linked via DEG_AUD_DETAIL_ID, tying attempts to their audit detail.
• IGS_AV_STND_UNIT_ALL / IGS_AV_STND_UNIT_LVL_ALL — standing unit and standing unit level records referencing the audit detail.
• IGS_AD_TERM_UNITDTLS — term unit details joined on DEG_AUD_DETAIL_ID.

These FK relationships confirm IGS_DA_DETAILS as the parent/master for degree audit detail references across attempt and standing-unit tables in the IGS schema.