Search Results igs_uc_sys_decision

Overview

The IGS_UC_SYS_DECISION table is a seeded reference table within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its primary role is to serve as a master repository for system decision codes. These standardized codes are critical for managing and tracking application decisions, particularly in contexts related to admissions and student lifecycle management. As a seeded table, its data is pre-populated by Oracle, and it functions as a foundational lookup entity that ensures data integrity and consistency across related transactional tables. Its existence is essential for the proper functioning of processes that map internal decision states to external system codes or default values.

Key Information Stored

The table's structure is defined by a composite primary key, which dictates the core data it holds. The SYSTEM_CODE column identifies the specific external or internal system context for which the decision code is valid. The DECISION_CODE column stores the actual decision value or identifier within that system context. While the provided metadata does not list additional descriptive columns, such as MEANING or DESCRIPTION, which are common in seeded lookup tables, the combination of these two key columns uniquely defines a valid system decision record. This pairing allows the application to support multiple decision-coding schemes from different sources or for different processes.

Common Use Cases and Queries

A primary use case for this table is to validate and translate decision codes used in data interfaces or mapping exercises. For instance, when importing application data from an external admissions service, the system would reference this table to ensure incoming decision codes are valid for the specified system. Common queries involve joining this table to transactional data to retrieve a human-readable description or to enforce referential integrity. A typical reporting query might join this table to a mapping or response table to list all configured decisions for a specific system.

SELECT sdec.system_code, sdec.decision_code, map.mapped_value
FROM igs_uc_sys_decision sdec,
     igs_uc_map_off_resp map
WHERE sdec.system_code = map.system_code
  AND sdec.decision_code = map.decision_code
  AND sdec.system_code = '&SYSTEM';

Related Objects

The IGS_UC_SYS_DECISION table is central to a small reference constellation within the Student System. It is directly referenced by the following tables, as documented by the foreign key relationships:

• IGS_UC_DEFAULTS: References IGS_UC_SYS_DECISION.SYSTEM_CODE to establish default settings linked to a specific system context.
• IGS_UC_MAP_OFF_RESP: References both IGS_UC_SYS_DECISION.SYSTEM_CODE and IGS_UC_SYS_DECISION.DECISION_CODE. This table likely maps system decision codes to internal "offer response" statuses.
• IGS_UC_MAP_OUT_STAT: References both IGS_UC_SYS_DECISION.SYSTEM_CODE and IGS_UC_SYS_DECISION.DECISION_CODE. This table likely maps system decision codes to internal "outcome status" values.

These relationships highlight the table's purpose: to provide the authoritative source of valid decision codes that are then mapped or applied in various operational tables.