Search Results igs_uc_map_off_resp




Overview
Explore in AI Chat

Overview

The table IGS_UC_MAP_OFF_RESP is a data mapping entity within the Oracle E-Business Suite 12.1.1 and 12.2.2, specifically designed for the now-obsolete Student System (IGS) module. Its primary function is to act as a translation layer between external UCAS (Universities and Colleges Admissions Service) decision codes and the internal admission offer response statuses used by the institution's system. This mapping is critical for automating the processing of applicant decisions received via the UCAS system, ensuring that external status codes are correctly interpreted and reflected in the internal student lifecycle management processes.

Key Information Stored

The table's structure is defined by a composite primary key and several foreign key relationships. The core data stored consists of specific code combinations and their corresponding internal mappings. The primary key columns are SYSTEM_CODE, DECISION_CODE, and REPLY_CODE, which together uniquely identify a specific UCAS decision scenario. The pivotal mapping column is ADM_OFFER_RESP_STATUS, which stores the internal admission offer response status code from the IGS_AD_OFR_RESP_STAT table that corresponds to the given UCAS code combination. This design allows for a precise one-to-one mapping between external UCAS communication and internal system states.

Common Use Cases and Queries

The primary use case for this table is during the automated batch or interface processing of UCAS decision files. When a new UCAS decision record is imported, a query against this mapping table determines the appropriate internal admission status to apply to the applicant's record. A typical SQL pattern for this lookup would be:

  • SELECT map.adm_offer_resp_status FROM igs_uc_map_off_resp map WHERE map.system_code = :p_system_code AND map.decision_code = :p_decision_code AND map.reply_code = :p_reply_code;

This mapping is essential for accurate reporting on admission funnel metrics, as it ensures all applicant responses, regardless of origin, are categorized consistently within the institution's operational reports. Administrators might also query this table to audit or maintain the mapping rules themselves.

Related Objects

The functionality of IGS_UC_MAP_OFF_RESP is intrinsically linked to two other tables via foreign key constraints, ensuring referential integrity. The documented relationships are:

  • IGS_AD_OFR_RESP_STAT: The column IGS_UC_MAP_OFF_RESP.ADM_OFFER_RESP_STATUS references this table. It validates that the mapped internal status code is a valid admission offer response status within the system.
  • IGS_UC_SYS_DECISION: The columns IGS_UC_MAP_OFF_RESP.SYSTEM_CODE and IGS_UC_MAP_OFF_RESP.DECISION_CODE together reference this table. This ensures that the UCAS decision code being mapped is recognized and valid within the configured UCAS system definitions.

These relationships create a controlled data model where mappings can only be defined for pre-existing, valid codes in both the external (UCAS) and internal (Admissions) domains.

  • Table: IGS_UC_MAP_OFF_RESP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_UC_MAP_OFF_RESP,  object_name:IGS_UC_MAP_OFF_RESP,  status:VALID,  product: IGS - Student System ,  description: Stores the mappings between UCAS decision,reply code combinations and admission offer response status codes ,  implementation_dba_data: IGS.IGS_UC_MAP_OFF_RESP , 

  • Table: IGS_UC_SYS_DECISION 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_UC_SYS_DECISION,  object_name:IGS_UC_SYS_DECISION,  status:VALID,  product: IGS - Student System ,  description: Seeded Table containing the system decision codes ,  implementation_dba_data: IGS.IGS_UC_SYS_DECISION , 

  • View: IGS_UC_MAP_OFF_RESP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_UC_MAP_OFF_RESP_V,  object_name:IGS_UC_MAP_OFF_RESP_V,  status:VALID,  product: IGS - Student System ,  description: Shows the mappings between the UCAS decision ,reply codes and oss offer response status codes along with the descriptions ,  implementation_dba_data: APPS.IGS_UC_MAP_OFF_RESP_V , 

  • Table: IGS_AD_OFR_RESP_STAT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_OFR_RESP_STAT,  object_name:IGS_AD_OFR_RESP_STAT,  status:VALID,  product: IGS - Student System ,  description: Describes user-defined admission offer response statuses, which map to system admission offer response statuses ,  implementation_dba_data: IGS.IGS_AD_OFR_RESP_STAT ,