Search Results inq_extracurr_id




Overview
Explore in AI Chat

Overview

The IGS_SS_INQ_EXTRACURR table is a staging table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Systems (OSS) product family. Its primary role is to temporarily hold data related to the extracurricular activities and interests reported by prospective students or inquiries during the self-service application process. As explicitly noted in its documentation, this table is designated as "Obsolete." This status indicates that while the table may exist in the schema for backward compatibility, its active use in current processes is deprecated, and it has likely been superseded by other data structures or a revised data flow in more recent implementations of the application.

Key Information Stored

The table captures details about a prospective student's non-academic pursuits. The key columns include the unique identifier INQ_EXTRACURR_ID, which serves as the primary key. The INQ_PERSON_ID foreign key links each activity record to a specific inquiry person in the IGS_SS_INQ_PERSON_ALL table. The nature of the activity is defined by INTEREST_TYPE_CODE (e.g., sports, arts, clubs) and INTEREST_NAME. The temporal scope of the activity is recorded via START_DATE and END_DATE. Additional administrative columns track the data's STATUS, its ACTIVITY_SOURCE_CD, and the standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, etc.) for auditing and concurrent program integration.

Common Use Cases and Queries

Historically, this table supported processes where inquiry data was collected via self-service portals and staged before being validated and migrated to core transactional tables. Common operational queries would involve extracting activity data for a specific inquiry or batch processing. A typical reporting query to list all extracurricular activities for an inquiry person would be:

  • SELECT INTEREST_TYPE_CODE, INTEREST_NAME, START_DATE, END_DATE, STATUS FROM IGS.IGS_SS_INQ_EXTRACURR WHERE INQ_PERSON_ID = :PERSON_ID ORDER BY START_DATE DESC;

Given its obsolete status, direct interaction with this table for new development is not recommended. Any required functionality should be verified against the current application's data model, which may use different objects for storing extracurricular information.

Related Objects

The table has a defined relationship with the core inquiry person table, forming the primary data model link for staged extracurricular data.

  • Primary Key: IGS_SS_INQ_EXTRACURR_PK on column INQ_EXTRACURR_ID.
  • Foreign Key (References): The column INQ_PERSON_ID is a foreign key referencing the IGS_SS_INQ_PERSON_ALL table. This enforces referential integrity, ensuring every extracurricular record is associated with a valid inquiry person record.
  • Referenced By: The dependency information notes that an object named IGS_SS_INQ_EXTRACURR under the APPS schema references this IGS schema table, which is typical for synonym-based application access.