Search Results igs_ps_pat_of_study_n2

Overview

The IGS_PS_PAT_OF_STUDY table is a core entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Student Management (Campus Solutions) module. It defines a pattern of study, which is a specific academic structure applied to a program offering (course and version). This table is fundamental for configuring how a student's academic progression is mapped against calendar periods, effectively linking a program to a specific academic calendar type and sequence. It serves as a critical configuration point for managing program attempts, enabling institutions to define different study patterns based on location, attendance mode, and admission criteria.

Key Information Stored

The table's primary key uniquely identifies a pattern of study through four columns: COURSE_CD (program code), VERSION_NUMBER (program version), CAL_TYPE (academic calendar type), and SEQUENCE_NUMBER. The SEQUENCE_NUMBER allows for multiple distinct patterns for a single program offering. Key descriptive columns include LOCATION_CD, ATTENDANCE_MODE, and ATTENDANCE_TYPE, which act as filters to restrict the pattern's applicability to student program attempts that match these attributes. Notably, the ADMISSION_CAL_TYPE column, which was highlighted in the user's search, is present and has a non-unique index (IGS_PS_PAT_OF_STUDY_N2). This column typically references the calendar type used for the admission process associated with this study pattern.

Common Use Cases and Queries

A primary use case is retrieving the valid study patterns for a specific program offering to present enrollment options to a student or advisor. Another common scenario involves administrative reporting to list all patterns of study configured for a particular admission calendar or location. For instance, to find all study patterns linked to a specific admission calendar type, a query would leverage the indexed ADMISSION_CAL_TYPE column:

• SELECT course_cd, version_number, cal_type, sequence_number FROM igs.igs_ps_pat_of_study WHERE admission_cal_type = :p_adm_cal_type;

To identify the default or applicable pattern for a student's program attempt based on their specific attributes, a query would join on COURSE_CD, VERSION_NUMBER, and CAL_TYPE, while filtering on the optional LOCATION_CD, ATTENDANCE_MODE, and ATTENDANCE_TYPE columns to find the most precise match.

Related Objects

The IGS_PS_PAT_OF_STUDY table sits at the center of a relational network within the IGS schema. It is a child of the program offering (IGS_PS_OFR_ALL) and references numerous foundational code tables via foreign keys. Key documented relationships include:

• Parent Tables (Foreign Key References): IGS_PS_OFR_ALL (COURSE_CD, VERSION_NUMBER), IGS_CA_INST_ALL (CAL_TYPE), IGS_CA_TYPE (ADMISSION_CAL_TYPE), IGS_AD_CAT_ALL (ADMISSION_CAT), IGS_EN_ATD_MODE_ALL (ATTENDANCE_MODE), IGS_EN_ATD_TYPE_ALL (ATTENDANCE_TYPE), IGS_AD_LOCATION_ALL (LOCATION_CD).
• Child Table (Referenced by): IGS_PS_PAT_STUDY_PRD (via COURSE_CD, VERSION_NUMBER, CAL_TYPE, SEQUENCE_NUMBER), which stores the detailed period structure of the study pattern.

These relationships enforce data integrity and ensure that patterns of study are built upon valid, configured institutional codes and master data.