Search Results extra_flag

Overview

IGS.IGS_UC_CYC_DEFAULTS is a transaction-data table in the Oracle E-Business Suite IGS (Student Systems) schema that stores cycle-level default values used by the UCAS (Universities and Colleges Admissions Service) interface. The table drives the behavior of inbound and outbound UCAS processing for a given admissions cycle, supplying the interface selection, MARVIN file sequence tracking, and various processing indicators that govern how UCAS submissions are staged, extracted, and cleared. It resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its primary key index IGS_UC_CYC_DEFAULTS_PK is stored in APPS_TS_TX_IDX. The object is registered as FND Design Data under the same name and holds VALID status in the EBS 12.1.1 and 12.2.2 data dictionary.

From a Data Vault modeling perspective, the ETRM relationship metadata classifies this object as satellite-leaning. This is consistent with its design: the table hangs off a parent key (SYSTEM_CODE referenced from IGS_UC_DEFAULTS) and carries descriptive, cycle-specific attributes such as interface selection and file sequence numbers rather than acting as an independent hub or a pure associative link. Analysts building a raw vault-style model would treat it as a satellite keyed on the business composite (SYSTEM_CODE, UCAS_CYCLE).

Key Information Stored

The table contains twelve documented columns. The most operationally significant are listed below; the surrogate versus business key distinction is important because the unique index, not the physical row identifier, defines row uniqueness.

• SYSTEM_CODE (VARCHAR2) — the UCAS system code; first column of the composite primary key and the join key back to the parent IGS_UC_DEFAULTS table.
• UCAS_CYCLE (NUMBER(15)) — the admissions cycle, documented as taking values such as 2003 and 2004; second column of the composite primary key.
• UCAS_INTERFACE (VARCHAR2) — the UCAS interface selection, determining which interface path or mode is active for the cycle.
• MARVIN_SEQ (NUMBER(15)) — the MARVIN file sequence number, which is the column most frequently sought when users search for "marvin_seq." It tracks the sequential position of generated MARVIN-format UCAS extract files.
• CLEARING_FLAG (VARCHAR2) — clearing indicator, controlling whether clearing-related processing is enabled for the cycle.
• EXTRA_FLAG (VARCHAR2) — extra processing indicator used to toggle supplementary UCAS handling.
• CVNAME_FLAG (VARCHAR2) — CVNAME indicator affecting name-format handling in UCAS transmissions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns present on the table.

The composite primary key IGS_UC_CYC_DEFAULTS_PK (SYSTEM_CODE, UCAS_CYCLE) is the unique index and therefore the business-key candidate. There is no separate surrogate column exposed in the metadata; uniqueness is enforced entirely by these two business columns.

Common Use Cases and Queries

Typical uses center on cycle configuration review, MARVIN sequence diagnostics, and interface troubleshooting. A common query retrieves the current MARVIN sequence and interface settings for a given cycle:

• SELECT SYSTEM_CODE, UCAS_CYCLE, UCAS_INTERFACE, MARVIN_SEQ, CLEARING_FLAG FROM IGS.IGS_UC_CYC_DEFAULTS WHERE UCAS_CYCLE = :cycle;
• Reporting on which cycles have clearing enabled: SELECT UCAS_CYCLE, CLEARING_FLAG FROM IGS.IGS_UC_CYC_DEFAULTS WHERE CLEARING_FLAG = 'Y';
• Auditing recent configuration changes using the WHO columns: SELECT UCAS_CYCLE, MARVIN_SEQ, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGS.IGS_UC_CYC_DEFAULTS ORDER BY LAST_UPDATE_DATE DESC;

Because MARVIN_SEQ governs file numbering, extracting its value before generating an outbound UCAS file is a standard operational check. Discrepancies in this sequence are a frequent root cause of UCAS file rejection or duplication.

Related Objects

The documented dependency data shows this table references IGS_UC_DEFAULTS through SYSTEM_CODE, and it is referenced by the APPS synonym IGS_UC_CYC_DEFAULTS. Significant related objects include:

• IGS.IGS_UC_DEFAULTS — parent table providing the system-level defaults; join on SYSTEM_CODE.
• APPS.IGS_UC_CYC_DEFAULTS — the APPS-layer synonym exposing the table to application code and reports.
• IGS_UC_CYC_DEFAULTS_PK — the unique index enforcing the composite business key.

Additional UCAS interface tables and concurrent programs in the IGS schema consume the flags and sequence values stored here, making this table a configuration anchor for the wider UCAS integration.