Search Results igs_en_unit_set_cat




Overview
Explore in AI Chat

Overview

The IGS_EN_UNIT_SET_CAT table is a core reference table within the Oracle E-Business Suite Student System (IGS). It functions as a master list defining the distinct categories or types of unit sets that an educational institution can establish and manage. A unit set represents a structured collection of academic units, such as courses or modules, that form a coherent program component. This table is fundamental for classifying these sets, enabling the system to differentiate between, for example, a primary academic focus (Major), a secondary focus (Minor), a prescribed sequence (Stream), or a general elective list. Its role is to provide a standardized, controlled vocabulary for categorizing unit sets across all student academic program structures, ensuring data integrity and consistency in related processes like degree audit, program planning, and reporting.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the table's description and relationships indicate its core structure. The central column is UNIT_SET_CAT, which serves as the primary key. This column stores the unique code representing each valid unit set category, such as 'MAJOR', 'MINOR', 'STREAM', or 'LIST'. Typically, a corresponding description column (e.g., DESCRIPTION) would also exist to provide a meaningful name for each category code, though this is inferred from standard practice. The table acts as a simple but critical lookup entity, where each row defines one permissible category that can be assigned to unit set records in other transactional tables.

Common Use Cases and Queries

This table is primarily used in validation, reporting, and setup scenarios. Administrators may query it to review or maintain the list of available categories. A common operational use is to populate list-of-values (LOV) in application forms where a unit set category must be selected, such as when defining a new unit set or a Degree Audit setup rule. For reporting, it is frequently joined to transactional data to categorize unit set completions or enrollments. A typical query would retrieve all active categories:

  • SELECT unit_set_cat, description FROM igs.igs_en_unit_set_cat WHERE closed_ind = 'N' ORDER BY 1;

Another essential pattern is joining to unit set details, for example, to list all unit sets classified as Majors:

  • SELECT us.unit_set_cd, us.version_number, us.title FROM igs.igs_en_unit_set us WHERE us.unit_set_cat = 'MAJOR';

Related Objects

The IGS_EN_UNIT_SET_CAT table is referenced by foreign keys in other setup and configuration tables, primarily within the Degree Audit module. As per the documented metadata:

  • IGS_DA_SETUP: This table references IGS_EN_UNIT_SET_CAT three times to define default unit set categories for Degree Audit (WIF - "What-If") scenarios. The specific foreign key columns are:

While not listed in the provided excerpt, it is highly probable that the main transactional table for unit sets, IGS_EN_UNIT_SET, contains a foreign key column (UNIT_SET_CAT) referencing this table's primary key to categorize every unit set record.

  • 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 , 

  • 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 , 

  • View: IGS_EN_SUSA_YEAR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_EN_SUSA_YEAR_V,  object_name:IGS_EN_SUSA_YEAR_V,  status:VALID,  product: IGS - Student System ,  description: This view would be used for logical grouping of student unit set attmpts in year of program mode for unit set inquiry form ,  implementation_dba_data: APPS.IGS_EN_SUSA_YEAR_V , 

  • View: IGS_AS_SUSA_INQ_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AS_SUSA_INQ_V,  object_name:IGS_AS_SUSA_INQ_V,  status:VALID,  product: IGS - Student System ,  description: - Retrofitted ,  implementation_dba_data: APPS.IGS_AS_SUSA_INQ_V , 

  • View: IGSFV_CONCENTRATIONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_CONCENTRATIONS,  object_name:IGSFV_CONCENTRATIONS,  status:VALID,  product: IGS - Student System ,  description: This view describes a unit-set, being a logical sub-grouping of course. e.g. Major, Minor, Stream, Strand. A unit-set is typically related to the rules, which govern its completion via the Rules Sub-system. - Obsolete ,  implementation_dba_data: APPS.IGSFV_CONCENTRATIONS , 

  • View: IGSFV_PROG_CONCENTRATIONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PROG_CONCENTRATIONS,  object_name:IGSFV_PROG_CONCENTRATIONS,  status:VALID,  product: IGS - Student System ,  description: This entity describes a unit-set, being a logical sub-grouping of program. eg .Major, Minor, Stream, Strand. A unit-set is typically related to the rules which governs its completion via the Rules Sub-system. ,  implementation_dba_data: APPS.IGSFV_PROG_CONCENTRATIONS , 

  • View: IGS_PR_ACAD_YEAR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PR_ACAD_YEAR_V,  object_name:IGS_PR_ACAD_YEAR_V,  status:VALID,  product: IGS - Student System ,  description: This view contains the details of a Student Program Attempt within a Year of Program with earned credit point values. ,  implementation_dba_data: APPS.IGS_PR_ACAD_YEAR_V , 

  • View: IGS_EN_SUA_YEAR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_EN_SUA_YEAR_V,  object_name:IGS_EN_SUA_YEAR_V,  status:VALID,  product: IGS - Student System ,  description: This view would be used for logical grouping of student unit attempts under unit set (in year of program mode) for unit set inquiry form ,  implementation_dba_data: APPS.IGS_EN_SUA_YEAR_V , 

  • View: IGS_AS_PROGUGAI_ADI_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AS_PROGUGAI_ADI_V,  object_name:IGS_AS_PROGUGAI_ADI_V,  status:VALID,  product: IGS - Student System ,  description: Assessment Progression/UnitGrade/AssessmentItem WebADI View ,  implementation_dba_data: APPS.IGS_AS_PROGUGAI_ADI_V , 

  • View: IGS_DA_EXPL_PRG_CAT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_EXPL_PRG_CAT_V,  object_name:IGS_DA_EXPL_PRG_CAT_V,  status:VALID,  product: IGS - Student System ,  description: View is used to determine the program catalogs allowed to be displayed for the Explore Program Catalog LOV based on configuration of profiles setup and the user allowed to choose Explore Program options. ,  implementation_dba_data: APPS.IGS_DA_EXPL_PRG_CAT_V ,