Search Results dflt_item_ind




Overview
Explore in AI Chat

Overview

The view IGS_AS_UNITASS_ITEM is a critical data object within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2, specifically for the now-obsolete IGS (Student System) module. It serves as the primary interface for querying the assignment of assessment items to a specific unit version offered within a particular teaching calendar instance, such as a unit offering pattern. This view encapsulates the relationship between a unit offering and its constituent assessment components (e.g., exams, assignments), enabling the academic structure to define what work students must complete. The underlying logic filters records based on the Multi-Org context (ORG_ID) derived from the user's session, ensuring data security and partitioning. It is important to note the ETRM metadata explicitly states this view is "Not implemented in this database," indicating it may be a reference definition or its deployment is conditional.

Key Information Stored

The view consolidates columns that define the assessment item's context, scheduling, and configuration. Key identifiers include UNIT_CD, VERSION_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER to pinpoint the unit offering. The assessment item itself is identified by ASS_ID and SEQUENCE_NUMBER. Critical scheduling and descriptive columns are DUE_DT, REFERENCE, and DESCRIPTION. A column of particular interest, as indicated by the user's search, is DFLT_ITEM_IND. This flag likely denotes whether the assessment item is a default or standard item for the unit. Other significant columns manage lifecycle (LOGICAL_DELETE_DT, ACTION_DT), grading linkage (GRADING_SCHEMA_CD, GS_VERSION_NUMBER), exam scheduling (EXAM_CAL_TYPE), weighting (MIDTERM_WEIGHT_QTY, FINAL_WEIGHT_QTY), and the standard EBS audit and WHO columns (CREATED_BY, LAST_UPDATE_DATE, etc.).

Common Use Cases and Queries

This view is primarily used for reporting and data extraction related to academic assessment planning. Common scenarios include generating a list of all assessment items for a unit offering in a given term, auditing default assessment setups, and verifying due dates. A sample query to find default assessment items for a specific unit would leverage the DFLT_ITEM_IND column:

  • SELECT unit_cd, version_number, ass_id, sequence_number, due_dt, description FROM igs_as_unitass_item WHERE unit_cd = 'MATH101' AND cal_type = 'SEMESTER1' AND dflt_item_ind = 'Y';

Another typical use case involves joining this view to student result tables to analyze assessment workload or compliance. Reports on assessment schedules for a teaching calendar instance would filter on CAL_TYPE and CI_SEQUENCE_NUMBER while selecting DUE_DT and REFERENCE.

Related Objects

The view's definition reveals a direct dependency on the base table IGS_AS_UNITASS_ITEM_ALL, from which it selects and applies the Multi-Org security filter. It is intrinsically related to other core IGS tables defining the academic structure, such as those storing Unit (IGS_PS_UNIT), Calendar Instances (IGS_CA_INST), and Assessment Definitions (IGS_AS_ASSESSMNT_ITM). The presence of columns like GRADING_SCHEMA_CD and GS_VERSION_NUMBER indicates a relationship to grading schema tables. Furthermore, this view would be referenced by higher-level assessment and result processing logic within the student system, though specific API or package dependencies are not detailed in the provided metadata.