Search Results assessment_type_desc

Overview

IGS_AS_ANON_METHOD_V is a reporting view in the Oracle E-Business Suite (EBS) student systems product family, owned by the APPS schema in release 12.1.1 and 12.2.2. Its purpose is to expose the configuration of anonymous grading methods for assessments. Recording which assessment type may be graded anonymously, and through which grading method, is a core control in the academic records model; this view presents that configuration in a denormalised, user-readable form suitable for concurrent programs, Discoverer workbooks, OBIEE extracts and custom Oracle Forms or OAF pages.

The object is a join view rather than a table, so it is read-only. It carries no documented plural base object beyond the two tables named in its defining query, and no procedural logic other than a call to a lookup function that resolves the internal grading method code into a descriptive value.

Underlying Base Objects

The view is defined with an outer join between two tables:

• IGS_AS_ANON_METHOD (aliased ANON) — the driving table, holding the anonymous grading method setup rows, keyed by load calendar type, method and assessment type.
• IGS_AS_ASSESSMNT_TYP (aliased ASSES) — the assessment type definition table, supplying the descriptive text.

The join predicate is ANON.ASSESSMENT_TYPE = ASSES.ASSESSMENT_TYPE(+). The Oracle outer-join syntax means rows in IGS_AS_ANON_METHOD are retained even where no matching assessment type definition exists, in which case the descriptive column returns NULL. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are surfaced directly from the driving table.

Key Columns

• LOAD_CAL_TYPE — the load calendar type, identifying the teaching period context in which the anonymous grading method applies.
• METHOD — the internal code for the anonymous grading method. This is the value passed to the lookup routine.
• METHOD_DESC — derived at runtime by IGS_GE_GEN_004.GENP_GET_LOOKUP('IGS_AS_ANONYMOUS_GRADING_TYPE', anon.method). It returns the meaningful description of the grading method, insulating reports from hard-coded code values.
• ASSESSMENT_TYPE — the assessment type code linking to assessment setup.
• ASSESSMENT_TYPE_DESC — the DESCRIPTION from IGS_AS_ASSESSMNT_TYP. This is the column most commonly requested by users searching for assessment_type_desc, and its outer-joined nature means it can be null.
• Audit Columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE and LAST_UPDATE_LOGIN support data lineage and change tracking.

Common Use Cases and Queries

Typical uses include validating that every anonymous grading method is attached to a recognised assessment type, and producing reference listings for academic administration. The presence of the lookup call on every row means queries should filter by LOAD_CAL_TYPE or ASSESSMENT_TYPE rather than scanning the full view.

• Reviewing configured anonymous grading methods for a given load calendar.
• Identifying orphaned or unconfigured assessment types (where ASSESSMENT_TYPE_DESC is null).
• Feeding grade-approval or anonymisation control reports.
• Joining to other assessment setup views on ASSESSMENT_TYPE.

A representative query:

SELECT load_cal_type, method, method_desc, assessment_type, assessment_type_desc
FROM apps.igs_as_anon_method_v
WHERE load_cal_type = :p_cal_type
ORDER BY assessment_type_desc;

Because the view resolves the grading method through a PL/SQL lookup function, the function must be available and its lookup type IGS_AS_ANONYMOUS_GRADING_TYPE must be populated; missing lookup values will yield a null METHOD_DESC. Under ETRM 12.2.2, the view is documented as a simple two-table read with no additional base objects, so it remains stable across the 12.1.1 to 12.2.2 upgrade path.