Search Results igsbv_as_assessment_types

Overview

The view IGSBV_AS_ASSESSMENT_TYPES belongs to the Oracle E-Business Suite (EBS) product family identified as IGS — Student System, which Oracle classifies as obsolete. The view is documented in the ETRM (E-Business Suite Technical Reference Manual) repository with the description "Describes possible types of assessment items." Its purpose is to expose the catalogue of assessment type definitions used within the Student System's assessment and grading subsystem, presenting each assessment type alongside its descriptive attributes and translated indicator values.

From a reporting and integration standpoint, the "BV" naming convention indicates a business view: a denormalised, read-only projection intended for external consumption, reporting tools, and interface development rather than for transactional processing. The view is defined with a WITH READ ONLY clause, which prevents DML against the view and confirms its role as a query-only construct. Because the underlying product is obsolete, this view is unlikely to be present in most current EBS installations; ETRM explicitly records that it is "Not implemented in this database" in the referenced environment, meaning implementations should verify its existence before relying on it.

Underlying Base Objects

The view text is defined over a single base table, IGS_AS_ASSESSMNT_TYP, aliased as ATYP. The ETRM metadata records no additional referenced base objects beyond this table, and the excerpt of the view text confirms a direct, flat selection from it without joins to lookup or translation tables.

The relationship between view and base table is therefore one-to-one at the row level: each row in IGS_AS_ASSESSMNT_TYP produces exactly one row in the view. The view does not aggregate, filter, or restrict the base table's rows; instead it performs column-level transformation. Notably, three indicator columns are exposed through embedded lookup-value constructs rather than as simple columns. The view text contains literal expressions of the form '_LA:ATYP.EXAMINABLE_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', which instruct the EBS framework to resolve the stored code value against the IGS_LOOKUP_VALUES table using the YES_NO lookup type and return the corresponding MEANING. This mechanism replaces raw Y/N flags with user-readable descriptions.

Key Columns

The view exposes the following columns:

• ASSESSMENT_TYPE — the primary business key identifying the assessment type; sourced from ATYP.ASSESSMENT_TYPE.
• ASSESSMENT_TYPE_DESCRIPTION — the descriptive text for the type, sourced from ATYP.DESCRIPTION.
• SYSTEM_ASSESSMENT_TYPE — a system-defined assessment type attribute, sourced from ATYP.S_ASSESSMENT_TYPE, typically used to identify seeded or system-controlled types.
• _LA:EXAMINABLE_INDICATOR — indicates whether the assessment type is examinable, resolved from EXAMINABLE_IND via the YES_NO lookup.
• _LA:CLOSED_INDICATOR — indicates whether the assessment type is closed for further use, resolved from CLOSED_IND.
• _LA:ANONYMOUS_GRADING_IND — indicates whether anonymous grading applies to this assessment type, resolved from ANON_GRADING_IND.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns tracking record creation and modification.

The prefixed "_LA:" column names reflect the substituted, translated labels produced by the framework at runtime; consumers querying the view directly may reference these aliases as delivered.

Common Use Cases and Queries

Typical usage involves validating or listing assessment types for configuration, migration, and reporting of student assessment structures. A basic listing query is:

• SELECT ASSESSMENT_TYPE, ASSESSMENT_TYPE_DESCRIPTION, SYSTEM_ASSESSMENT_TYPE, "_LA:EXAMINABLE_INDICATOR", "_LA:CLOSED_INDICATOR", "_LA:ANONYMOUS_GRADING_IND" FROM IGSBV_AS_ASSESSMENT_TYPES;
• Filtering for active, examinable types: add WHERE "_LA:EXAMINABLE_INDICATOR" = 'Yes' AND "_LA:CLOSED_INDICATOR" = 'No'.
• Identifying seeded types: WHERE SYSTEM_ASSESSMENT_TYPE IS NOT NULL.
• Audit reconciliation: select the audit columns to compare record provenance against the base table during upgrades or data fixes.

Because the view is read-only and unimplemented in some databases, any script or report referencing it should include existence checks against ALL_VIEWS and fall back to querying IGS_AS_ASSESSMNT_TYP directly where appropriate.