Search Results system_assessment_type

Overview

The view APPS.IGSBV_AS_ASSESSMENT_TYPES is a Business Intelligence System (BIS) view in Oracle E-Business Suite that exposes the catalogue of assessment types used by the Student Records and assessment components of Oracle Student System (IGS). Its purpose is to describe the possible types of assessment items that an institution may define and apply to student assessment records, such as examinations, assignments, practicals, and similar graded instruments. The view provides a stable, query-ready representation of assessment type definitions together with the descriptions and behavioural indicators associated with each type.

Fields such as ASSESSMENT_TYPE_DESCRIPTION — the column most frequently searched when users look for "assessment_type_description" — supply the human-readable text that identifies the meaning of an assessment type code. This makes the view particularly valuable for reporting, data extraction, and integration scenarios where the descriptive label, rather than the short code, must be surfaced to end users or downstream systems.

The object is owned by the APPS schema and carries an FND Design Data reference of IGS.IGSBV_AS_ASSESSMENT_TYPES, confirming that it is a delivered, seeded database object. Its status is VALID, and it is classified as a View (Business Intelligence System view) rather than a base table, so it presents read-only data for enquiry and reporting.

Underlying Base Objects

The view references a single documented base object: APPS.IGS_AS_ASSESSMNT_TYP. This is the assessment type base table in the IGS product family. The BIS view is defined as a query over that table, exposing the assessment type code, its description, an optional mapping to a system assessment type, and indicator columns that describe grading and examination behaviour.

No other database objects are documented as referencing APPS.IGSBV_AS_ASSESSMENT_TYPES, which is consistent with its role as a terminal reporting view. It is not itself referenced by further database objects, so dependency flows from the base table into the view and outward only to reporting or integration consumers.

Key Columns

• ASSESSMENT_TYPE (VARCHAR2(10)) — The institution-defined name or code of the assessment type.
• ASSESSMENT_TYPE_DESCRIPTION (VARCHAR2(60)) — The descriptive text for the assessment type; the primary descriptive column for reporting.
• SYSTEM_ASSESSMENT_TYPE (VARCHAR2(10)) — The system-defined assessment type to which the institution-defined type is optionally mapped.
• _LA:EXAMINABLE_INDICATOR (CHAR) — Indicates whether the assessment type is examinable or non-examinable. The _LA: prefix denotes a translated or language-attributed descriptive column.
• _LA:CLOSED_INDICATOR (CHAR) — Indicates whether the assessment type is open or closed.
• _LA:ANONYMOUS_GRADING_IND (CHAR) — Indicates whether anonymous grading applies (Y/N).
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard WHO audit columns recording creation and last-update metadata.

Common Use Cases and Queries

Typical uses include validating institution-defined assessment types during data migration or integration, generating assessment configuration reports, and producing reference listings for assessment setup. The sample below selects the core descriptive columns.

SELECT ASSESSMENT_TYPE, ASSESSMENT_TYPE_DESCRIPTION, SYSTEM_ASSESSMENT_TYPE FROM APPS.IGSBV_AS_ASSESSMENT_TYPES;

To identify examinable assessment types or those using anonymous grading, filter on the indicator columns:

SELECT ASSESSMENT_TYPE, ASSESSMENT_TYPE_DESCRIPTION FROM APPS.IGSBV_AS_ASSESSMENT_TYPES WHERE _LA:ANONYMOUS_GRADING_IND = 'Y';

To reconcile institution-defined types against their system mappings, join or filter on SYSTEM_ASSESSMENT_TYPE. Because the view is read-only and seeded, no Direct UPDATE or DELETE operations should be attempted against it; changes are made to the underlying IGS_AS_ASSESSMNT_TYP table through supported application flows.