Search Results igs_ad_adm_unit_stat_pk

Overview

The table IGS_AD_ADM_UNIT_STAT_ALL is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) modules, specifically for versions 12.1.1 and 12.2.2. It functions as a master reference table for defining the lifecycle statuses of administrative units within the institution. Its primary role is to provide a mapping layer between user-defined, business-specific status codes and the system-defined statuses that drive application logic. This design allows institutions to customize their administrative unit status nomenclature (e.g., "Active," "Under Review," "Inactive") while ensuring these custom statuses correctly align with predefined system behaviors for processes like enrollment, disciplinary actions, and unit availability. The table supports multi-organization architecture, as indicated by the "_ALL" suffix.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the table's primary key and foreign key relationships define its critical data elements. The central column is ADMINISTRATIVE_UNIT_STATUS, which serves as the unique identifier (Primary Key: IGS_AD_ADM_UNIT_STAT_PK) for each status record. This column stores the user-defined status code. The table inherently stores the mapping of this user code to an underlying system-defined unit status, which controls automated and manual application logic. Other typical columns in such a reference table would include a description field, effective dates, and an enabled flag, though these are inferred based on standard EBS design patterns.

Common Use Cases and Queries

This table is primarily referenced in transactional and reporting contexts to validate and interpret administrative unit statuses. A common use case is generating a report of all configured statuses and their system mappings for audit or setup verification. Another critical scenario involves queries that join this table to student unit attempt or disciplinary records to filter or categorize data based on the business-friendly status description. For example, an analyst may run a query to find all student unit attempts linked to administrative units currently in a "Suspended" or "Probation" status as defined in this table. A fundamental sample SQL pattern is a simple lookup: SELECT ADMINISTRATIVE_UNIT_STATUS FROM IGS_AD_ADM_UNIT_STAT_ALL WHERE [enabled criteria]. This data is essential for workflows governing when and how administrative units can be used in academic programs.

Related Objects

The table IGS_AD_ADM_UNIT_STAT_ALL is a parent reference for several key transactional tables, as documented by its foreign key relationships. The ADMINISTRATIVE_UNIT_STATUS column is referenced by:

• IGS_AD_ADM_UT_STA_GD: Likely stores status change guidance or rules.
• IGS_AD_ADM_UT_STT_LD: Likely tracks the status change history or load details.
• IGS_EN_NSD_DLSTP_ALL: Non-standard Disciplinary Steps, linking disciplinary actions to a unit's status.
• IGS_PE_USR_ADISC_ALL: User Administrative Disciplines, associating user roles or actions with unit statuses.
• IGS_EN_SU_ATTEMPT_ALL: Student Unit Attempts, a critical table where the administrative unit's status may affect enrollment validity.
• IGS_PS_UNIT_DISC_CRT: Unit Disciplinary Criteria, defining rules based on unit status.

These relationships underscore the table's central role in integrating administrative unit state with student enrollment, discipline, and program structure modules.