Search Results unit_set_category_desc




Overview
Explore in AI Chat

Overview

The view IGSFV_PROG_CONCENTRATIONS belongs to the IGS — Student System product family, a module classified as obsolete in Oracle EBS 12.1.1 and 12.2.2. Despite its name, the view does not describe program concentrations in the admissions sense; it exposes the unit-set entity, defined as a logical sub-grouping of a program such as a Major, Minor, Stream, or Strand. Each unit-set captured through this view represents a structured academic grouping whose completion is typically governed by the Rules Sub-system.

The view is a reporting and integration construct rather than a transactional table. It flattens the primary unit-set record together with its status and category descriptions and the responsible organizational unit, producing a denormalized projection suitable for enquiry screens, extracts, and downstream integration. The view is declared WITH READ ONLY, confirming it is intended strictly for query access. The ETRM note stating "Not implemented in this database" indicates the view may not be present in every environment, and it should be validated against the target instance before use.

The user search term unit_set_category_desc maps directly to the UNIT_SET_CATEGORY_DESC column, which supplies the decoded category text for a unit-set.

Underlying Base Objects

Although the ETRM metadata documents no referenced base objects, the view text reveals the physical sources. The view is defined over four objects joined on their natural keys:

The (+) outer-join operator on the organization view means unit-sets without a resolvable responsible organization still return, with RESP_ORG_UNIT_DESC null.

Key Columns

Common Use Cases and Queries

Typical usage includes listing all unit-sets for a program, filtering by category or status, and extracting records for reporting. Because the view is read-only, it is safe for ad-hoc enquiry.

  • Retrieve all unit-sets with decoded status and category:
SELECT unit_set_code, version_number, title,
       unit_set_category_desc, unit_set_status_desc
FROM   igsfv_prog_concentrations
WHERE  TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date, SYSDATE);
  • Filter by the searched category description, using the searched term column:
SELECT unit_set_code, unit_set_category_desc, resp_org_unit_desc
FROM   igsfv_prog_concentrations
WHERE  UPPER(unit_set_category_desc) LIKE '%MAJOR%';
  • Identify unit-sets requiring authorisation:
SELECT unit_set_code, title, unit_set_status_desc
FROM   igsfv_prog_concentrations
WHERE  authorisation_rqrd_indicator = 'Y';

Consultants should treat this object as legacy IGS functionality; where it is not implemented, equivalent data must be sourced directly from the underlying IGS_EN_UNIT_SET_ALL and its lookups.