Results for “igs_ad_ou_stat”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AD_OU_STAT is a reference (lookup) table in the Oracle EBS Student System (IGS) product family. It describes user-defined admission outcome statuses and, critically, maps each user-defined status to the corresponding system admission outcome status. This mapping layer allows institutions to extend the standard admissions decision vocabulary without breaking seeded processing logic that depends on system-level status codes such as pending, rejected, or obsolete.

In Oracle EBS 12.1.1 and 12.2.2 the table resides in the IGS schema and is fully validated. It is a low-volume, largely static configuration object populated during implementation and maintained by admissions administrators and functional super-users. Because admissions application records reference this table for their outcome status, it is also a referential anchor for decisions, defaults, and UCAS-related outcome mapping.

Applying a Data Vault-style classification heuristically: based on its single-column primary key and the pattern of foreign keys pointing outward to transactional and configuration tables, IGS_AD_OU_STAT behaves as a hub candidate — a business entity table holding the durable set of admission outcome statuses, with dependent attributes (descriptions, defaults, flags) satelling it. This is a modeling suggestion only; the physical table is a conventional master/detail-style lookup.

Key Information Stored

The documented physical schema in ETRM 12.1.1 carries ten columns. The most significant are:

• ADM_OUTCOME_STATUS — the primary key column of the IGS_AD_OU_STAT_PK constraint. It is the user-definable status code, and it also defines the unique index IGS_AD_OU_STAT_U1, making it both the surrogate primary key and the business key in this design.
• S_ADM_OUTCOME_STATUS — the system (seeded) admission outcome status to which the user-defined status maps. This column is the purpose of the table: it preserves standard processing behaviour while allowing site-specific terminology.
• DESCRIPTION — the display text for the status, used in forms, lists of values, and reporting.
• SYSTEM_DEFAULT_IND — indicates whether the status is the system default value applied when none is selected.
• CLOSED_IND — flags a status as closed, typically meaning the outcome is final and no further processing should occur.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS audit (WHO) columns recording row creation and last modification, used for audit trails and data reconciliation.

There are no additional columns in the documented schema; the ten listed comprise the complete physical definition.

Common Use Cases and Queries

The table is used whenever admission outcome statuses must be validated, translated to system values, or filtered by open/closed state. A common form-assistance query returns the user-facing statuses and their system equivalents:

• SELECT adm_outcome_status, description, s_adm_outcome_status, closed_ind FROM igs_ad_ou_stat WHERE closed_ind = 'N' ORDER BY description;
• Resolving the system value for a given user status during decision processing: SELECT s_adm_outcome_status FROM igs_ad_ou_stat WHERE adm_outcome_status = :status;
• Reporting the distribution of applications by outcome, joining decision data through the outcome status: SELECT s.adm_outcome_status, COUNT(*) FROM igs_ad_ps_appl_inst_all a, igs_ad_ou_stat s WHERE a.adm_outcome_status = s.adm_outcome_status GROUP BY s.adm_outcome_status;
• Configuration audit to find statuses not yet mapped or flagged as defaults: SELECT * FROM igs_ad_ou_stat WHERE system_default_ind = 'Y';

Because the table is small, it is frequently cached by forms and concurrent programs; changes should be made through the admissions setup forms rather than by direct DML to avoid invalidating cached lookup values.

Related Objects

The following objects reference IGS_AD_OU_STAT through foreign keys on ADM_OUTCOME_STATUS and related columns, per the documented relationship data:

• IGS_AD_PS_APPL_INST_ALL — the applicant instance record; ADM_OUTCOME_STATUS references this table, making it the primary transactional consumer of the status.
• IGS_AD_DFLT_OUDTLS — outcome detail defaults, joined on ADM_OUTCOME_STATUS.
• IGS_UC_DEFAULTS — holds the default outcome statuses via PENDING_OUTCOME_STATUS, REJECTED_OUTCOME_STATUS, and OBSOLETE_OUTCOME_STATUS; a single row can therefore reference three different statuses in this table.
• IGS_UC_MAP_OUT_STAT — the UCAS outcome status mapping table, joined on ADM_OUTCOME_STATUS.

Together these relationships confirm the table's role as the central definition point for admission outcome statuses, referenced by both online admissions processing and UCAS integration setup.