Search Results igs_ps_ofr_pat




Overview
Explore in AI Chat

Overview

The IGS_PS_OFR_PAT table is a core entity within the Oracle E-Business Suite Student System (IGS), now marked as obsolete. It serves as a junction table that defines the offering pattern for a specific program (course) offering option. Its primary role is to link a program offering option with a calendar instance, thereby specifying the precise temporal availability—such as the academic term or session—for that option. This table is essential for modeling when and where a particular program pathway, with its defined attendance mode and type, is offered within the institutional academic calendar.

Key Information Stored

The table stores composite identifiers that define a unique offering pattern. The primary key (IGS_PS_OFR_PAT_PK) is a combination of columns that identify the specific program offering instance and its attributes: COURSE_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, LOCATION_CD, ATTENDANCE_MODE, and ATTENDANCE_TYPE. A critical surrogate key is the COP_ID column, which serves as a unique identifier for each row and is the basis for the alternate unique key (IGS_PS_OFR_PAT_UK1). Other significant columns include COO_ID, which links to the parent offering option, and columns for associating a grading schema (GRADING_SCHEMA_CD, GS_VERSION_NUMBER) and an administrative contact person (ADM_CONTACT_PERSON_ID).

Common Use Cases and Queries

A primary use case is querying all available offering patterns for a specific program to support academic advising or enrollment planning. For instance, an administrator might need to list all the terms and locations where a Master's program is offered full-time. Given the user's search for "cop_id," a common query pattern involves retrieving a specific offering pattern record using this unique identifier for integration or data validation purposes.

  • Retrieve a specific pattern by COP_ID: SELECT * FROM IGS_PS_OFR_PAT WHERE cop_id = :p_cop_id;
  • List patterns for a program offering instance: SELECT cop_id, location_cd, attendance_mode FROM IGS_PS_OFR_PAT WHERE course_cd = :p_crs_cd AND version_number = :p_ver AND cal_type = :p_cal_type AND ci_sequence_number = :p_ci_seq;

Related Objects

The table maintains several documented foreign key relationships, integrating it deeply within the Student System's data model. Key related objects include:

  • IGS_PS_OFR_INST: Links to the parent program offering instance via COURSE_CD, VERSION_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER.
  • IGS_PS_OFR_OPT_ALL: Has two relationships. One links via the business key columns (COURSE_CD, VERSION_NUMBER, etc.), and another links directly via the COO_ID column.
  • IGS_AS_GRD_SCHEMA: Associates a grading schema via GRADING_SCHEMA_CD and GS_VERSION_NUMBER.
  • HZ_PARTIES: Identifies an administrative contact via ADM_CONTACT_PERSON_ID.
  • IGS_PS_OFR_PAT_NOTE: Child table storing notes; linked both by the composite primary key columns and by the COP_ID column.