Search Results igs_ps_usec_act_type




Overview
Explore in AI Chat

Overview

The IGS_PS_USEC_ACT_TYPE table is a reference data table within the Oracle E-Business Suite Student System (IGS), specifically designed for the management of academic units. Its primary function is to store and define the distinct types of instructional activities that can be associated with a unit section, such as a lecture, tutorial, laboratory session, or seminar. This table provides a standardized classification system for scheduling and resource planning within the academic structure. It is critical to note that, according to the provided ETRM documentation, this table and the encompassing IGS module are marked as "Obsolete." Furthermore, the metadata explicitly states it was "Not implemented in this database," indicating it may have been a planned or legacy component not deployed in standard instances of Oracle EBS 12.1.1 or 12.2.2.

Key Information Stored

The table's structure centers on a unique identifier and a code for each activity type. The primary technical identifier is the ACTIVITY_TYPE_ID column, which serves as the system's internal primary key (IGS_PS_USEC_ACT_TYPE_PK). For business and reporting purposes, the ACTIVITY_TYPE_CODE column is the unique, human-readable key (enforced by the IGS_PS_USEC_ACT_TYPE_UK1 unique key). While the provided metadata does not list descriptive columns like ACTIVITY_TYPE_NAME or DESCRIPTION, such fields would typically exist in a reference table of this nature to provide a full textual description of each activity type code.

Common Use Cases and Queries

In a functional implementation, this table would be queried to populate lists of valid activity types for user interfaces, validate data entry, and support reporting on scheduled academic activities. Common SQL operations would include joining to scheduling tables to categorize instructional hours. A typical reporting query might resemble:

  • SELECT act.ACTIVITY_TYPE_CODE, COUNT(sched.UNIT_SECTION_ID) AS Scheduled_Count FROM IGS_PS_USEC_ACT_TYPE act LEFT JOIN IGS_PS_US_UNSCHED_CL sched ON act.ACTIVITY_TYPE_ID = sched.ACTIVITY_TYPE_ID GROUP BY act.ACTIVITY_TYPE_CODE;

Given its obsolete and unimplemented status, direct operational or integration use cases in active EBS environments are highly unlikely. Its primary relevance is for technical consultants analyzing legacy data models or performing historical data migrations.

Related Objects

The documented relationship data indicates a single foreign key dependency from the scheduling table. The IGS_PS_US_UNSCHED_CL table, which manages unscheduled class details for unit sections, references IGS_PS_USEC_ACT_TYPE to classify its activities. The relationship is defined as:

  • Foreign Key: From IGS_PS_US_UNSCHED_CL.ACTIVITY_TYPE_ID to IGS_PS_USEC_ACT_TYPE.ACTIVITY_TYPE_ID.

This relationship enforces referential integrity, ensuring that any activity type assigned to a unit section class exists in the central reference table. The absence of other documented foreign keys suggests this was a focused lookup table with a specific purpose in the scheduling sub-module of the obsolete Student System.