Search Results waitlist_status_code

Overview

The IGS_AD_DFLT_OUDTLS table is a core data definition table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Admissions (IGS) module. It serves as a configuration table that stores default values and rules for admission outcome decisions. Its primary role is to define the standard parameters—such as dates, statuses, and authorizations—that are automatically applied when a specific admission outcome status (e.g., Offer, Conditional Offer, Reject, Waitlist) is assigned to an applicant. This table ensures process consistency and data integrity by providing a centralized repository of decision defaults, which the application logic references during admission processing workflows.

Key Information Stored

The table's columns define the comprehensive set of defaults for an admission outcome. Key columns include the mandatory ADM_OUTCOME_STATUS and CREATED_BY, which form the primary key. Critical business rule columns are DFLT_DECISIONDATE_FLAG and DFLT_OFFERDATE_FLAG, which control the defaulting of system dates. Status and workflow are managed through fields like RECONSIDER_FLAG, WAITLIST_STATUS_CODE, and WAITLIST_RANK. For conditional offers, significant columns include ADM_CNDTNL_OFFER_STATUS, CNDTNL_OFFER_CNDTN_TXT, and the user-searched field UCAS_COND_NAME, which stores the name of a UCAS (Universities and Colleges Admissions Service) condition. Authorization details are captured in ADM_OTCM_STATUS_AUTH_PERSON_ID and ADM_OUTCOME_STATUS_AUTH_DATE.

Common Use Cases and Queries

This table is primarily used by application logic to populate decision screens and automate data entry. Common operational and reporting queries involve retrieving default settings for specific admission outcomes or validating UCAS-related configurations. For instance, to find all default records associated with a 'CONDITIONAL' outcome status and their UCAS condition details, a query would be:

• SELECT adm_outcome_status, ucas_cond_name, dflt_decisiondate_flag, decision_maker_id FROM igs.igs_ad_dflt_oudtls WHERE adm_outcome_status = 'CONDITIONAL';

Another typical use case is generating a report of all default outcomes that utilize UCAS conditions, which is essential for institutions integrated with the UCAS service:

• SELECT adm_outcome_status, ucas_cond_category, ucas_cond_name FROM igs.igs_ad_dflt_oudtls WHERE ucas_cond_name IS NOT NULL ORDER BY adm_outcome_status;

Related Objects

The table maintains strict referential integrity through its primary and foreign key relationships. Its composite primary key is enforced by the index IGS_AD_DEF_OTCM_DEC_PK. It references numerous master and code tables, as documented in the ETRM:

• IGS_AD_OU_STAT via ADM_OUTCOME_STATUS (Validates the outcome status code).
• HZ_PARTIES via DECISION_MAKER_ID and ADM_OTCM_STATUS_AUTH_PERSON_ID (Identifies the person making or authorizing the decision).
• IGS_CA_INST_ALL via FUTURE_ACAD_CAL_TYPE and FUTURE_ADM_CAL_TYPE (Links to future academic and admission calendar instances).
• IGS_AD_CODE_CLASSES via DECISION_REASON_ID and PENDING_REASON_ID (References coded reasons for decisions).
• IGS_UC_OFFER_CONDS via UCAS_COND_CATEGORY (Validates the UCAS condition category).
• IGS_AD_CNDNL_OFRSTAT via ADM_CNDTNL_OFFER_STATUS (Validates the conditional offer status code).