Search Results adplans_id




Overview
Explore in AI Chat

Overview

The IGF_AW_DP_TERMS table is a core setup table within the Oracle E-Business Suite (EBS) Grants Accounting (IGF) module, specifically for versions 12.1.1 and 12.2.2. It functions as the Award Distribution Plan Term Setup table. Its primary role is to define the specific academic terms or periods associated with an award distribution plan, enabling the proportional allocation of award funds across multiple terms. This table is essential for configuring how financial aid or grant awards are scheduled and disbursed over time according to an institution's academic calendar, supporting both automated and manual distribution logic.

Key Information Stored

The table stores the linkage between a distribution plan and the academic calendar, along with distribution percentages. Key columns include:

  • ADTERMS_ID: A system-generated, mandatory primary key (NUMBER) uniquely identifying each term record within a plan.
  • ADPLANS_ID: A mandatory foreign key (NUMBER) referencing the parent award distribution plan in the IGF_AW_DIST_PLANS table. This is the column relevant to the user's search for "adplans_id".
  • LD_CAL_TYPE and LD_SEQUENCE_NUMBER: Together, these columns (VARCHAR2(10) and NUMBER) define the specific academic term (e.g., 'FALL', 2024) within the institutional calendar to which the distribution applies. They form a unique constraint with ADPLANS_ID.
  • LD_PERCT_NUM: A NUMBER column storing the percentage of the total award amount to be distributed in the associated term. This is critical for manual award distribution calculations.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): For auditing and tracking record changes.

Common Use Cases and Queries

This table is central to queries related to award disbursement schedules and term-based financial reporting. A common use case is retrieving the full disbursement schedule for a specific award distribution plan to verify term percentages or generate forecast reports. The following query pattern is fundamental:

SELECT dp.adplans_id, dt.ld_cal_type, dt.ld_sequence_number, dt.ld_perct_num
FROM igf.igf_aw_dp_terms dt, igf.igf_aw_dist_plans dp
WHERE dt.adplans_id = dp.adplans_id
AND dp.adplans_id = :specific_plan_id
ORDER BY dt.ld_sequence_number;

Another critical scenario involves data validation, such as ensuring the sum of LD_PERCT_NUM for all terms linked to a single ADPLANS_ID equals 100% for manual distributions. Administrators and technical consultants query this table to troubleshoot award distribution issues, audit setup configurations, and integrate disbursement schedules with downstream systems.

Related Objects

IGF_AW_DP_TERMS has defined relationships with other key EBS objects, primarily through foreign key constraints. Based on the provided metadata:

  • Parent Table (Foreign Key Reference): The ADPLANS_ID column is a documented foreign key to the IGF_AW_DIST_PLANS table (the Award Distribution Plan table). This is the primary relationship, linking term details to their parent plan.
  • Referencing Objects: The ETRM indicates the table is referenced by the APPS synonym IGF_AW_DP_TERMS, which is the standard access point for EBS applications. While specific dependent tables or views are not listed in the excerpt, in a typical Grants Accounting implementation, this setup table is likely referenced by transactional award tables and views that execute the distribution logic configured here.

The unique index IGF_AW_DP_TERMS_U1 on (ADPLANS_ID, LD_CAL_TYPE, LD_SEQUENCE_NUMBER) enforces business rule integrity, preventing duplicate term assignments within a single distribution plan.