Search Results date_offset_cd




Overview
Explore in AI Chat

Overview

The IGF_AW_DP_TEACH_PRDS table is a core setup table within the Oracle E-Business Suite's Student Financial Aid module (iGrants/Fund Management). It functions as the Award Distribution Plan Teaching Period Setup table. Its primary role is to define the specific teaching periods (or sub-terms) within a broader academic term for the purpose of distributing financial aid awards. This table enables the precise allocation of award funds across different instructional segments of a term, a critical requirement for compliant disbursement scheduling and reporting in educational institutions. It is integral to the configuration of how and when aid is paid out to students based on their enrollment patterns.

Key Information Stored

The table stores the instructional calendar and financial breakdown for each teaching period within a distribution plan term. Key columns include:

  • ADTEACH_ID: The system-generated primary key uniquely identifying each teaching period record.
  • ADTERMS_ID: A foreign key linking to the parent award distribution plan term (IGF_AW_DP_TERMS), establishing the hierarchical relationship.
  • TP_CAL_TYPE and TP_SEQUENCE_NUMBER: Together, these identify the specific academic calendar period (e.g., "SEMESTER", 1) used as the teaching period.
  • TP_PERCT_NUM: A crucial numeric field storing the percentage of the total term award amount that is allocated to this specific teaching period. This directly addresses the user's search context.
  • DATE_OFFSET_CD: A code that determines the disbursement date calculation rule for this period, relative to the teaching period's start or end date.
  • ATTENDANCE_TYPE_CODE and CREDIT_POINTS_NUM: Define the attendance type (e.g., Full-time, Half-time) and credit points associated with this teaching period, which can influence aid eligibility and amounts.
  • Standard WHO columns (CREATED_BY, CREATION_DATE, etc.) for auditing.

Common Use Cases and Queries

This table is central to processes involving the proration and scheduling of financial aid disbursements. A common use case is generating a report showing the planned disbursement schedule for an award, detailing the percentage and amount for each teaching period. Administrators may query this table to validate or adjust distribution rules. A typical query involves joining to the parent terms table and selecting the distribution percentages:

SELECT t.adplan_id, dpt.adterms_id, dtp.tp_cal_type, dtp.tp_sequence_number, dtp.tp_perct_num, dtp.date_offset_cd
FROM igf_aw_dp_teach_prds dtp,
igf_aw_dp_terms dpt,
igf_aw_award_terms t
WHERE dtp.adterms_id = dpt.adterms_id
AND dpt.adterms_id = t.adterms_id
AND t.adplan_id = :plan_id
ORDER BY dtp.tp_sequence_number;

Another critical scenario is during the disbursement engine runtime, where the system references the TP_PERCT_NUM and DATE_OFFSET_CD to calculate the exact disbursement amount and date for each scheduled payment.

Related Objects

Based on the provided metadata, the primary relationship for this table is a foreign key dependency to the Award Distribution Plan Term table.

  • IGF_AW_DP_TERMS: The IGF_AW_DP_TEACH_PRDS.ADTERMS_ID column is a foreign key to this table. This establishes that teaching periods are child records of a specific distribution term. The unique index IGF_AW_DP_TEACH_PRDS_U1 on ADTERMS_ID, TP_CAL_TYPE, and TP_SEQUENCE_NUMBER enforces business rules within a term.
The table itself is referenced by the APPS schema synonym (IGF_AW_DP_TEACH_PRDS), indicating it is a published application table accessible via this synonym. The absence of other explicitly listed referencing objects in the excerpt suggests it is primarily a setup table queried by the financial aid engine's internal logic and related views or packages.