Search Results igs_uc_defaults_pk




Overview
Explore in AI Chat

Overview

The IGS_UC_DEFAULTS table is a critical configuration table within the Oracle E-Business Suite Student System (IGS) module, specifically for institutions integrated with the UK's Universities and Colleges Admissions Service (UCAS). Its primary role is to serve as a central repository for default values that are automatically applied to UCAS application records during their import into the Oracle Student System (OSS). As documented, a key architectural constraint is that this table is designed to always contain exactly one record at any given time, ensuring a single, consistent set of defaults governs the UCAS import process for the entire system instance.

Key Information Stored

The table's structure is defined by its primary key, SYSTEM_CODE, and a series of foreign key columns that reference specific lookup values from other application tables. These columns establish the default mappings and statuses for incoming data. Key columns include APPLICATION_TYPE (default application type), DECISION_MAKE_ID (default decision-maker), and several outcome status defaults such as PENDING_OUTCOME_STATUS, REJECTED_OUTCOME_STATUS, and OBSOLETE_OUTCOME_STATUS. Other significant fields are NI_NUMBER_ALT_PERS_TYPE, which defines an alternate person type for National Insurance numbers, and DECISION_REASON_ID for a default decision reason. The singular SYSTEM_CODE primary key underscores the table's role as a system-wide control point.

Common Use Cases and Queries

The primary use case is the batch import and processing of UCAS application data, where the values in this table populate mandatory fields in applicant, course detail, and transaction records if the UCAS data is incomplete. Administrators typically query or maintain this table via a dedicated administrative form in the EBS application. Direct SQL interaction is generally for verification or troubleshooting. A fundamental query retrieves the single default record: SELECT * FROM igs.igs_uc_defaults WHERE system_code = [VALUE];. Another common pattern involves joining to referenced tables to decode the default IDs, for example, joining to IGS_AD_OU_STAT to resolve the meaning of the stored PENDING_OUTCOME_STATUS code. Reporting use cases focus on auditing the current import configuration to ensure alignment with institutional business rules.

Related Objects

IGS_UC_DEFAULTS is a central hub in the UCAS data model, referenced by numerous transactional and control tables via foreign key relationships. As per the provided metadata, the primary key IGS_UC_DEFAULTS_PK on SYSTEM_CODE is referenced by:

Conversely, IGS_UC_DEFAULTS itself holds foreign keys to lookup tables to ensure data integrity: IGS_PE_PERSON_ID_TYP (NI_NUMBER_ALT_PERS_TYPE), IGS_AD_SS_APPL_TYP (APPLICATION_TYPE), IGS_AD_CODE_CLASSES (DECISION_REASON_ID), IGS_AD_OU_STAT (for three status columns), and HZ_PARTIES (DECISION_MAKE_ID).