Results for “igs_pr_sdt_pr_unt_st”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_PR_SDT_PR_UNT_ST table is a core component of the Oracle E-Business Suite Student System (IGS) module, which supports the management of academic records, program enrollments, and course registrations in higher-education institutions. This table stores unit sets from which a student will be excluded in a specific course attempt. In practical terms, it defines exclusion rules governing which instructional or curricular unit sets a student cannot enrol in when undertaking a particular course, thereby supporting progression rules, prerequisite enforcement, and academic eligibility checking.

From a Data Vault modeling perspective (a heuristic classification mined from the foreign key structure), this object behaves as a link. It sits between the student's program/course attempt record and the unit set definition, resolving the many-to-many-style relationship between a student's course attempt and the unit sets that must be excluded. As a link, it carries the keys that connect these two hubs rather than descriptive attributes about either entity in isolation.

Key Information Stored

The table is owned by the IGS schema and contains 10 documented columns. The most significant are the composite primary key and business key columns identified below.

• PERSON_ID — identifies the student whose course attempt carries the exclusion. This is the first component of both the primary key and the unique business key, and it also forms part of the foreign key to IGS_PR_STDNT_PR_OU_ALL.
• COURSE_CD — the code of the course attempt to which the exclusion applies. Together with PERSON_ID and SPO_SEQUENCE_NUMBER it identifies the specific student-program-offering attempt.
• SPO_SEQUENCE_NUMBER — the sequence number uniquely identifying the student program offering attempt within the student's record.
• UNIT_SET_CD — the code of the unit set that is to be excluded from the course attempt. This column forms part of the foreign key to IGS_EN_UNIT_SET_ALL.
• VERSION_NUMBER — the version of the referenced unit set, allowing exclusions to be pinned to a specific version of the unit set definition.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns recording insert and update metadata for each row.

The surrogate primary key IGS_PR_SDT_PR_UNT_ST_PK is composed of PERSON_ID, COURSE_CD, SPO_SEQUENCE_NUMBER, UNIT_SET_CD, and VERSION_NUMBER. The unique index IGS_PR_SDT_PR_UNT_ST_U1 carries the same column set, which is a documented business-key candidate. Because the primary key columns are identical to the business key columns, the table does not employ a separate meaningless surrogate; the composite natural key serves both roles.

Common Use Cases and Queries

Typical use cases include validating a student's eligibility for a course attempt, reporting on exclusions for academic advising, and enforcing progression rules during registration. A common query retrieves all unit-set exclusions for a given student and course attempt:

• SELECT PERSON_ID, COURSE_CD, SPO_SEQUENCE_NUMBER, UNIT_SET_CD, VERSION_NUMBER FROM IGS.IGS_PR_SDT_PR_UNT_ST WHERE PERSON_ID = :p_person_id AND COURSE_CD = :p_course_cd;
• Joining to IGS_EN_UNIT_SET_ALL to obtain the description and details of each excluded unit set for reporting purposes.
• Joining to IGS_PR_STDNT_PR_OU_ALL to correlate exclusions with the student's program offering record.
• Extract queries for downstream student-record data marts, filtering by LAST_UPDATE_DATE for incremental loads.

Reporting scenarios frequently aggregate exclusions by unit set or course to identify rules with widespread impact, while integrity checks verify that every exclusion references a valid, current unit set version.

Related Objects

The following objects are most significant to IGS_PR_SDT_PR_UNT_ST, based on documented foreign key relationships:

• IGS_PR_STDNT_PR_OU_ALL — referenced via PERSON_ID, COURSE_CD, and SPO_SEQUENCE_NUMBER; the parent student program offering attempt record.
• IGS_EN_UNIT_SET_ALL — referenced via UNIT_SET_CD and VERSION_NUMBER; the unit set definition master, supplying the excluded unit sets.
• IGS_EN_UNIT_SET_ALL (versioned access) — joined on UNIT_SET_CD and VERSION_NUMBER for version-specific lookups.
• Related student progression and registration tables within the IGS Student System that share the PERSON_ID and COURSE_CD identifiers.

Because the table enforces foreign keys to these parents, DBA operations such as data cleanup or archival must respect the referential hierarchy; deleting a student program offering or unit set version will fail while dependent exclusion rows exist.