Search Results inq_addr_id




Overview
Explore in AI Chat

Overview

The IGS_SS_INQ_ADDRESS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically under the IGS (Oracle Student Systems) schema. Its primary function is to serve as a staging table for address information related to prospective students or inquiries within the Self-Service application. As explicitly noted in its documentation, its purpose is to "Holds Self Service Staging Address." Importantly, the metadata indicates this table is flagged as "Obsolete." This status suggests that while the table may exist in current installations for backward compatibility, its active use in new implementations or processes is likely deprecated in favor of newer data models or consolidated address tables within the application's architecture.

Key Information Stored

The table stores comprehensive address details for inquiry records. The primary unique identifier is the INQ_ADDR_ID column, a mandatory 15-digit number. Each address is linked to a specific inquiry person via the INQ_PERSON_ID foreign key. The table captures the address's purpose (ADDR_USAGE), its physical components across four lines (ADDR_LINE_1 through ADDR_LINE_4), and geographic details such as CITY, STATE, COUNTY, PROVINCE, COUNTRY, and POSTCODE. Temporal validity is managed through START_DATE and END_DATE columns, and a STATUS field tracks the record's active state. The table also includes a full suite of standard EBS "Who" columns (CREATED_BY, LAST_UPDATED_BY, etc.) for auditing and the standard concurrent program "Who" columns (REQUEST_ID, PROGRAM_ID, etc.).

Common Use Cases and Queries

Given its staging and obsolete nature, this table's primary use case is in legacy data interfaces or reports concerning prospective student address history. Common queries involve retrieving all addresses for a specific inquiry or finding active addresses of a particular usage type. A typical reporting query would join to the parent person table. For instance, to extract current mailing addresses for inquiries, one might use:

SELECT p.inquiry_number, a.addr_line_1, a.city, a.state, a.country, a.postcode
FROM igs.igs_ss_inq_address a,
     igs.igs_ss_inq_person_all p
WHERE a.inq_person_id = p.inq_person_id
  AND a.addr_usage = 'MAILING'
  AND TRUNC(SYSDATE) BETWEEN a.start_date AND NVL(a.end_date, TRUNC(SYSDATE))
  AND a.status = 'ACTIVE';

Data migration or cleanup scripts may also query this table to identify records that have been end-dated or have an inactive status, especially during upgrades or transitions away from this obsolete object.

Related Objects

The table's relationships are defined by its primary key and foreign key constraints, as documented in the provided metadata.

  • Primary Key: The table is uniquely identified by the IGS_SS_INQ_ADDRESS_PK constraint on the INQ_ADDR_ID column.
  • Foreign Key (Parent Table): The INQ_PERSON_ID column is a foreign key that references the IGS_SS_INQ_PERSON_ALL table. This establishes that every address record must be associated with a valid inquiry person record in the system. The relationship is foundational for joining address data to the core inquiry person information.