Results for “igs_uc_map_off_resp_u1”

6 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS.IGS_UC_MAP_OFF_RESP is a reference mapping table in the Oracle E-Business Suite Recruitment (IGS) schema. It stores the mappings between UCAS decision and reply code combinations and admission offer response status codes. UCAS (Universities and Colleges Admissions Service) is the UK clearing body for undergraduate admissions, and EBS institutions integrating with UCAS use this table to translate inbound UCAS decision and reply values into the internal admissions offer response status codes understood by the Oracle admissions subsystem.

Physically, the table resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and its unique index IGS_UC_MAP_OFF_RESP_U1 — the business-key index identified in the user's search — resides in APPS_TS_TX_IDX. The table carries the standard WHO audit columns and has a documented dependency relationship in which it is referenced by the APPS synonym IGS_UC_MAP_OFF_RESP.

Under a heuristic Data Vault classification, the metadata suggests a link classification: the primary key (SYSTEM_CODE, DECISION_CODE, REPLY_CODE) associates multiple reference codes, and the table carries foreign keys to IGS_UC_SYS_DECISION and IGS_AD_OFR_RESP_STAT, an association pattern consistent with a link between reference hubs rather than a pure hub or satellite.

Key Information Stored

The table contains ten documented columns. The single most important columns are described below.

  • SYSTEM_CODE (VARCHAR2(10)) — Identifies the UCAS admissions system. It is part of the primary key IGS_UC_MAP_OFF_RESP_PK and of the unique index IGS_UC_MAP_OFF_RESP_U1, and it participates in a foreign key to IGS_UC_SYS_DECISION.
  • DECISION_CODE (VARCHAR2(10)) — The UCAS Decision Code; part of the primary key and unique index.
  • REPLY_CODE (VARCHAR2(10)) — The UCAS Reply Code; part of the primary key and unique index.
  • ADM_OFFER_RESP_STATUS (VARCHAR2(10)) — The Admissions offer response code to which the UCAS combination resolves. It carries a foreign key to IGS_AD_OFR_RESP_STAT.
  • CLOSED_IND (VARCHAR2) — A single-character indicator defaulting to 'N' that flags whether the record is valid for use; records set to a closed value are effectively retired from active mapping.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording insert and update provenance and timing.

The surrogate row identity is provided by the composite business key (SYSTEM_CODE, DECISION_CODE, REPLY_CODE) enforced through IGS_UC_MAP_OFF_RESP_U1; there is no separate numeric surrogate column documented.

Common Use Cases and Queries

The primary use case is translation during UCAS import processing: for each incoming decision/reply combination, the admissions conversion routine looks up the corresponding internal offer response status. Typical queries filter on the UCAS system and demand only active mappings.

  • Resolve a single combination: SELECT ADM_OFFER_RESP_STATUS FROM IGS.IGS_UC_MAP_OFF_RESP WHERE SYSTEM_CODE = :p_system AND DECISION_CODE = :p_decision AND REPLY_CODE = :p_reply AND CLOSED_IND = 'N';
  • Full extract of active mappings for reconciliation or setup review: SELECT SYSTEM_CODE, DECISION_CODE, REPLY_CODE, ADM_OFFER_RESP_STATUS FROM IGS.IGS_UC_MAP_OFF_RESP WHERE CLOSED_IND = 'N' ORDER BY 1, 2, 3;
  • Reverse lookup — identify which UCAS combinations map to a given internal status: filter on ADM_OFFER_RESP_STATUS.
  • Audit reporting — surface rows by CREATION_DATE or LAST_UPDATE_DATE to track mappings added or changed by setup administrators.

Related Objects

The following objects are the most significant related dependencies, grounded in the documented foreign key and dependency metadata.

  • IGS_UC_SYS_DECISION — joined on SYSTEM_CODE; the parent reference for UCAS system and decision definitions used to qualify each mapping.
  • IGS_AD_OFR_RESP_STAT — joined on ADM_OFFER_RESP_STATUS; supplies the description and attributes of the internal admissions offer response status.
  • IGS.IGS_UC_MAP_OFF_RESP (the table itself) — referenced by the APPS synonym, which is the standard access point for application code and concurrent programs.
  • UCAS import and admissions conversion components within the IGS schema consume this mapping during processing; these reference the table indirectly through the synonym rather than through declared foreign keys.

Administrators maintaining UCAS integration setup should treat this table as reference configuration data and avoid ad hoc modification, since incorrect mappings propagate directly into admissions offer response processing.