Search Results igs_as_anon_id_ass

Overview

The table IGS_AS_ANON_ID_ASS is a core data object within the Oracle E-Business Suite Student System (IGS) module, specifically designed to support anonymous assessment processes. Its primary function is to maintain a secure and auditable mapping between a student's identity (PERSON_ID) and an assigned ANONYMOUS_ID for a specific assessment period and type. This decoupling is critical for ensuring impartial grading, where assessors evaluate work without knowledge of the student's identity. The table is integral to the "ASSESSMENT" method, as indicated in its description, and operates within the context of defined academic calendars and assessment cycles in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its composite primary and unique keys, which enforce critical business rules for anonymous assessment. The primary key (IGS_AN_ANON_ID_ASS_PK) uniquely identifies a record by combining the student's PERSON_ID, the ASSESSMENT_TYPE, and the academic load calendar identifiers (LOAD_CAL_TYPE and LOAD_CI_SEQUENCE_NUMBER). This ensures a student can only have one anonymous ID per assessment type per academic period. A separate unique key (IGS_AS_ANON_ID_ASS_UK) guarantees the ANONYMOUS_ID itself is unique within that same academic period (LOAD_CAL_TYPE, LOAD_CI_SEQUENCE_NUMBER), preventing identifier collision. The key columns are:

• PERSON_ID: References the student's master person record in the system.
• ANONYMOUS_ID: The anonymized identifier assigned to the student for grading purposes.
• ASSESSMENT_TYPE: The type of assessment (e.g., final exam, coursework) for which the ID is valid.
• LOAD_CAL_TYPE and LOAD_CI_SEQUENCE_NUMBER: Together, these identify the specific academic calendar instance (e.g., "SEMESTER 1, 2023") governing the assessment load.

Common Use Cases and Queries

The primary use case is the administration and execution of anonymous marking. During setup, system processes or administrators populate this table to generate and assign anonymous IDs. During grading, assessment tools join to this table via the ANONYMOUS_ID to retrieve submissions while masking the PERSON_ID. After grading, the table is used to re-identify students for result publication. A typical reporting query would join to person tables to audit assignments:

SELECT p.person_number, a.anonymous_id, a.assessment_type, a.load_cal_type
FROM igs_as_anon_id_ass a,
     igs_pe_person_base_v p
WHERE a.person_id = p.person_id
AND a.load_ci_sequence_number = 202301;

Another common pattern is validating the uniqueness of an anonymous ID assignment before an insert or update, leveraging the defined unique key constraints.

Related Objects

IGS_AS_ANON_ID_ASS maintains defined foreign key relationships with other critical Student System tables, ensuring referential integrity:

• IGS_AS_ASSESSMNT_TYP (via ASSESSMENT_TYPE): Validates that the ASSESSMENT_TYPE used in the anonymous ID record is a defined and active assessment type in the system.
• IGS_CA_INST_ALL (via LOAD_CAL_TYPE and LOAD_CI_SEQUENCE_NUMBER): Validates that the academic calendar period specified for the anonymous assignment is a valid calendar instance. This ties the anonymous assessment to a concrete teaching period.

These relationships mean this table is central to the data model for assessments, sitting between core person/calendar data and the grading processes that rely on anonymous identifiers.