Search Results resp_org_unit_code




Overview
Explore in AI Chat

Overview

APPS.IGSBV_HIGH_EDU_PRG_GROUPS is a read-only Oracle EBS view in the Student System (IGS) product family. It exposes higher-education program group (course group) definitions as a simplified, reporting-friendly projection of the underlying IGS_PS_GRP_ALL table. The view renames several columns into a consistent naming convention: COURSE_GROUP_CD becomes PROGRAM_GROUP_CODE, DESCRIPTION becomes PROGRAM_GROUP_DESCRIPTION, RESPONSIBLE_ORG_UNIT_CD becomes RESP_ORG_UNIT_CODE, RESPONSIBLE_OU_START_DT becomes RESP_ORG_UNIT_START_DATE, COURSE_GROUP_TYPE becomes PROGRAM_GROUP_TYPE, and CLOSED_IND becomes PROGRAM_CLOSED_INDICATOR.

Because these aliases normalise terminology and the definition carries a WITH READ ONLY clause, the view is intended strictly for query, reporting, and integration purposes. It is not an updateable entity, and any DML against it will fail by design. It is a convenient abstraction layer that insulates report authors and external interfaces from the raw IGS_PS_GRP_ALL structure.

Underlying Base Objects

The view is defined over a single documented base object, IGS_PS_GRP_ALL, aliased as GR. The defining SQL selects the COURSE_GROUP_CD, DESCRIPTION, RESPONSIBLE_ORG_UNIT_CD, RESPONSIBLE_OU_START_DT, COURSE_GROUP_TYPE, and CLOSED_IND columns, along with the standard audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE. No other base objects are documented for this view.

The GR alias and the presence of the RESPONSIBLE_OU_START_DT column indicate that the underlying table is keyed by course group code and responsible organisational unit, with effective dating on the responsible OU assignment. The view therefore inherits the row granularity of IGS_PS_GRP_ALL.

Key Columns

  • PROGRAM_GROUP_CODE — The course group code (source: COURSE_GROUP_CD). This is the primary business key and the value most commonly searched via the term program_group_code.
  • PROGRAM_GROUP_DESCRIPTION — Descriptive text for the program group (source: DESCRIPTION).
  • RESP_ORG_UNIT_CODE — The organisational unit responsible for the program group (source: RESPONSIBLE_ORG_UNIT_CD).
  • RESP_ORG_UNIT_START_DATE — Effective start date of the responsible OU assignment (source: RESPONSIBLE_OU_START_DT).
  • PROGRAM_GROUP_TYPE — Classification of the course group (source: COURSE_GROUP_TYPE).
  • PROGRAM_CLOSED_INDICATOR — Flag indicating whether the program group is closed (source: CLOSED_IND).
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, inherited from the base table.

Common Use Cases and Queries

The view is typically queried to resolve a program_group_code into its description, responsible OU, type, and lifecycle status, or to list all active program groups for a given organisation unit. A representative lookup below returns programme-group detail for a specific code and OU start date.

  • Validate an incoming program_group_code during interface/data conversion.
  • Populate an LOV or BI report listing open program groups by responsible OU.
  • Reconcile program group definitions between EBS and a downstream system.

Sample SQL:

  • SELECT program_group_code, program_group_description, resp_org_unit_code, program_group_type, program_closed_indicator
  • FROM apps.igsbv_high_edu_prg_groups
  • WHERE program_group_code = :p_code
  • AND program_closed_indicator = 'N';

To list open groups for an OU: SELECT * FROM apps.igsbv_high_edu_prg_groups WHERE resp_org_unit_code = :p_ou AND program_closed_indicator = 'N'; Because the view is read-only and defined over IGS_PS_GRP_ALL, joins to other IGS course and program tables should use PROGRAM_GROUP_CODE as the join key.