Search Results igs_pr_class_std_id




Overview
Explore in AI Chat

Overview

The IGS_PR_CLASS_STD table is a core setup table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle's Higher Education product) module. Its primary role is to maintain the institution's master list of defined Class Standing values. Class Standing is a critical academic concept, often representing a student's progression level (e.g., Freshman, Sophomore, Junior, Senior) or academic rank based on completed credit hours. This table acts as a reference or lookup source, ensuring data integrity and consistency wherever class standing information is used across student academic records, progression rules, and reporting.

Key Information Stored

The table structure is designed to store both the business data and standard audit information. The key columns include:

  • IGS_PR_CLASS_STD_ID (NUMBER): A system-generated, unique numeric identifier serving as the primary key for each record.
  • CLASS_STANDING (VARCHAR2): A unique code, such as 'FR', 'SO', 'JR', 'SR', representing the class standing.
  • DESCRIPTION (VARCHAR2): A textual description of the class standing code for clarity in user interfaces and reports.
  • CLOSED_IND (VARCHAR2): A flag indicating whether the class standing code is active or closed for further use, supporting data retention without active selection.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns that track the user and timestamp for record creation and modification, as per Oracle EBS conventions.
The unique constraints on IGS_PR_CLASS_STD_ID (U1) and CLASS_STANDING (U2) enforce data integrity at the database level.

Common Use Cases and Queries

This table is primarily referenced during student enrollment, academic advising, and progression auditing. Common operational and reporting scenarios include validating student class standing during course registration, determining eligibility for programs or honors, and generating demographic reports segmented by academic level. A fundamental query to retrieve all active class standings for a dropdown list would be: 

SELECT CLASS_STANDING, DESCRIPTION
FROM IGS.IGS_PR_CLASS_STD
WHERE NVL(CLOSED_IND, 'N') = 'N'
ORDER BY CLASS_STANDING;
For technical integration or data validation, joining to related student progression tables often requires the unique identifier: 
SELECT s.student_number, cs.description as current_class_standing
FROM igs_pe_student_base s,
     igs_pr_stdnt_pr_ps sc,
     igs.igs_pr_class_std cs
WHERE s.person_id = sc.person_id
  AND sc.class_standing_id = cs.igs_pr_class_std_id
  AND sc.progression_status = 'CURRENT';

Related Objects

Based on the provided metadata, the IGS_PR_CLASS_STD table is referenced by other objects within the APPS schema. While specific table names are not listed in the excerpt, it is a standard architectural pattern in Oracle EBS for transactional and student profile tables (e.g., those storing a student's current or historical class standing) to hold a foreign key reference to IGS_PR_CLASS_STD_ID. This setup ensures that all class standing data points throughout the system trace back to this centralized, controlled list. Developers and administrators should examine dependencies within the APPS schema to identify specific child tables, such as those within the IGS_PR (Progression) or IGS_EN (Enrollment) areas, for complete impact analysis.