Search Results responsible_org_unit_code

Overview

IGSBV_CONCENTRATIONS is a reporting view within the Oracle E-Business Suite IGS (Student System) product family. In the ETRM 12.1.1 and 12.2.2 documentation it is classified as obsolete and is explicitly marked "Not implemented in this database." Its purpose, as described in the metadata, is to present a unit-set, defined as a logical sub-grouping of a course, such as a Major, Minor, Stream, or Strand. A unit-set is typically associated with the rules governing its completion through the Rules Sub-system. The view therefore served as a read-only presentation layer for concentration and unit-set definitions used by student records, enrollment, and academic structure reporting.

Underlying Base Objects

The view is defined with a single SELECT statement over the base table IGS_EN_UNIT_SET_ALL, using the WITH READ ONLY clause. The full view text is:

SELECT UNIT_SET_CD, VERSION_NUMBER, UNIT_SET_STATUS, UNIT_SET_CAT, START_DT, REVIEW_DT, EXPIRY_DT, END_DT, TITLE, SHORT_TITLE, ABBREVIATION, RESPONSIBLE_ORG_UNIT_CD, RESPONSIBLE_OU_START_DT, ADMINISTRATIVE_IND, AUTHORISATION_RQRD_IND, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGS_EN_UNIT_SET_ALL WITH READ ONLY

IGS_EN_UNIT_SET_ALL is the primary base object. It stores the current and versioned definitions of unit-sets. The view renames several base columns to more descriptive forms (for example, UNIT_SET_CD to UNIT_SET_CODE and START_DT to START_DATE), providing a cleaner interface for downstream consumers. No other base objects are documented for this view in the ETRM metadata.

Key Columns

• UNIT_SET_CODE — Unique identifier for the unit-set (concentration), such as a Major, Minor, Stream, or Strand.
• VERSION_NUMBER — Version identifier supporting the versioned nature of unit-set definitions.
• UNIT_SET_STATUS — Current status of the unit-set record.
• UNIT_SET_CATEGORY — Category or classification of the unit-set.
• START_DATE, REVIEW_DATE, EXPIRY_DATE, END_DATE — Effective-dating columns controlling the lifecycle and validity window of the unit-set definition.
• UNIT_SET_TITLE, UNIT_SET_SHORT_TITLE, UNIT_SET_ABBREVIATION — Descriptive naming attributes.
• RESPONSIBLE_ORG_UNIT_CODE — The organization unit accountable for the unit-set; this corresponds directly to the user search term "responsible_org_unit_code" and is central to the view's administrative reporting.
• RESPONSIBLE_OU_START_DATE — Effective start date associated with the responsible organization unit assignment.
• ADMINISTRATIVE_INDICATOR — Indicates whether the unit-set is administrative in nature.
• AUTHORISATION_RQRD_INDICATOR — Indicates whether authorisation is required for the unit-set.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard audit columns.

Common Use Cases and Queries

Because the view renames columns and enforces read-only access, it was intended for reporting and integration rather than transactional maintenance. A common use case is identifying which organization unit owns a given concentration. A representative query is:

SELECT unit_set_code, unit_set_title, responsible_org_unit_code, responsible_ou_start_dt FROM igsbv_concentrations WHERE responsible_org_unit_code = :org_unit_code;

Another scenario filters active unit-sets by status and effective dates for enrollment and academic planning reports. Given its obsolete and unimplemented status in 12.1.1 and 12.2.2, all references should be validated against the target instance before use, as the underlying IGS_EN_UNIT_SET_ALL object and the view itself may be absent or disabled. Where the Student System is not licensed or the object is not deployed, equivalent concentration data must be sourced from the corresponding base table if it exists, or from the successor academic structure objects.