Search Results igs_as_sassess_type




Overview
Explore in AI Chat

Overview

The IGS_AS_SASSESS_TYPE table is a core reference table within the Oracle E-Business Suite Student System (IGS) module. It serves as the master repository for system-defined assessment types, providing a standardized set of classifications for evaluating student performance. Its primary role is to enforce data integrity and consistency across the assessment management functionality by defining the valid types of assessments that can be configured and recorded. As a system-level table, its data is typically seeded during installation and is fundamental to the operation of related transactional tables that manage specific assessment instances and rules.

Key Information Stored

The table's structure is designed to catalog assessment type codes and their associated control attributes. The primary column is S_ASSESSMENT_TYPE, which serves as the unique identifier (primary key) for each assessment type, such as 'EXAM', 'ASSIGNMENT', or 'PROJECT'. A critical foreign key column is NON_CNTRL_EXAM_LOC_CD, which links to the IGS_AD_LOCATION_ALL table. This column specifies a default or associated location code for non-controlled examinations, demonstrating how the table integrates assessment type definitions with logistical planning. While the provided metadata does not list all columns, typical attributes in such a table would include a description, system flags (e.g., closed indicator), and who columns for auditing.

Common Use Cases and Queries

This table is central to setup and reporting on academic assessments. Administrators use it to validate and constrain the assessment types available when creating new assessment definitions. Common operational queries include listing all active system assessment types for a setup form or identifying which assessment types are linked to specific default locations for scheduling purposes. For reporting, it is frequently joined to transactional data to categorize assessment results. A typical SQL pattern involves selecting assessment details joined to this table for descriptive context:

  • SELECT a.assessment_code, t.s_assessment_type, t.description FROM igs_as_assessmnt_typ a, igs_as_sassess_type t WHERE a.s_assessment_type = t.s_assessment_type;
  • SELECT s_assessment_type FROM igs_as_sassess_type WHERE non_cntrl_exam_loc_cd IS NOT NULL; (to find types with a default exam location).

Related Objects

The IGS_AS_SASSESS_TYPE table maintains defined relationships with other key Student System tables, as documented in the provided metadata. It is referenced by the transactional table IGS_AS_ASSESSMNT_TYP via a foreign key, where IGS_AS_ASSESSMNT_TYP.S_ASSESSMENT_TYPE must be a valid value from IGS_AS_SASSESS_TYPE.S_ASSESSMENT_TYPE. This enforces that all configured assessment types are system-defined. Furthermore, IGS_AS_SASSESS_TYPE itself references the IGS_AD_LOCATION_ALL table through its NON_CNTRL_EXAM_LOC_CD column, linking assessment types to physical location data for examination management. These relationships are essential for maintaining a normalized and consistent data model within the assessment subsystem.