Results for “transcript_source”

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

Overview

IGS_DA_OUT_UNT_AH is a transactional table in the IGS (Student System) product schema of Oracle E-Business Suite, documented as valid in both 12.1.1 and 12.2.2. Its documented purpose is the storage of all outgoing Academic History for a student referenced within a Degree Audit Request. In practical terms, the table holds the external transcript/unit-credit detail that the institution transmits outward — for example to another institution, a transfer articulation service, or a SPEEDE/EDI exchange — as part of a degree audit processing cycle. It is therefore an outbound staging and audit structure rather than an operational student record: rows represent individual academic-history units belonging to a specific student and a specific degree audit batch.

From a dimensional modeling perspective, the mined relationship metadata suggests a satellite-leaning classification. The table is keyed by a composite of BATCH_ID, PERSON_ID and UNIT_SEQ_NUM, and its single documented foreign key points back to IGS_DA_REQ_STDNTS on BATCH_ID and PERSON_ID, which behaves as a parent/context reference rather than an independent business entity. Analysts should treat this as a descriptive satellite hanging off the degree audit request/student context, with the batch identifier supplying the effective grouping.

Key Information Stored

The table is documented with 33 columns and a single unique index, IGS_DA_OUT_UNT_AH_U1, defined on (BATCH_ID, PERSON_ID, UNIT_SEQ_NUM). This composite is both the declared primary key (enforced through IGS_DA_OUT_UNT_AH_PK) and the business-key candidate — there is no separate meaningless surrogate column, so the natural key and the primary key coincide.

• BATCH_ID, PERSON_ID, UNIT_SEQ_NUM — the composite identifier linking each outgoing unit to a degree audit batch, a student, and a sequence position within that student's extract.
• HOME_INST_ID, HOME_INST_ALT_ID — the owning institution and an alternate identifier for it.
• UNIT_INSTITUTION_ID, ALT_INSTITUTION_ID, INSTITUTION_TYPE, INSTITUTION_TITLE — the institution that awarded the unit, including descriptive title and classification.
• CURR_INSTITUTION_IND — flag indicating whether the institution is the current one.
• TRANSCRIPT_SOURCE, TRANSCRIPT_STATUS — origin and processing status of the transcript line.
• TERM_PERIOD, TRANS_DETAIL_TERM_TYPE — the academic period and its term-type classification.
• SRC_UNIT_CODE, SOURCE_UNIT_TITLE — the source course/unit code and title as received or defined.
• UNIT_GRADE, UNIT_DIFFICULTY — grade awarded and unit difficulty/level.
• UNIT_CREDIT_SIGN, UNIT_CREDIT_PTS, UNIT_PTS_EARN_ACHVE, QUALITY_PTS_EARNED — credit direction, attempted credit points, earned/achieved points, and quality points used in GPA-style calculations.
• SPEEDE_HONORS, SPEEDE_BACC, SPEEDE_REPEATF, SPEEDE_AGCLC, SPEEDE_GRADEQ, SPEEDE_ACTC — SPEEDE/EDI qualifier flags carrying honors, baccalaureate, repeat, accelerated-learning, grade-qualifier and action codes.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle WHO audit columns for row provenance.

Common Use Cases and Queries

Typical usage centres on degree audit extraction and outbound transcript reporting. A frequent pattern retrieves all outgoing units for a batch:

• Batch reproduction: SELECT * FROM igs.igs_da_out_unt_ah WHERE batch_id = :batch_id ORDER BY person_id, unit_seq_num;
• Student-level history: filter on BATCH_ID and PERSON_ID to reconstruct a single student's transmitted academic history.
• Credit aggregation for GPA or articulation checks, summing UNIT_PTS_EARN_ACHVE and QUALITY_PTS_EARNED grouped by PERSON_ID.
• Institution-level analysis of transfer volume using UNIT_INSTITUTION_ID and INSTITUTION_TYPE.
• SPEEDE exchange monitoring, filtering on TRANSCRIPT_STATUS and the SPEEDE_* qualifier flags to identify records pending or rejected transmission.
• Error/exception reporting, comparing TRANSCRIPT_SOURCE against expected values and reviewing LAST_UPDATE_DATE for stale extracts.

Related Objects

The documented foreign key relationship ties this table to the degree audit request-student context, which is the primary parent object:

• IGS_DA_REQ_STDNTS — joined on BATCH_ID and PERSON_ID; supplies the degree audit request and student context for each outgoing unit.
• IGS_DA_REQ_... family of degree audit request tables (request headers, batch definitions) — reached through the batch identifier.
• Student records (IGS/STUDENT-related person tables) — PERSON_ID resolves to the person/student entity.
• Institution tables — HOME_INST_ID, UNIT_INSTITUTION_ID and ALT_INSTITUTION_ID resolve to institution reference data.
• Term/period reference tables — TERM_PERIOD and TRANS_DETAIL_TERM_TYPE resolve to academic period validation.
• SPEEDE/EDI processing objects — the SPEEDE_* qualifier columns support outbound transcript exchange processing.

No public API is documented for this table in the supplied metadata; it is typically populated by degree audit extraction concurrent programs rather than through direct DML.