Search Results igs_pr_cs_schdl

Overview

The table IGF_AP_PR_PRG_TYPE is a core data object within the now-obsolete Oracle Financial Aid (IGF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function is to serve as a master repository for year-specific program type definitions. These definitions are foundational for establishing and managing grade levels and class standings associated with specific academic programs within a given award year. By linking program types to academic calendars and program schedules, this table enables the precise mapping of a student's academic progress (class standing) to the correct financial aid rules and eligibility criteria, which is a critical requirement for compliant aid packaging and disbursement.

Key Information Stored

The table's structure is designed to uniquely identify and describe a program type within a specific context. While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal its critical components. The primary key is the PPT_ID, a unique system-generated identifier for each record. Essential relational attributes include CAL_TYPE and SEQUENCE_NUMBER, which together reference a specific academic calendar instance (IGS_CA_INST_ALL), anchoring the program type to a defined term or year. The IGS_PR_CS_SCHDL_ID column links to a program schedule (IGS_PR_CS_SCHDL), defining the structural plan for the program. Other columns, inferred from its purpose, would typically store descriptive data such as a program type code, name, and active status flag for the specified year.

Common Use Cases and Queries

This table is central to configuration and validation processes within the Financial Aid lifecycle. A primary use case is the setup and maintenance of class standing mappings, where administrators define which grade levels (e.g., Freshman, Sophomore) are applicable to a specific program type in a given year. This data is subsequently used by packaging engines to apply correct cost of attendance budgets and award limits. Common reporting and validation queries would involve joining this table to its related entities. For example, to list all active program types for the current award year, a query might join IGF_AP_PR_PRG_TYPE to IGS_CA_INST_ALL on calendar type and sequence number, filtering for the relevant year. Another critical query would verify mappings by joining to IGF_AP_CLASS_STD_MAP on PPT_ID to ensure all program types have appropriate class standing rules defined.

Related Objects

• Primary Key: The table is uniquely identified by the constraint IGF_AP_PR_PRG_TYPE_PK on the column PPT_ID.
• Foreign Keys (Referenced by this table):
  • References IGS_CA_INST_ALL via columns CAL_TYPE and SEQUENCE_NUMBER to link to an academic calendar instance.
  • References IGS_PR_CS_SCHDL via column IGS_PR_CS_SCHDL_ID to link to a program course schedule.
• Foreign Keys (Referencing this table):
  • Referenced by IGF_AP_CLASS_STD_MAP via column PPT_ID. This is the primary child table, storing the specific grade level and class standing definitions for each program type.