Search Results igs_pr_css_class_std_id




Overview
Explore in AI Chat

Overview

The IGS.IGS_PR_CSS_CLASS_STD table is a core configuration entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product. It functions as a mapping table that defines the criteria for awarding academic class standings (e.g., First Class, Second Class) to students. Its primary role is to store the relationship between a defined class standing schedule, specific class standing codes, and the qualifying academic parameters. The table establishes the rules by which a student's cumulative credit points and academic years of study are evaluated against minimum and maximum thresholds to determine an appropriate class standing for a given program type and period.

Key Information Stored

The table stores the rule definitions for class standing calculations. The IGS_PR_CSS_CLASS_STD_ID column serves as the unique system-generated identifier for each mapping record. The IGS_PR_CS_SCHDL_ID and IGS_PR_CLASS_STD_ID are foreign keys that link to the parent schedule (IGS_PR_CS_SCHDL) and the specific class standing code (IGS_PR_CLASS_STD) respectively. The core business logic is encapsulated in the MIN_CP and MAX_CP columns, which define the inclusive credit point range, and the ACAD_YEAR column, which specifies the applicable number of academic years. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track audit information for each row.

Common Use Cases and Queries

This table is central to automated class standing determination during academic processes like graduation eligibility checks or academic audits. A common operational query involves retrieving all class standing rules for a specific schedule to review or maintain thresholds. For reporting, a join is typically performed to translate foreign key IDs into meaningful descriptions from related tables.

Sample Query to List All Mappings with Descriptions:

  • SELECT css.IGS_PR_CSS_CLASS_STD_ID,
  • sch.SCHEDULE_NAME,
  • std.CLASS_STANDING,
  • css.MIN_CP,
  • css.MAX_CP,
  • css.ACAD_YEAR
  • FROM IGS.IGS_PR_CSS_CLASS_STD css,
  • IGS.IGS_PR_CS_SCHDL sch,
  • IGS.IGS_PR_CLASS_STD std
  • WHERE css.IGS_PR_CS_SCHDL_ID = sch.IGS_PR_CS_SCHDL_ID
  • AND css.IGS_PR_CLASS_STD_ID = std.IGS_PR_CLASS_STD_ID
  • ORDER BY sch.SCHEDULE_NAME, css.MIN_CP;

Related Objects

The IGS_PR_CSS_CLASS_STD table exists within a defined hierarchy and is referenced by other modules. Its primary relationships, as documented, are:

  • Referenced Parent Tables (Foreign Keys):
    • IGS.IGS_PR_CS_SCHDL: Via the IGS_PR_CS_SCHDL_ID column. This is the parent Class Standing Schedule.
    • IGS.IGS_PR_CLASS_STD: Via the IGS_PR_CLASS_STD_ID column. This is the parent Class Standing code definition.
  • Referencing Child Objects:
    • IGF_AP_CLASS_STD_MAP: The column IGS_PR_CSS_CLASS_STD_ID in this table references IGS_PR_CSS_CLASS_STD. This links class standing rules to financial aid (IGF) components.
  • Primary Key Constraint: The business key ensuring unique combination of schedule and class standing is enforced by IGS_PR_CSS_CLASS_STD_UK on (IGS_PR_CS_SCHDL_ID, IGS_PR_CLASS_STD_ID).