Results for “igs_ps_usec_grd_schm_u2”

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

Overview

IGS_PS_USEC_GRD_SCHM is a transactional entity within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to capture the grading schemas that are associated with individual unit sections. In the academic structure of Oracle Student System, a unit offering option represents a deliverable instance of a unit, and a grading schema defines how students within that offering are assessed and graded. This table therefore acts as the associative bridge that records which grading schema, and which version of that schema, applies to a given unit section offering.

From a data modeling perspective, the mined relationship structure suggests this object behaves as a link table. It resolves a many-to-many style association between unit offering options and grading schemas, carrying descriptive attributes — most notably the default indicator — that qualify the relationship rather than describe either parent entity in isolation. Analysts designing an integration or warehouse layer should treat IGS_PS_USEC_GRD_SCHM as an association entity, with its own primary key and two foreign key branches.

Key Information Stored

The table is owned by the IGS schema and, in the documented 12.1.1 physical schema, contains ten columns. The most significant are summarized below.

• UNIT_SECTION_GRADING_SCHEMA_ID — the surrogate primary key, enforcing uniqueness through the IGS_PS_USEC_GRD_SCHM_PK constraint and also indexed by the unique index IGS_PS_USEC_GRD_SCHM_U1. This is the identifier exposed to downstream integrations.
• UOO_ID — the foreign key to IGS_PS_UNIT_OFR_OPT_ALL, identifying the unit offering option (unit section) to which the grading schema is attached.
• GRADING_SCHEMA_CODE — the foreign key to IGS_AS_GRD_SCHEMA, identifying the grading schema applied.
• GRD_SCHM_VERSION_NUMBER — the version of the grading schema in force for the association, allowing historical versions to coexist.
• DEFAULT_FLAG — indicates whether this grading schema is the default for the unit section when more than one schema is linked.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit and who-columns captured on every row.

Two unique indexes define the business keys. IGS_PS_USEC_GRD_SCHM_U1 covers UNIT_SECTION_GRADING_SCHEMA_ID, while IGS_PS_USEC_GRD_SCHM_U2 spans the composite of UOO_ID, GRADING_SCHEMA_CODE, and GRD_SCHM_VERSION_NUMBER — this composite is the true natural key, guaranteeing that a unit offering option cannot reference the same schema version twice.

Common Use Cases and Queries

Typical reporting scenarios include determining which grading schema is active for a unit section, and auditing where a particular grading schema version has been deployed. The join to the unit offering option table is the standard entry point:

• Resolving the grading schema for a section: select g.GRADING_SCHEMA_CODE, g.GRD_SCHM_VERSION_NUMBER, g.DEFAULT_FLAG from IGS_PS_USEC_GRD_SCHM g where g.UOO_ID = :uooid.
• Identifying the default schema only: add the predicate DEFAULT_FLAG = 'Y' to the previous query.
• Reverse impact analysis for a schema version: filter on GRADING_SCHEMA_CODE and GRD_SCHM_VERSION_NUMBER and join back to IGS_AS_GRD_SCHEMA to retrieve schema definitions.
• Regression queries: compare CREATION_DATE and LAST_UPDATE_DATE ranges to detect recently added or modified associations at a campus or term level.

Because the table is narrow and key-driven, these queries are efficient when driven through the unique indexes, particularly U2 for point lookups by unit offering option.

Related Objects

The most significant related objects derive from the documented foreign keys and primary key relationships.

• IGS_AS_GRD_SCHEMA — parent table for grading schema definitions, joined on GRADING_SCHEMA_CODE and GRD_SCHM_VERSION_NUMBER.
• IGS_PS_UNIT_OFR_OPT_ALL — parent table for unit offering options, joined on UOO_ID.
• IGS_PS_USEC_GRD_SCHM_PK — primary key constraint on UNIT_SECTION_GRADING_SCHEMA_ID.
• IGS_PS_USEC_GRD_SCHM_U1 and IGS_PS_USEC_GRD_SCHM_U2 — unique indexes enforcing surrogate and composite business keys respectively.

Downstream, assessment and grading interfaces within the IGS module consume these associations when resolving how a student's result should be recorded for a given unit section.