Search Results igf_aw_dp_teach_prds




Overview
Explore in AI Chat

Overview

The table IGF_AW_DP_TEACH_PRDS is a core setup entity within the now-obsolete Financial Aid (IGF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the foundation for configuring the Award Distribution Plan Teaching Period Setup. This table defines the specific teaching periods (e.g., academic sessions, terms) within a broader award distribution term, enabling the precise scheduling and disbursement of financial aid awards to students across an academic calendar. Its primary function is to map distribution logic to the institutional calendar, ensuring aid is released according to defined academic milestones.

Key Information Stored

The table's structure is designed to link distribution terms with calendar details. The primary identifier is ADTEACH_ID, a system-generated unique key. A separate unique key constraint ensures business rule integrity, combining ADTERMS_ID (linking to the parent distribution term), TP_CAL_TYPE (the calendar type, e.g., 'ACADEMIC'), and TP_SEQUENCE_NUMBER (the sequence of the teaching period within that calendar). The DATE_OFFSET_CD column is a critical field, storing a code that references a date alias, which is used to calculate the specific disbursement date relative to the teaching period's start or end. This setup allows for flexible, rule-based date calculation.

Common Use Cases and Queries

This table is central to backend processes that generate disbursement schedules. A common operational query involves retrieving all teaching periods for a specific award distribution term to validate or report on the disbursement timeline. For troubleshooting or auditing, one might join this table with calendar instances to reconcile planned disbursement dates with actual academic calendar dates.

  • Sample Query to List Teaching Periods for a Distribution Term:
    SELECT adteach_id, tp_cal_type, tp_sequence_number, date_offset_cd FROM igf_aw_dp_teach_prds WHERE adterms_id = :dist_term_id ORDER BY tp_sequence_number;
  • Use Case: Generating a report that maps each financial aid award's planned disbursement dates to the academic teaching periods, which is essential for compliance and student communication.

Related Objects

IGF_AW_DP_TEACH_PRDS is intricately connected to other setup and base tables within EBS, primarily through foreign key relationships as documented in the ETRM.

  • IGF_AW_DP_TERMS: The parent table for Award Distribution Terms. Joined via IGF_AW_DP_TEACH_PRDS.ADTERMS_ID = IGF_AW_DP_TERMS.ADTERMS_ID.
  • IGS_CA_INST_ALL: The Calendar Instance table. Joined via the composite key IGF_AW_DP_TEACH_PRDS.TP_CAL_TYPE = IGS_CA_INST_ALL.CAL_TYPE and IGF_AW_DP_TEACH_PRDS.TP_SEQUENCE_NUMBER = IGS_CA_INST_ALL.SEQUENCE_NUMBER to obtain detailed calendar dates.
  • IGS_CA_DA: The Date Alias table. Joined via IGF_AW_DP_TEACH_PRDS.DATE_OFFSET_CD = IGS_CA_DA.DATE_ALIAS to resolve the offset code into a calculable date rule.