Search Results dist_plan_method_code




Overview
Explore in AI Chat

Overview

The IGF_AW_AWD_DIST_PLANS table is a core setup entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Integrated Student Financial Aid (ISF) module. It functions as the master repository for defining and storing award distribution plans. A distribution plan dictates the methodology and timing for disbursing financial aid funds to students across the terms of an academic award year. This table is critical for configuring how awards are paid out, ensuring compliance with institutional and regulatory disbursement schedules. Its data is referenced throughout the award packaging and disbursement processes.

Key Information Stored

The table's structure captures the plan's definition, its active status, and its association with an academic calendar. The primary columns include the system-generated primary key ADPLANS_ID and the user-defined AWD_DIST_PLAN_CD, which serves as the unique business identifier for the plan. The AWD_DIST_PLAN_CD_DESC provides a descriptive name. The plan's validity is controlled by the ACTIVE_FLAG. Crucially, the table links the plan to a specific award year via the CAL_TYPE and SEQUENCE_NUMBER columns, which reference the academic calendar instance. The DIST_PLAN_METHOD_CODE specifies the core disbursement logic or method employed by the plan. Standard WHO columns track creation and modification history.

Common Use Cases and Queries

A primary use case is the administration of distribution plans via the corresponding EBS form, where plans are created, updated, or inactivated. Reporting and validation SQL often center on retrieving active plans for a given award year or troubleshooting award packaging issues. A common query pattern involves joining to calendar tables and filtering on the active flag.

  • To list all active distribution plans for a specific award year calendar: SELECT AWD_DIST_PLAN_CD, AWD_DIST_PLAN_CD_DESC, DIST_PLAN_METHOD_CODE FROM IGF_AW_AWD_DIST_PLANS WHERE CAL_TYPE = '&CAL_TYPE' AND SEQUENCE_NUMBER = &SEQ_NUM AND ACTIVE_FLAG = 'Y';
  • To find all awards using a specific distribution plan code (joining to the award table): SELECT awd.AWARD_ID FROM IGF_AW_AWARD_ALL awd, IGF_AW_AWD_DIST_PLANS plan WHERE awd.ADPLANS_ID = plan.ADPLANS_ID AND plan.AWD_DIST_PLAN_CD = '&PLAN_CODE';

Related Objects

The IGF_AW_AWD_DIST_PLANS table sits at the center of a key relationship hierarchy in ISF. It is referenced by multiple transactional and setup tables via its primary key (ADPLANS_ID), establishing it as a parent record. The documented foreign key relationships are:

Furthermore, the table itself references the academic calendar via IGS_CA_INST_ALL on the CAL_TYPE and SEQUENCE_NUMBER columns.