Results for “igs_ad_aplins_admreq”

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

Overview

The IGS_AD_APLINS_ADMREQ table is a transactional link object within the IGS – Student System product family in Oracle E-Business Suite (12.1.1 and 12.2.2). It resides in the IGS schema and holds valid, active status within the data dictionary. Its documented purpose is to link student application instances to admission requirement–related tracking types, wherein an application instance combined with a tracking type produces a discrete "tracking item." This makes it a bridge (junction) table that records which admission requirements — expressed as tracking items — apply to a given application.

From a heuristic Data Vault modeling perspective, the relationship data classifies this object as a link. This classification is a modeling suggestion derived from its foreign key structure: the table does not own the core business concepts (applicants or tracking items) but instead associates them. In an EBS operational context, it is a child of the application-instance entity and the tracking-item entity, enabling requirement tracking and compliance workflows tied to admissions processing.

Key Information Stored

Although the documented physical schema lists 15 columns, the most important are the identifiers that define and resolve each link record.

• APLINS_ADMREQ_ID — the surrogate primary key (enforced by IGS_AD_APLINS_ADMREQ_PK and a unique index IGS_AD_APLINS_ADMREQ_U1). It uniquely identifies each link row and carries no business meaning.
• PERSON_ID — the applicant (party) identifier; part of the foreign key to IGS_AD_PS_APPL_INST_ALL and of the business-key unique index IGS_AD_APLINS_ADMREQ_U2.
• ADMISSION_APPL_NUMBER — the admission application number, distinguishing individual applications for a person.
• COURSE_CD — the course code associated with the application instance.
• SEQUENCE_NUMBER — a sequence qualifier that, together with the other key columns, identifies the specific application-instance record.
• TRACKING_ID — the admission-requirement tracking item; foreign key to IGS_TR_ITEM_ALL.
• Standard audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE for concurrency and audit tracking.

The business-key candidate from unique index U2 is the composite of ADMISSION_APPL_NUMBER, COURSE_CD, PERSON_ID, SEQUENCE_NUMBER, and TRACKING_ID — meaning a tracking item is unique per application instance.

Common Use Cases and Queries

Typical reporting asks which admission requirements are tracked against a given applicant or application. A representative query joins to the tracking item master:

• List tracking items for an applicant:

  SELECT a.ADMISSION_APPL_NUMBER, a.TRACKING_ID, t.NAME
FROM IGS.IGS_AD_APLINS_ADMREQ a, IGS.IGS_TR_ITEM_ALL t
WHERE a.TRACKING_ID = t.TRACKING_ID
AND a.PERSON_ID = :p_person_id;

• Locate link rows for a specific application instance by joining on PERSON_ID, ADMISSION_APPL_NUMBER, COURSE_CD, and SEQUENCE_NUMBER back to IGS_AD_PS_APPL_INST_ALL.
• Audit reconciliation using CREATED_BY, CREATION_DATE, and REQUEST_ID to trace concurrent-program inserts and satisfy compliance or data-quality reviews.

Because the table is a pure link, most queries retrieve it only to resolve which requirements attach to which application; updates are typically performed through the Student System application logic rather than direct DML.

Related Objects

• IGS_AD_PS_APPL_INST_ALL — the application-instance parent; joined on PERSON_ID, ADMISSION_APPL_NUMBER, COURSE_CD, and SEQUENCE_NUMBER.
• IGS_TR_ITEM_ALL — the tracking-item master; joined on TRACKING_ID.
• IGS_AD_APLINS_ADMREQ_PK / _U1 / _U2 — the primary and unique constraints backing the keys.
• Application-instance and tracking-item APIs in the IGS schema that create, validate, and delete link records as admission requirements are assigned.

Together these objects form the requirement-tracking subsystem used throughout admissions processing in the Oracle Student System.