Search Results igs_ad_stat_int_all




Overview
Explore in AI Chat

Overview

IGS_AD_STAT_INT_ALL is an interface staging table within the Oracle E-Business Suite IGS (Student System) product family. As its name implies—IGS_AD_STAT_INT_ALL—it serves as an open-interface repository that "Holds person's statistics records," functioning as a temporary landing zone where external statistics data is loaded before validation and transfer into the production student records schema. The table is part of the Admissions (AD) functional area and carries population-specific attributes such as ethnicity, marital status, religion, and criminal/academic history flags that are typically collected during the admissions lifecycle.

According to the ETRM documentation, this object is marked as Obsolete and is not implemented in the current reference database, which indicates that the interface was superseded in later IGS releases but is still documented for upgrade and migration purposes. The primary key is defined as the IGS_AD_STAT_INT_PK constraint on the INTERFACE_STAT_ID column. Under a heuristic Data Vault classification mined from the foreign key structure, this table leans toward a satellite model, since it describes descriptive attributes associated with a person (hub) rather than acting as an independent hub or a pure associative link. This classification is offered as a modeling suggestion only; in the operational EBS context the object is best understood as a transitional interface table.

Key Information Stored

The documented physical schema contains 48 columns. The most significant are:

  • INTERFACE_STAT_ID – Surrogate primary key (IGS_AD_STAT_INT_PK), uniquely identifying each interface statistics row.
  • PERSON_ID – Foreign key to HZ_PARTIES, linking the statistics record to the person/party it describes.
  • INTERFACE_ID – Identifier of the interface batch or process context for the row.
  • INTERFACE_RUN_ID – Reference to the specific interface run in which the row was processed.
  • ORG_ID – Operating unit context, supporting multi-org data separation.
  • ETHNIC_ORIGIN – Ethnicity classification for the person.
  • MARITAL_STATUS and MARITAL_STATUS_EFFECTIVE_DATE – Marital status value and its effective date.
  • PLACE_OF_BIRTH and COUNTRY_CD3 – Birth location and three-character country code.
  • RELIGION_CD – Religious affiliation code.
  • CRIMINAL_CONVICT, ACAD_DISMISSAL, NON_ACAD_DISMISSAL – Disclosure flags relating to conduct and prior academic standing.
  • STATUS and MATCH_IND – Processing state and person-match indicator used during validation.
  • ERROR_CODE – Diagnostic code populated when the row fails validation.
  • RESID_STAT_ID – Reference to the resident statistics record this row represents.

The 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 provide standard EBS audit and concurrent-program tracking. Twenty ATTRIBUTE (1–20) columns and ATTRIBUTE_CATEGORY support extensible descriptive flexfield data.

Common Use Cases and Queries

Typical usage centers on loading, validating, and reconciling external statistics feeds. A common query identifies unprocessed rows for a given interface run:

SELECT ist.interface_stat_id, ist.person_id, ist.status, ist.error_code
FROM   igs_ad_stat_int_all ist
WHERE  ist.interface_run_id = :run_id
AND    NVL(ist.status,'PENDING') = 'PENDING';

Joining to HZ_PARTIES confirms that each statistics row resolves to a valid party:

SELECT p.party_id, p.party_name, ist.ethnic_origin, ist.marital_status
FROM   igs_ad_stat_int_all ist
JOIN   hz_parties p ON p.party_id = ist.person_id
WHERE  ist.error_code IS NOT NULL;

Reporting use cases include error-rate analysis per interface run, audit of disclosure attributes (criminal conviction, dismissals), and reconciliation against the target production statistics table by joining on PERSON_ID and RESID_STAT_ID.

Related Objects

  • HZ_PARTIES – Joined via IGS_AD_STAT_INT_ALL.PERSON_ID = HZ_PARTIES.PARTY_ID; the primary person reference.
  • IGS_AD_STAT_INT_PK – The primary key constraint on INTERFACE_STAT_ID.
  • Concurrent program / request tables (e.g. FND_CONCURRENT_REQUESTS) – Related through REQUEST_ID, PROGRAM_ID, and INTERFACE_RUN_ID for process traceability.
  • Target IGS statistics and resident-stat tables – Populated from this staging object after validation.
  • IGS_AD_* interface tables – Sibling staging tables sharing the same loader and error-handling pattern.

Because the object is obsolete, consultants should confirm its existence status in the target environment before designing interfaces or upgrade scripts against it.