Search Results igs_ps_ofr_inst




Overview
Explore in AI Chat

Overview

The table IGS_PS_OFR_INST is a core entity within the now-obsolete Oracle E-Business Suite Student System (IGS). Its primary function is to model the specific temporal offerings of an academic program. It establishes a critical link between a defined program (course) and the concrete calendar instances in which that program is available for enrollment. This table enables the system to manage which academic terms or periods a particular program version is active and offered, forming a foundational part of scheduling and program planning. The provided metadata explicitly notes this table is "Not implemented in this database," indicating it may exist as a reference or legacy object in some installations but is not actively used in the standard product for the referenced versions (12.1.1 / 12.2.2).

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies each program offering instance. The key columns are COURSE_CD (the code identifying the academic program), VERSION_NUMBER (the specific version of that program), CAL_TYPE (the type of calendar, such as 'SEMESTER' or 'QUARTER'), and CI_SEQUENCE_NUMBER (a sequence identifying a specific instance within that calendar type). While the full column list is not provided in the excerpt, the foreign key relationships imply the table also contains at least CI_START_DT and CI_END_DT columns, which would store the start and end dates for that particular calendar instance as it relates to the program offering.

Common Use Cases and Queries

In an active implementation, this table would be central to queries determining program availability. Common use cases would include generating catalogs of programs offered in a given term, validating student enrollment against active offering periods, and planning academic schedules. A typical reporting query might join this table to program details and calendar tables to list all available programs for an upcoming semester.

SELECT prog.course_cd,
       prog.title,
       inst.cal_type,
       inst.ci_sequence_number,
       inst.ci_start_dt,
       inst.ci_end_dt
FROM   igs_ps_ofr_inst inst,
       igs_ps_ofr_all prog
WHERE  inst.course_cd = prog.course_cd
AND    inst.version_number = prog.version_number
AND    inst.cal_type = '&CALENDAR_TYPE'
AND    SYSDATE BETWEEN inst.ci_start_dt AND inst.ci_end_dt;

Related Objects

Based on the documented foreign key relationships, IGS_PS_OFR_INST has defined dependencies with the following key tables:

  • IGS_PS_OFR_ALL: The master table for program (course) offerings. The join is on COURSE_CD, VERSION_NUMBER, and CAL_TYPE, establishing the base program definition to which an instance belongs.
  • IGS_CA_INST_ALL: The table for calendar instances. The join uses CAL_TYPE, CI_SEQUENCE_NUMBER, CI_START_DT, and CI_END_DT, linking the program offering to a specific dated period in the academic calendar.
  • IGS_PS_OFR_PAT: Likely a table for program offering patterns. It references IGS_PS_OFR_INST via its primary key columns (COURSE_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER), suggesting that patterns of study are defined per offering instance.