Search Results igsfv_as_anonymous_id_assess

Overview

IGSFV_AS_ANONYMOUS_ID_ASSESS is a read-only view owned by the APPS schema in the Oracle E-Business Suite IGS (Student System) product family. It describes each occurrence of an application for special consideration, exposing the anonymity-controlled assessment context through which a student's anonymous examination identity is linked to the party record, the assessment type, and the load calendar against which the assessment was scheduled.

The view is a reporting and integration convenience layer. Rather than requiring external systems, concurrent programs, or custom reports to join party, assessment, assessment type, and calendar instance data manually, the view presents a single denormalised result set with human-readable descriptions for coded values. The inclusion of the WITH READ ONLY clause guarantees that no DML can be issued against the view, making it safe for ad-hoc querying and downstream extract processes.

Because the view returns the anonymous identifier alongside the underlying person identifier and party name, it is typically restricted to privileged assessment administration and examination board reporting rather than student- or faculty-facing screens.

Underlying Base Objects

The view is defined over four base objects joined on their natural keys:

• HZ_PARTIES (HP) — joined on AASS.PERSON_ID = HP.PARTY_ID, supplying the party name and party number for the person associated with the anonymous assessment.
• IGS_AS_ANON_ID_ASS (AASS) — the driving table, holding the anonymous identifier, assessment type, load calendar type, load calendar instance sequence number, and the system-generated indicator.
• IGS_AS_ASSESSMNT_TYP (ATYP) — joined on AASS.ASSESSMENT_TYPE = ATYP.ASSESSMENT_TYPE, supplying the assessment type description.
• IGS_CA_INST_ALL (CI) — joined on AASS.LOAD_CAL_TYPE = CI.CAL_TYPE and AASS.LOAD_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER, supplying the load calendar description.

The join to IGS_CA_INST_ALL uses the _ALL variant, which is the multi-organisation (MOAC) enabled calendar instance table; the view itself does not filter by organisation, so any org-security behaviour is inherited from the caller's environment.

Key Columns

• PERSON_NAME / PERSON_NUMBER — party name and party number of the assessed person.
• ANONYMOUS_ID — the anonymity-controlled identifier assigned to the assessment occurrence.
• ASSESSMENT_TYPE / ASSESSMENT_TYPE_DESCRIPTION — the assessment type code and its decoded description.
• _LA:SYSTEM_GENERATED_IND — a descriptive flexfield reference column expressed as a literal lookup expression; it drives the IGS_LOOKUP_VALUES YES_NO lookup meaning for the system-generated indicator.
• LOAD_CAL_TYPE / LOAD_CI_SEQUENCE_NUMBER — the load calendar type and calendar instance sequence identifying the teaching period.
• LOAD_CALENDAR_DESCRIPTION — the decoded calendar instance description; this is the column returned when users search on "load_calendar_description".
• PERSON_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard identifiers and audit columns.

Common Use Cases and Queries

Typical scenarios include producing examination board listings that reconcile anonymous assessment identifiers to real students under controlled access, and extracting assessment occurrences by teaching period for institutional reporting.

Retrieve all anonymous assessments attached to a given load calendar:

SELECT person_name, person_number, anonymous_id,
       assessment_type_description, load_calendar_description
FROM   apps.igsfv_as_anonymous_id_assess
WHERE  load_calendar_description = :p_calendar;

Count anonymous assessments by type for a period:

SELECT assessment_type_description, COUNT(*) occurrences
FROM   apps.igsfv_as_anonymous_id_assess
WHERE  load_cal_type = :p_cal_type
AND    load_ci_sequence_number = :p_seq
GROUP  BY assessment_type_description;

Because the view is read-only and exposes the party identifier, it should be queried only by roles authorised to de-anonymise assessment records.