Search Results igs_as_grd_sch_trn_all




Overview
Explore in AI Chat

Overview

The IGS_AS_GRD_SCH_TRN_ALL table resides in the IGS schema (Student System) within Oracle EBS 12.1.1 and 12.2.2. Its documented purpose is to contain the information required to translate a grade from one grading schema to another. In practice, it serves as the cross-reference matrix that maps a grade value expressed under a source grading schema and version to an equivalent grade value expressed under a target grading schema and version. This is essential for institutions that maintain multiple grading schemes, external transcript equivalencies, or regulatory conversions, where a value such as an "A" in one scheme must be re-expressed in the scale of another scheme.

From a modeling perspective, the mined Data Vault classification is standalone, meaning the table is not resolved into a hub, link, or satellite pattern; no foreign key relationships were detected in the metadata. The relationship data therefore suggests the object behaves as an independent reference or mapping table rather than participating in a normalized hub-and-satellite hierarchy.

Key Information Stored

The table contains twelve documented columns. The most significant are those forming the composite primary key and business key, since they define the identity and the mapping semantics of each row.

  • GRADING_SCHEMA_CD — the source grading schema code, identifying which scheme the original grade belongs to.
  • VERSION_NUMBER — the source schema version, distinguishing iterations of the same grading schema.
  • GRADE — the source grade value being translated.
  • TO_GRADING_SCHEMA_CD — the destination grading schema code onto which the grade is mapped.
  • TO_VERSION_NUMBER — the destination schema version.
  • TO_GRADE — the translated grade value under the destination schema.

These six columns constitute both the primary key IGS_AS_GRD_SCH_TRN_ALL_PK and the unique index IGS_AS_GRD_SCH_TRN_ALL_U1. Because the primary key and the business-key candidate are identical, there is no separate surrogate key for this object; identity is entirely business-driven, and no row may duplicate a source-to-target grade mapping.

The remaining documented columns are standard EBS audit and multitenancy attributes: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and ORG_ID. The presence of ORG_ID indicates the table is operating-unit aware, supporting multiple academic or administrative organizations within one installation.

Common Use Cases and Queries

Typical usage centers on grade conversion, transcript equivalency reporting, and data validation. A conversion query retrieves the translated grade for a known source pair:

  • SELECT TO_GRADE FROM IGS_AS_GRD_SCH_TRN_ALL WHERE GRADING_SCHEMA_CD = :src_schema AND VERSION_NUMBER = :src_version AND GRADE = :src_grade AND TO_GRADING_SCHEMA_CD = :tgt_schema AND TO_VERSION_NUMBER = :tgt_version AND ORG_ID = :org;
  • Bidirectional coverage checks: querying rows where a given schema pair has no reciprocal mapping, which often reveals gaps in conversion setup.
  • Reporting which grade values are unmapped by comparing active grades in a source schema against the GRADE values present here.
  • Auditing changes via LAST_UPDATED_BY and LAST_UPDATE_DATE to track who altered conversion rules and when.

Because the object is standalone, most reporting joins are performed manually against grading schema and grade definition tables rather than through declared foreign keys.

Related Objects

The metadata does not document foreign keys, so the following are the most significant logical dependencies inferred from the column semantics rather than declared constraints.

  • Grading schema definition tables in the IGS schema, joined on GRADING_SCHEMA_CD, providing descriptions for the source scheme.
  • Grading schema version tables, joined on GRADING_SCHEMA_CD and VERSION_NUMBER, validating the source version.
  • Grade definition tables, joined on GRADING_SCHEMA_CD, VERSION_NUMBER, and GRADE, supplying grade descriptions and valid values.
  • Target-schema equivalents of the above, joined on TO_GRADING_SCHEMA_CD, TO_VERSION_NUMBER, and TO_GRADE to resolve destination grade meaning.
  • Student grade and academic standing tables within IGS that consume converted grades for transcript and standing calculation.
  • IGS_AS_GRD_SCH_TRN_ALL_PK and IGS_AS_GRD_SCH_TRN_ALL_U1, the primary key constraint and unique index enforcing mapping integrity.

Because no FK relationships were mined, integration and extract processes must enforce referential integrity to these tables through application logic or custom validation rather than database constraints.