Search Results igs_ad_batc_def_det




Overview
Explore in AI Chat

Overview

IGS_AD_BATC_DEF_DET is a view within the IGS (Student System) product family of Oracle E-Business Suite, applicable to releases 12.1.1 and 12.2.2. The IGS module is documented as obsolete, meaning it is retained for backward compatibility and reference but is no longer an actively developed component of the EBS application stack. In the ETRM metadata, the object is explicitly flagged as "Not implemented in this database," indicating that the view definition exists as documented metadata but is not deployed in every environment.

Functionally, the view presents admissions batch definition detail records. The "BATC_DEF_DET" naming convention reflects batch definition detail, and the column set confirms this by exposing calendar, admission process, decision, and offer-related attributes. The view serves reporting and integration consumers that require a structured, org-secured projection of admissions batch records without directly accessing the underlying _ALL table.

Underlying Base Objects

The view is defined over a single base object: IGS_AD_BATC_DEF_DET_ALL. This is consistent with the standard Oracle multi-tenant pattern in which an _ALL table stores rows partitioned by ORG_ID, and a corresponding view applies operating unit security using the USERENV('CLIENT_INFO') mechanism. The documented metadata lists no additional referenced base objects beyond this table.

All columns in the view are projected directly from IGS_AD_BATC_DEF_DET_ALL with a TAB alias. The ROWID of the base table row is exposed as ROW_ID, preserving the ability to reference specific physical rows. The view does not perform joins, unions, or aggregations; it is a straight projection with a WHERE clause implementing organization-level row filtering.

Key Columns

Common Use Cases and Queries

The view is typically queried in reporting and integration scenarios where admissions batch detail must be retrieved within the caller's operating unit context. Because the view enforces org security via USERENV('CLIENT_INFO'), results are automatically scoped to the active organization.

To retrieve all batch definitions visible to the current organization:

  • SELECT BATCH_ID, DESCRIPTION, ADMISSION_CAT, DECISION_DATE FROM IGS_AD_BATC_DEF_DET;

To examine admissions decisions with associated offer activity:

  • SELECT BATCH_ID, DECISION_MAKE_ID, DECISION_DATE, OFFER_DT, OFFER_RESPONSE_DT FROM IGS_AD_BATC_DEF_DET WHERE DECISION_DATE IS NOT NULL AND OFFER_DT IS NOT NULL;

To audit recent updates within the organization:

  • SELECT BATCH_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY FROM IGS_AD_BATC_DEF_DET ORDER BY LAST_UPDATE_DATE DESC;

Practitioners should treat this view as read-only reference data, given the obsolete status of the IGS product and the explicit "Not implemented" designation in the ETRM metadata. Any dependency should be validated against the target environment before use in production reporting or interfaces.