Search Results igs_pr_stdnt_pr_unit

Overview

The table IGS_PR_STDNT_PR_UNIT is a core data object within the Oracle E-Business Suite Student System (IGS), specifically designed to manage academic progression. It represents the specific course units a student is mandated to enroll in as a direct consequence of being placed on probation for failing a defined progression rule. This table functions as a child entity, detailing the prescribed remedial coursework linked to a student's probation outcome. Its role is to formally record the academic requirements imposed to address performance deficiencies, ensuring a structured path for the student to regain good standing. It is critical to note that the provided metadata explicitly labels the IGS - Student System module as "Obsolete," indicating this table pertains to a legacy implementation within the EBS suite.

Key Information Stored

The table's structure centers on uniquely identifying a student's probation record and the associated mandated unit. The primary key is a composite of four columns, ensuring a unique record for each unit assigned to a specific probation instance. The key columns are:

• PERSON_ID: Identifies the student.
• COURSE_CD: The code for the course of study in which the probation was applied.
• SPO_SEQUENCE_NUMBER: A sequence number linking to the specific student probation outcome (SPO) record.
• UNIT_CD: The code of the unit the student is required to undertake.

Together, these columns create a direct link between a disciplinary academic action and the concrete, unit-level academic requirement levied upon the student.

Common Use Cases and Queries

This table supports administrative and reporting functions related to academic probation management. A primary use case is generating a list of all mandated units for students currently on probation within a given term or course, which is essential for academic advising and enrollment verification. Another scenario involves auditing to ensure students have successfully completed the required probationary units as a condition for clearing their probation status. A typical query would join this table with student and unit master tables to produce a readable report.

Sample Query Pattern:
SELECT spu.person_id, spu.unit_cd, u.unit_name, spo.probation_start_date
FROM igs_pr_stdnt_pr_unit spu,
igs_pr_stdnt_pr_ou_all spo,
igs_ps_unit u
WHERE spu.person_id = spo.person_id
AND spu.course_cd = spo.course_cd
AND spu.spo_sequence_number = spo.sequence_number
AND spu.unit_cd = u.unit_cd
AND spo.probation_status = 'ACTIVE';

Related Objects

IGS_PR_STDNT_PR_UNIT maintains critical foreign key relationships with two primary tables, as documented in the ETRM metadata. Its existence is wholly dependent on the parent probation record and the valid unit definition.

• IGS_PR_STDNT_PR_OU_ALL: This is the primary parent table. The foreign key (PERSON_ID, COURSE_CD, SPO_SEQUENCE_NUMBER) links each mandated unit to a specific Student Probation Outcome record, which contains the overarching details of the probation.
• IGS_PS_UNIT: The foreign key on UNIT_CD ensures that the mandated unit code is a valid, defined unit within the institution's curriculum catalog.

The metadata also states the table is "Not implemented in this database," which may indicate it was part of a documented data model but not physically instantiated in all deployments, or that it has been superseded in later configurations.