Search Results igs_pr_stdnt_pr_ps




Overview
Explore in AI Chat

Overview

The table IGS_PR_STDNT_PR_PS is a core data entity within the Oracle E-Business Suite Student System (IGS) module, versions 12.1.1 and 12.2.2. It serves a critical function in managing student academic progression and probationary statuses. Specifically, this table stores records that define the academic programs (courses) a student is mandated to enroll in as a direct consequence of failing a progression rule. It acts as a junction table, linking a student's specific probationary outcome to the required corrective course of study, thereby formally documenting the conditions of their probation within the system.

Key Information Stored

The table's structure is designed to uniquely identify a probation requirement for a student within a specific program sequence. Its primary key is a composite of three columns, establishing a direct link to the student's probation record. The key columns and their significance are:

  • PERSON_ID: The unique identifier for the student placed on probation.
  • SPO_COURSE_CD: The code of the course (program) in which the student incurred the probation.
  • SPO_SEQUENCE_NUMBER: A sequence number identifying the specific probation occurrence within the aforementioned course.
  • COURSE_CD: A critical foreign key column that stores the code for the program the student is now required to enroll in as part of their probation terms. This is the mandated course of study linked to the probation outcome.

Common Use Cases and Queries

This table is central to administrative processes and reporting related to academic standing. A primary use case is generating a list of all students currently on probation and the specific programs they must undertake. For example, an advisor may query for a specific student to review their probation requirements. A typical reporting query would join this table with person and course detail tables.

Sample Query: To retrieve details of probation-mandated courses for a student, one might use:
SELECT spp.PERSON_ID, spp.COURSE_CD AS REQUIRED_COURSE, c.COURSE_TITLE
FROM IGS_PR_STDNT_PR_PS spp,
IGS_PS_COURSE c
WHERE spp.COURSE_CD = c.COURSE_CD
AND spp.PERSON_ID = :student_id;
This table is also essential for batch processes that validate student enrollment against their probation conditions, ensuring compliance with academic policies.

Related Objects

IGS_PR_STDNT_PR_PS maintains integral relationships with other key entities in the Student System schema. Its foreign key constraints explicitly define these dependencies:

  • IGS_PR_STDNT_PR_OU_ALL: This is the parent table for student probation outcomes. The composite foreign key (PERSON_ID, SPO_COURSE_CD, SPO_SEQUENCE_NUMBER) in IGS_PR_STDNT_PR_PS references this table, linking each mandated course to its originating probation decision.
  • IGS_PS_COURSE: This table contains the master definition of all academic programs. The COURSE_CD foreign key in IGS_PR_STDNT_PR_PS references IGS_PS_COURSE, ensuring the mandated program is valid and providing access to its descriptive attributes (title, version, etc.).

Consequently, any processes, forms, or reports concerning student probation and mandated enrollment will typically involve joins across these three core tables.