Search Results rate_order_num

Overview

The table IGF_AW_COA_RATE_DET is a core data object within the Oracle E-Business Suite Financial Aid module (IGF). It functions as the detail repository for configurable rate tables used in calculating a student's Cost of Attendance (COA). The COA is a foundational element in financial aid packaging, representing the estimated total cost for a student to attend an institution for a specific period. This table stores the granular rules and associated percentage or fixed rates that are applied to base cost items (e.g., tuition, housing) to derive the final COA components for students based on various academic and demographic criteria. Its role is to provide the system with the business logic necessary to automate and standardize COA calculations across diverse student populations.

Key Information Stored

The table's structure is designed to link a rate table entry to specific institutional and student contexts. Its primary key uniquely identifies a record through a combination of the calendar instance (CI_CAL_TYPE, CI_SEQUENCE_NUMBER), the financial aid item code (ITEM_CODE), and a sequence (RATE_ORDER_NUM). Key columns define the application criteria and the resulting calculation. Criteria-defining columns include LD_CAL_TYPE and LD_SEQUENCE_NUMBER (load calendar), ATTENDANCE_TYPE, ATTENDANCE_MODE, CLASS_STANDING, PROGRAM_TYPE, PROGRAM_CD, and PROGRAM_LOCATION_CD. The core calculation data is stored in the RATE column, which holds the percentage or fixed amount to be applied. The table maintains foreign key relationships to numerous reference tables, ensuring data integrity for these criteria.

Common Use Cases and Queries

The primary use case is the dynamic determination of a student's COA during the financial aid packaging process. The system queries this table to find the applicable rate record(s) matching the student's academic program, load, attendance type, and other attributes for each cost item. Common reporting and operational queries involve analyzing or validating rate configurations. A typical SQL pattern retrieves all active rates for a given academic period and item:

• SELECT * FROM igf_aw_coa_rate_det WHERE ci_cal_type = :cal_type AND ci_sequence_number = :seq_num AND item_code = :item_code ORDER BY rate_order_num;

Another critical query joins to related tables like IGS_CA_INST_ALL for calendar descriptions and IGF_AW_ITEM for item descriptions to produce human-readable rate tables for business user review. Data fixes often target this table when COA calculations are incorrect, requiring updates to the RATE or the criteria columns for specific records.

Related Objects

IGF_AW_COA_RATE_DET is centrally connected to many entities within the Student Systems and Financial Aid modules. As per the metadata, its primary foreign key relationship is with IGF_AW_ITEM via the ITEM_CODE, linking the rate to the financial aid cost item being calculated. It references IGS_CA_INST_ALL twice: for the controlling calendar instance (primary key) and the load calendar. It also links to student standing (IGS_PR_CLASS_STD), attendance details (IGS_EN_ATD_TYPE_ALL, IGS_EN_ATD_MODE_ALL), and program details (IGS_PS_TYPE_ALL, IGS_PS_COURSE, IGS_AD_LOCATION_ALL). This table is typically populated and maintained via the corresponding Financial Aid forms and is integral to the COA calculation engine within the IGF_AW packaging process.