Search Results igs_ps_unt_prv_grade




Overview
Explore in AI Chat

Overview

IGS_PS_UNT_PRV_GRADE is a configuration table within the Oracle E-Business Suite Student System (IGS) product family, present in both release 12.1.1 and 12.2.2. Its purpose, as documented in the ETRM repository, is to capture the relationship between academic units and the previous grades that qualify a student for a repeat attempt of that unit. In institutional practice, this table encodes the rules that determine whether a prior grade outcome — for example, a fail or a marginal pass — permits or requires a student to re-enrol in a unit version.

The table is owned by the IGS schema and holds eleven documented columns in the 12.1.1 physical schema. It is a low-volume control table rather than a high-transaction fact table; rows are typically maintained by academic administrators during curriculum and grading-rule setup.

From a Data Vault modelling perspective, the mined foreign-key structure classifies this object heuristically as a link. That classification is a modelling suggestion rather than an EBS-imposed construct: the table's role is to associate two independent business entities — a specific unit version and a specific grading schema value — and the association itself carries the repeat-qualification semantics. No descriptive satellite attributes beyond standard audit columns are present.

Key Information Stored

The primary key is a surrogate identifier named UNIT_PREV_GRADE_ID, enforced by the unique index IGS_PS_UNT_PRV_GRADE_PK. Business users rarely reference this value directly; it exists to give each repeat-qualification rule a stable technical handle for referential integrity and API processing.

The substantive business keys are captured by the composite unique index IGS_PS_UNT_PRV_GRADE_U2, which spans five columns: UNIT_CODE, UNIT_VERSION_NUMBER, GRADING_SCHEMA_CODE, GRADING_SCHEMA_VERSION_NUMBER, and GRADING_SCHEMA_VALUE. Together these define the grain of the table — one row per combination of unit version and qualifying grade value.

  • UNIT_PREV_GRADE_ID — surrogate primary key for the rule row.
  • UNIT_CODE — identifies the unit of study to which the repeat rule applies.
  • UNIT_VERSION_NUMBER — narrows the rule to a specific version of the unit, since grading rules can change between versions.
  • GRADING_SCHEMA_CODE — identifies the grading schema (for example, a percentage or letter-grade scheme) from which the qualifying grade is drawn.
  • GRADING_SCHEMA_VERSION_NUMBER — the version of that grading schema, ensuring the rule binds to the correct scale definition.
  • GRADING_SCHEMA_VALUE — the specific grade value within the schema that qualifies a student for a repeat.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns recording who created and last amended each rule and when.

The five business-key columns form a natural key suitable for external reporting extracts, while the surrogate key is preferred for internal joins.

Common Use Cases and Queries

The principal use case is validation at enrolment or progression time: when a student attempts to re-enrol in a unit, the Student System consults IGS_PS_UNT_PRV_GRADE to confirm that the previously awarded grade is one that qualifies for a repeat. Administrators also use the table to audit which grades are configured as repeat-qualifying across the curriculum.

A typical reporting query retrieves all qualifying grades for a given unit version:

  • SELECT unit_code, unit_version_number, grading_schema_code, grading_schema_value FROM igs_ps_unt_prv_grade WHERE unit_code = :unit_code AND unit_version_number = :version;
  • SELECT g.grading_schema_value, g.grading_schema_version_number FROM igs_ps_unt_prv_grade g, igs_as_grd_sch_grade s WHERE g.grading_schema_code = s.grading_schema_code AND g.unit_code = :unit_code;

A second frequent pattern is a completeness check for configuration gaps — identifying unit versions that have no repeat-qualifying grade defined by comparing against IGS_PS_UNIT_VER_ALL. Reverse lookups ("which units treat grade X as repeat-qualifying?") are also common for policy review and are driven by GRADING_SCHEMA_VALUE.

Related Objects

Two foreign keys are documented, and both define meaningful dependencies:

  • IGS_AS_GRD_SCH_GRADE — referenced through GRADING_SCHEMA_CODE, GRADING_SCHEMA_VERSION_NUMBER, and GRADING_SCHEMA_VALUE. This is the grade-schema definition table and supplies the valid grade values.
  • IGS_PS_UNIT_VER_ALL — referenced through UNIT_CODE and UNIT_VERSION_NUMBER. This view or table exposes unit versions and is the source of the unit side of the rule.

In practice, these two parents are the objects most frequently joined to IGS_PS_UNT_PRV_GRADE for both validation and reporting. Related functional objects include the enrolment and progression processing components of the Student System that consume these rules, and the standard concurrent programs that extract Student System configuration for institutional reporting. Because the table is a link between two parents, any reconciliation activity should verify that each row resolves to a valid unit version and a valid grade-schema value; orphaned rules from deleted or end-dated parents are the most common data-quality issue encountered.