Search Results govt_score




Overview
Explore in AI Chat

Overview

The IGS_AS_TYPGOV_SCORMP table is a configuration and mapping table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Student Management (Campus Solutions) product family under the IGS (iGrants) schema. Its primary role is to facilitate standardized government reporting for educational institutions. The table provides a critical mapping function, translating an institution's internal secondary education assessment scores into a common, government-reportable tertiary entrance score. This ensures compliance with national reporting requirements, such as those defined by DETYA (Department of Education, Training and Youth Affairs), by aligning diverse local scoring systems (e.g., VCE, IB) to a standardized index.

Key Information Stored

The table's structure is defined by a composite primary key and columns that capture the mapping logic and audit information. The key columns are:

  • SCNDRY_EDU_ASS_TYPE (VARCHAR2(10)): A mandatory field describing the type of secondary education assessment, such as VCE, IB, or YR12-ACT. It is part of the primary key and has a foreign key relationship to the IGS_AD_AUSE_ED_AS_TY table.
  • RESULT_OBTAINED_YR (NUMBER): The year the secondary education results were obtained. This is part of the primary key, allowing mappings to be specific to different academic years.
  • INSTITUTION_SCORE (NUMBER): The student's tertiary entrance score as recognized by the local institution for the specified assessment type. This is the final component of the primary key.
  • GOVT_SCORE (NUMBER): The corresponding score, drawn from DETYA's common index, that must be reported to the government (e.g., for DETYA element 369). This is the target value of the mapping.
The table also includes standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing data changes.

Common Use Cases and Queries

This table is essential during batch processes for government submissions and for generating compliance reports on student admissions data. A typical use case involves an institution receiving student applications with various secondary education scores; the system uses this table to convert each student's INSTITUTION_SCORE into the correct GOVT_SCORE for aggregation and reporting. Administrators maintain this table to update mappings for new assessment types or scoring changes. A fundamental query to retrieve the full mapping for a specific assessment type and year would be: SELECT SCNDRY_EDU_ASS_TYPE, RESULT_OBTAINED_YR, INSTITUTION_SCORE, GOVT_SCORE FROM IGS.IGS_AS_TYPGOV_SCORMP WHERE SCNDRY_EDU_ASS_TYPE = 'VCE' AND RESULT_OBTAINED_YR = 2023 ORDER BY INSTITUTION_SCORE; Another common pattern is to join this table with student assessment data to translate a cohort's scores in preparation for a government extract.

Related Objects

The table has defined relationships with other EBS objects, primarily enforcing data integrity for the assessment type. The documented relationships are:

  • Primary Key: IGS_AS_TYPGOV_SCORMP_PK on (SCNDRY_EDU_ASS_TYPE, RESULT_OBTAINED_YR, INSTITUTION_SCORE).
  • Foreign Key (Inbound Reference): The column SCNDRY_EDU_ASS_TYPE references the TABLE: IGS.IGS_AD_AUSE_ED_AS_TY. This ensures that only valid, pre-defined secondary education assessment types can be used in the mapping table.
  • Referenced By: The metadata indicates the table is referenced by the AP (Applications) product family, suggesting its data is accessed by various application modules and reports within the EBS suite.
The unique index IGS_AS_TYPGOV_SCORMP_U1 enforces the primary key constraint on the APPS_TS_TX_IDX tablespace.