Search Results instructor_number




Overview
Explore in AI Chat

Overview

The APPS.IGS_PS_UNSCHED_CL_V view is a reporting and integration object within the Oracle E-Business Suite IGS (Institution of Higher Education / Student System) product family. It exposes unscheduled class activity records together with fully resolved descriptive attributes for the instructor, activity type, location, building, and room. Rather than forcing downstream consumers to perform multiple joins against the HZ (Trading Community Architecture) party model and the IGS academic location hierarchy, the view presents a single denormalized result set suitable for concurrent programs, Oracle Reports, OBIEE extracts, and inbound/outbound interfaces.

The object is relevant to users searching on instructor_number, because the view surfaces the instructor's HZ party number as the column INSTRUCTOR_NUMBER. This allows an institution to report on unscheduled class delivery using the same party identifier used elsewhere in the HZ party model, rather than the internal surrogate INSTRUCTOR_ID. In EBS 12.1.1 and 12.2.2, the view is defined with a number of outer and inner joins, so its availability depends on the presence of related setup data.

Underlying Base Objects

The view is defined over the following documented base tables:

The ROW_ID pseudo-column from the driving table is retained, which supports certain EBS framework operations that require a row identifier (for example, in DML-enabled block-based forms or updatable regions).

Key Columns

Common Use Cases and Queries

Typical usage includes instructor workload reporting, room and location utilization analysis, and integration extracts that must carry the instructor's party number.

SELECT instructor_number, instructor_name,
       activity_type_description, location_description,
       building_description, room_description,
       number_of_students, hours_per_faculty
FROM   apps.igs_ps_unsched_cl_v
WHERE  instructor_number = :p_instructor_number;

SELECT activity_type_description,
       COUNT(*), SUM(hours_per_student)
FROM   apps.igs_ps_unsched_cl_v
GROUP  BY activity_type_description;

Because the location, building, and room joins are inner joins, only records with valid setup for those entities are returned; consumers should be aware that missing reference data will suppress otherwise valid rows.