Search Results adm_cal_seq_no

Overview

The IGS_UC_SYS_CALNDRS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (iGrads) product family. It functions as a critical mapping table for the Universities and Colleges Admissions Service (UCAS) integration. Its primary role is to maintain the relationship between UCAS application cycles—defined by an entry year and month—and the corresponding internal academic and admission calendars managed within the Oracle Student System (OSS). This mapping is essential for correctly processing and aligning UCAS applications with the institution's internal academic timelines and administrative workflows.

Key Information Stored

The table stores a combination of UCAS identifiers and internal calendar references. The primary key uniquely identifies a UCAS application cycle and is composed of SYSTEM_CODE, ENTRY_YEAR, and ENTRY_MONTH. The ENTRY_MONTH column is a crucial field, as it defines the specific month within the entry year for the UCAS cycle. The table then maps this cycle to two distinct internal calendar types and their sequence numbers: ACA_CAL_TYPE and ACA_CAL_SEQ_NO for the academic calendar, and ADM_CAL_TYPE and ADM_CAL_SEQ_NO for the admission calendar. Standard EBS WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track row creation and maintenance history.

Common Use Cases and Queries

A primary use case is retrieving the internal academic or admission calendar details for a specific UCAS application entry point. This is vital for processes like generating offer letters, setting decision deadlines, or aligning applicant data with the correct term. Reports on UCAS cycle configurations also rely on this table. Common query patterns include fetching the calendar mapping for a known UCAS entry period or listing all configured cycles. For example, to find the internal academic calendar for UCAS entries in September 2024:

• SELECT ACA_CAL_TYPE, ACA_CAL_SEQ_NO FROM IGS.IGS_UC_SYS_CALNDRS WHERE ENTRY_YEAR = 2024 AND ENTRY_MONTH = 9;

Another frequent pattern is a join to OSS calendar tables (like IGS_CA_INST) using the ACA_CAL_TYPE and ACA_CAL_SEQ_NO or ADM_CAL_TYPE and ADM_CAL_SEQ_NO to pull descriptive calendar details for reporting.

Related Objects

As per the dependency information, the IGS_UC_SYS_CALNDRS table is referenced by an APPS synonym named IGS_UC_SYS_CALNDRS. This synonym facilitates access from the EBS application tier. The table's core relationships are logical, pointing to calendar entities within the Oracle Student System, such as those defined by the IGS_CA_INST table or similar structures for academic and admission calendar types. It serves as a foundational lookup for any UCAS-related functional modules or data feeds that require translation between UCAS timelines and institutional academic periods.