Search Results igf_aw_awd_prd_term

Overview

The IGF_AW_AWD_PRD_TERM table is a core data structure within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It functions as a detailed definition table that associates specific academic terms with a broader awarding period. An awarding period is a high-level timeframe, such as an academic year, for which financial aid is packaged. This table effectively breaks down that period into its constituent terms (e.g., Fall, Spring, Summer), enabling the system to manage and disburse aid according to the precise academic calendar. Its role is critical for ensuring that award amounts are correctly allocated and scheduled across the terms defined within an institution's academic structure.

Key Information Stored

The table's primary key uniquely identifies a term within an awarding period and consists of five columns: CI_CAL_TYPE, CI_SEQUENCE_NUMBER, AWARD_PRD_CD, LD_CAL_TYPE, and LD_SEQUENCE_NUMBER. The first three columns (CI_CAL_TYPE, CI_SEQUENCE_NUMBER, AWARD_PRD_CD) constitute a foreign key reference to the parent awarding period definition in the IGF_AW_AWARD_PRD table. The final two columns (LD_CAL_TYPE, LD_SEQUENCE_NUMBER) form a foreign key to the IGS_CA_INST_ALL table, which holds the institutional calendar details for the specific academic term being linked. Therefore, each record maps one unique academic term instance (Load Calendar) to one unique awarding period (Commitment Item Calendar).

Common Use Cases and Queries

This table is central to processes that require term-level visibility into financial aid awards. A primary use case is the generation of disbursement schedules and term-based award letters. System logic queries this table to determine which terms are active for a given award period before calculating pro-rated award amounts. For reporting, administrators often join this table to student award detail tables to analyze aid distribution. A common diagnostic query would verify the terms configured for an awarding period:

• SELECT ap.award_prd_cd, ci.cal_type AS ci_cal_type, ld.cal_type AS term_cal_type FROM igf_aw_awd_prd_term term JOIN igf_aw_award_prd ap ON term.award_prd_cd = ap.award_prd_cd AND term.ci_cal_type = ap.cal_type AND term.ci_sequence_number = ap.sequence_number JOIN igs_ca_inst_all ld ON term.ld_cal_type = ld.cal_type AND term.ld_sequence_number = ld.sequence_number WHERE ap.award_prd_cd = '&AWARD_PERIOD';

Related Objects

The IGF_AW_AWD_PRD_TERM table maintains defined foreign key relationships with two primary tables, as documented in the ETRM metadata:

• IGF_AW_AWARD_PRD: This is the parent table defining the awarding period. The relationship is established via the columns (CI_CAL_TYPE, CI_SEQUENCE_NUMBER, AWARD_PRD_CD) in IGF_AW_AWD_PRD_TERM.
• IGS_CA_INST_ALL: This table from the Student System (IGS) contains all institutional calendar term instances. The relationship is established via the columns (LD_CAL_TYPE, LD_SEQUENCE_NUMBER) in IGF_AW_AWD_PRD_TERM, linking to the specific academic term.

These relationships ensure data integrity, enforcing that a term assigned to an awarding period must be a valid calendar instance and belong to a valid, existing award period definition.