Search Results inq_addr_id

Overview

The IGS_RC_IS_ADDRESS table is a staging table within the Oracle E-Business Suite (EBS) Student System (IGS) module, which is documented as obsolete. Its primary role is to temporarily hold address information for inquiries submitted through a self-service interface before this data is processed and potentially migrated to core transactional tables. As a staging table, it acts as an intermediary data store, facilitating data validation and workflow management for prospective student or inquiry address details. The documentation explicitly notes this table was "Not implemented in this database," indicating it may exist in the data dictionary but was not deployed in a standard configuration for the referenced EBS versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to capture address details linked to a specific inquiry. The primary key, INQ_ADDR_ID, uniquely identifies each address record within the staging environment. The most critical foreign key column is INQ_PERSON_ID, which links the address to a corresponding inquiry person record in the related staging table, IGS_RC_IS_PER_ALL. While the full column list is not detailed in the provided excerpt, tables of this nature typically store standard address components such as address lines, city, state, postal code, country, address type (e.g., home, mailing), and status flags.

Common Use Cases and Queries

The primary use case involves ETL (Extract, Transform, Load) or batch processes that manage inquiry data from self-service portals. A common operational query would retrieve all staged addresses for a specific inquiry person to review or validate data before processing. For troubleshooting or data reconciliation, one might query for addresses orphaned from their main inquiry record.

• Sample SQL to join with the person staging table:
  SELECT addr.* FROM igs_rc_is_address addr INNER JOIN igs_rc_is_per_all per ON addr.inq_person_id = per.inq_person_id WHERE per.inquiry_number = 'INQ1001';
• Sample SQL to find orphaned records:
  SELECT inq_addr_id FROM igs_rc_is_address WHERE inq_person_id NOT IN (SELECT inq_person_id FROM igs_rc_is_per_all);

Related Objects

The table maintains a direct foreign key relationship, which is the sole documented link to other entities in the staging schema.

• IGS_RC_IS_PER_ALL: This is the primary related table. The column IGS_RC_IS_ADDRESS.INQ_PERSON_ID references a record in IGS_RC_IS_PER_ALL. This relationship enforces that every staged address must be associated with a valid staged inquiry person record.

The table's own primary key, IGS_RC_IS_ADDRESS_PK on INQ_ADDR_ID, may be referenced by other objects, but no such dependencies are documented in the provided metadata.