Search Results coald_id

Overview

The table IGF_AW_COA_TP_ALL is a core data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). Its primary function is to store the percentage-based distribution of a student's total Cost of Attendance (COA) across different teaching periods within an academic year. This granular breakdown is critical for accurate financial aid packaging, as aid awards are often disbursed and calculated on a per-term basis. The table enables the system to prorate costs and associated aid eligibility according to institutional academic calendars, ensuring compliance with regulatory requirements for fund distribution.

Key Information Stored

The table's structure is designed to link a Cost of Attendance definition to specific academic periods. The documented primary and unique keys indicate the critical data points. The surrogate primary key is COATP_ID. The logical unique key is a combination of COALD_ID (which links to a specific Cost of Attendance definition), TP_CAL_TYPE (the teaching period calendar type), and TP_SEQUENCE_NUMBER (the sequence of the period within that calendar). While specific percentage or amount columns are not detailed in the provided excerpt, the table's description confirms it holds the "percentage split up" for each period, implying columns for the allocated percentage or calculated monetary value derived from the total COA.

Common Use Cases and Queries

This table is central to processes that require term-level financial calculations. A primary use case is the generation of a student's financial aid award letter, which details costs and awards for each term (e.g., Fall, Spring). System processes query this table to determine the portion of a student's total budget (cost of attendance) that is applicable to a given term, which in turn influences the term-specific calculation of need and eligibility for programs like Pell Grants or Direct Loans. A typical reporting query would join this table to the main COA definition table to analyze cost distributions.

• Sample Query Pattern: Retrieving the cost split for a specific student's COA across terms:
  SELECT tp_cal_type, tp_sequence_number, percentage FROM igf_aw_coa_tp_all WHERE coald_id = (SELECT coald_id FROM igf_aw_coald_all WHERE ...);

Related Objects

Based on the provided Foreign Key metadata, IGF_AW_COA_TP_ALL has a direct and fundamental relationship with a parent table via the COALD_ID column. This foreign key references the primary key of a table containing the master Cost of Attendance definition details, which is almost certainly named IGF_AW_COALD_ALL (Cost of Attendance - Load Details). This relationship is essential, as every teaching period split must be associated with a valid, overarching COA record. The table is also likely referenced by award calculation engines and disbursement planning routines within the IGF module.

• Primary Parent Table: IGF_AW_COALD_ALL (joined on IGF_AW_COA_TP_ALL.COALD_ID = IGF_AW_COALD_ALL.COALD_ID)