Search Results igs_uc_map_out_stat

Overview

The IGS_UC_MAP_OUT_STAT table is a critical reference table within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically in versions 12.1.1 and 12.2.2. Its primary function is to store the mapping relationships between external UCAS (Universities and Colleges Admissions Service) decision codes and the internal Oracle EBS admission outcome status codes. This mapping is essential for the automated processing of student applications received through the UCAS system, ensuring that decisions communicated by UCAS are correctly interpreted and reflected within the institution's internal student information system. The table acts as a translation layer, enabling seamless data integration and maintaining consistency in application status tracking across the two systems.

Key Information Stored

The table's structure is defined by a composite primary key and a mapping column. The key columns identify the specific UCAS context and decision, while the mapping column points to the corresponding internal status. The SYSTEM_CODE identifies the specific UCAS system or context for the decision. The DECISION_CODE stores the actual decision code received from UCAS. The ADM_OUTCOME_STATUS column holds the internal Oracle EBS admission outcome status code (from the IGS_AD_OU_STAT table) that corresponds to the given UCAS system and decision code combination. This design ensures a precise, one-to-one mapping that dictates how an incoming UCAS decision updates an applicant's record.

Common Use Cases and Queries

The primary use case is the batch or real-time processing of UCAS decision files. When a decision is imported, a process queries this table to find the matching ADM_OUTCOME_STATUS for the provided SYSTEM_CODE and DECISION_CODE, then updates the applicant's admission record accordingly. Common queries include retrieving the full mapping set for validation or reporting, and finding the internal status for a specific UCAS code. For example, to find the internal status for a UCAS decision code 'U' in system 'UG':

• SELECT adm_outcome_status FROM igs.igs_uc_map_out_stat WHERE system_code = 'UG' AND decision_code = 'U';

Administrators may also query the table to audit or maintain the mapping rules, ensuring synchronization with any changes in UCAS codes or internal business processes.

Related Objects

The IGS_UC_MAP_OUT_STAT table has defined foreign key relationships with two other tables, centralizing its role in the data model. It references the IGS_AD_OU_STAT table via the ADM_OUTCOME_STATUS column. This links the mapping to the valid list of internal admission outcome statuses. It also references the IGS_UC_SYS_DECISION table via the composite key of SYSTEM_CODE and DECISION_CODE. This ensures that only valid, predefined UCAS system and decision code combinations can be used in the mapping. These relationships enforce data integrity, guaranteeing that mappings point to existing and valid codes in both the external (UCAS) and internal (EBS) domains.