Search Results igs_uc_adm_systems

Overview

IGS_UC_ADM_SYSTEMS is a configuration table within the IGS (Student System) product family of Oracle E-Business Suite. Its documented purpose is to hold the list of UCAS (Universities and Colleges Admissions Service) system details. UCAS is the United Kingdom's centralized admissions service, and within the IGS Student System the table served as a reference repository for the identifiers and security credentials used when exchanging applicant data between the institution's EBS instance and the UCAS central systems.

The ETRM documentation flags this object explicitly as OBSOLETE, and the implementation notes record that it is "Not implemented in this database." In Oracle EBS 12.1.1 and 12.2.2, the table is therefore a legacy artifact retained in the data dictionary for backward compatibility and historical reference rather than an object that participates in active processing. The table is owned by the IGS schema and carries 14 documented columns in the 12.1.1 physical schema.

The mined Data Vault classification is standalone, with no foreign key relationships to other tables. Under Data Vault modeling conventions this would suggest treating the object as a hub-like reference entity keyed on its own business identifier, with no associated link or satellite structures — a modeling suggestion only, since the table exhibits no outgoing relationships in the documented FK structure.

Key Information Stored

The primary key is defined by the constraint IGS_UC_ADM_SYSTEMS_PK on the column SYSTEM_ID. This surrogate identifier is the sole documented unique key; no separate business-key unique index is recorded in the metadata, so the natural candidate keys — the UCAS-specific codes — should be treated as descriptive attributes rather than enforced unique identifiers in the documented model.

• SYSTEM_ID — Surrogate primary key, populated from the IGS sequence convention.
• NAME — Human-readable name of the UCAS system entry.
• DESCRIPTION — Free-text explanation of the system's purpose or scope.
• UCAS_SYSTEM_CODE — The code assigned by UCAS identifying the external system or admissions cycle.
• UCAS_SECURITY_KEY — Credential material used to authenticate data transmissions with UCAS.
• CLEARING_FLAG — Indicates whether the entry applies to the UCAS Clearing process.
• EXTRA_FLAG — Configuration indicator for supplementary or non-standard processing.
• CVNAME_FLAG — Flag governing character-set or validation naming behavior for the entry.
• MARVIN_SEQ — Sequencing column used by the legacy Marvin data-transfer utilities.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording row provenance.

Common Use Cases and Queries

Because the object is obsolete and not implemented, production use is limited to historical reporting, upgrade impact assessment, and data-migration reconciliation. A typical query enumerates all configured systems:

SELECT system_id, name, ucas_system_code, clearing_flag
FROM igs.igs_uc_adm_systems
ORDER BY system_id;

Analysts auditing UCAS connectivity historically filtered on the clearing indicator:

SELECT name, ucas_system_code, extra_flag
FROM igs.igs_uc_adm_systems
WHERE clearing_flag = 'Y';

During 12.1.1 to 12.2.2 upgrade planning, the table is examined to confirm whether any custom extensions reference SYSTEM_ID, and to verify that the object can be dropped when the UCAS integration is retired. Security reviews may also inspect UCAS_SECURITY_KEY to ensure no live credentials persist in a dormant table.

Related Objects

The documented relationship data classifies IGS_UC_ADM_SYSTEMS as standalone, with no foreign keys to or from other IGS objects. Consequently, the related objects listed below are inferred from the UCAS integration domain rather than derived from enforced constraints:

• IGS_UC_ADM_SYSTEMS_PK — The primary key constraint on SYSTEM_ID.
• IGS_UC_APPLICANTS — Applicant-level UCAS records that historically resolved system context via the UCAS system code.
• IGS_UC_CHOICES — Choice records transmitted to UCAS under a given system configuration.
• IGS_UC_OFFERS — Offers exchanged with UCAS in the same integration flow.
• IGS_UC_INSTITUTIONS — Institution reference data shared with the UCAS interfaces.
• IGS_UC_PROCESSES — Batch process definitions that consumed the security key and system code.
• IGS_UC_IMPORT — Inbound staging structures for UCAS data loads.
• IGS_UC_EXPORT — Outbound staging structures for UCAS submissions.

Given the obsolete status, any references should be validated against the actual 12.1.1 or 12.2.2 schema before reliance, as customizations may still join on UCAS_SYSTEM_CODE or SYSTEM_ID despite the absence of declared foreign keys.