Search Results sua_unit_mode




Overview
Explore in AI Chat

Overview

IGS_AS_UAP_SUA_V is a public Oracle E-Business Suite view owned by the APPS schema and registered under FND Design Data as IGS.IGS_AS_UAP_SUA_V. In Oracle EBS 12.1.1 and 12.2.2 it belongs to the Student Systems (IGS) product family, specifically the Assessment (IGS_AS) module, which supports the recording and processing of student assessment outcomes, marks, and grades in an institution's student record. The view describes the assessment patterns that make up the assessment requirement for a student's unit attempt, effectively joining student unit attempt (SUA) context to the unit assessment pattern (UAP) definition that applies to it.

Because it is documented as a public view, Oracle exposes it explicitly for custom reporting and other data requirements, rather than restricting it to internal application use. Its role is therefore that of a reporting and integration surface: it lets institutions and integrators retrieve, in a single flat structure, the assessment pattern information associated with a student's attempt at a unit, without having to reimplement the join logic between the student unit attempt and the unit assessment pattern tables. The object carries a VALID status, indicating that it is compiled and usable in the environment from which the metadata was extracted.

Underlying Base Objects

The ETRM metadata for this view does not enumerate the underlying base tables it is defined over; the referenced base objects list is empty in the documented record. Based on the IGS_AS naming conventions and the column set, the view is derived from the student unit attempt assessment and unit assessment pattern entities within the Assessment module. The column naming reflects two contributing sources: columns prefixed UAP_ originate from the unit assessment pattern definition, while columns prefixed SUA_ originate from the student unit attempt record. Columns such as PERSON_ID, COURSE_CD, UNIT_CD, VERSION_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER supply the student and offering context that keys the attempt, and ASS_PATTERN_ID, ASS_PATTERN_CD, and DESCRIPTION carry the pattern identity and description.

Where documented references are not available, the safest practice is to inspect the view source through the data dictionary (for example, by querying ALL_VIEWS and ALL_DEPENDENCIES, or using the view text exposed in the ETRM "View Source" section) before building dependencies on it. This confirms the exact base tables and any inline filters or decode logic that shape the returned rows.

Key Columns

  • PERSON_ID – Person identifier for the student whose unit attempt is described.
  • COURSE_CD – Program (course) code associated with the attempt.
  • UNIT_CD, VERSION_NUMBER – Unit code and unit version number of the attempted unit.
  • CAL_TYPE, CI_SEQUENCE_NUMBER – Calendar type and calendar instance sequence number, giving the teaching period context.
  • ASS_PATTERN_ID, ASS_PATTERN_CD, DESCRIPTION – Assessment pattern identifier, code, and description making up the assessment requirement.
  • UAP_LOCATION_CD, UAP_UNIT_CLASS, UAP_UNIT_MODE, UAP_DFLT_PATTERN_IND, UAP_LOGICAL_DELETE_DT – Attributes of the unit assessment pattern, including its location, class, mode, default-pattern indicator, and logical deletion date (the last of which enables soft-delete handling).
  • SUA_LOCATION_CD, SUA_UNIT_CLASS, SUA_UNIT_MODE – Attributes of the student unit attempt itself.
  • DEG_AUD_DETAIL_ID, UOO_ID – Degree Audit Detail identifier and Unit Section identifier, supporting links to degree audit processing and unit section structure.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard Who columns for audit traceability.

Common Use Cases and Queries

Typical uses include reporting the assessment patterns in force for a student's unit attempts, extracting assessment requirement data for integration with external marking or learning-management systems, and auditing where the UAP and SUA attributes differ (for example, class or mode mismatches). The following query lists assessment patterns for a given student.

SELECT person_id, unit_cd, version_number, ass_pattern_cd, description, sua_unit_class, uap_unit_class, uap_dflt_pattern_ind FROM apps.igs_as_uap_sua_v WHERE person_id = :p_person_id;

To isolate active patterns only, filter on the logical deletion date: WHERE uap_logical_delete_dt IS NULL. Because the view is public but its base objects are not enumerated in the ETRM record, always validate column semantics against the live source in the target release (12.1.1 or 12.2.2) before embedding it in scheduled reports or interfaces.