Search Results igs_ps_usec_prv_grad_u1

Overview

IGS.IGS_PS_USEC_PRV_GRAD is a transactional table within the Oracle E-Business Suite Student Systems (IGS) schema. It describes the relationship between unit sections and the previous grades that qualify a student for repeat enrolment in that unit section. In practical terms, the table records which prior grading outcomes are accepted as prerequisites for repeating a unit offering option, linking a specific unit section (UOO_ID) to a grading schema value that the student previously earned.

The table resides in the APPS_TS_ARCHIVE tablespace, which is consistent with its role as a reference or configuration-style entity that changes infrequently and is therefore a candidate for archival in a multi-tier storage strategy. The object carries standard Oracle Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and is designated VALID in the ETRM 12.1.1 documentation, with the same definition applicable to 12.2.2.

From a Data Vault modeling perspective, the metadata heuristics classify this object as a link. This is a modelling suggestion rather than a documented fact: the table sits between two parent entities — a unit offering option and a grading schema — and its structure is essentially a relationship record carrying the qualifying grade value. A link classification is appropriate because the table primarily resolves a many-to-many-style association between unit sections and acceptable prior grades, rather than acting as a descriptive hub or a change-tracking satellite.

Key Information Stored

The table contains ten documented columns. The most significant are:

• UNIT_SECTION_PREV_GRADE_ID — A NUMBER surrogate primary key that uniquely identifies each relation between a unit section and a previous grade qualifying for repeat. It is the single column forming the primary key (IGS_PS_USEC_PRV_GRAD_PK) and the unique index IGS_PS_USEC_PRV_GRAD_U1.
• UOO_ID — The unique identifier for the unit section (unit offering option). This is the foreign key to IGS_PS_UNIT_OFR_OPT_ALL and establishes which offering the rule applies to.
• GRADING_SCHEMA_CODE — A VARCHAR2(10) code for the grading schema used in the previous grade. It participates in the foreign key relationship to IGS_AS_GRD_SCH_GRADE.
• GRADING_SCHEMA_VERSION_NUMBER — The numeric version of the grading schema in effect for the prior grade, allowing version-aware qualifying rules.
• GRADING_SCHEMA_VALUE — The actual grading schema value (for example, a specific grade letter or mark band) that qualifies the student for repeat.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Who audit columns capturing row creation and last modification metadata.

Two unique indexes are documented. IGS_PS_USEC_PRV_GRAD_U1 enforces uniqueness on the surrogate key UNIT_SECTION_PREV_GRADE_ID alone. IGS_PS_USEC_PRV_GRAD_U2 enforces a composite business-key uniqueness constraint across UOO_ID, GRADING_SCHEMA_CODE, GRADING_SCHEMA_VERSION_NUMBER, and GRADING_SCHEMA_VALUE — ensuring that a given unit section cannot have duplicate qualifying grade definitions for the same schema, version, and value. The composite index is the true business-key candidate; the surrogate key is the technical identifier.

Common Use Cases and Queries

The primary use case is identifying, for a given unit offering option, which prior grades allow a student to repeat the unit. Administrators and student systems developers query this table when configuring or auditing repeat-enrolment rules. A typical query returns all qualifying grades for a specific unit section:

• SELECT UNIT_SECTION_PREV_GRADE_ID, UOO_ID, GRADING_SCHEMA_CODE, GRADING_SCHEMA_VERSION_NUMBER, GRADING_SCHEMA_VALUE FROM IGS.IGS_PS_USEC_PRV_GRAD WHERE UOO_ID = :p_uooid;
• Joining to IGS_PS_UNIT_OFR_OPT_ALL on UOO_ID to retrieve unit section descriptive attributes alongside the qualifying grade rules.
• Joining to IGS_AS_GRD_SCH_GRADE on GRADING_SCHEMA_CODE to resolve the grading schema description for reporting.
• Referential integrity audits that detect grade values configured for a unit section whose grading schema is no longer valid.

Reporting scenarios include repeat-enrolment eligibility exports, regulatory extracts showing which grades trigger repeat rights, and validation of configuration against institutional grading policy. Because the table is small and archive-tiered, full-table scans are inexpensive relative to transactional IGS tables, though queries should still filter on UOO_ID to leverage the U2 index.

Related Objects

The following objects are the most significant related entities based on documented dependency and key relationships:

• IGS.IGS_PS_UNIT_OFR_OPT_ALL — Referenced by the UOO_ID foreign key. This is the parent unit offering option entity, the primary join target for resolving which unit section a qualifying grade rule belongs to.
• IGS.IGS_AS_GRD_SCH_GRADE — Referenced by GRADING_SCHEMA_CODE. Provides the grading schema description and validation for the prior grade values.
• APPS.IGS_PS_USEC_PRV_GRAD — The APPS-layer synonym or view that exposes the IGS table to application code; documented as referencing the base object.
• IGS_PS_USEC_PRV_GRAD_PK — The primary key constraint over UNIT_SECTION_PREV_GRADE_ID.
• IGS_PS_USEC_PRV_GRAD_U1 and IGS_PS_USEC_PRV_GRAD_U2 — The unique indexes enforcing surrogate and business-key uniqueness respectively.

The ETRM documentation states that IGS_PS_USEC_PRV_GRAD does not reference any database object beyond those noted and is referenced only by the APPS-layer object. Application logic in the Student Systems repeat-enrolment and progression modules is the principal consumer of this table.