Search Results igs_ss_inq_address_pk

Overview

The IGS_SS_INQ_ADDRESS table is a data object within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its documented purpose is to hold address information for inquiries staged through the Self Service application. This staging mechanism is typically part of a data import or online capture process before information is formally processed into the core transactional tables of the system. Critically, the official ETRM description explicitly marks this table as "Obsolete." This status indicates that while the table may physically exist in a database, particularly in versions 12.1.1 and 12.2.2, it is no longer actively used or supported by the standard application code. Its presence is likely a legacy artifact, and new implementations or customizations should avoid dependencies on it.

Key Information Stored

Based on the provided metadata, the table's primary function was to store address records linked to prospective student inquiries. The key structural element is the primary key column, INQ_ADDR_ID, which uniquely identifies each address record. The table's main relational link is established via the foreign key column INQ_PERSON_ID. This column references a corresponding record in the IGS_SS_INQ_PERSON_ALL table, thereby associating an address with a specific inquiry person record. While the full column list is not detailed in the excerpt, a table of this nature would typically contain standard address attributes such as address lines, city, state, postal code, country, and address type (e.g., home, mailing).

Common Use Cases and Queries

Given the table's obsolete status, there are no recommended common use cases in a production environment. Direct interaction with this table for reporting or integration is discouraged as its data integrity and synchronization with the active application are not guaranteed. Historically, it would have been used in staging processes. Example query patterns from a legacy context would involve joining to the person staging table:

• Basic Join: SELECT addr.* FROM igs.igs_ss_inq_address addr JOIN igs.igs_ss_inq_person_all per ON addr.inq_person_id = per.inq_person_id WHERE per.last_name = :l_name;
• Existence Check: Queries might have been used to verify if address data existed for a staged inquiry before proceeding with a batch process to the core system tables.

Any current reporting on inquiry data must be performed against the active, supported tables within the Student System module.

Related Objects

The metadata defines a clear, singular relationship for this table. It is a child table in a foreign key relationship, meaning its records depend on the existence of a parent record.

• IGS_SS_INQ_PERSON_ALL (Table): This is the primary related object. The IGS_SS_INQ_ADDRESS.INQ_PERSON_ID column is a foreign key that references the IGS_SS_INQ_PERSON_ALL table. This relationship enforces that every address record must be associated with a valid staging inquiry person record. The direction of this relationship is important: IGS_SS_INQ_ADDRESS references IGS_SS_INQ_PERSON_ALL.

No other foreign keys, indexes (beyond the primary key), or dependent views are documented in the provided excerpt, which is consistent with an obsolete object that has been phased out of the application's logical data model.