Search Results igs_ps_pat_of_study




Overview
Explore in AI Chat

Overview

The IGS_PS_PAT_OF_STUDY table is a core entity within the Oracle E-Business Suite Student System (IGS) module, specifically in releases 12.1.1 and 12.2.2. It formally defines a Pattern of Study (POS), which is a structured template for how a student can undertake a specific program offering. A pattern of study maps the academic load, attendance mode, location, and other administrative parameters over the defined calendar periods of a course version. This table is essential for enforcing academic policy, enabling accurate enrollment planning, and ensuring that student progression aligns with the institution's approved program structures.

Key Information Stored

The table's primary key uniquely identifies a pattern of study for a specific program offering, consisting of COURSE_CD (the program code), VERSION_NUMBER, CAL_TYPE (the calendar type for the offering), and a SEQUENCE_NUMBER. Critical descriptive and referential columns include ATTENDANCE_MODE and ATTENDANCE_TYPE, which define the method of participation (e.g., full-time, part-time, on-campus, distance). The ADMISSION_CAT and LOCATION_CD columns link to the admission category and physical location for the study pattern. The table also maintains links to the academic calendar via CAL_TYPE and APRVD_CI_SEQUENCE_NUMBER (approved calendar instance) and ADMISSION_CAL_TYPE, which govern the applicable teaching periods and admission timelines for the pattern.

Common Use Cases and Queries

This table is central to operations involving program setup, student enrollment validation, and academic reporting. A common use case is retrieving all valid patterns of study for a prospective student based on their chosen program, version, and intended attendance mode to present enrollment options. Administrators may query the table to audit or report on the study patterns linked to a specific course offering. A typical SQL pattern involves joining to related setup tables to get a comprehensive view.

  • Listing patterns for a course offering: SELECT * FROM igs_ps_pat_of_study WHERE course_cd = 'BSC001' AND version_number = 1 AND cal_type = 'SEMESTER';
  • Reporting on patterns with descriptive values: SELECT pos.course_cd, pos.version_number, pos.sequence_number, am.attendance_mode, at.attendance_type FROM igs_ps_pat_of_study pos JOIN igs_en_atd_mode_all am ON pos.attendance_mode = am.attendance_mode JOIN igs_en_atd_type_all at ON pos.attendance_type = at.attendance_type WHERE pos.location_cd = 'MAIN_CAMPUS';

Related Objects

The IGS_PS_PAT_OF_STUDY table has integral relationships with several key setup and transactional tables in the Student System, as documented by its foreign key constraints.