Search Results igs_rc_is_contact

Overview

The IGS_RC_IS_CONTACT table is a data object within the Oracle E-Business Suite, specifically belonging to the now-obsolete IGS (Student System) product family. Its primary function was to serve as a staging table for contact information processed through the Self Service interface. As a staging table, it acted as a temporary holding area for data submitted by prospective students or other users via web forms before that data was validated and transferred into the core transactional tables of the system. The metadata explicitly notes this table was "Not implemented in this database," indicating it may have been part of a planned or legacy feature that was not deployed in standard installations of EBS 12.1.1 or 12.2.2.

Key Information Stored

Based on the provided metadata, the table's structure centers on uniquely identifying contact records and linking them to a corresponding person record in the staging layer. The primary key column, INQ_CONTACT_ID, is the unique identifier for each staged contact entry. The critical foreign key column is INQ_PERSON_ID, which establishes a relationship to the IGS_RC_IS_PER_ALL staging table for person data. While specific detail columns (like phone, email, or address lines) are not listed in the excerpt, the table's purpose suggests it would have held contact details such as phone numbers, email addresses, and physical or postal addresses associated with the staged person record.

Common Use Cases and Queries

The principal use case for this table was the inbound processing of contact data from Oracle EBS Self-Service web pages. A typical operational flow would involve inserting a new record into IGS_RC_IS_CONTACT for each contact method submitted, followed by a batch or concurrent program that validated and migrated this staged data. Common queries would have focused on extracting staged data for processing or troubleshooting. For example, to retrieve all staged contact records for a specific person, one might use a query such as: SELECT * FROM igs_rc_is_contact WHERE inq_person_id = <PERSON_ID>;. Reporting use cases would have been limited to monitoring the staging process, such as generating counts of pending contact records awaiting migration.

Related Objects

The documented relationship for this table is singular and foundational. IGS_RC_IS_CONTACT has a foreign key dependency on the person staging table, as detailed below:

• Primary Key: IGS_RC_IS_CONTACT_PK on column INQ_CONTACT_ID.
• Foreign Key (References): The column IGS_RC_IS_CONTACT.INQ_PERSON_ID references the primary key of the table IGS_RC_IS_PER_ALL. This enforces that every contact record must be associated with a valid, existing person record within the same staging layer.

This relationship indicates that IGS_RC_IS_CONTACT is a child table within the self-service staging schema, with IGS_RC_IS_PER_ALL as its parent. There are no other documented foreign keys where this table is referenced by another, suggesting it was an endpoint in the data model for raw contact input.