Search Results igs_rc_is_per_all_pk




Overview
Explore in AI Chat

Overview

The IGS_RC_IS_PER_ALL table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS), specifically designed for the Recruiting module. It serves as the central staging table for person-level information captured through Self Service Inquiry functionality. This table acts as a temporary holding area for prospective student (inquirer) data submitted via web-based portals before the information is validated and potentially processed into the main application tables. Its role is critical for managing the flow of inbound recruitment data, ensuring data integrity during the initial capture phase in both EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The primary purpose of the table is to store a unique identifier for each prospective person record submitted through the inquiry interface. The key column is INQ_PERSON_ID, which serves as the primary key (IGS_RC_IS_PER_ALL_PK). This identifier is the foreign key for numerous related staging tables, linking the core person record to their associated academic, contact, and demographic details. While the provided ETRM excerpt does not list all column definitions, the table's description and foreign key relationships imply it holds foundational person attributes necessary to identify and link an inquirer across the staging schema. The "_ALL" suffix typically indicates the table is partitioned by a Set of Books (SOB) or Legal Entity identifier, supporting multi-organization architectures.

Common Use Cases and Queries

The primary use case involves data staging and validation workflows for prospective student inquiries. Data is inserted into this table and its related child tables via the Self Service application. Common operational and reporting queries would focus on reviewing or processing staged data. For instance, identifying all inquirer person records pending processing or joining to related staging data for a comprehensive view. A typical SQL pattern would involve joining to child tables using the INQ_PERSON_ID.

  • Sample Query: SELECT per.*, addr.* FROM IGS_RC_IS_PER_ALL per LEFT JOIN IGS_RC_IS_ADDRESS addr ON per.INQ_PERSON_ID = addr.INQ_PERSON_ID WHERE per.CREATION_DATE > SYSDATE - 1;
  • Reporting Use Case: Generating a daily report of new inquiry submissions by joining IGS_RC_IS_PER_ALL with IGS_RC_IS_INQUIRY and IGS_RC_IS_CONTACT tables.

It is crucial to note the provided metadata states "Not implemented in this database," which may indicate the table is part of a delivered data model but not actively used or populated in a specific implementation without corresponding customizations or module setups.

Related Objects

The IGS_RC_IS_PER_ALL table is the central parent table for a suite of inquiry staging tables. Its primary key is referenced by the following foreign keys, establishing a clear data model for staged inquirer information:

  • IGS_RC_IS_ACAD: Links staged academic history (IGS_RC_IS_ACAD.INQ_PERSON_ID).
  • IGS_RC_IS_ADDRESS: Links staged address information (IGS_RC_IS_ADDRESS.INQ_PERSON_ID).
  • IGS_RC_IS_CONTACT: Links staged contact details (IGS_RC_IS_CONTACT.INQ_PERSON_ID).
  • IGS_RC_IS_EXTRACURR: Links staged extracurricular activity data (IGS_RC_IS_EXTRACURR.INQ_PERSON_ID).
  • IGS_RC_IS_INQUIRY: Links the core inquiry header information (IGS_RC_IS_INQUIRY.INQ_PERSON_ID).
  • IGS_RC_IS_RACE: Links staged racial or ethnic demographic data (IGS_RC_IS_RACE.PERSON_ID).
  • IGS_RC_IS_TEST: Links staged standardized test score information (IGS_RC_IS_TEST.INQ_PERSON_ID).