Search Results unit_set_status_desc




Overview
Explore in AI Chat

Overview

IGSFV_PROG_CONCENTRATIONS is a read-only Oracle EBS view owned by the APPS schema that consolidates program (unit set) concentration definitions drawn from the Student Systems / Academic institution model. It presents one row per unit set version, enriched with decoded status, category, and responsible organization descriptions. The view derives its name from the concept of a programme concentration — an approved combination or grouping of units (courses) within an academic programme — but the physical definition is built over the generic IGS_EN_UNIT_SET infrastructure, so the same rows describe any unit set version tracked by the institution.

The view is declared WITH READ ONLY, meaning it cannot be used as a DML target; it exists purely for inquiry, reporting, and integration. Because it resolves surrogate codes into human-readable descriptions, it is a natural source for concurrent programs, Oracle Reports, OBIEE/BI Publisher data models, and inbound interface validation queries in the 12.1.1 and 12.2.2 releases.

Underlying Base Objects

The view is defined over four documented sources, joined in a single SELECT:

No additional base objects are documented in the ETRM metadata beyond these four. The literal '_DF:IGS:IGS_PS_UNIT_SET_FLEX:UST' exposed as a column is a descriptive flexfield reference token, indicating that the unit set entity carries a DFF context used by the Products/Sales flexfield definition.

Key Columns

Common Use Cases and Queries

Typical uses include reporting all active concentrations within a programme and listing the responsible organization for each. A representative query follows:

  • SELECT unit_set_code, version_number, title, unit_set_status_desc, unit_set_category_desc, resp_org_unit_desc FROM apps.igsfv_prog_concentrations WHERE unit_set_status_desc = 'ACTIVE';
  • Filtering by effective date to identify concentrations current as of a given term: WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);
  • Joining to unit set element tables via unit_set_code and version_number to expand the members of a concentration.

Because the view is read-only and pre-joins the status and category lookups, it is preferred over direct queries against IGS_EN_UNIT_SET_ALL whenever descriptive text is required.