Results for “mailing_address1”

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

Overview

IGS_DA_OUT_STDNT is a transactional table within the Oracle E-Business Suite IGS (Student System) product module. It stores the specific outgoing information for a Student that is captured during a Degree Audit Request. In practical terms, the table acts as a staging and persistence layer for student-level data that the degree audit process extracts, formats, or transmits — for example, mailing address details and academic context that must accompany a degree audit output. The object resides in the IGS schema and carries a VALID status in the ETRM 12.1.1 physical schema documentation, with 19 documented columns.

From a heuristic Data Vault modeling perspective, the mined relationship structure classifies IGS_DA_OUT_STDNT as satellite-leaning. This classification is best treated as a design suggestion rather than a definitional fact: the combination of a composite primary key and a foreign key back to IGS_DA_REQ_STDNTS indicates that the table records descriptive, context-dependent attributes about a request-and-person combination rather than acting as an independent hub of business entities. In a formal Data Vault design, this pattern corresponds to a satellite hanging off a link between the degree audit request and the student.

Key Information Stored

The primary key of the table is IGS_DA_OUT_STDNT_PK, defined over the composite of BATCH_ID and PERSON_ID. A unique index, IGS_DA_OUT_STDNT_U1, mirrors these same two columns, making them the documented business-key candidates. BATCH_ID identifies the degree audit processing batch or request grouping, while PERSON_ID identifies the student. Neither column is a system-generated surrogate in the single-column sense; the composite key serves the identification role.

• BATCH_ID — Grouping identifier for the degree audit batch; also the foreign key column referencing IGS_DA_REQ_STDNTS.
• PERSON_ID — The student for whom outgoing degree audit information is stored.
• MAILING_ADDRESS1 through MAILING_ADDRESS4 — Four free-form address lines captured for outgoing correspondence or printed output.
• CITY, STATE, PROVINCE, COUNTRY, POSTAL_CODE — Geographic address components supporting domestic and international address formats.
• PIN — Postal or alternate identification code associated with the student record.
• MATRICULATION_TERM — The term in which the student matriculated, providing academic standing context for the audit.
• ADVISOR — Advisor information carried on the outgoing student record.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording who created and last modified each row.

Common Use Cases and Queries

The table is queried primarily to assemble address and academic context for degree audit output and to reconcile what was transmitted for a given batch. Typical reporting includes verifying outgoing student records per batch and auditing address completeness before degree audit correspondence is generated.

Retrieve all outgoing records for a specific batch:

• SELECT PERSON_ID, CITY, STATE, COUNTRY, POSTAL_CODE, MATRICULATION_TERM, ADVISOR FROM IGS_DA_OUT_STDNT WHERE BATCH_ID = :batch_id;

Join to the request-student table to validate identity, using the documented foreign key path:

• SELECT o.PERSON_ID, o.MAILING_ADDRESS1, o.CITY, r.* FROM IGS_DA_OUT_STDNT o, IGS_DA_REQ_STDNTS r WHERE o.BATCH_ID = r.BATCH_ID AND o.PERSON_ID = r.PERSON_ID;

Detect records with missing address data for cleanup before an audit run:

• SELECT BATCH_ID, PERSON_ID FROM IGS_DA_OUT_STDNT WHERE POSTAL_CODE IS NULL OR CITY IS NULL;

Related Objects

The most significant relationship is the foreign key from IGS_DA_OUT_STDNT to IGS_DA_REQ_STDNTS on BATCH_ID, with PERSON_ID participating in the composite join. This parent table holds the degree audit request-student records that drive which students are included in a batch.

• IGS_DA_REQ_STDNTS — Parent table referenced by the documented foreign key; join on BATCH_ID (and PERSON_ID).
• IGS_DA_OUT_STDNT_PK — Primary key constraint over BATCH_ID, PERSON_ID.
• IGS_DA_OUT_STDNT_U1 — Unique index over BATCH_ID, PERSON_ID; business-key candidate.

Additional degree audit request and batch objects in the IGS schema, together with the PERSON_ID-keyed person and address entities elsewhere in the Student System, are typical downstream dependents; the documented metadata confirms IGS_DA_REQ_STDNTS as the authoritative parent reference.