Search Results pos_sequence_number

Overview

The table IGS_PS_PAT_STUDY_PRD is a core data entity within the Oracle E-Business Suite Student System (IGS), specifically in the context of the now-obsolete module. It functions as a child table within the academic program structure, defining the individual study periods that constitute a broader pattern of study. A pattern of study outlines the planned sequence of academic periods (e.g., semesters, terms) for a student enrolled in a specific course version. This table provides the granular detail for that pattern, mapping each sequential period to a specific teaching calendar type. Its primary role is to establish the temporal framework against which specific course units are scheduled within a student's academic plan.

Key Information Stored

The table stores the composite structure of an academic study pattern. Its primary key is a five-column combination that uniquely identifies each period within a pattern. The key columns are COURSE_CD and VERSION_NUMBER, which link to the parent pattern of study; CAL_TYPE and POS_SEQUENCE_NUMBER, which further identify the specific parent pattern; and SEQUENCE_NUMBER, which orders the periods within that pattern. A critical data column is TEACH_CAL_TYPE, which references the IGS_CA_TYPE table to define the academic calendar (e.g., 'SEMESTER', 'TRIMESTER') applicable to that specific study period. This design allows a single pattern of study to span different calendar types across its duration.

Common Use Cases and Queries

This table is central to queries that analyze or report on the planned structure of academic programs. A common use case is generating a timeline of study periods for a given course and version. For example, to list all study periods for a specific pattern, one would query using the parent pattern's identifiers. Another critical use case is supporting the scheduling of course units (via IGS_PS_PAT_STUDY_UNT) by providing the valid period sequence into which units can be placed. A typical reporting query would join this table with the parent IGS_PS_PAT_OF_STUDY and the calendar type table to produce a human-readable study plan.

SELECT prd.course_cd,
       prd.version_number,
       prd.sequence_number,
       prd.teach_cal_type,
       ct.description
FROM igs_ps_pat_study_prd prd
JOIN igs_ca_type ct ON prd.teach_cal_type = ct.cal_type
WHERE prd.course_cd = '&course_code'
  AND prd.version_number = &version_num
  AND prd.cal_type = '&cal_type'
  AND prd.pos_sequence_number = &pos_seq_num
ORDER BY prd.sequence_number;

Related Objects

The IGS_PS_PAT_STUDY_PRD table sits at the center of key relationships within the student system's program structure. It is a direct child of the IGS_PS_PAT_OF_STUDY table, inheriting its identity via the foreign key on (COURSE_CD, VERSION_NUMBER, CAL_TYPE, POS_SEQUENCE_NUMBER). It references the IGS_CA_TYPE table through the TEACH_CAL_TYPE column to validate the calendar type for each period. Most importantly, it acts as a parent table to IGS_PS_PAT_STUDY_UNT, which stores the specific units of study assigned to each defined period. The foreign key from IGS_PS_PAT_STUDY_UNT links on all five primary key columns of IGS_PS_PAT_STUDY_PRD (COURSE_CD, VERSION_NUMBER, CAL_TYPE, POS_SEQUENCE_NUMBER, POSP_SEQUENCE_NUMBER), ensuring that every scheduled unit is attached to a valid, pre-defined study period.