Search Results acad_period_num

Overview

The IGS_PS_PAT_STUDY_PRD table is a core data object within the Oracle E-Business Suite Student System (iCampus/PeopleSoft Enterprise). It functions as a detailed schedule builder, defining the chronological teaching periods that constitute a Pattern of Study. A Pattern of Study is a template for a student's academic progression within a specific program (course). This table decomposes a pattern into its constituent academic periods (e.g., Year 1, Year 2) and further specifies the teaching calendar type (e.g., Semester 1, Trimester 2) applicable for each period. Its primary role is to provide the temporal framework against which specific course units are assigned within the IGS_PS_PAT_STUDY_UNT table, enabling structured academic planning and pre-enrollment.

Key Information Stored

The table's structure captures the relationship between a program, its study pattern, and the academic timeline. The composite primary key uniquely identifies each teaching period record. Critical columns include:

• COURSE_CD, VERSION_NUMBER, CAL_TYPE, POS_SEQUENCE_NUMBER: Together, these foreign key columns link the record to its parent Pattern of Study (IGS_PS_PAT_OF_STUDY).
• SEQUENCE_NUMBER: A mandatory numeric identifier that uniquely sequences the periods within a single pattern.
• ACAD_PERIOD_NUM: Represents the academic year (e.g., 1 for first year, 2 for second year) within the overall pattern.
• TEACH_CAL_TYPE: A foreign key to IGS_CA_TYPE, specifying the teaching period (e.g., 'SEMESTER1', 'TRIMESTER') within the academic year number.
• DESCRIPTION: A user-friendly label for the period, such as 'Year 1 - Semester 1'.

The column POS_SEQUENCE_NUMBER, as indicated in the user's search context, is specifically the sequence number of the parent Pattern of Study itself, within which this period record exists.

Common Use Cases and Queries

This table is central to queries involving academic program structures and enrollment planning. A common use case is retrieving the complete timeline for a specific program pattern to understand its structure or to validate unit assignments. For example, to list all teaching periods for a given program pattern, one might execute:

SELECT sequence_number, acad_period_num, teach_cal_type, description
FROM igs.igs_ps_pat_study_prd
WHERE course_cd = :p_course_cd
AND version_number = :p_version_number
AND cal_type = :p_cal_type
AND pos_sequence_number = :p_pos_seq_num
ORDER BY sequence_number;

Another critical use case is joining this table to IGS_PS_PAT_STUDY_UNT to report all units scheduled for a specific academic period within a pattern. This supports curriculum management and audit reports to ensure program requirements are met across the defined study timeline.

Related Objects

The IGS_PS_PAT_STUDY_PRD table sits at the intersection of program patterns and scheduled units, with defined foreign key relationships as per the ETRM metadata.

• Parent Object (Referenced by): IGS_PS_PAT_OF_STUDY table. The columns (COURSE_CD, VERSION_NUMBER, CAL_TYPE, POS_SEQUENCE_NUMBER) in IGS_PS_PAT_STUDY_PRD reference this table to define the parent pattern.
• Referenced Object: IGS_CA_TYPE table. The TEACH_CAL_TYPE column references this table to validate the teaching calendar type.
• Child Object (Referencing this table): IGS_PS_PAT_STUDY_UNT table. This table references IGS_PS_PAT_STUDY_PRD (via COURSE_CD and other key columns) to assign specific course units to the teaching periods defined here.