Search Results to_version_number

Overview

IGS.IGS_AS_GRD_SCH_TRN_ALL is a transactional table in the Oracle E-Business Suite (12.1.1 / 12.2.2) Student Systems product family, owned by the IGS schema. It stores the mapping rules required to translate a grade awarded under one grading schema into the equivalent grade under a different grading schema. In academic assessment processing, an institution may maintain multiple grading schemas (for example, a percentage-based schema versus a letter-grade schema, or a legacy schema versus a revised one), and this table provides the crosswalk that allows assessed outcomes to be interpreted consistently across those schemas during transfer credit evaluation, progression checks, and external reporting.

The physical table resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and it is indexed in APPS_TS_TX_IDX. A heuristic Data Vault classification mined from the foreign-key structure identifies the object as standalone. The documented relationships indicate no parent-child FK dependencies to other tables; consequently, the object is best modeled as a standalone reference or mapping table rather than a classic hub, link, or satellite. Its six-column composite primary key gives it the character of a pure keyed mapping structure that can be consumed directly by assessment logic without additional context joins.

Key Information Stored

The table holds the "from" and "to" sides of each grading translation in a symmetrical pair of column sets, plus standard EBS administrative columns.

• GRADING_SCHEMA_CD (VARCHAR2 10) — identifies the source ("from") grading schema, describing the set of marks and grades available for assessing student unit attempts.
• VERSION_NUMBER (NUMBER) — system-generated version identifier for the source grading schema in the translation; quoted in the ETRM metadata as the version of the "from" schema.
• GRADE (VARCHAR2) — the source grade code that is being mapped.
• TO_GRADING_SCHEMA_CD (VARCHAR2 10) — identifies the target ("to") grading schema, which may differ from the source schema.
• TO_VERSION_NUMBER (NUMBER) — the user's search term. It is a system-generated number identifying the version of the target grading schema in the translation, mirroring VERSION_NUMBER on the "to" side. It is part of the primary key and must be supplied in every lookup against the translation set.
• TO_GRADE (VARCHAR2) — the target grade code to which the source grade is mapped.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ORG_ID — standard WHO audit columns and the multi-org identifier.

The composite primary key IGS_AS_GRD_SCH_TRN_ALL_PK is formed from all six mapping columns (GRADING_SCHEMA_CD, VERSION_NUMBER, GRADE, TO_GRADING_SCHEMA_CD, TO_VERSION_NUMBER, TO_GRADE). The unique index IGS_AS_GRD_SCH_TRN_ALL_U1 covers the same six columns, so it is a business-key candidate mirroring the PK rather than an independent surrogate. The non-unique index IGS_AS_GRD_SCH_TRN_ALL_N1 covers TO_GRADING_SCHEMA_CD, TO_VERSION_NUMBER, and TO_GRADE, supporting reverse lookups from the target side.

Common Use Cases and Queries

Typical usage includes transfer-credit grade normalization, conversion of historical grades after a schema revision, and reporting that must express outcomes against a single institutional schema.

• Forward translation — retrieve the target grade for a known source schema, version, and grade:

SELECT to_grading_schema_cd, to_version_number, to_grade
FROM   igs.igs_as_grd_sch_trn_all
WHERE  grading_schema_cd = :from_schema
AND    version_number    = :from_version
AND    grade             = :source_grade;

• Reverse translation — use the N1 index to list all source grades mapping to a given target grade:

SELECT grading_schema_cd, version_number, grade
FROM   igs.igs_as_grd_sch_trn_all
WHERE  to_grading_schema_cd = :to_schema
AND    to_version_number    = :to_version
AND    to_grade             = :target_grade;

• Completeness audit — detect source grades lacking a translation for a given schema version pair, a common data-quality check before grade rollover.
• Change tracking — extract rows where LAST_UPDATE_DATE exceeds a report cutoff to audit maintenance of grading crosswalks.

Related Objects

Because the object is classified as standalone, the documented relationship data exposes no foreign keys to other tables; joins are therefore driven by the shared grading-schema and grade code columns rather than enforced constraints. The most significant related objects to consider are:

• IGS_AS_GRADING_SCHEMES (grading schema definitions) — joined on GRADING_SCHEMA_CD and TO_GRADING_SCHEMA_CD to resolve schema descriptions and version data.
• IGS_AS_GRD_SCHEME_VERSIONS (schema version records) — joined on VERSION_NUMBER and TO_VERSION_NUMBER to validate that the referenced schema versions exist and are current.
• IGS_AS_GRADE_MASTER / grade code reference tables — joined on GRADE and TO_GRADE to obtain grade descriptions and mark ranges.
• IGS_AS_STUDENT_UNIT_ATTEMPTS — the transactional assessment records whose awarded grades are transformed using the mappings in this table.
• IGS_AS_ASSESSMENTS — provides assessment context for the student unit attempts whose grades are translated.
• IGS_AS_SCH_TRN_V or equivalent translation views — reporting views over this table used in Student Systems inquiries.

Together these objects form the grading-translation layer that permits a single assessment outcome to be expressed faithfully across multiple institutional grading schemas.