Search Results weeks_per_year




Overview
Explore in AI Chat

Overview

The view IGS_AD_EXCURR_INT belongs to the IGS — Student System product family, an obsolete Oracle EBS module that historically supported student administration, admissions, extracurricular activities, and related enrollment data within Oracle E-Business Suite releases 12.1.1 and 12.2.2. The view exposes the structure of the interface table IGS_AD_EXCURR_INT_ALL, which serves as a staging area for extracurricular interest and activity records prior to validation and loading into the base IGS tables. Its principal reporting and integration role is to present inbound data — including hours-per-week and weeks-per-year metrics describing participation intensity — so that concurrent programs, interface validators, and downstream import routines can inspect, match, and reconcile records before committing them.

Because the IGS module is flagged as obsolete in the ETRM repository, the view is documented for reference only and is not implemented in the current database. The product’s documentation status confirms that customers on modern 12.2.2 environments will not find this object instantiated unless a legacy IGS installation remains active.

Underlying Base Objects

According to the ETRM metadata, no base objects are formally documented for this view, though the view text itself is explicit: it selects from IGS_AD_EXCURR_INT_ALL (aliased as TAB). The _ALL suffix indicates a multi-organization table partitioned by ORG_ID, which aligns with the view’s exposure of the ORG_ID column for operating-unit filtering. Because the view derives every column directly from the interface table without aggregation or joins (the ROWID is projected as ROW_ID), it functions as a thin, denormalized access layer over the staging table.

Key Columns

The columns fall into several functional groupings:

Common Use Cases and Queries

Typical scenarios include auditing unprocessed interface records, reviewing participation metrics, and diagnosing validation errors. A representative query filtering on the frequently searched attribute follows:

  • Locate records by annual commitment:
    SELECT INTERFACE_EXCURR_ID, INTEREST_NAME, HOURS_PER_WEEK, WEEKS_PER_YEAR, STATUS FROM IGS_AD_EXCURR_INT WHERE WEEKS_PER_YEAR > 30 AND STATUS = 'NEW';
  • Inspect failed loads by organization:
    SELECT ORG_ID, ERROR_CODE, COUNT(*) FROM IGS_AD_EXCURR_INT WHERE STATUS = 'ERROR' GROUP BY ORG_ID, ERROR_CODE;
  • Reconcile sports-related interests:
    SELECT INTEREST_TYPE_CODE, SPORT_INDICATOR, RANK, TEAM FROM IGS_AD_EXCURR_INT WHERE SPORT_INDICATOR = 'Y';

Because the view carries no validation logic, consumers should always pair these queries with the corresponding IGS import concurrent program to ensure staged rows are processed correctly.