Search Results igs_pr_css_class_std_uk

Overview

The IGS_PR_CSS_CLASS_STD table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its primary function is to maintain the mapping rules that determine a student's academic class standing (e.g., Freshman, Sophomore) based on accumulated credit points. This mapping is not universal; it is specifically defined for combinations of program type, academic period, and a defined credit point range. The table serves as a critical configuration point for automating academic progress tracking and reporting. It is important to note that the ETRM metadata explicitly labels the IGS - Student System as "Obsolete," indicating this table belongs to a legacy component of the EBS suite, which may have been superseded in later functional designs or implementations. Furthermore, the documentation states "Not implemented in this database," suggesting that while the table is defined in the data model, it may not be populated or actively used in all deployment instances of versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure centers around linking a credit schedule to a class standing definition within a specific context. The key columns, as indicated by the primary and foreign key constraints, include IGS_PR_CSS_CLASS_STD_ID (the unique surrogate primary key), IGS_PR_CS_SCHDL_ID, and IGS_PR_CLASS_STD_ID. The IGS_PR_CS_SCHDL_ID foreign key links to a credit schedule (IGS_PR_CS_SCHDL), which likely defines the applicable academic period and program type. The IGS_PR_CLASS_STD_ID foreign key links to the specific class standing definition (e.g., "Junior") in the IGS_PR_CLASS_STD table. While the explicit column for credit point range is not named in the provided metadata, the table's description confirms it stores the mapping for a "credit point range," implying the presence of columns such as MIN_CREDIT_POINT and MAX_CREDIT_POINT to establish the boundaries for each standing tier.

Common Use Cases and Queries

The primary use case is the dynamic determination of a student's class standing for academic advising, enrollment eligibility, and official transcripts. A batch process or real-time function would query this table to find the appropriate class standing record matching a student's program type, current period, and total earned credits. A typical reporting query might join this table to student academic history to analyze the distribution of standings across a cohort.

• Sample Query Pattern: SELECT cs.class_standing_code FROM igs_pr_css_class_std css, igs_pr_class_std cs, igs_pr_cs_schdl sch WHERE css.igs_pr_class_std_id = cs.igs_pr_class_std_id AND css.igs_pr_cs_schdl_id = sch.igs_pr_cs_schdl_id AND sch.program_type = '&PROG_TYPE' AND sch.academic_period = '&PERIOD' AND &STUDENT_CREDITS BETWEEN css.min_credit_point AND css.max_credit_point;

Related Objects

The table exists within a defined relational schema, as evidenced by its foreign key relationships. It is a child table to both IGS_PR_CS_SCHDL (Credit Schedule) and IGS_PR_CLASS_STD (Class Standing definition). Conversely, it acts as a parent table to IGF_AP_CLASS_STD_MAP, which is part of the Financial Aid (IGF) module, indicating that class standing mappings are also referenced for aid eligibility or packaging purposes. The documented join columns are critical for data integrity and query construction.

• Parent Tables:
  • IGS_PR_CS_SCHDL: Joined via IGS_PR_CSS_CLASS_STD.IGS_PR_CS_SCHDL_ID.
  • IGS_PR_CLASS_STD: Joined via IGS_PR_CSS_CLASS_STD.IGS_PR_CLASS_STD_ID.
• Child Table:
  • IGF_AP_CLASS_STD_MAP: References IGS_PR_CSS_CLASS_STD.IGS_PR_CSS_CLASS_STD_ID.