Search Results igs_ad_dflt_oudtls




Overview
Explore in AI Chat

Overview

The IGS_AD_DFLT_OUDTLS table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It serves as a configuration table that stores default outcome decision details for the admissions process. Its primary role is to define the standard or default set of attributes, reasons, and conditions automatically associated with a specific admission outcome status. This table enables process standardization, ensuring consistent data capture and workflow initiation when an application is assigned a particular outcome, such as a conditional offer, firm offer, or rejection.

Key Information Stored

The table's structure centers on linking an admission outcome status to its default parameters. The primary key is the ADM_OUTCOME_STATUS column, which references a valid status from the IGS_AD_OU_STAT table. Key columns include DECISION_MAKER_ID and ADM_OTCM_STATUS_AUTH_PERSON_ID, which link to HZ_PARTIES to identify default authorizing personnel. It stores default reason codes via DECISION_REASON_ID and PENDING_REASON_ID, linking to IGS_AD_CODE_CLASSES. For managing future academic terms, it holds FUTURE_ACAD_CAL_TYPE and FUTURE_ADM_CAL_TYPE with their corresponding sequence numbers, referencing IGS_CA_INST_ALL. Furthermore, it defines default conditional offer statuses (ADM_CNDTNL_OFFER_STATUS) and UCAS condition categories and names for integrations.

Common Use Cases and Queries

This table is primarily accessed during the automated application processing and decision entry workflows. When an admissions officer selects an outcome status for an application, the system can query this table to pre-populate related decision fields with the configured defaults, streamlining data entry. Common reporting and validation queries involve joining this table to its referenced lookups. For instance, to audit all default outcome configurations with their associated decision reasons, a query would join IGS_AD_DFLT_OUDTLS to IGS_AD_OU_STAT and IGS_AD_CODE_CLASSES. Another critical use case is in batch processes that assign outcomes, where this table provides the rule set for populating dependent attributes without manual intervention.

Related Objects

The IGS_AD_DFLT_OUDTLS table maintains integral relationships with several key tables in the IGS and Trading Community Architecture (TCA) modules, as documented by its foreign keys:

  • IGS_AD_OU_STAT: Via ADM_OUTCOME_STATUS. This is the master list of valid admission outcome statuses.
  • HZ_PARTIES: Via DECISION_MAKER_ID and ADM_OTCM_STATUS_AUTH_PERSON_ID. Links to person or organization records for authorizing parties.
  • IGS_CA_INST_ALL: Via (FUTURE_ACAD_CAL_TYPE, FUTURE_ACAD_CI_SEQUENCE_NUMBER) and (FUTURE_ADM_CAL_TYPE, FUTURE_ADM_CI_SEQUENCE_NUMBER). Links to academic calendar instances.
  • IGS_AD_CODE_CLASSES: Via DECISION_REASON_ID and PENDING_REASON_ID. Provides the reason code values.
  • IGS_UC_OFFER_CONDS: Via UCAS_COND_CATEGORY and UCAS_COND_NAME. For UCAS integration conditional offers.
  • IGS_AD_CNDNL_OFRSTAT: Via ADM_CNDTNL_OFFER_STATUS. For conditional offer status defaults.

The primary key constraint IGS_AD_DFLT_OUTDTLS_PK enforces uniqueness on the ADM_OUTCOME_STATUS column.