Search Results igs_pe_course_excl_u1

Overview

The IGS_PE_COURSE_EXCL table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the Student System (often part of the Campus Solutions or Oracle Student Management product). It serves as the definitive repository for recording program-level exclusions associated with a student's institutional encumbrance or hold. The table's primary role is to enforce business rules that prevent a student from being admitted to or enrolled in specific academic programs due to an active hold condition, such as a financial or disciplinary block. Each record represents a single program exclusion linked to a specific person, encumbrance type, and its associated system effect, forming a detailed audit trail of exclusionary actions.

Key Information Stored

The table stores a combination of identifying keys, descriptive data, and audit information. The primary key is a composite of eight columns, precisely linking the exclusion to its parent encumbrance effect. Critical columns include:

• PERSON_ID: The unique identifier for the student or applicant subject to the exclusion.
• ENCUMBRANCE_TYPE and PEN_START_DT: Define the specific hold type and its effective date on the person.
• S_ENCMB_EFFECT_TYPE, PEE_START_DT, and PEE_SEQUENCE_NUMBER: Uniquely identify the precise system hold effect (e.g., "Exclusion from Program") applied under the parent encumbrance.
• COURSE_CD: The code of the academic program from which the person is excluded.
• PCE_START_DT: The date the program exclusion itself became effective, which is the specific column referenced in the user's search.
• EXPIRY_DT: The date the exclusion expires; a NULL value indicates the exclusion remains current.
• Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for audit purposes.

Common Use Cases and Queries

This table is central to processes that validate student eligibility for program admission and enrollment. A common operational report lists all current program exclusions for a student to guide academic advising. System processes query this table to block enrollment transactions programmatically. A typical query to find active exclusions for a specific person would filter on PERSON_ID and a null or future EXPIRY_DT. For instance, to audit exclusions related to a particular encumbrance type that became effective within a date range, one would join on the key columns and filter using PCE_START_DT. The unique index IGS_PE_COURSE_EXCL_U1 outlines the optimal columns for such joins and queries.

Related Objects

IGS_PE_COURSE_EXCL is not a standalone object; it is a child table within a larger encumbrance data model. The documented foreign key relationships are essential for accurate joins and data integrity:

• References IGS_PE_PERSENC_EFFCT: This is the primary parent relationship. The columns PERSON_ID, ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, and PEE_SEQUENCE_NUMBER in IGS_PE_COURSE_EXCL together reference the person encumbrance effect record that spawned this specific program exclusion.
• References IGS_PS_COURSE: The COURSE_CD column references the IGS_PS_COURSE table, which stores the master definition of the academic program from which the student is excluded.

These relationships ensure that every program exclusion is validly attached to an existing encumbrance effect and a defined academic program.