Results for “program_major_code”

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

Overview

The IGS.IGS_DA_REQ_STDNTS table is a core component of the Oracle E-Business Suite Student System (product family IGS). It stores the roster of students associated with a Degree Audit request, acting as the intersection between a submitted audit request and the individual learners evaluated within that request. Each row represents a single student included in a degree audit processing batch, carrying both identity attributes and the academic configuration used to evaluate that student.

In the documented ETRM 12.1.1 schema the table resides in the IGS schema and contains 20 columns. From a heuristic Data Vault modeling perspective, the table is classified as hub-leaning, which reflects its role as a central anchor around which many downstream result tables cluster. Practically, this means IGS_DA_REQ_STDNTS behaves as the parent record for a family of inbound and outbound degree audit detail tables that all join back to it on BATCH_ID and PERSON_ID.

Key Information Stored

The table's surrogate primary key is IGS_DA_REQ_STDNTS_ID, enforced by the IGS_DA_REQ_STDNTS_PK unique index. No additional business-key unique index is documented other than a system LOB index (SYS_IL0000327366C00014$$), so the surrogate key is the sole uniqueness guarantee.

• IGS_DA_REQ_STDNTS_ID — surrogate primary key, the value most commonly searched by users.
• BATCH_ID — the degree audit request batch to which the student belongs; the principal join key to downstream tables.
• PERSON_ID — the student's person identifier, also used in downstream joins.
• PERSON_NUMBER, ALT_PERSON_NUMBER — student identification numbers.
• LAST_NAME, FIRST_NAME — denormalized student name fields for reporting.
• PROGRAM_CODE, PROGRAM_MAJOR_CODE, MAJOR_UNIT_SET_CD — the academic program context used during evaluation.
• WIF_PROGRAM_CODE, SPECIAL_PROGRAM_CODE — program codes referencing IGS_PS_COURSE.
• WIF_ID — link to the degree audit WIF (What-If) configuration record.
• REPORT_TEXT, ERROR_CODE — captured output and processing error information.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical usage centers on retrieving the students for a given degree audit request, or tracing a student's audit output across the related outbound tables. A common query resolves all students in a batch:

• SELECT IGS_DA_REQ_STDNTS_ID, PERSON_ID, PERSON_NUMBER, LAST_NAME, FIRST_NAME FROM IGS.IGS_DA_REQ_STDNTS WHERE BATCH_ID = :batch_id;
• SELECT * FROM IGS.IGS_DA_REQ_STDNTS WHERE IGS_DA_REQ_STDNTS_ID = :id; — the direct lookup implied by the search term.
• Joining to outbound results, e.g. IGS_DA_REQ_STDNTS s JOIN IGS_DA_OUT_STDNT o ON s.BATCH_ID = o.BATCH_ID AND s.PERSON_ID = o.PERSON_ID, to assemble a complete audit report.
• Filtering on ERROR_CODE to identify students whose audit processing failed.

These patterns support degree audit reporting, batch reconciliation, and reconciliation of inbound source units against evaluated results.

Related Objects

The table anchors a broad set of degree audit tables that reference it on BATCH_ID and PERSON_ID:

• IGS_DA_RQST and IGS_DA_REQ_WIF — parent request/WIF records referenced via BATCH_ID.
• IGS_PS_COURSE — referenced through WIF_PROGRAM_CODE and SPECIAL_PROGRAM_CODE.
• IGS_DA_OUT_STDNT, IGS_DA_OUT_PRG, IGS_DA_OUT_STDT_DEG, IGS_DA_OUT_SPCL_REQ, IGS_DA_OUT_STDT_SPT, IGS_DA_OUT_UNT_AS, IGS_DA_OUT_UNT_EN, IGS_DA_OUT_UNT_AH, IGS_DA_OUT_TSTS, IGS_DA_OUT_USR_DEF — outbound audit result tables keyed on BATCH_ID and PERSON_ID.
• IGS_DA_IN_PRG, IGS_DA_IN_RSLT_UNTS, IGS_DA_IN_SRC_UNTS, IGS_DA_IN_USR_DEF — inbound processing tables sharing the same composite key.
• IGS_DA_REQ_RPTS — report output records linked by BATCH_ID and PERSON_ID.