Search Results unit_section_call_number_id

Overview

The IGS_PS_USEC_CAL_NUMS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (formerly Campus Solutions) product. Its primary function is to serve as a control table for managing unique call numbers assigned to unit sections (classes) within specific academic calendar instances. By storing the maximum call number per calendar type and sequence, it ensures the generation of unique identifiers for scheduling and enrollment purposes, preventing conflicts and maintaining data integrity across the academic planning modules.

Key Information Stored

The table's design centers on a small set of critical columns that define the calendar context and the assigned call number. The UNIT_SECTION_CALL_NUMBER_ID serves as the primary key and unique surrogate identifier for each record. The CALENDER_TYPE and CI_SEQUENCE_NUMBER columns together define a specific calendar instance (e.g., "ACADEMIC" type with a specific term sequence). These two columns form a unique constraint (IGS_PS_USEC_CAL_NUMS_U2), highlighting their combined importance in identifying a distinct calendar. The CALL_NUMBER column stores the actual maximum numeric identifier that has been assigned for sections within that calendar instance. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track audit information for each row.

Common Use Cases and Queries

This table is integral to processes that create or manage class schedules. A primary use case is during the section creation workflow, where the system must generate a new, unique call number for a class within a given term. The application logic would query this table for the target CALENDER_TYPE and CI_SEQUENCE_NUMBER, increment the CALL_NUMBER, and update the record. Common queries include verifying the next available call number for a calendar or auditing call number assignments. A typical reporting query to view all control numbers would be:

• SELECT CALENDER_TYPE, CI_SEQUENCE_NUMBER, CALL_NUMBER FROM IGS.IGS_PS_USEC_CAL_NUMS ORDER BY 1, 2;

For troubleshooting, one might join this data with actual unit section tables to correlate control numbers with scheduled classes.

Related Objects

Based on the provided metadata, the IGS_PS_USEC_CAL_NUMS table is referenced by the APPS synonym of the same name (IGS_PS_USEC_CAL_NUMS), which is the standard access point for application code. The table's primary key relationship is defined by the constraint IGS_PS_USEC_CAL_NUMS_PK on the UNIT_SECTION_CALL_NUMBER_ID column. While the dependency list does not show explicit foreign key relationships from other tables, it is logically and functionally central to the unit section scheduling entities within the IGS schema. In practice, it relates to tables storing calendar definitions (for CALENDER_TYPE and CI_SEQUENCE_NUMBER context) and the main unit section tables that consume the generated CALL_NUMBER values.