Results for “igs_as_appr_grd_sch_pk”

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

Overview

IGS_AS_APPR_GRD_SCH is a table within the IGS (Student System) product schema of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It stores the approved grading schemas that are permitted for specific assessment types when those assessment types are associated with a particular unit and unit version. In other words, the table acts as a controlled mapping between an institution's assessment definitions and the grading scales that may legitimately be applied to them at the unit level.

The table supports defaulting behavior. When assessment items are linked to a unit offering and its sections, the grading schema recorded here can be defaulted onto the assessment item, ensuring that grading conventions are applied consistently without requiring manual entry by the user. The table is owned by the IGS schema and is documented as VALID in the ETRM repository.

From a Data Vault modeling perspective, the relationship metadata classifies this object heuristically as a link table. This is a modeling suggestion rather than a physical attribute: the table resolves relationships among assessment types, grading schemas, and unit versions, and its composite primary key reflects that associative role rather than describing a single business entity.

Key Information Stored

The table contains twelve documented columns. The most significant are those that form the primary key and carry the business meaning of the record:

• UNIT_CD — the unit code identifying the academic unit to which the approved grading schema applies.
• VERSION_NUMBER — the version of the unit, allowing different approvals across successive unit versions.
• ASSESSMENT_TYPE — the category of assessment (for example, examination or coursework) for which the grading schema is approved.
• GRADING_SCHEMA_CD — the code of the grading schema approved for that assessment type and unit version.
• GS_VERSION_NUMBER — the version number of the grading schema, permitting multiple versions of the same schema code to be distinguished.
• DEFAULT_IND — indicates whether this grading schema should be defaulted when assessment items are linked to the unit offering and sections.
• CLOSED_IND — flags whether the approval record is closed or inactive.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS who-columns providing audit information.

The primary key is IGS_AS_APPR_GRD_SCH_PK over ASSESSMENT_TYPE, GRADING_SCHEMA_CD, GS_VERSION_NUMBER, UNIT_CD, and VERSION_NUMBER. The unique index IGS_AS_APPR_GRD_SCH_U1 carries the identical column set, making it the business-key candidate that mirrors the surrogate primary key in this design.

Common Use Cases and Queries

Typical reporting and validation scenarios include identifying which grading schema is approved for a given assessment type on a specific unit version, and confirming defaulting behavior before assessment items are linked to unit offerings.

• Listing all approved grading schemas for a unit: SELECT assessment_type, grading_schema_cd, gs_version_number, default_ind FROM igs_as_appr_grd_sch WHERE unit_cd = :unit AND version_number = :ver;
• Locating the default schema for a unit/assessment combination: filter on DEFAULT_IND = 'Y' and CLOSED_IND = 'N'.
• Reconciling approvals against the assessment type master by joining to IGS_AS_ASSESSMNT_TYP on ASSESSMENT_TYPE.

These patterns are commonly used in assessment setup validation reports, grading configuration extracts, and integration checks prior to loading assessment item data.

Related Objects

The following objects are the most significant dependencies for this table, based on the documented foreign key relationships.

• IGS_AS_ASSESSMNT_TYP — referenced via IGS_AS_APPR_GRD_SCH.ASSESSMENT_TYPE; supplies the assessment type definition.
• IGS_AS_GRD_SCHEMA — referenced via GRADING_SCHEMA_CD and GS_VERSION_NUMBER; supplies the grading schema definition and its versions.
• IGS_PS_UNIT_VER_ALL — referenced via UNIT_CD and VERSION_NUMBER; supplies the unit version context against which approval is recorded.

Because these foreign keys resolve the table's three principal dimensions, the object functions as an integration point among assessment types, grading schemas, and unit versions in the IGS Student System.