Search Results igf_aw_awd_dist_plans




Overview
Explore in AI Chat

Overview

The table IGF_AW_AWD_DIST_PLANS is a core setup table within the Oracle E-Business Suite's Financial Aid module (IGF). It serves as the master repository for defining award distribution plans, which are critical templates governing how financial aid awards are disbursed to students across academic terms. In the context of Oracle EBS 12.1.1 and 12.2.2, this table provides the foundational data structure that links award definitions to specific disbursement schedules, ensuring funds are released according to institutional policies and regulatory requirements. Its integrity is central to the automated disbursement process.

Key Information Stored

The table stores the configuration for each unique distribution plan. Its primary identifier is the system-generated ADPLANS_ID. A unique key constraint ensures the combination of AWD_DIST_PLAN_CD (the user-defined plan code), CAL_TYPE, and SEQUENCE_NUMBER is not duplicated, tying the plan to a specific academic calendar instance. While the full column list is not detailed in the excerpt, the foreign key relationships imply the table likely stores descriptive information such as the plan name, status, and effective dates. The linkage to IGS_CA_INST_ALL via CAL_TYPE and SEQUENCE_NUMBER is essential for aligning disbursements with the correct term boundaries.

Common Use Cases and Queries

This table is primarily referenced during award packaging and disbursement generation. Common operational and reporting scenarios include validating the disbursement schedule attached to an award, listing all active distribution plans for an academic year, and auditing historical changes to award terms. A typical query might join this table to award and calendar tables to analyze disbursement patterns.

  • Identifying Active Plans for a Calendar: SELECT awd_dist_plan_cd FROM igf_aw_awd_dist_plans WHERE cal_type = 'SEMESTER' AND status = 'ACTIVE';
  • Linking an Award to Its Distribution Plan: SELECT a.*, p.awd_dist_plan_cd FROM igf_aw_award_all a, igf_aw_awd_dist_plans p WHERE a.adplans_id = p.adplans_id;

Related Objects

IGF_AW_AWD_DIST_PLANS is a pivotal hub table with numerous dependencies, as evidenced by its foreign key relationships. Key related objects include: