Results for “reply_code”

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

Overview

The IGS_UC_MAP_OFF_RESP table is a reference configuration table within the IGS (Student System) product of Oracle E-Business Suite. It stores the mapping rules that translate UCAS (Universities and Colleges Admissions Service) decision and reply code combinations into the internal admission offer response status codes used by Oracle Student System. UCAS is the UK centralised admissions service, and institutions receive decision and reply codes from UCAS that must be reconciled with their own offer response workflows. This table provides the crosswalk that enables that reconciliation, allowing the system to interpret an incoming UCAS decision/reply pair and assign the corresponding offer response status.

Under the heuristic Data Vault classification derived from its foreign key structure, the table is modelled as a link. It sits between the UCAS decision reference data and the admission offer response status reference data, resolving the many-to-many relationship between UCAS decision/reply combinations and institutional offer response statuses. This classification is a modelling suggestion rather than a documented physical attribute; the actual implementation is a conventional relational mapping table with a composite primary key.

Key Information Stored

The table contains ten documented columns in the ETRM 12.1.1 physical schema. The composite primary key, enforced by index IGS_UC_MAP_OFF_RESP_PK, comprises three columns: SYSTEM_CODE, DECISION_CODE, and REPLY_CODE. The same three-column set is also defined as the unique business-key candidate through index IGS_UC_MAP_OFF_RESP_U1, meaning a single system/decision/reply combination resolves to exactly one offer response status. The most important columns are:

• SYSTEM_CODE — Identifies the UCAS system context for the decision; part of the primary key and a foreign key to IGS_UC_SYS_DECISION.
• DECISION_CODE — The UCAS decision code; part of the primary key and also a foreign key to IGS_UC_SYS_DECISION.
• REPLY_CODE — The UCAS reply code supplied by the applicant; part of the primary key.
• ADM_OFFER_RESP_STATUS — The resultant internal admission offer response status; a foreign key to IGS_AD_OFR_RESP_STAT and the core output of the mapping.
• CLOSED_IND — Indicates whether the mapping is currently active or retired.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording who created and last modified each mapping row and when.

The three key columns constitute the surrogate and business key; ADM_OFFER_RESP_STATUS carries the substantive mapping value, while CLOSED_IND governs whether the mapping remains in effect.

Common Use Cases and Queries

Typical uses include resolving an incoming UCAS decision/reply pair to an institutional offer response status during admissions import, and reporting on which UCAS outcomes drive which internal statuses. A representative lookup query is:

• SELECT ADM_OFFER_RESP_STATUS FROM IGS_UC_MAP_OFF_RESP WHERE SYSTEM_CODE = :p_sys AND DECISION_CODE = :p_dec AND REPLY_CODE = :p_rep AND NVL(CLOSED_IND,'N') = 'N';
• Auditing active mappings: joining to IGS_AD_OFR_RESP_STAT to report the human-readable status description for each decision/reply combination.
• Detecting configuration gaps where UCAS decision/reply combinations arriving in transaction data have no matching mapping row.

Related Objects

The foreign key metadata identifies the principal related objects. IGS_AD_OFR_RESP_STAT is referenced by the ADM_OFFER_RESP_STATUS column and supplies the valid internal offer response statuses. IGS_UC_SYS_DECISION is referenced by SYSTEM_CODE and DECISION_CODE and provides the authoritative UCAS decision reference data validated by the composite foreign key. Together these two tables flank the link and form the core reference set. Applications and concurrent programs that translate UCAS admissions data depend on this table to assign offer response statuses, and any reporting layer that reconciles UCAS decisions with institutional admission outcomes joins through it.