Search Results igs_da_setup




Overview
Explore in AI Chat

Overview

The IGS_DA_SETUP table is a core configuration object within the Oracle E-Business Suite Student System (IGS) module, specifically for the Degree Audit functionality. As a single-record table, it serves as a central repository for system-wide parameters that control the behavior and default settings of the degree audit process. Degree audit is a critical academic operation that evaluates a student's completed coursework against the requirements of a specific program, degree, or certification. The configuration stored in IGS_DA_SETUP ensures this evaluation is performed consistently according to the institution's defined policies, making it an essential setup component for the academic advising and graduation clearance workflows in Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is a system control number (S_CONTROL_NUM), which enforces the single-record nature of the table. Its most significant columns are foreign keys that establish institutional defaults. These include DEFAULT_INST_ID_TYPE and DEFAULT_STUDENT_ID_TYPE, which link to identifier types for institutions and persons, respectively. Crucially, it stores the unit set categories used for "What-If" analyses (WIF), a common degree audit scenario where hypothetical academic paths are evaluated. Specifically, it defines the default categories for a Major (WIF_MAJOR_UNIT_SET_CAT), a Minor (WIF_MINOR_UNIT_SET_CAT), and a Track (WIF_TRACK_UNIT_SET_CAT) within these analyses, ensuring standardized program component mapping.

Common Use Cases and Queries

The primary use case is the initial configuration and ongoing maintenance of degree audit parameters by a system administrator. A typical operational query retrieves all setup values to inform application logic or for validation during audit execution. For example:

  • SELECT default_student_id_type, wif_major_unit_set_cat FROM igs.igs_da_setup;

Another critical use is during a "What-If" analysis, where the application references the WIF_*_UNIT_SET_CAT values to correctly classify the student's hypothetical program components. Reporting on configuration, or troubleshooting audit discrepancies, often involves joining this table to its referenced lookup tables to display meaningful descriptions instead of internal IDs.

Related Objects

IGS_DA_SETUP has defined foreign key relationships with several foundational tables in the Student System, as documented in the ETRM. These relationships are vital for data integrity and enforce valid configuration values:

  • IGS_OR_ORG_ALT_IDTYP via DEFAULT_INST_ID_TYPE: Validates the default institution identifier type.
  • IGS_PE_PERSON_ID_TYP via DEFAULT_STUDENT_ID_TYPE: Validates the default student identifier type.
  • IGS_EN_UNIT_SET_CAT via WIF_MAJOR_UNIT_SET_CAT, WIF_MINOR_UNIT_SET_CAT, and WIF_TRACK_UNIT_SET_CAT: Ensures the categories specified for What-If analyses are valid unit set categories.

The table is referenced by the degree audit engine and associated application programming interfaces (APIs) that perform the evaluation logic, making it a key dependency for the entire IGS_DA (Degree Audit) subsystem.