Search Results igs_ps_ofr_all




Overview
Explore in AI Chat

Overview

The IGS_PS_OFR_ALL table is a core data entity within the Oracle E-Business Suite Student System (IGS), specifically in releases 12.1.1 and 12.2.2. It serves as the master table for defining and managing the offering of an academic program (course) within a specific academic calendar type. An offering represents a scheduled instance of a program, linking the program's definition to the temporal structure (calendar) in which it is available for enrollment. This table is fundamental to the academic structure, enabling the university to manage multiple intakes or offerings of the same program across different terms, semesters, or other calendar periods. Its 'ALL' suffix indicates it is a multi-organization table, capable of storing data partitioned by operating unit.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies each program offering. The key columns are COURSE_CD (the code identifying the academic program), VERSION_NUMBER (the specific version of that program), and CAL_TYPE (the academic calendar type, such as 'SEMESTER' or 'QUARTER', in which the program is offered). Beyond the key, the table typically stores descriptive and control attributes for the offering. While the provided metadata does not list all columns, common attributes in such an entity include offering status (e.g., Active, Inactive), start and end dates for the offering within the calendar, location codes, attendance mode, and various system control columns like CREATION_DATE, LAST_UPDATE_DATE, and ORG_ID for multi-org support.

Common Use Cases and Queries

This table is central to numerous academic operations and reports. A primary use case is the setup and maintenance of program availability for student admissions and enrollment cycles. System administrators use this table to define which program versions are offered in which upcoming academic periods. Common reporting needs include listing all active offerings for a given term or generating a catalog of available programs. Sample SQL to retrieve active offerings for a specific calendar would leverage joins to the program (IGS_PS_VER_ALL) and calendar (IGS_CA_TYPE) tables:

  • SELECT ofr.course_cd, ofr.version_number, ver.title, ofr.cal_type FROM igs_ps_ofr_all ofr JOIN igs_ps_ver_all ver ON (ofr.course_cd = ver.course_cd AND ofr.version_number = ver.version_number) WHERE ofr.cal_type = '&CAL_TYPE' AND ofr.status = 'ACTIVE';

Another critical use case is enforcing data integrity in downstream processes like creating program patterns (IGS_PS_PAT_OF_STUDY) or unit sets (IGS_PS_OFR_UNIT_SET), which must reference a valid program offering.

Related Objects

The IGS_PS_OFR_ALL table sits at the center of a significant relational hierarchy within the Student System, as evidenced by its foreign key relationships. It is a child of IGS_PS_VER_ALL (Program Version) and IGS_CA_TYPE (Calendar Type). Crucially, it acts as a parent table to numerous other entities that define the specifics of an offering. Key child tables include:

These relationships underscore the table's role as the anchor point for all configuration and operational data pertaining to a specific instance of a program.