Search Results action_dt




Overview
Explore in AI Chat

Overview

The IGS_AS_UNTAS_PATTERN view is a critical data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for releases 12.1.1 and 12.2.2. It provides a multi-organization (Multi-Org) enabled perspective on the assessment patterns that constitute the assessment requirements for an academic unit. The view filters the underlying base table data (IGS_AS_UNTAS_PATTERN_ALL) based on the current operating unit context derived from the user's session, ensuring data security and isolation. Its primary role is to define and manage the specific assessment structures—such as exams, assignments, and projects—that students must complete for a unit offering within a given academic calendar.

Key Information Stored

The view consolidates key identifiers and descriptive attributes for unit assessment patterns. Essential columns include UNIT_CD, VERSION_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER, which together identify the specific unit offering. The ASS_PATTERN_ID and ASS_PATTERN_CD uniquely identify the assessment pattern itself. Operational flags and dates govern the pattern's lifecycle: DFLT_PATTERN_IND specifies a default pattern, LOGICAL_DELETE_DT supports soft deletion, and the ACTION_DT column, noted in the user's search, is a significant date field typically recording when a key action (like pattern activation or a status change) was taken. Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and program context columns (REQUEST_ID, PROGRAM_ID) are also present.

Common Use Cases and Queries

This view is central to academic operations and reporting. Common use cases include generating unit assessment outlines, validating student assessment loads, and auditing changes to assessment requirements. A typical query might retrieve all active assessment patterns for a unit to display in a course catalog, often filtering out logically deleted records. For example, to find patterns for a specific unit where an action occurred after a certain date, one might use:

  • SELECT UNIT_CD, ASS_PATTERN_CD, DESCRIPTION, ACTION_DT FROM APPS.IGS_AS_UNTAS_PATTERN WHERE UNIT_CD = 'MATH101' AND LOGICAL_DELETE_DT IS NULL AND ACTION_DT > '01-JAN-2023';

Reporting often involves joining this view with related calendar and unit definition tables to produce comprehensive assessment schedules.

Related Objects

IGS_AS_UNTAS_PATTERN is part of a tightly integrated schema within the Student System. Its primary key, IGS_AS_UNTAS_PATTERN_PK, is defined on the columns UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, and ASS_PATTERN_ID. This key is frequently referenced by foreign keys in child tables that store detailed assessment items or student results. The provided metadata indicates a foreign key relationship from the view's UNIT_MODE column, though the specific referenced table is not fully detailed in the excerpt. The view's source is the ALL table (IGS_AS_UNTAS_PATTERN_ALL), and it is inherently related to core IGS tables defining units (IGS_PS_UNIT_VER), calendars (IGS_CA_INST), and assessment components.

  • View: IGS_AS_UNTAS_PATTERN 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AS_UNTAS_PATTERN,  object_name:IGS_AS_UNTAS_PATTERN,  status:VALID,  product: IGS - Student System ,  description: IGS_AS_UNTAS_PATTERN describes the assessment patterns that make up the assessment requirement for a unit. ,  implementation_dba_data: APPS.IGS_AS_UNTAS_PATTERN , 

  • View: IGS_AS_UNITASS_ITEM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AS_UNITASS_ITEM_V,  object_name:IGS_AS_UNITASS_ITEM_V,  status:VALID,  product: IGS - Student System ,  description: This view displays the assessment item for a unit offering. ,  implementation_dba_data: APPS.IGS_AS_UNITASS_ITEM_V , 

  • View: IGS_PS_UNITASS_ITEM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_UNITASS_ITEM_V,  object_name:IGS_PS_UNITASS_ITEM_V,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGS_PS_UNITASS_ITEM_V , 

  • View: IGS_AS_UNITASS_ITEM 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AS_UNITASS_ITEM,  object_name:IGS_AS_UNITASS_ITEM,  status:VALID,  product: IGS - Student System ,  description: IGS_AS_UNITASS_ITEM describes the assessment items that are allocated to a unit version within a nominated teaching calendar instance, such as unit offering pattern. A unit might be assigned many assessment items, and in turn, an assessmen ,  implementation_dba_data: APPS.IGS_AS_UNITASS_ITEM , 

  • View: IGS_AS_UAP_ITEM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AS_UAP_ITEM_V,  object_name:IGS_AS_UAP_ITEM_V,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGS_AS_UAP_ITEM_V , 

  • View: IGS_PE_HOLD_REL_OVR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PE_HOLD_REL_OVR_V,  object_name:IGS_PE_HOLD_REL_OVR_V,  status:VALID,  product: IGS - Student System ,  description: Describes the Hold override or release details ,  implementation_dba_data: APPS.IGS_PE_HOLD_REL_OVR_V , 

  • View: IGS_TR_STEP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_TR_STEP_V,  object_name:IGS_TR_STEP_V,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGS_TR_STEP_V , 

  • View: IGS_AS_UAI_EXAM_CI_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AS_UAI_EXAM_CI_V,  object_name:IGS_AS_UAI_EXAM_CI_V,  status:VALID,  product: IGS - Student System ,  description: IGS_AS_UAI_EXAM_CI_V describes the examination calendar instances that a unit assessment item record is examined. This is determined based on the relationships between the teaching and examination calendar instances and the override uai.exa ,  implementation_dba_data: APPS.IGS_AS_UAI_EXAM_CI_V , 

  • View: IGS_AS_UAI_EXAM_CI_INIT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AS_UAI_EXAM_CI_INIT_V,  object_name:IGS_AS_UAI_EXAM_CI_INIT_V,  status:VALID,  product: IGS - Student System ,  description: Describes the examination calendar instances that a unit assessment item record is examined. This view ignores the relationship represented in the uai.exam_cal_type, exam_ci_sequence_number fields. ,  implementation_dba_data: APPS.IGS_AS_UAI_EXAM_CI_INIT_V ,