Search Results clearing_flag

Overview

IGS_UC_ADM_SYSTEMS_V is an APPS-owned database view in the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to present "List of the UCAS System details," where UCAS denotes the United Kingdom Universities and Colleges Admissions Service, the central admissions body through which undergraduate applications are processed. The view exposes configuration rows governing how an institution communicates with UCAS admission systems, including the system identifier, security key, clearing behavior, and related flags.

The ETRM metadata marks this object explicitly as OBSOLETE. It remains VALID in the dictionary and is therefore queryable, but it is retained only for backward compatibility and should not be treated as a supported integration point in Oracle EBS 12.1.1 or 12.2.2. The view is a read-only presentation layer: it joins a UCAS administration configuration table to the site's lookup view so that coded values (system codes) are resolved to their human-readable meaning and description. This pattern is typical of IGS and other EBS reporting views, which denormalize coded identifiers for use in concurrent programs, BI Publisher reports, and ad hoc SQL.

Underlying Base Objects

The documented view text defines the object over two EBS data sources:

• IGS_UC_ADM_SYSTEMS ADM — the primary configuration table holding the UCAS system records, including the lookup code, security key, sequence, and various flags.
• IGS_LOOKUPS_VIEW LV — the standard IGS lookup view, used here filtered to LOOKUP_TYPE = 'IGS_UC_ADM_SYS_TYP', which supplies the lookup meaning and description for each system code.

The join is an equality between ADM.UCAS_SYSTEM_CODE and LV.LOOKUP_CODE, restricted by lookup type. This means the view only returns rows whose system code has a corresponding active lookup entry in the IGS_UC_ADM_SYS_TYP lookup type. Rows orphaned from that lookup are silently excluded. Note that the ETRM 12.2.2 metadata lists no documented referenced base objects, so the join is described here on the basis of the view text itself rather than the base-object registry.

Key Columns

• ROW_ID — the row identifier of the underlying IGS_UC_ADM_SYSTEMS row.
• SYSTEM_ID — the primary key of the UCAS system configuration record.
• NAME — the lookup meaning, giving the descriptive name of the system code.
• DESCRIPTION — the lookup description associated with the code.
• UCAS_SYSTEM_CODE — the lookup code from IGS_UC_ADM_SYS_TYP; this is the column most often referenced by users searching for "ucas_system_code."
• UCAS_SECURITY_KEY — the security credential used when exchanging data with the UCAS system.
• MARVIN_SEQ — the sequence value associated with MARVIN, the UCAS data-transfer mechanism.
• CLEARING_FLAG, EXTRA_FLAG, CVNAME_FLAG — indicator flags controlling clearing behavior, extra processing, and CV name handling respectively.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns mirrored from the base table.

Common Use Cases and Queries

Because the object is obsolete, its principal practical use is diagnostic: identifying which UCAS system codes are configured, verifying the associated security key and clearing flags, and confirming lookup alignment. A typical query retrieves the resolved code set:

SELECT ucas_system_code, name, description, clearing_flag
FROM apps.igs_uc_adm_systems_v
ORDER BY ucas_system_code;

To confirm there are no orphaned configuration rows — that every system row has a matching lookup entry — a query can be run against the excluded set using the base table directly, since the view itself cannot expose these rows. For active implementations, the recommended path is to query IGS_UC_ADM_SYSTEMS and IGS_LOOKUPS_VIEW directly, or to consult the replacement objects indicated by the relevant patch or upgrade documentation, rather than relying on this retained compatibility view.