Results for “igs_ps_usec_grd_schm_v”

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

Overview

The IGS_PS_USEC_GRD_SCHM_V view is a reporting construct within the Oracle E-Business Suite Student System (IGS) module, which is classified as obsolete in ETRM documentation. The view exposes the association between a unit offering option (identified by UOO_ID) and the grading schema that governs the assessment of students enrolled against that unit section. It denormalizes the assignment record held in IGS_PS_USEC_GRD_SCHM by joining it to the grading schema definition in IGS_AS_GRD_SCHEMA, thereby surfacing descriptive and date-effective attributes alongside the raw mapping.

In Oracle EBS 12.1.1 and 12.2.2, IGS is the legacy Student System product family predating the Oracle Student Cloud and PeopleSoft Campus Solutions replacement paths. ETRM notes that this object is "not implemented in this database," meaning the view is documented for reference but is not created as a database object in a standard installation. Its principal purpose in reporting and integration is to provide a single, human-readable row per unit section grading schema assignment, including the grading schema description, validity dates, and version number, so that downstream queries do not need to perform the join manually.

Underlying Base Objects

The documented view text defines two referenced base tables:

• IGS_PS_USEC_GRD_SCHM (aliased UGS) — the primary table holding the unit section grading schema assignment. It supplies UNIT_SECTION_GRADING_SCHEMA_ID, UOO_ID, GRADING_SCHEMA_CODE, GRD_SCHM_VERSION_NUMBER, DEFAULT_FLAG, and the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).
• IGS_AS_GRD_SCHEMA (aliased GS) — the grading schema definition. It contributes DESCRIPTION (exposed as GRADING_SCHEMA_DESCRIPTION), START_DT, and END_DT.

The join is performed on two predicates: UGS.GRADING_SCHEMA_CODE = GS.GRADING_SCHEMA_CD and UGS.GRD_SCHM_VERSION_NUMBER = GS.VERSION_NUMBER. The composite key on code plus version number is significant because grading schemas are versioned; a schema code alone does not uniquely identify a definition. In 12.2.2, ETRM lists no additional referenced base objects beyond these two, so the view is a straightforward two-table join with no further dependency on unit, course, or enrollment tables.

Key Columns

• UNIT_SECTION_GRADING_SCHEMA_ID — the primary identifier of the assignment row. This is the column most frequently sought under the search term unit_section_grading_schema_id.
• UOO_ID — the unit offering option to which the grading schema applies. Each row links one grading schema assignment to one unit offering option.
• GRADING_SCHEMA_CODE — the code identifying the grading schema, carrying semantics defined in IGS_AS_GRD_SCHEMA.
• GRADING_SCHEMA_DESCRIPTION — the descriptive name of the grading schema, sourced from GS.DESCRIPTION.
• START_DT / END_DT — the effective date range of the grading schema definition, useful for point-in-time reporting.
• GRD_SCHM_VERSION_NUMBER — the schema version applied to the unit section, completing the composite join key.
• DEFAULT_FLAG — indicates whether this grading schema is the default assignment for the unit offering option.
• ROW_ID — the ROWID of the underlying IGS_PS_USEC_GRD_SCHM row, exposed for direct row addressing.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN support audit and change-tracking reporting.

Common Use Cases and Queries

Typical scenarios include confirming which grading schema applies to a given unit offering option, identifying default grading schemas, and auditing changes to grading schema assignments by date. Because the view is documented as obsolete and not implemented, queries should be validated against the actual installation; if the view is absent, equivalent logic can be written directly against the two base tables.

Retrieve all grading schema assignments for a unit offering option:

SELECT unit_section_grading_schema_id,
       uoo_id,
       grading_schema_code,
       grading_schema_description,
       grd_schm_version_number,
       default_flag
FROM   igs_ps_usec_grd_schm_v
WHERE  uoo_id = :uoo_id;

Identify the default grading schema per unit section:

SELECT uoo_id,
       grading_schema_code,
       grading_schema_description
FROM   igs_ps_usec_grd_schm_v
WHERE  default_flag = 'Y';

Apply date-effective filtering and audit inspection:

SELECT v.unit_section_grading_schema_id,
       v.grading_schema_code,
       v.start_dt,
       v.end_dt,
       v.last_updated_by,
       v.last_update_date
FROM   igs_ps_usec_grd_schm_v v
WHERE  TRUNC(SYSDATE) BETWEEN v.start_dt AND NVL(v.end_dt, TRUNC(SYSDATE))
ORDER  BY v.uoo_id;

Where the view is unavailable, the same result set may be obtained by joining IGS_PS_USEC_GRD_SCHM to IGS_AS_GRD_SCHEMA on GRADING_SCHEMA_CODE = GRADING_SCHEMA_CD and GRD_SCHM_VERSION_NUMBER = VERSION_NUMBER.