Results for “igs_da_out_stdnt_u1”

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

Overview

IGS.IGS_DA_OUT_STDNT is a student-facing interface table within the Oracle E-Business Suite Student System (IGS) schema. It stores outgoing information for students selected in a diploma and awards (DA) request, capturing the mailing address, personal identifiers, matriculation term, and academic advisor details that are staged for downstream processing or output generation. The table resides in the APPS_TS_INTERFACE tablespace and is flagged in the ETRM documentation as obsolete, meaning it is retained for backward compatibility and historical reference rather than for active functional use in Oracle EBS 12.1.1 or 12.2.2. Its structure follows a request-batch pattern, where rows are grouped under a single BATCH_ID representing the originating request.

From a Data Vault modeling perspective, the metadata heuristics classify this object as satellite-leaning. This reflects its role as a descriptive, attribute-bearing structure that hangs off a parent request entity and carries time-stamped, who-column-audited detail rather than acting as a standalone hub or an associative link.

Key Information Stored

The table is uniquely keyed by the composite index IGS_DA_OUT_STDNT_U1 on (BATCH_ID, PERSON_ID), which also serves as the primary key IGS_DA_OUT_STDNT_PK. BATCH_ID is the surrogate identifier for the originating request, and PERSON_ID identifies the selected student. Between them they form the business-key candidate that distinguishes one row from another.

• BATCH_ID – Unique ID for the request; foreign key to IGS_DA_REQ_STDNTS.
• PERSON_ID – Unique identifier for the person (student).
• MAILING_ADDRESS1 – MAILING_ADDRESS4 – Up to four lines of the preferred address, or an optional preferred override address for batch-type requests.
• CITY, STATE, PROVINCE, COUNTRY, POSTAL_CODE – Address components corresponding to the preferred or overridden mailing address.
• PIN – Personal Identification Number, inserted by a user hook.
• MATRICULATION_TERM – The term the student first enrolled in a unit attempt at the local institution, or the term of first enrollment while in a degree-granting program attempt. This is the column most relevant to the search term.
• ADVISOR – Academic counselor associated with the student ID of the request.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN – Standard WHO audit columns.

Common Use Cases and Queries

Because the object is obsolete, its primary practical use is historical reconciliation, data migration validation, and audit of outgoing award or graduation mailings. A typical query retrieves the selected students for a given request batch along with their matriculation term and advisor:

• SELECT person_id, matriculation_term, advisor, city, state, country FROM igs.igs_da_out_stdnt WHERE batch_id = :p_batch_id;
• Reporting on matriculation cohorts: SELECT matriculation_term, COUNT(*) FROM igs.igs_da_out_stdnt GROUP BY matriculation_term;
• Joining to the request parent to validate batch integrity: SELECT o.*, r.* FROM igs.igs_da_out_stdnt o, igs.igs_da_req_stndts r WHERE o.batch_id = r.batch_id;
• Auditing override addresses by comparing MAILING_ADDRESS lines against the master person address.

Related Objects

The principal documented relationship is the foreign key from BATCH_ID to IGS.IGS_DA_REQ_STDNTS, which supplies the request context for each staged student row. OTHER significant dependents include the person master (PER_ALL_PEOPLE_F) joined via PERSON_ID, address sources such as HZ_LOCATIONS or the IGS address structures used to populate MAILING_ADDRESS lines, and the IGS_DA_REQ_STDNTS parent table that anchors the batch. Reporting views built over IGS_DA_OUT_STDNT typically join these tables to reconstruct the full outgoing student record.