Search Results fte_cal_type




Overview
Explore in AI Chat

Overview

IGS_HE_FTE_CAL_PRD_V is a reporting view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. It presents Full-Time Equivalent (FTE) calculation periods alongside their associated teaching calendar periods, exposing a denormalized result set suitable for reporting, extracts, and integration interfaces. The view is documented as VALID in ETRM for releases 12.1.1 and 12.2.2 and is described as "Stores FTE calculation period." Because FTE processing in the Student System must be aligned to both the calendar period used to measure FTE load and the teaching calendar during which instruction actually occurs, this view removes the need for consumers to join three separate tables themselves, presenting a single row per FTE calculation period with resolved calendar names and date boundaries. This makes the view a convenient source for FTE reporting, calendar validation, and downstream data warehouse loads.

Underlying Base Objects

The view is defined over three underlying objects:

  • IGS_HE_FTE_CAL_PRD — aliased as A; the primary FTE calculation period entity, supplying the FTE calendar type, FTE sequence number, teaching calendar type, teaching sequence number, and standard WHO audit columns.
  • IGS_CA_INST — aliased as B; the calendar instance for the FTE calendar, supplying the alternate code (used as the FTE calendar name) and the start and end dates of the FTE period.
  • IGS_CA_INST — aliased as C; the calendar instance for the teaching calendar, supplying the alternate code and the teaching period start and end dates.

The join predicates match calendar type and sequence number for both the FTE calendar (A to B) and the teaching calendar (A to C). ROWID from IGS_HE_FTE_CAL_PRD is exposed as ROW_ID, giving each row a stable identifier derived from the base FTE period record.

Key Columns

Common Use Cases and Queries

Typical usage includes reporting FTE periods by teaching start date, validating that teaching and FTE periods are correctly aligned, and feeding FTE calculation results into extracts or downstream systems.

  • List all FTE periods with their teaching start dates: SELECT fte_cal_type, fte_sequence_num, fte_cal_name, teach_cal_type, teach_sequence_num, teach_cal_name, teach_start_dt, teach_end_dt FROM igs_he_fte_cal_prd_v ORDER BY teach_start_dt;
  • Filter by a specific teaching start date (the common search term): SELECT * FROM igs_he_fte_cal_prd_v WHERE teach_start_dt = TO_DATE('2024-09-01','YYYY-MM-DD');
  • Find FTE periods whose teaching period begins within an academic year: SELECT fte_cal_type, fte_sequence_num, teach_cal_name, teach_start_dt FROM igs_he_fte_cal_prd_v WHERE teach_start_dt BETWEEN TO_DATE('2024-08-01','YYYY-MM-DD') AND TO_DATE('2025-07-31','YYYY-MM-DD');
  • Compare FTE and teaching period boundaries: SELECT fte_cal_name, teach_cal_name, fte_start_dt, teach_start_dt, fte_end_dt, teach_end_dt FROM igs_he_fte_cal_prd_v;

Because the view is read-only and derives entirely from its base tables, no maintenance or DML operations apply; consumers should treat it as a query-only reporting object for the Student System.