Results for “teach_cal_type”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AS_X_USEC_CLASSLIST_V is a reporting view owned by the APPS schema within the IGS – Student System product family in Oracle EBS 12.1.1 and 12.2.2. Its documented purpose is to describe cross-listed unit sections for class list reporting. In the Oracle Student System model, a "use case" (USEC) refers to a specific offering of a unit section, while a cross-listed group (USEC_X_LISTED_GROUP) represents two or more unit offerings that are taught together and share a single class roster. This view flattens the relationships between those groups, their member sections, the assigned lead instructor, and the associated teaching load into a single queryable structure, which allows institutions to produce consolidated class lists that correctly attribute shared sections to the correct delivery and teaching calendar instances.

The view is read-only and exposes no DML; it is intended for reporting, extracts, and downstream integration where a denormalized instructor-per-class-list record is required. The user search term "instructor_name" maps directly to the INSTRUCTOR_NAME column documented in this view.

Underlying Base Objects

The view is defined over six referenced objects, joining them on the cross-listed group identifier, the unit offering option identifier (UOO_ID), and the teaching calendar instance.

Key Columns

Common Use Cases and Queries

The primary use case is producing a cross-listed class list with instructor attribution. A typical query selects the group and instructor details filtered by teaching calendar:

SELECT group_name, instructor_name, location,
       load_cal_type, load_ci_sequence_number,
       load_start_dt, load_end_dt
FROM   apps.igs_as_x_usec_classlist_v
WHERE  teach_cal_type = :p_cal_type
AND    teach_ci_sequence_number = :p_ci_seq;

A secondary scenario is looking up the lead instructor for a particular cross-listed group:

SELECT instructor_id, instructor_name
FROM   apps.igs_as_x_usec_classlist_v
WHERE  group_id = :p_group_id;

Because the view resolves the instructor through HZ_PARTIES, results reflect current party name data; reconciliations between class lists and the load calendar should account for the calendar-type join conditions embedded in the view definition.