Results for “igs_da_in_rslt_unts_u1”

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

Overview

IGS.IGS_DA_IN_RSLT_UNTS is a Degree Audit (DA) inbound staging table in the Oracle E-Business Suite Student Systems (IGS) schema. It stores resulting unit information returned from a third-party degree audit engine for students referenced in a degree audit request. The table captures the transfer evaluation result units — the equivalent units granted toward program requirements — that the external software generates and returns to Oracle EBS for a given student. The ETRM metadata explicitly annotates this object as obsolete, meaning it is retained for historical completeness and backward compatibility but is not the target of new development in 12.1.1 or 12.2.2.

Heuristic Data Vault classification derived from the foreign-key structure suggests this is a satellite-leaning entity. Its single outbound foreign key (BATCH_ID to IGS_DA_REQ_STDNTS) and its descriptive, attribute-rich column set — codes, titles, credits, grades, and filter values — are characteristic of a satellite attached to a degree audit request/student hub-link, rather than an independent business hub.

Key Information Stored

The table is physically documented with 51 columns in APPS_TS_TX_DATA. The most operationally significant are:

• RSLT_UNIT_ID — the surrogate primary key (IGS_DA_IN_RSLT_UNTS_PK and unique index IGS_DA_IN_RSLT_UNTS_U1). It is a sequence number generated by the third-party software that links a result unit record to the correct result unit produced by that software.
• BATCH_ID — unique identifier for the degree audit request, and the documented foreign key to IGS_DA_REQ_STDNTS. Indexed by IGS_DA_IN_RSLT_UNTS_N1 together with PERSON_ID.
• PERSON_ID — unique identifier for the student person record.
• RESLT_UNIT_GROUP / RESLT_UNIT_DPMASK — grouping and degree program filter values assigned by the third party, used to link transfer evaluation source units to result units and later stored on degree audit details linked to Advanced Standing.
• RESLT_UNIT_INST_ID / RESLT_UNIT_ALT_INST_ID — institution and alternate institution identifiers where the result units are to be applied toward program requirements.
• RESLT_UNIT_CODE / RESLT_UNIT_CODE_VERSION / RESLT_UNIT_TITLE — the third-party code, version, and title of the result unit.
• RESLT_UNIT_EARNED_CRED, RESLT_UNIT_GRADE, RESLT_UNIT_GPA_PTS, RESLT_UNIT_QUAL_PTS_EARNED, RESLT_UNIT_COUNT — quantitative outcome values. RESLT_UNIT_QUAL_PTS_EARNED, the column associated with the user's original search term, holds the quality points earned for the result unit.
• RESLT_UNIT_LEVEL / RESLT_UNIT_LEVEL_TITLE / RESLT_UNIT_TEACH_PERIOD — academic level and teaching period context.
• RESLT_UNIT_PSEUDO_FLAG, RESLT_ALT_UNIT_ID1-3, RESLT_UNIT_FLAG1-5, RESLT_DA_UNIT_CODE1-12 — extensible third-party-supplied flags, alternate unit identifiers, and DA unit codes.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Because the table is obsolete, primary usage centers on historical reporting and reconciliation of prior degree audit runs. Typical patterns join the result units back to the request/student staging row and forward to the resulting degree audit details:

• Retrieve all result units for a given student's audit request, ordered by the third-party sequence:

SELECT r.RSLT_UNIT_ID, r.RESLT_UNIT_CODE, r.RESLT_UNIT_TITLE,
       r.RESLT_UNIT_EARNED_CRED, r.RESLT_UNIT_GRADE,
       r.RESLT_UNIT_QUAL_PTS_EARNED
  FROM   IGS.IGS_DA_IN_RSLT_UNTS r
 WHERE   r.PERSON_ID = :person_id
   AND   r.BATCH_ID  = :batch_id
 ORDER BY r.RSLT_UNIT_ID;

• Aggregate quality and GPA points earned per batch to validate the third-party transfer evaluation outcome.
• Reconcile result units against Advanced Standing degree audit details using RESLT_UNIT_GROUP and RESLT_UNIT_DPMASK as the matching keys.
• Report institution-level credit granted using RESLT_UNIT_INST_ID and RESLT_UNIT_ALT_INST_ID filters.

Queries should rely on the unique index on RSLT_UNIT_ID and the composite nonunique index on (BATCH_ID, PERSON_ID) to avoid full table scans on large historical volumes.

Related Objects

• IGS.IGS_DA_REQ_STDNTS — parent staging table referenced through BATCH_ID; the documented foreign key (IGS_DA_IN_RSLT_UNTS.BATCH_ID → IGS_DA_REQ_STDNTS).
• IGS Person tables (PER_ALL_PEOPLE_F / IGS_PE_PERSON) — joined via PERSON_ID to resolve student identity and demographics.
• Degree audit detail tables associated with Advanced Standing — the documented destination for RESLT_UNIT_GROUP and RESLT_UNIT_DPMASK values, used to link source and result units.
• Transfer evaluation source-unit staging tables — the counterpart structures linked to these result units through the group and degree program mask values.
• IGS_DA_IN_RSLT_UNTS_U1 / _N1 indexes — the unique (RSLT_UNIT_ID) and nonunique (BATCH_ID, PERSON_ID) indexes supporting the table's access paths.

No API layer is documented for this object; integration is achieved by writing staging rows from the third-party degree audit output and consuming them through concurrent programs that populate the downstream degree audit and Advanced Standing records.