Search Results igs_ad_other_inst




Overview
Explore in AI Chat

Overview

IGS_AD_OTHER_INST is a table in the IGS (Student System) product schema within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores details about the other institutions to which an applicant has applied, capturing the applicant's competing or alternate admissions activity alongside the institution's own admissions records. In an EBS deployment running the Student System module, this table supports admissions processing, applicant tracking, and downstream reporting on applicant behavior across multiple institutions.

Heuristic Data Vault classification mined from the foreign-key structure identifies this object as standalone. As a modeling suggestion, this indicates the table does not participate in a documented parent-child FK network at the physical layer and could be treated as a source for a hub or satellite construct, with the primary key acting as the business key candidate in a Data Vault model.

Key Information Stored

The table is documented with 16 columns in the ETRM 12.1.1 physical schema. The most significant include:

Common Use Cases and Queries

Typical usage centers on admissions reporting and applicant analysis: listing all other institutions an applicant has applied to, identifying applicants with competing admission applications, and reporting on nominated courses across external institutions. A common query pattern joins on the person and application identifiers:

  • Retrieve other-institution records for an applicant: SELECT * FROM igs_ad_other_inst WHERE person_id = :person_id ORDER BY sequence_number;
  • Filter by institution: SELECT person_id, admission_appl_number, institution_code FROM igs_ad_other_inst WHERE institution_code = :institution_code;
  • Link to program applications: SELECT a.other_inst_id, a.person_id, a.program_application_id FROM igs_ad_other_inst a WHERE a.program_application_id IS NOT NULL;
  • Audit recent changes: SELECT other_inst_id, last_updated_by, last_update_date FROM igs_ad_other_inst WHERE last_update_date > SYSDATE - 30;

Related Objects

The ETRM metadata classifies this table as standalone, so no parent-child foreign keys are documented. Logical relationships inferred from identical key columns and standard IGS conventions include the following, joined on the columns named:

  • IGS_AD_APPL — admissions application header, joined via ADMISSION_APPL_NUMBER and PERSON_ID.
  • IGS_AD_PROGRAM_APPL — program application details, joined via PROGRAM_APPLICATION_ID.
  • IGS_AD_PROGRAM — program definition, joined via PROGRAM_ID.
  • HZ_PARTIES / PER_PEOPLE_F — person identity, joined via PERSON_ID.
  • IGS_AD_INSTITUTION — institution reference, joined via INSTITUTION_CODE.
  • IGS_AD_OTHER_INST_PK / U1 — constraints defining the primary key and unique business key on OTHER_INST_ID.