Results for “igs_ad_appl_stat”

50+ results




Overview
Explore in AI Chat

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

Overview

The IGS_AD_APPL_STAT table belongs to the IGS — Student System product family within Oracle E-Business Suite, and is documented as obsolete in the ETRM metadata for releases 12.1.1 and 12.2.2. Functionally, the table stores the set of user-defined admission application statuses and maps each of them to a corresponding system-defined status. Typical status concepts referenced by the metadata include received, withdrawn, under consideration, and complete, although the precise value list is defined by each institution during implementation. The table therefore acts as a controlled reference (lookup) list that governs how an admission application is classified as it moves through its lifecycle.

The metadata records the object as not implemented in this database, which is consistent with its obsolete classification; the physical schema documented for ETRM 12.1.1 lists the owner as IGS with 10 columns. From a heuristic Data Vault modeling perspective, the FK topology mined from the metadata (two dependent child tables referencing it, and no upward foreign keys of its own) suggests a hub-leaning classification: the table behaves as a stable, uniquely keyed business entity rather than as a transactional link or a descriptive satellite.

Key Information Stored

The table is anchored by a surrogate primary key constraint, IGS_AD_APPL_STAT_PK, defined on the ADM_APPL_STATUS column. A unique index, IGS_AD_APPL_STAT_U1, is also defined on ADM_APPL_STATUS, which makes it the documented business-key candidate for this entity. The most significant columns are:

  • ADM_APPL_STATUS — the admission application status code; primary key and business key, and the value propagated to child tables.
  • DESCRIPTION — the user-visible, descriptive text for the status.
  • S_ADM_APPL_STATUS — the system-defined status to which the user-defined status is mapped; this is the core mapping attribute.
  • SYSTEM_DEFAULT_IND — indicates whether the row represents the default status applied by the system.
  • CLOSED_IND — flags statuses that represent a closed or terminal application state.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO-column audit attributes capturing row provenance and change history.

Common Use Cases and Queries

The primary use case is validation and decoding: joining child admission tables to IGS_AD_APPL_STAT to translate a stored status code into a description and to determine the corresponding system-defined status. Reporting use cases include status distribution counts across admission terms, identification of open versus closed applications using CLOSED_IND, and confirming which status the system applies by default. A representative query is:

  • SELECT s.ADM_APPL_STATUS, s.DESCRIPTION, s.S_ADM_APPL_STATUS, s.CLOSED_IND FROM IGS_AD_APPL_STAT s ORDER BY s.ADM_APPL_STATUS;
  • SELECT a.ADM_APPL_STATUS, s.DESCRIPTION, COUNT(*) FROM IGS_AD_APPL_ALL a JOIN IGS_AD_APPL_STAT s ON a.ADM_APPL_STATUS = s.ADM_APPL_STATUS GROUP BY a.ADM_APPL_STATUS, s.DESCRIPTION;
  • SELECT INST.APPL_INST_STATUS, s.DESCRIPTION FROM IGS_AD_PS_APPL_INST_ALL INST JOIN IGS_AD_APPL_STAT s ON INST.APPL_INST_STATUS = s.ADM_APPL_STATUS;

Because the table is marked obsolete, queries should be treated as reference or migration-oriented rather than as part of a supported functional flow.

Related Objects

The documented foreign-key metadata identifies the following dependent objects, which reference this table and join on the columns shown:

  • IGS_AD_APPL_ALL — references IGS_AD_APPL_STAT via IGS_AD_APPL_ALL.ADM_APPL_STATUS; the principal admission application record.
  • IGS_AD_PS_APPL_INST_ALL — references IGS_AD_APPL_STAT via IGS_AD_PS_APPL_INST_ALL.APPL_INST_STATUS; the application instance record.

These two child tables represent the principal consumers of the status lookup, and their join columns (ADM_APPL_STATUS and APPL_INST_STATUS respectively) both resolve to the primary key of IGS_AD_APPL_STAT. No additional views, packages, or APIs are documented in the supplied metadata; any such dependencies would require validation against the deployed instance.