Search Results load_calendar_type




Overview
Explore in AI Chat

Overview

IGSFV_AS_ANONYMOUS_ID_ASSESS is a Business Intelligence System (BIS) view owned by the APPS schema within the Oracle E-Business Suite Student System (formerly Oracle Student System, now part of the Student Information Management footprint). It is registered in FND Design Data under the application short name IGS with the designation IGS.IGSFV_AS_ANONYMOUS_ID_ASSESS, and it carries a status of VALID. The view describes the occurrence of an application for special consideration as it relates to anonymised student assessment. In practice, it exposes the linkage between an anonymous identifier assigned to a person, the assessment type under which that anonymity applies, and the load calendar in which the assessment takes place.

Because the object is defined as a view rather than a base table, it presents a denormalised, read-only projection suitable for reporting, extraction, and integration. Report authors and interface developers use it when they need assessment anonymity data without traversing the full normalised entity model underneath the Student System.

Underlying Base Objects

The documented ETRM metadata for this view lists no referenced base objects, and the excerpt provides only a dependency stub referencing APPS.IGSFV_AS_ANONYMO. This is consistent with a view that is generated as part of the Business Intelligence System layer, where the underlying joins are maintained internally rather than being published as discrete dependencies. Consequently, the view should be treated as a derived object whose physical source tables reside within the IGS (Student System) schema family, most plausibly the assessment and anonymous identifier entities that hold person, assessment type, and load calendar attributes.

Because the base objects are not documented here, administrators should not assume that any single table supplies all columns. The safest practice when tracing data lineage is to inspect the view DDL directly in the EBS instance, since the ETRM excerpt does not reproduce the full definition.

Key Columns

Common Use Cases and Queries

The view is commonly queried to retrieve anonymous identifiers for assessment processing filtered by load calendar. The query text published in the ETRM is:

SELECT PERSON_NAME, PERSON_NUMBER, ANONYMOUS_ID, ASSESSMENT_TYPE,
       ASSESSMENT_TYPE_DESCRIPTION, _LA:SYSTEM_GENERATED_IND,
       LOAD_CALENDAR_TYPE, LOAD_CI_SEQUENCE_NUMBER,
       LOAD_CALENDAR_DESCRIPTION, PERSON_ID, CREATED_BY,
       CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE
FROM APPS.IGSFV_AS_ANONYMOUS_ID_ASSESS;

A typical refinement adds a calendar filter, for example restricting to a single calendar type and sequence number, or selecting only system-generated anonymous IDs where the indicator equals Y. These patterns support audit reporting and the reconciliation of assessment anonymity against load calendar definitions.