Search Results responsible_ou_start_date

Overview

APPS.IGSFV_CONCENTRATIONS is a read-only Oracle EBS view residing in the APPS schema and belonging to the IGS – Student System product family. It describes a unit-set, defined as a logical sub-grouping of a course — for example a Major, Minor, Stream, or Strand. A unit-set is typically associated with the rules that govern its completion through the Rules Sub-system.

Despite its name, the view does not expose concentration-specific data beyond the unit-set abstraction; "concentrations" is the legacy label applied to this entity class. The view carries an Obsolete status in the ETRM documentation, which is significant for impact assessment: Oracle has effectively retired the object, and any custom reporting, interface, or integration that references IGSFV_CONCENTRATIONS should be reviewed for remediation. Nonetheless, because the view remains VALID, it continues to be queryable in both 12.1.1 and 12.2.2 environments, often through the OAF-based or Oracle Forms-based Student System UI, or through custom concurrent programs and BI Publisher reports that were authored against the older student data model.

The user's search term, responsible_org_unit_code, maps to the RESPONSIBLE_ORG_UNIT_CODE column exposed by the view, and is the principal link to the owning academic or administrative organization.

Underlying Base Objects

The view is defined over four documented base tables, joined with an outer join on the responsible organization:

• IGS_EN_UNIT_SET_ALL (alias USET) — the driving unit-set table holding code, version, status, category, dates, titles, and the responsible organization attributes.
• IGS_EN_UNIT_SET_STAT (alias STAT) — lookup of unit-set statuses, joined on UNIT_SET_STATUS to supply the status description.
• IGS_EN_UNIT_SET_CAT (alias CAT) — lookup of unit-set categories, joined on UNIT_SET_CAT to supply the category description.
• HZ_PARTIES (alias ORG) and IGS_PE_HZ_PARTIES (alias IHP) — joined to resolve the responsible organization party name from the organization unit code.

The relationship is enforced as follows: STAT.UNIT_SET_STATUS = USET.UNIT_SET_STATUS, CAT.UNIT_SET_CAT = USET.UNIT_SET_CAT, USET.RESPONSIBLE_ORG_UNIT_CD = IHP.OSS_ORG_UNIT_CD (+), and ORG.PARTY_ID = IHP.PARTY_ID. The outer join ((+)) on the responsible organization unit code means unit-sets that have no resolvable responsible organization still appear, with a null RESP_ORG_NAME. The view is defined WITH READ ONLY, so no DML is possible.

Key Columns

• UNIT_SET_CODE (mapped to UNIT_SET_CD) — the primary identifier of the unit-set.
• VERSION_NUMBER — versioning of the unit-set record, supporting effective-dated changes.
• UNIT_SET_STATUS / UNIT_SET_STATUS_DESC — status code and its descriptive lookup meaning.
• UNIT_SET_CATEGORY / UNIT_SET_CATEGORY_DESC — category code and description (Major, Minor, Stream, Strand).
• START_DATE, REVIEW_DATE, EXPIRY_DATE, END_DATE — lifecycle dates for the unit-set.
• UNIT_SET_TITLE, UNIT_SET_SHORT_TITLE, UNIT_SET_ABBREVIATION — descriptive naming attributes.
• RESPONSIBLE_ORG_UNIT_CODE (RESPONSIBLE_ORG_UNIT_CD) — the organization unit accountable for the unit-set; the subject of the user's search.
• RESPONSIBLE_OU_START_DATE — the effective start date of the responsible organization assignment.
• RESP_ORG_NAME — the resolved party name of the responsible organization, drawn from HZ_PARTIES.PARTY_NAME.
• ADMINISTRATIVE_INDICATOR / "_LA:ADMINISTRATIVE_IND_DESC" — administrative flag with lookup meaning.
• AUTHORISATION_RQRD_INDICATOR / "_LA:AUTH_RQR_IND_DES" — authorisation-required flag with lookup meaning.
• "_DF" — descriptive flexfield context placeholder on IGS_PS_UNIT_SET_FLEX.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include extracting the catalogue of unit-sets by responsible organization, reporting on status distribution, and integrating the student data model with downstream reporting. Because the view is flagged Obsolete, usage should be inventoried ahead of any upgrade.

Example queries:

• List active unit-sets for a responsible organization:

SELECT unit_set_code, unit_set_title, unit_set_category_desc,
       responsible_org_unit_code, resp_org_name
FROM   appls.igsfv_concentrations
WHERE  responsible_org_unit_code = :org_unit_code
AND    unit_set_status = 'ACTIVE';

• Count unit-sets grouped by responsible organization:

SELECT responsible_org_unit_code, resp_org_name, COUNT(*) sets
FROM   apps.igsfv_concentrations
GROUP  BY responsible_org_unit_code, resp_org_name
ORDER  BY sets DESC;

• Filter by category:

SELECT unit_set_code, unit_set_category_desc, unit_set_title
FROM   apps.igsfv_concentrations
WHERE  unit_set_category_desc = 'Major';

Given the Obsolete designation, consider migrating queries to the underlying base table IGS_EN_UNIT_SET_ALL and joining the current lookup tables directly, which future-proofs reports against removal of this view.