Search Results igs_ad_stat_int




Overview
Explore in AI Chat

Overview

IGS_AD_STAT_INT is a reporting and integration view belonging to the IGS (Student System) product family within Oracle E-Business Suite. The view exposes records from the student statistics interface staging area, presenting personal, demographic, and status attributes that are staged for processing into the Student System. Because the module is flagged as obsolete in the ETRM documentation, the view is retained for backward compatibility and historical reporting rather than for active functional processing in Oracle EBS 12.1.1 or 12.2.2. The metadata notes that it is "Not implemented in this database," meaning the view may not exist in every environment and its availability depends on whether the IGS Student System schema components were ever deployed.

The view is defined as a thin projection over the underlying interface table, selecting the table's ROWID as ROW_ID together with the full set of interface and descriptive columns. Its principal role is to provide a stable, query-friendly interface for extracting staged student statistics records — including the PLACE_OF_BIRTH column, which was the specific search term that surfaced this object.

Underlying Base Objects

The view text confirms its sole referenced base object:

  • IGS_AD_STAT_INT_ALL — the multi-organization interface table holding staged student statistics records. The view selects all rows from this table and renames the anchor table alias as TAB.

The view is essentially a one-to-one row projection. No joins, unions, or aggregations are present in the documented view text, so row counts and key uniqueness characteristics are inherited directly from IGS_AD_STAT_INT_ALL. The _ALL suffix on the base table indicates an organization-partitioned (multi-org) design, which is why ORG_ID appears as an exposed column and typically participates in the operating unit security model.

Key Columns

Common Use Cases and Queries

Typical usage centers on auditing and troubleshooting staged student statistics data, particularly where place-of-birth or demographic attributes are involved. A representative query filtering on the searched attribute is:

  • SELECT person_id, place_of_birth, marital_status, status, error_code FROM igs_ad_stat_int WHERE place_of_birth IS NOT NULL;
  • SELECT interface_stat_id, interface_id, person_id, status, error_code FROM igs_ad_stat_int WHERE status = 'E' OR error_code IS NOT NULL; — identifies staged rows that failed validation.
  • SELECT org_id, COUNT(*) FROM igs_ad_stat_int GROUP BY org_id; — validates multi-org distribution of staged data.

Because the object is obsolete and not implemented in all databases, queries should first confirm existence via ALL_VIEWS before use, and any production reporting should migrate to the currently supported Student System interface tables.