Search Results igs_pr_cs_schdl_pk

Overview

The table IGS_PR_CS_SCHDL is a core data object within the Oracle E-Business Suite's now-obsolete Student System (IGS). Its primary function is to maintain the schedule for Class Standing, a concept typically related to academic progression or ranking within a course of study. This table acts as a master definition, establishing the framework against which individual student class standing records are created and managed. The documentation explicitly notes this table was "Not implemented in this database" for the referenced instance, indicating it may exist as a shell or its data may be managed through alternative means in specific deployments of versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure centers on a unique schedule identifier and the parameters that define the schedule's applicability. The primary key is the surrogate key IGS_PR_CS_SCHDL_ID, which uniquely identifies each schedule record. A separate unique key constraint ensures business rule integrity by combining START_DT (the effective start date of the schedule) and COURSE_TYPE (the type of academic program to which the schedule applies). This combination prevents duplicate schedules for the same course type starting on the same date. The COURSE_TYPE column is a foreign key referencing the IGS_PS_TYPE_ALL table, linking the schedule to the institution's defined program types.

Common Use Cases and Queries

This table supports administrative processes for tracking and applying class standing rules. A common operational query would retrieve the active schedule for a specific course type to validate or generate student records. For example: SELECT * FROM IGS_PR_CS_SCHDL WHERE COURSE_TYPE = '<PROGRAM_CODE>' AND SYSDATE >= START_DT ORDER BY START_DT DESC;. Reporting use cases include auditing all defined class standing schedules by course type and their effective dates, or identifying schedules that lack associated class standing detail records. As the module is obsolete, direct data manipulation is rare; integration or data migration scripts may reference this table to extract legacy configuration.

Related Objects

IGS_PR_CS_SCHDL maintains defined relationships with several other tables in the Student and Financial Aid modules, as per the provided metadata:

• Parent Reference: The table references IGS_PS_TYPE_ALL via the COURSE_TYPE column to validate the academic program type.
• Child Dependencies: Two key tables reference IGS_PR_CS_SCHDL via its primary key:
  • IGF_AP_PR_PRG_TYPE (Financial Aid): Links financial aid program types to a specific class standing schedule using IGS_PR_CS_SCHDL_ID.
  • IGS_PR_CSS_CLASS_STD (Student System): Stores the detailed class standing rules or student records associated with a master schedule, joined on IGS_PR_CS_SCHDL_ID.

These relationships position IGS_PR_CS_SCHDL as a configuration hub between program definitions, detailed standing rules, and financial aid linkages.