Search Results igs_pr_cs_schdl_id




Overview
Explore in AI Chat

Overview

The IGS_PR_CS_SCHDL table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or related IGS modules. Its primary function is to maintain the schedule for Class Standing, a concept used to determine a student's academic progression level based on completed coursework. The table acts as a master definition, controlling the effective periods and application rules for how class standing calculations are processed across different program or course types within the institution.

Key Information Stored

The table stores the configuration parameters that govern the execution of class standing schedules. The IGS_PR_CS_SCHDL_ID column serves as the unique primary key identifier for each schedule record. The COURSE_TYPE links the schedule to a specific academic program type, enforcing data integrity through a foreign key relationship. The START_DT and END_DT columns define the active date range for the schedule. A critical business rule column is CONSIDER_CHANGES, which determines whether class standing updates are processed immediately or deferred to a specific period, directly impacting the student's academic status timeline. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide audit trails.

Common Use Cases and Queries

This table is central to administrative processes involving academic progression. A common use case is the batch or online process that evaluates student credits against program requirements to assign or update a class standing (e.g., Freshman, Sophomore). System administrators may query this table to audit or manage active schedules. A typical reporting query would retrieve all currently active schedules for a given course type.

SELECT cs_schdl_id,
       course_type,
       consider_changes,
       start_dt,
       end_dt
FROM igs.igs_pr_cs_schdl
WHERE course_type = 'UNDERGRAD'
  AND SYSDATE BETWEEN start_dt AND NVL(end_dt, SYSDATE);

Another critical operation is identifying the controlling schedule for a specific student's program, often requiring a join to the student's program type record to obtain the relevant IGS_PR_CS_SCHDL_ID.

Related Objects

The IGS_PR_CS_SCHDL table has defined relationships with several other key EBS objects, forming the backbone of the class standing functionality.

  • Primary Key: IGS_PR_CS_SCHDL_PK on column IGS_PR_CS_SCHDL_ID.
  • Foreign Key (Outgoing): The COURSE_TYPE column references the IGS_PS_TYPE_ALL table, linking the schedule to valid program types.
  • Foreign Keys (Incoming - Referenced By):
    • The IGF_AP_PR_PRG_TYPE table references IGS_PR_CS_SCHDL via IGS_PR_CS_SCHDL_ID, likely associating the schedule with financial aid or academic progression program types.
    • The IGS_PR_CSS_CLASS_STD table references IGS_PR_CS_SCHDL via IGS_PR_CS_SCHDL_ID. This is a direct child relationship where individual class standing records for students are created under a specific master schedule.