Results for “igs_ad_other_inst_pk”

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

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:

• OTHER_INST_ID — surrogate primary key, defined by index IGS_AD_OTHER_INST_PK. The unique index IGS_AD_OTHER_INST_U1 on the same column identifies it as the business-key candidate.
• PERSON_ID — identifies the applicant (person) associated with the other-institution record.
• ADMISSION_APPL_NUMBER — the admissions application number linking the record to the applicant's admission application context.
• SEQUENCE_NUMBER — orders multiple other-institution entries for the same applicant.
• INSTITUTION_CODE — code identifying the external institution to which the applicant applied.
• NEW_INSTITUTION — indicates the institution is new or previously unrecorded in the system.
• NOMINATED_COURSE_CD — the course code nominated or selected at the other institution.
• PROGRAM_APPLICATION_ID — links the record to the applicant's program application.
• PROGRAM_ID — identifies the program associated with the application.
• PROGRAM_UPDATE_DATE — date the program-related information was last updated.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID — standard EBS audit and concurrent-request columns tracking record creation, modification, and the originating concurrent request.

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.