Search Results activity_source_meaning




Overview
Explore in AI Chat

Overview

The view IGS_AD_EXTRACURR_ACT_V belongs to the Oracle E-Business Suite Student System family, carrying the IGS product prefix associated with the obsolete student information management modules shipped alongside Oracle HRMS and Oracle Advanced Benefits. ETRM classifies the object as Obsolete and records that it is not implemented in this database under Oracle EBS 12.1.1 / 12.2.2. Its purpose is to present consolidated data about a person's extracurricular activities and personal interests, joining HRMS party interest records to an IGS extracurricular activity detail table and enriching coded values with lookup meanings.

Functionally the view acts as a reporting and integration facade. Rather than forcing consumers to resolve foreign keys across three separate tables and to join lookup values manually, it exposes a denormalized row containing person interest attributes plus the corresponding activity end date, effort metrics (hours per week, weeks per year), and decoded meaning columns. It also exposes ROWID and the full set of standard WHO/audit columns, allowing it to serve as a data source for extracts, Fast Formulas, and OAF/Forms blocks.

Underlying Base Objects

The definition is a two-branch UNION ALL query over three base objects documented in the view text:

Note that ACTIVITY_SOURCE_MEANING is decoded from IGS_LOOKUP_VALUES (lookup type ACTIVITY_SOURCE), not from FND_LOOKUP_VALUES. ETRM documents no referenced base objects in its metadata, so the relationships above are derived from the published view text.

Key Columns

Common Use Cases and Queries

Typical uses include extracting extracurricular activity records for a party, filtering by activity source, and reporting participation levels. A representative query retrieves activities for a party together with their decoded source:

SELECT pi.party_id,
       v.activity_source_cd,
       v.activity_source_meaning,
       v.hours_per_week,
       v.weeks_per_year,
       v.end_date
  FROM igs_ad_extracurr_act_v v
 WHERE v.party_id = :p_party_id
   AND v.activity_source_cd IS NOT NULL;

Because the object is documented as obsolete and not implemented, deployments on 12.1.1 / 12.2.2 should confirm its existence in ALL_VIEWS before relying on it, and treat any dependent customizations as candidates for migration to supported HRMS/party-interest reporting structures.