Search Results igs_ps_usec_prv_grad_pk

Overview

IGS_PS_USEC_PRV_GRAD is a transactional table within the IGS (Student System) product family of Oracle E-Business Suite, present in both the 12.1.1 and 12.2.2 releases. The entity describes the relationship between unit sections and the previous grades that qualify a student to repeat a unit. In practical terms, it functions as a configuration or control table that constrains which prior grading outcomes permit a repeat attempt of a given unit offering option. The table resides in the IGS schema and is documented as VALID in the ETRM repository.

From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is link. This classification should be treated as a modeling suggestion rather than a directive: the table carries no descriptive attributes beyond the four WHO columns, and its payload is entirely composed of references that associate a unit offering option with a grading schema value. It therefore behaves as an associative or junction structure rather than an operational hub or a descriptive satellite.

Key Information Stored

The documented physical schema contains ten columns. The distinguishing columns are as follows.

• UNIT_SECTION_PREV_GRADE_ID — the surrogate primary key, enforced by the constraint IGS_PS_USEC_PRV_GRAD_PK and by the unique index IGS_PS_USEC_PRV_GRAD_U1. This identifier uniquely distinguishes each qualifying previous-grade record.
• UOO_ID — the unit offering option identifier, a foreign key to IGS_PS_UNIT_OFR_OPT_ALL. It anchors the record to the specific unit offering option whose repeat eligibility is being configured.
• GRADING_SCHEMA_CODE, GRADING_SCHEMA_VERSION_NUMBER, and GRADING_SCHEMA_VALUE — the composite reference to IGS_AS_GRD_SCH_GRADE, identifying the grading schema, its version, and the specific grade value that qualifies as a prior grade for repeat purposes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — the standard Oracle EBS audit (WHO) columns recording creation and last modification context.

The second unique index, IGS_PS_USEC_PRV_GRAD_U2, spans UOO_ID, GRADING_SCHEMA_CODE, GRADING_SCHEMA_VERSION_NUMBER, and GRADING_SCHEMA_VALUE. This is the business-key candidate: it enforces that a given unit offering option may register a specific qualifying grade combination only once. The surrogate key exists primarily for referential convenience, while the business key carries the true uniqueness semantics.

Common Use Cases and Queries

The principal use case is validation during enrolment and repeat processing: when a student attempts to re-enrol in a unit whose prior attempt resulted in a particular grade, the Student System consults this table to determine whether that grade qualifies for a repeat. Administrators and functional analysts also use it to audit or maintain repeat policy configuration for unit offerings.

A typical reporting query lists all qualifying prior grades for a given unit offering option, joining across the grading schema reference:

• SELECT p.UNIT_SECTION_PREV_GRADE_ID, p.UOO_ID, p.GRADING_SCHEMA_CODE, p.GRADING_SCHEMA_VERSION_NUMBER, p.GRADING_SCHEMA_VALUE FROM IGS.IGS_PS_USEC_PRV_GRAD p WHERE p.UOO_ID = :uooid;
• SELECT g.DESCRIPTION, p.GRADING_SCHEMA_VALUE FROM IGS.IGS_PS_USEC_PRV_GRAD p, IGS.IGS_AS_GRD_SCH_GRADE g WHERE p.GRADING_SCHEMA_CODE = g.GRADING_SCHEMA_CODE AND p.GRADING_SCHEMA_VERSION_NUMBER = g.GRADING_SCHEMA_VERSION_NUMBER AND p.GRADING_SCHEMA_VALUE = g.GRADING_SCHEMA_VALUE;

Common audit points include identifying orphaned UOO_ID values, detecting duplicated business-key combinations across systems, and comparing repeat-qualifying grade sets between academic periods following configuration migration.

Related Objects

The following objects are most significant, derived from documented foreign key relationships.

• IGS_PS_UNIT_OFR_OPT_ALL — referenced through UOO_ID; supplies the unit offering option context for each repeat-qualifying grade record.
• IGS_AS_GRD_SCH_GRADE — referenced through the composite of GRADING_SCHEMA_CODE, GRADING_SCHEMA_VERSION_NUMBER, and GRADING_SCHEMA_VALUE; defines the grade descriptions and validation against the grading schema.
• IGS_PS_USEC_PRV_GRAD_PK and IGS_PS_USEC_PRV_GRAD_U1 / U2 — the constraints and unique indexes that enforce integrity on the table itself.

Because the table sits within the enrolment and repeat-processing domain of the Student System, related views and APIs that read unit offering option configuration and grading schema definitions are the natural integration points for reporting and data migration work. Modifications should be made through supported Student System processes rather than by direct DML, so that WHO audit columns and downstream validation remain consistent.