Search Results activity_type_description




Overview
Explore in AI Chat

Overview

The IGS_PS_US_UNSCHED_CL_V view is a reporting and integration object owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product family. It exposes data relating to unscheduled class activity — that is, teaching or instructional activity that is not tied to a fixed scheduled meeting pattern — together with the descriptive attributes of the activity type, physical location, building, room, and assigned instructor.

The view is defined over the base table IGS_PS_US_UNSCHED_CL and enriches its rows by joining to several reference and party tables. It functions primarily as a denormalized read-only presentation layer, allowing developers, report authors, and integration components to retrieve unscheduled class records with human-readable descriptions rather than raw foreign key identifiers. Because the view carries the standard ROW_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN columns, it is compatible with Oracle Forms-style "WHO" auditing conventions and can be treated like a base table by many EBS tooling components.

The user search term us_unscheduled_cl_id maps to the US_UNSCHEDULED_CL_ID column, which is the unique identifier of the unscheduled class record and appears as the second column of the view's projection.

Underlying Base Objects

The view text references the following base and reference objects in the APPS schema:

  • IGS_PS_US_UNSCHED_CL — the primary transactional table holding unscheduled class records; aliased as USUCL and the driver of the joins.
  • HZ_PARTIES — the Trading Community Architecture party registry, aliased as HZ, providing instructor identification. This join is outer-joined (HZ.PARTY_ID(+)), so records without a matched instructor are still returned.
  • IGS_PS_USEC_ACT_TYPE — the activity type reference table, aliased as USAT.
  • IGS_AD_LOCATION — the location reference table, aliased as LOC.
  • IGS_AD_BUILDING — the building reference table, aliased as BLD.
  • IGS_AD_ROOM — the room reference table, aliased as ROM.

All joins except the instructor join are standard inner joins on the respective business keys (ACTIVITY_TYPE_ID, LOCATION_CD, BUILDING_ID, ROOM_ID). Consequently, a row is only returned when valid activity type, location, building, and room reference data exists for the unscheduled class record.

Key Columns

Common Use Cases and Queries

Typical uses include reporting on unscheduled teaching activity per unit offering option, workload analysis, instructor assignment reporting, and location utilization enquiries. The following query lists unscheduled classes for a given instructor with resolved descriptions:

  • SELECT us_unscheduled_cl_id, activity_type_description, location_description, building_description, room_description, number_of_students, hours_per_student, hours_per_faculty, instructor_number, instructor_name FROM igs_ps_us_unsched_cl_v WHERE instructor_id = :p_instructor_id;
  • SELECT uoo_id, COUNT(*) unsched_count, SUM(hours_per_faculty) total_faculty_hours FROM igs_ps_us_unsched_cl_v GROUP BY uoo_id;
  • SELECT us_unscheduled_cl_id, instructor_name, room_description FROM igs_ps_us_unsched_cl_v WHERE us_unscheduled_cl_id = :p_id;

Because the view performs inner joins on most reference tables, reports requiring orphaned records should query IGS_PS_US_UNSCHED_CL directly.