Search Results igs_ad_adm_ut_sta_gd




Overview
Explore in AI Chat

Overview

The table IGS_AD_ADM_UT_STA_GD is a data entity within the Oracle E-Business Suite's now-obsolete Student System (IGS). Its primary function is to define the specific grades from a grading schema that are considered valid or applicable for a given administrative unit status. This table acts as a cross-reference, enforcing data integrity by linking the status of an administrative unit (e.g., a department or school) with permissible academic grades. It is critical to note that, according to the provided ETRM documentation, this table was not implemented in the referenced database instance for Oracle EBS 12.1.1 / 12.2.2, indicating it may be part of a legacy or unimplemented data model.

Key Information Stored

The table's structure is defined by a composite primary key, ensuring a unique combination of its core attributes. The key columns are:

  • ADMINISTRATIVE_UNIT_STATUS: A code identifying the specific status of an administrative unit.
  • GRADING_SCHEMA_CD: The code for the grading schema (e.g., 'LETTER', 'PASS/FAIL').
  • VERSION_NUMBER: The version number of the specified grading schema, allowing for historical tracking of schema changes.
  • GRADE: The actual grade code (e.g., 'A', 'B', 'P') within the specified grading schema and version.
Together, these columns store the rule that a particular grade is applicable when the associated administrative unit is in a particular status.

Common Use Cases and Queries

In a functional Student System, this table would be queried for validation and reporting during academic processes. A primary use case would be to validate a grade entered for a student's record against the current status of their administrative unit, ensuring data consistency. For reporting, it could be used to analyze which grade options are available for units in different operational statuses. A typical validation query would join this table to the administrative unit status and grading schema tables to retrieve the list of permissible grades.

SELECT gd.grade
FROM igs_ad_adm_ut_sta_gd gd
WHERE gd.administrative_unit_status = :p_unit_status
  AND gd.grading_schema_cd = :p_schema_cd
  AND gd.version_number = :p_version_num;

Related Objects

The table's integrity is maintained through defined foreign key relationships, as documented in the ETRM. It references two key tables in the Student System data model:

  • IGS_AD_ADM_UNIT_STAT_ALL: The foreign key from the column ADMINISTRATIVE_UNIT_STATUS ensures that the status code referenced in IGS_AD_ADM_UT_STA_GD is a valid, existing administrative unit status.
  • IGS_AS_GRD_SCH_GRADE: The foreign key from the combined columns GRADING_SCHEMA_CD, VERSION_NUMBER, and GRADE ensures that the grade specified is a valid entry within the master grading schema definition table.
These relationships position IGS_AD_ADM_UT_STA_GD as a junction table, linking the domains of administrative unit statuses and academic grading schemas.

  • Table: IGS_AD_ADM_UT_STA_GD 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_ADM_UT_STA_GD,  object_name:IGS_AD_ADM_UT_STA_GD,  status:VALID,  product: IGS - Student System ,  description: Describes grading schema code grades applicable to an administrative unit status ,  implementation_dba_data: IGS.IGS_AD_ADM_UT_STA_GD , 

  • Table: IGS_AD_ADM_UNIT_STAT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_ADM_UNIT_STAT_ALL,  object_name:IGS_AD_ADM_UNIT_STAT_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes user-defined administrative unit statuses that map to system-defined unit statues, which are system and manually applied ,  implementation_dba_data: IGS.IGS_AD_ADM_UNIT_STAT_ALL , 

  • Table: IGS_AS_GRD_SCH_GRADE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AS_GRD_SCH_GRADE,  object_name:IGS_AS_GRD_SCH_GRADE,  status:VALID,  product: IGS - Student System ,  description: Describes characteristics of grade within grading schema ,  implementation_dba_data: IGS.IGS_AS_GRD_SCH_GRADE , 

  • View: IGS_AD_ADM_UT_STA_GD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AD_ADM_UT_STA_GD_V,  object_name:IGS_AD_ADM_UT_STA_GD_V,  status:VALID,  product: IGS - Student System ,  description: Describes the grading schema code grades applicable to an administrative unit status. This caters for versions of the grading schema code. At any point in time, there should be only one grading schema code grade applicable. ,  implementation_dba_data: APPS.IGS_AD_ADM_UT_STA_GD_V ,