Results for “load_ci_sequence_number”

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.

• IGS_PS_USEC_X_GRP (UXG) – the cross-listed group header; joined to the member table on USEC_X_LISTED_GROUP_ID.
• IGS_PS_USEC_X_GRPMEM (UXGM) – the group membership table; the filter PARENT = 'Y' restricts the result to the parent (primary) unit offering of each group.
• IGS_PS_UNIT_OFR_OPT_V (UOO) – the unit offering option view; filtered to statuses OPEN, HOLD, CLOSED, and FULLWAITOK, and joined to USEC_TCH_RESP on UOO_ID.
• IGS_PS_USEC_TCH_RESP (USTR) – the teaching responsibility table; the filter LEAD_INSTRUCTOR_FLAG = 'Y' ensures only the lead instructor is returned.
• HZ_PARTIES (HZ) – the trading community party record supplying person name attributes, joined on INSTRUCTOR_ID = PARTY_ID.
• IGS_CA_TEACH_TO_LOAD_V (TTL) – the teaching-to-load view supplying load description, load calendar type/sequence, and load start/end dates.

Key Columns

• INSTRUCTOR_NAME – a concatenation of HZ_PARTIES PERSON_LAST_NAME, PERSON_FIRST_NAME, and PERSON_MIDDLE_NAME, formatted as "Last, First Middle".
• INSTRUCTOR_ID – the party identifier of the lead instructor (USTR.INSTRUCTOR_ID).
• GROUP_NAME – the cross-listed group name (USEC_X_LISTED_GROUP_NAME).
• GROUP_ID – the USEC_X_LISTED_GROUP_ID, the primary grouping key.
• LOCATION – the location description of the unit offering option.
• LOAD_DESCRIPTION / TEACH_DESCRIPTION – descriptive text for the teaching load and its delivery.
• LOAD_CAL_TYPE, LOAD_CI_SEQUENCE_NUMBER, LOAD_START_DT, LOAD_END_DT – the teaching calendar instance and date range applicable to the load.
• TEACH_CAL_TYPE, TEACH_CI_SEQUENCE_NUMBER – the teaching calendar instance linking the group to the load view.

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.