Search Results cal_cat




Overview
Explore in AI Chat

Overview

IGS_PE_TEACH_PERIODS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It presents teaching period assignment data for persons within the Student Systems / Student Records (IGS) product family, enriching the base teaching period rows with human-readable descriptions drawn from the calendar and lookup infrastructure. The view resolves code values into their display meanings, so consumers receive decoded calendar descriptions and calendar category labels rather than raw identifiers. Its central role is to expose teaching period records together with the calendar instance and calendar category context in which they operate, making it suitable for operational reports, concurrent program outputs, and inbound/outbound integration extracts that require legible period data. The user search term cal_cat maps directly to the CALENDAR_CATEGORY column, which is derived from the CAL_CAT lookup alias defined in the view text.

Underlying Base Objects

The view is defined over four physical tables and joins them on coded keys:

The join between TP and CI is an equi-join on both SEQUENCE_NUMBER and CAL_TYPE, so each teaching period row is matched to exactly the calendar instance it belongs to. No base objects are separately documented in the ETRM metadata beyond what the view text shows.

Key Columns

  • ROW_ID — the ROWID of the underlying teaching period row, useful for direct-table correlation.
  • TEACHING_PERIOD_ID — primary identifier of the teaching period record.
  • PERSON_ID / PERSON_NUMBER — the person associated with the period; PERSON_NUMBER is returned as a NULL placeholder in the view definition.
  • CAL_TYPE / SEQUENCE_NUMBER — the calendar type and instance sequence keys linking the period to its calendar.
  • ALTERNATE_CODE / CALENDAR_DESC — the calendar instance's alternate code and description.
  • TEACH_PERIOD_RESID_STAT_CD / RES_STATUS_DESC — residual status code and its decoded meaning from lookup PE_TEA_PER_RES.
  • CALENDAR_CATEGORY — the decoded calendar category (the "cal_cat" the user searched for), resolved from LOOKUP_TYPE 'CAL_CAT' against IGS_CA_TYPE.S_CAL_CAT.
  • START_DATE / END_DATE — returned as NULL placeholders (TO_DATE(NULL)) in this view version.

Common Use Cases and Queries

Typical usage includes listing teaching periods by calendar category, reporting residual statuses for a person, and joining the view to other student records. A representative query filtering on the calendar category is:

  • SELECT teaching_period_id, person_id, calendar_desc, calendar_category, res_status_desc FROM apps.igs_pe_teach_periods_v WHERE calendar_category = :category;
  • SELECT person_id, cal_type, sequence_number, calendar_desc FROM apps.igs_pe_teach_periods_v WHERE person_id = :person_id;
  • SELECT calendar_category, COUNT(*) FROM apps.igs_pe_teach_periods_v GROUP BY calendar_category;

Because the view exposes decoded lookup meanings, it is well suited for reporting layers, BI Publisher data templates, and integration extracts where calendar category and residual status must appear in business terminology rather than internal codes.