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.

  • Table: IGS_DA_SETUP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_SETUP,  object_name:IGS_DA_SETUP,  status:VALID,  product: IGS - Student System ,  description: Single record table to store the configuration information for degree audit ,  implementation_dba_data: IGS.IGS_DA_SETUP , 

  • Table: IGS_EN_UNIT_SET_CAT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_UNIT_SET_CAT,  object_name:IGS_EN_UNIT_SET_CAT,  status:VALID,  product: IGS - Student System ,  description: The entity describes the available categories of unit sets. eg. Major, Minor, Stream, List. ,  implementation_dba_data: IGS.IGS_EN_UNIT_SET_CAT , 

  • View: IGS_DA_XML_SUBPROGRAM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_SUBPROGRAM_V,  object_name:IGS_DA_XML_SUBPROGRAM_V,  status:VALID,  product: IGS - Student System ,  description: XML element SubProgramType (child of AcademicProgram). Returns the Major(s), Minor(s), and Track(s) of the Academic Program. ,  implementation_dba_data: APPS.IGS_DA_XML_SUBPROGRAM_V , 

  • View: IGS_DA_XML_ACADEMICPROGRAM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_ACADEMICPROGRAM_V,  object_name:IGS_DA_XML_ACADEMICPROGRAM_V,  status:VALID,  product: IGS - Student System ,  description: XML element AcademicProgramSub view indexed by Degree Program view Provides the provides the DA specified program information "SPA" -- Students Selected Degree Program "WIF" -- What-if Program "SPECIAL" -- Special Program ,  implementation_dba_data: APPS.IGS_DA_XML_ACADEMICPROGRAM_V , 

  • View: IGS_DA_XML_TE_INSTITUTION_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_TE_INSTITUTION_V,  object_name:IGS_DA_XML_TE_INSTITUTION_V,  status:VALID,  product: IGS - Student System ,  description: XML element InstitutionType (child of TransferEvaluation) ,  implementation_dba_data: APPS.IGS_DA_XML_TE_INSTITUTION_V , 

  • View: IGS_DA_XML_INSTITUTION_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_INSTITUTION_V,  object_name:IGS_DA_XML_INSTITUTION_V,  status:VALID,  product: IGS - Student System ,  description: XML element InstitutionTypeGets the Institution codes for the requested Institution. Base on the institution_cd passed in the XML whereclase. ,  implementation_dba_data: APPS.IGS_DA_XML_INSTITUTION_V , 

  • Table: IGS_PE_PERSON_ID_TYP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_PERSON_ID_TYP,  object_name:IGS_PE_PERSON_ID_TYP,  status:VALID,  product: IGS - Student System ,  description: This entity describes the type of person ids which may be attributed to a person. eg. OLAA id, VTAC id, old id. ,  implementation_dba_data: IGS.IGS_PE_PERSON_ID_TYP , 

  • Table: IGS_OR_ORG_ALT_IDTYP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_OR_ORG_ALT_IDTYP,  object_name:IGS_OR_ORG_ALT_IDTYP,  status:VALID,  product: IGS - Student System ,  description: This entity stores user defined other agencies or systems for which alternate ID codes are maintained. ,  implementation_dba_data: IGS.IGS_OR_ORG_ALT_IDTYP , 

  • View: IGS_DA_XML_PERSON_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_PERSON_V,  object_name:IGS_DA_XML_PERSON_V,  status:VALID,  product: IGS - Student System ,  description: XML element PersonType ,  implementation_dba_data: APPS.IGS_DA_XML_PERSON_V , 

  • View: IGS_DA_SETUP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_SETUP_V,  object_name:IGS_DA_SETUP_V,  status:VALID,  product: IGS - Student System ,  description: This view is used to retrieve the Degree Audit Interface configuration. ,  implementation_dba_data: APPS.IGS_DA_SETUP_V ,