Search Results igs_as_typgov_scormp_pk

Overview

The IGS_AS_TYPGOV_SCORMP table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, versions 12.1.1 and 12.2.2. It functions as a mapping or translation table, specifically designed to standardize student assessment scores for government reporting. Its primary role is to define the relationship between an institution's internal scoring for a secondary education assessment type and the official, government-reportable equivalent score. This mapping is critical for ensuring compliance with external reporting requirements, as it allows the institution's specific grading schema to be accurately converted into a mandated, standardized format for submission to governmental education bodies.

Key Information Stored

The table's structure is defined by its composite primary key, which uniquely identifies each mapping rule. The key columns are SCNDRY_EDU_ASS_TYPE, RESULT_OBTAINED_YR, and INSTITUTION_SCORE. These fields collectively specify the exact context for a score conversion: the type of secondary education assessment, the year the result was obtained, and the original score as recorded by the institution. The table then holds at least one corresponding column for the derived GOVERNMENT_SCORE. This design ensures that the mapping can be historically accurate (by year) and specific to different assessment types, accommodating changes in reporting standards over time and across different qualification types.

Common Use Cases and Queries

The primary use case is the batch or real-time translation of student historical results during the generation of government compliance reports. A typical query would join this table to secondary education records to fetch the reportable score. For example, to retrieve the standardized government score for a specific student's assessment record, one might use a SQL pattern such as:

• SELECT s.student_id, s.assessment_type, s.institution_score, m.government_score
• FROM igs_pe_sec_edu_score s, igs_as_typgov_scormp m
• WHERE s.assessment_type = m.scndry_edu_ass_type
• AND s.result_year = m.result_obtained_yr
• AND s.institution_score = m.institution_score;

Data maintenance is another critical activity, involving the insertion or updating of mapping rules whenever assessment types are introduced or government reporting scales are revised.

Related Objects

The table maintains a direct foreign key relationship, which is essential for data integrity. The SCNDRY_EDU_ASS_TYPE column references the IGS_AD_AUSE_ED_AS_TY table. This relationship ensures that any assessment type used in the score mapping is a valid, predefined type within the system. The primary key constraint IGS_AS_TYPGOV_SCORMP_PK enforces uniqueness on the combination of assessment type, year, and institution score. This table is likely referenced by various views, packages, and concurrent programs within the Student System that are responsible for assembling official transcripts, generating statutory returns, or populating external reporting interfaces.