Search Results grading_schema_value

Overview

The view IGS_PS_UNT_PRV_GRADE_V is an Oracle E-Business Suite database object owned by the APPS schema and delivered as part of the IGS – Student System product family. Its status is VALID in ETRM 12.2.2, and it is also present in release 12.1.1. Functionally, it presents prior (historical) grade information recorded against a student's unit attempt, enriched with the human-readable grade name from the grading schema definition. In the Student System data model, prior grade records support articulation, credit transfer, admission evaluation, and progression decisions, where a grade achieved elsewhere (or in a prior attempt) must be captured against a unit and validated against a grading schema.

Because the view decodes GRADING_SCHEMA_VALUE into FULL_GRADE_NAME, it is well suited to reporting, extracts, and integration interfaces that must display or transmit a meaningful grade description rather than an opaque schema value code. Unlike a base table, the view imposes no independent storage; it is a read-only projection intended for query and reporting access.

Underlying Base Objects

The view is defined over two documented base tables in the APPS schema:

• IGS_PS_UNT_PRV_GRADE (aliased UPG) — the primary prior-grade table holding unit, version, grading schema, and schema value attributes.
• IGS_AS_GRD_SCH_GRADE (aliased GSG) — the grading schema grade definition table, supplying the descriptive FULL_GRADE_NAME.

The join is a three-part equi-join: UPG.GRADING_SCHEMA_CODE = GSG.GRADING_SCHEMA_CD, UPG.GRADING_SCHEMA_VERSION_NUMBER = GSG.VERSION_NUMBER, and UPG.GRADING_SCHEMA_VALUE = GSG.GRADE. This means the view returns rows only where a matching grade definition exists in the referenced grading schema and version. If a prior grade references a schema value that is not defined (or whose version is mismatched), that row is excluded from the view output.

Key Columns

The documented columns are:

• ROW_ID — the ROWID of the underlying IGS_PS_UNT_PRV_GRADE row.
• UNIT_PREV_GRADE_ID — primary key identifier for the prior-grade record.
• UNIT_CODE and UNIT_VERSION_NUMBER — the unit and version against which the prior grade applies.
• GRADING_SCHEMA_CODE and GRADING_SCHEMA_VERSION_NUMBER — the grading schema and version used to interpret the grade.
• GRADING_SCHEMA_VALUE — the coded grade value recorded on the prior-grade row; the column most directly associated with the search term "grading_schema_value".
• FULL_GRADE_NAME — the decoded, descriptive grade name sourced from IGS_AS_GRD_SCH_GRADE.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include reporting prior grades for a unit, validating that recorded schema values resolve to defined grades, and feeding transfer-credit or articulation extracts.

Retrieve all prior grades for a unit:

• SELECT unit_code, grading_schema_code, grading_schema_value, full_grade_name FROM apps.igs_ps_unt_prv_grade_v WHERE unit_code = :p_unit_code;

Resolve a specific schema value to its description:

• SELECT unit_prev_grade_id, full_grade_name FROM apps.igs_ps_unt_prv_grade_v WHERE grading_schema_code = :p_schema AND grading_schema_value = :p_value;

Because the view performs an inner join, absence of a row can indicate either no prior grade or an unresolved grading schema value; reconciliation should therefore also query IGS_PS_UNT_PRV_GRADE directly where orphan or unmatched values are suspected.