Results for “igs_ad_basis_for_ad”

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

Overview

IGS_AD_BASIS_FOR_AD is a reference (lookup) table within the Oracle E-Business Suite IGS — Student System product family. It describes the user-defined basis for admissions that may be recorded against an application for admission to an academic program. In practice, each row defines a valid category — for example, "Qualifying Examination," "Prior Degree," "Transfer Credit," or "Mature Entry" — that an admissions officer can associate with an applicant when evaluating eligibility for a program.

The object is flagged as Obsolete in the ETRM documentation, and is reported as "Not implemented in this database." Consequently, this table is present in the documented physical schema for Oracle EBS 12.1.1 but is not expected to hold data or exist as a populated object in a 12.2.2 instance where the module has been retired or replaced. Its documented owner is the IGS schema and it carries 9 physical columns.

Based on the foreign key topology supplied in the metadata, a heuristic Data Vault classification of hub-leaning is appropriate: the table is keyed by a business code and is referenced by downstream transactional or attribute-bearing tables, making it a natural candidate for a hub with a small accompanying satellite holding descriptive attributes such as DESCRIPTION and CLOSED_IND. This is a modeling suggestion only, derived from the FK structure.

Key Information Stored

The table is a compact code/description construct. The most significant columns are:

• BASIS_FOR_ADMISSION_TYPE — the unique business identifier for the basis-for-admission category. It is both the primary key column (via IGS_AD_BASIS_FOR_AD_PK) and the single-column unique index IGS_AD_BASIS_FOR_AD_U1, making it the definitive business-key candidate.
• DESCRIPTION — the human-readable name or long description of the basis, displayed to admissions users and printed on reports.
• GOVT_BASIS_FOR_ADM_TYPE — an optional linkage to the governmental or statutory equivalent basis type, used where regulatory reporting requires an official code rather than the locally defined value.
• CLOSED_IND — a status flag indicating whether the basis code is still selectable or has been end-dated; closed values typically remain for historical reporting but are hidden from new entry.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS WHO audit columns, capturing the creating user and date, the most recent modifying user and date, and the login session identifier of the last change.

The surrogate nature of the primary key should be noted: BASIS_FOR_ADMISSION_TYPE functions as a meaningful business code rather than a system-generated number, which is characteristic of EBS setup/reference tables.

Common Use Cases and Queries

Because the table is a lookup, its principle use is to populate and validate lists of values and to support admissions reporting. A typical validation query retrieves only active bases:

SELECT basis_for_admission_type, description
  FROM igs_ad_basis_for_ad
 WHERE NVL(closed_ind, 'N') = 'N'
 ORDER BY description;

A reporting query joins the table to the applicant application table to tally applications by basis of admission:

SELECT b.description, COUNT(*) applications
  FROM igs_ad_ps_appl_all a,
       igs_ad_basis_for_ad  b
 WHERE a.basis_for_admission_type = b.basis_for_admission_type
 GROUP BY b.description
 ORDER BY applications DESC;

Where statutory reporting is required, joining through GOVT_BASIS_FOR_ADM_TYPE to IGS_AD_GOV_BAS_FR_TY maps local bases to government codes. Users should be aware that on 12.2.2 and any environment where the table is not implemented, these queries will fail with ORA-00942 and the equivalent functionality must be sourced elsewhere.

Related Objects

The metadata documents the following relationships, each keyed on the same business code:

• IGS_AD_PS_APPL_ALL — the person/program application table; its column BASIS_FOR_ADMISSION_TYPE references this table, so every application's recorded basis must exist as a row here. This is the primary transactional consumer.
• IGS_AD_CD — holds additional admissions code data keyed by BASIS_FOR_ADMISSION_TYPE, referencing this table as the parent for code-related attributes.
• IGS_AD_GOV_BAS_FR_TY — the governmental basis-for-admission type reference; this table's GOVT_BASIS_FOR_ADM_TYPE column points to it, forming the mapping between local and statutory classifications.

Together these define the table as a small but structurally central lookup: one inbound dependency (government type) and two outbound dependents (applications and admissions code detail), consistent with its hub-leaning classification.