Search Results adplans_id




Overview
Explore in AI Chat

Overview

The IGF_AW_DP_TERMS table is a core setup table within the now-obsolete Financial Aid (IGF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It specifically stores the term-level configuration for an Award Distribution Plan. An Award Distribution Plan defines how a financial aid award is disbursed to a student across the academic year. This table allows administrators to define the specific academic terms (e.g., Fall, Spring) that are part of that overall distribution plan, establishing the temporal framework for subsequent detailed scheduling of disbursements within each term.

Key Information Stored

The table's structure centers on linking a distribution plan to academic calendar terms and enforcing data integrity through its keys. The primary identifier is the ADTERMS_ID column. The table's unique key, which defines the critical business rule, is a composite of ADPLANS_ID, LD_CAL_TYPE, and LD_SEQUENCE_NUMBER. This ensures that within a single Award Distribution Plan (ADPLANS_ID), a given academic load calendar term (identified by its type and sequence number) can only be defined once. The LD_CAL_TYPE and LD_SEQUENCE_NUMBER columns directly reference the standard IGS_CA_INST_ALL (Calendar Instance) table to maintain alignment with the institution's academic calendar.

Common Use Cases and Queries

This table is primarily accessed for setup, validation, and reporting on the term structure of distribution plans. Common operational scenarios include creating or modifying the list of terms for a plan, validating that a term exists in the academic calendar before assignment, and generating lists of all plans that distribute funds in a specific term. A typical query would join this table to the plan header and calendar tables to report on the full term setup.

  • Sample Query: To list all distribution plans and their associated terms:
    SELECT dp.plan_name, ci.cal_type, ci.sequence_number, ci.start_dt
    FROM igf_aw_dp_terms dt,
    igf_aw_awd_dist_plans dp,
    igs_ca_inst_all ci
    WHERE dt.adplans_id = dp.adplans_id
    AND dt.ld_cal_type = ci.cal_type
    AND dt.ld_sequence_number = ci.sequence_number
    ORDER BY dp.plan_name, ci.start_dt;

Related Objects

IGF_AW_DP_TERMS sits at the center of a small hierarchy of distribution setup tables. It is a child of the IGF_AW_AWD_DIST_PLANS table, which stores the header-level plan definition, via the ADPLANS_ID foreign key. It is a parent to the IGF_AW_DP_TEACH_PRDS table, which holds the detailed teaching periods (and associated disbursement dates) within each term defined here, linked by the ADTERMS_ID column. As noted in its foreign keys, it relies on the foundational IGS_CA_INST_ALL table for valid academic calendar term definitions.