Search Results igs_ca_load_to_teach_v




Overview
Explore in AI Chat

Overview

IGS_CA_LOAD_TO_TEACH_V is a reporting view belonging to the IGS (Student System) product family within Oracle E-Business Suite. It is documented in the ETRM as an obsolete object. The view presents the relationship between a student's default load calendar and the associated teaching calendars, resolving the hierarchical calendar structure that governs how load periods map to teaching periods in an academic term.

In the Oracle EBS 12.1.1 and 12.2.2 data model, the IGS calendar infrastructure distinguishes between calendar categories such as ACADEMIC and TEACHING. A load calendar typically originates as an academic-category calendar instance, while teaching calendars are sub-calendars attached to it through the IGS_CA_INST_REL relationship table. This view flattens that hierarchy so that both the load side and the teaching side are presented side by side on a single row, making it convenient for institution-facing reporting and integration extracts that require teaching calendar context for each default load appointment.

Because the object is marked obsolete and is documented as "not implemented in this database," it should be treated as a legacy reference. It may still exist in historic or partially upgraded environments but is not guaranteed to be present in a current 12.2.2 installation.

Underlying Base Objects

The view is defined over three core IGS calendar tables, joined through a nested subquery against the calendar instance relationship and calendar type tables. The documented base objects are:

  • IGS_ST_DFT_LOAD_APPO — the default load appointment table, aliased AP1, which supplies the load calendar type and load calendar instance sequence number.
  • IGS_CA_INST — the calendar instance table, joining once as CI for the load instance and once as CI1 for the teaching instance.
  • IGS_CA_INST_REL — the calendar instance relationship table, aliased R1 and R2, which links superior and subordinate calendar instances.
  • IGS_CA_TYPE — the calendar type table, aliased CT and CT1, used to filter on the S_CAL_CAT calendar category.

The join logic begins with the default load appointment, matches the load instance in IGS_CA_INST, and then correlates to a teaching instance where the calendar type equals AP1.TEACH_CAL_TYPE. The nested subquery constrains the teaching instance to those relationship rows whose subordinate calendar type has an S_CAL_CAT of 'TEACHING' and whose superior calendar instance matches the load appointment with a superior calendar type categorized as 'ACADEMIC'.

Key Columns

The view exposes twelve columns, organized into two symmetrical groups:

Common Use Cases and Queries

Typical usage involves reporting the teaching periods that fall under a student's load calendar, validating that load appointments resolve to a valid teaching calendar, and driving downstream integration extracts for scheduling or enrolment processes.

A representative query returning all mapping rows for a given load calendar type and instance would be:

  • SELECT load_cal_type, load_ci_sequence_number, load_start_dt, load_end_dt, teach_cal_type, teach_ci_sequence_number, teach_start_dt, teach_end_dt FROM igs_ca_load_to_teach_v WHERE load_cal_type = :p_cal_type AND load_ci_sequence_number = :p_seq;
  • SELECT teach_cal_type, teach_ci_sequence_number, teach_start_dt FROM igs_ca_load_to_teach_v WHERE load_start_dt BETWEEN :p_from AND :p_to ORDER BY load_start_dt;
  • SELECT COUNT(*) FROM igs_ca_load_to_teach_v WHERE load_cal_type = :p_cal_type;

Because the ETRM documents no explicit base-object list and the view is obsolete, any implementation should confirm both the view's presence and the continued existence of the underlying IGS calendar tables before relying on it in 12.1.1 or 12.2.2 environments.