Search Results igs_as_anon_id_ps




Overview
Explore in AI Chat

Overview

The IGS_AS_ANON_ID_PS table is a data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases, specifically in the now-obsolete IGS (Student System) product family. Its core function is to manage the assignment of anonymous identifiers to students within the context of a specific academic program. The table acts as a cross-reference, linking a student's personal and program enrollment details to a generated anonymous ID. This mechanism is typically employed in assessment or examination processes where student work must be graded without bias, ensuring the evaluator cannot identify the student by name or student ID. The metadata explicitly notes this table is for the "Method PROGRAM," indicating its use is scoped to program-level anonymous marking schemes.

Key Information Stored

The table's structure is defined by its primary and unique keys, which dictate the critical data elements it holds. The primary purpose is to store the relationship between a student, their program, and the assigned anonymous code. The two key columns are PERSON_ID, which stores the internal identifier for the student (likely referencing IGS_PE_PERSON), and COURSE_CD, which stores the code for the academic program or course of study. The ANONYMOUS_ID column holds the system-generated or manually assigned identifier used for blind assessment. The table's design enforces data integrity by ensuring a single anonymous ID per unique student-program combination (via the primary key) and that each anonymous ID is unique across the table (via the unique key).

Common Use Cases and Queries

The primary use case is supporting anonymous marking workflows. When assessment materials are submitted, the system can use this table to replace personally identifiable information with the ANONYMOUS_ID. A common reporting need is to retrieve the anonymous ID for a specific student in a program, or to reverse-lookup a student's identity after grading is complete. Sample SQL patterns include retrieving the anonymous ID for grading purposes or joining to assessment data for reporting.

  • Retrieve Anonymous ID for a Student: SELECT anonymous_id FROM igs_as_anon_id_ps WHERE person_id = :p_person_id AND course_cd = :p_course_cd;
  • Join with Assessment Data for Anonymized Report: SELECT a.anonymous_id, asm.submission_data FROM igs_as_anon_id_ps a, igs_as_assessment_submission asm WHERE a.person_id = asm.person_id AND a.course_cd = asm.course_cd;

Related Objects

Based on the provided Foreign Key relationship data, this table has a direct and critical dependency on the student program enrollment entity. The documented foreign key relationship shows that the PERSON_ID and COURSE_CD columns in IGS_AS_ANON_ID_PS reference the IGS_EN_STDNT_PS_ATT_ALL table. This table stores a student's program attempt (enrollment) details. This relationship ensures that an anonymous ID can only be assigned to a student who is formally enrolled in the specified program, maintaining referential integrity. The primary key IGS_AS_ANON_ID_PS_PK and unique key IGS_AS_ANON_ID_PS_UK are also essential related objects that enforce the table's fundamental business rules.