Search Results s_assessment_type




Overview
Explore in AI Chat

Overview

The IGS_AS_SASSESS_TYPE table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2, specifically for the Oracle Student Management (OSM) product, owned by the IGS schema. It serves as the master repository for system-defined assessment types, which provide the foundational functionality for institution-defined assessment types. The table's primary role is to define the universe of possible assessment categories (e.g., Assignment, Examination) that an educational institution can map its own custom assessment types to, thereby inheriting standardized system behavior and processing rules. It is a critical component for configuring and controlling the assessment lifecycle within the application.

Key Information Stored

The table stores the definition and control attributes for each system assessment type. The key columns are:

Common Use Cases and Queries

This table is primarily referenced during setup and configuration, and for validation in transactional processes. A common use case is during the creation of an institution-defined assessment type in the front-end, where the application presents a list of open (CLOSED_IND = 'N') system types for mapping. For reporting and data validation, typical queries include listing all available system types or checking the configuration for non-central exams.

-- Retrieve all active system assessment types available for mapping
SELECT s_assessment_type,
       description
FROM igs.igs_as_sassess_type
WHERE closed_ind = 'N'
ORDER BY 1;

-- Query details for the non-central exam type and its linked location
SELECT sat.s_assessment_type,
       sat.description,
       sat.non_cntrl_exam_loc_cd,
       loc.location_name
FROM igs.igs_as_sassess_type sat,
     igs.igs_ad_location_all loc
WHERE sat.s_assessment_type = 'NONCENTRAL'
  AND sat.non_cntrl_exam_loc_cd = loc.location_cd(+);

Related Objects

The IGS_AS_SASSESS_TYPE table has defined relationships with other key tables in the OSM schema:

  • Primary Key Reference: The table's primary key (S_ASSESSMENT_TYPE) is referenced by the IGS_AS_ASSESSMNT_TYP table. This is the primary relationship, where each institution-defined assessment type (in IGS_AS_ASSESSMNT_TYP) must be mapped to one valid system-defined type from this table.
  • Foreign Key Reference: The NON_CNTRL_EXAM_LOC_CD column is a foreign key referencing the IGS_AD_LOCATION_ALL table. This relationship is specific to the 'NONCENTRAL' assessment type and provides the default location grouping for non-centrally managed examinations.