Search Results igs_as_assessmnt_typ_pk

Overview

The IGS_AS_ASSESSMNT_TYP table is a core reference table within the Oracle E-Business Suite Student System (IGS) module, applicable to both releases 12.1.1 and 12.2.2. It serves as a master data repository that defines and categorizes the different types of assessment items available within the academic framework. Its primary role is to enforce data integrity by providing a controlled list of valid assessment types, which are then referenced by numerous transactional and configuration tables throughout the assessment subsystem. This table is fundamental for standardizing how assessments are classified, managed, and processed across the institution's academic operations.

Key Information Stored

While the provided ETRM metadata does not list specific column details beyond the primary key, the table's structure is centered on the ASSESSMENT_TYPE column, which serves as the unique identifier (Primary Key: IGS_AS_ASSESSMNT_TYP_PK). This column stores the distinct codes representing each assessment type, such as 'FINAL_EXAM', 'QUIZ', 'PRACTICAL', 'THESIS', or 'PARTICIPATION'. Typically, a reference table like this would also include descriptive columns, such as a description field, an effective date range (e.g., START_DATE, END_DATE), and possibly attributes controlling the type's behavior (e.g., weight calculation method, grading basis). The data is primarily administrative and configured during system implementation or by functional users via the application's front-end.

Common Use Cases and Queries

This table is essential for setup, reporting, and data validation. Common use cases include populating list of values (LOVs) in assessment definition forms, validating data entry in transactional interfaces, and generating reports that categorize assessment results by type. A typical query would join this table to transactional data to provide meaningful descriptions.

• Listing All Active Assessment Types: SELECT assessment_type FROM igs.igs_as_assessmnt_typ WHERE NVL(end_date, SYSDATE) >= SYSDATE;
• Reporting on Assessments with Descriptions: SELECT t.assessment_type, a.item_code, a.grade FROM igs.igs_as_item_ass a JOIN igs.igs_as_assessmnt_typ t ON a.assessment_type = t.assessment_type;
• Data Validation in Interfaces: Before loading assessment data, a validation step checks if the provided assessment_type exists in this table to ensure referential integrity.

Related Objects

The IGS_AS_ASSESSMNT_TYP table maintains critical relationships with several other key tables in the Student System, as documented by its foreign key constraints.

• Referenced by (Child Tables):
  • IGS_AS_APPR_GRD_SCH: Links via ASSESSMENT_TYPE. This defines which grade schemes are approved for use with specific assessment types.
  • IGS_AS_ANON_ID_ASS: Links via ASSESSMENT_TYPE. This likely controls anonymous marking settings for different assessment types.
  • IGS_AS_ANON_METHOD: Links via ASSESSMENT_TYPE. This likely defines the specific anonymous marking method for an assessment type.
• References (Parent Table):
  • IGS_AS_SASSESS_TYPE: This table references IGS_AS_SASSESS_TYPE via the column S_ASSESSMENT_TYPE. This suggests a hierarchical or sub-typing relationship where an assessment type may be further classified into a more specific system-defined subtype.