Search Results level_of_participation_meaning

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:

• HZ_PERSON_INTEREST — aliased PI; the primary driver containing person-level interest records keyed by PERSON_INTEREST_ID and PARTY_ID.
• IGS_AD_HZ_EXTRACURR_ACT — aliased HEA; the extracurricular activity detail table, joined with an outer join ((+)) on PERSON_INTEREST_ID, supplying end date, effort hours/weeks, and the activity source code.
• FND_LOOKUP_VALUES — aliased FL1; joined on INTEREST_TYPE_CODE across the lookup types INTEREST_TYPE, ENTERTAINMENT, and PREFERENCES, restricted to VIEW_APPLICATION_ID = 222, SECURITY_GROUP_ID = 0, and the session language.

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

• PERSON_INTEREST_ID, PARTY_ID — the identity keys linking an interest row to a person party.
• INTEREST_TYPE_CODE / MEANING — the coded interest category and its decoded display name.
• ACTIVITY_SOURCE_CD / ACTIVITY_SOURCE_MEANING — the source of the activity record, decoded through the ACTIVITY_SOURCE lookup. This pair is the most relevant columns when the search term "activity_source" is used, and is the only column family in the view drawing on IGS_LOOKUP_VALUES.
• END_DATE, HOURS_PER_WEEK, WEEKS_PER_YEAR — activity duration and effort metrics from the extracurricular detail table.
• LEVEL_OF_INTEREST, LEVEL_OF_PARTICIPATION and their decoded RANK and LEVEL_OF_PARTICIPATION_MEANING counterparts.
• SPORT_INDICATOR, SUB_INTEREST_TYPE_CODE, INTEREST_NAME, TEAM, COMMENTS, SINCE — descriptive interest attributes.
• Standard audit/WHO columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER, plus ROWID and a constant WH_UPDATE_DATE.

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.