Search Results rate_order_num




Overview
Explore in AI Chat

Overview

The IGF_AW_COA_RATE_DET table is a core data structure within the Oracle E-Business Suite's Institutional Grants and Financial Aid (IGF) module, specifically for versions 12.1.1 and 12.2.2. This table functions as the detail repository for defining and storing the specific criteria and rules used to calculate variable components of a student's Cost of Attendance (COA). The COA is a foundational element in financial aid packaging, representing the total estimated cost for a student to attend an institution for a specific period. This table enables the system to apply different rates or amounts to standard COA items based on a complex set of student and program attributes, allowing for highly customized and rule-based financial aid calculations.

Key Information Stored

The table stores rule definitions that link COA items to specific student demographics and academic contexts. Key columns include the composite primary key (CI_CAL_TYPE, CI_SEQUENCE_NUMBER, ITEM_CODE, RATE_ORDER_NUM), which anchors the rule to an award year calendar instance and a specific COA item code. The RATE_ORDER_NUM, which was the focus of the user's search, is critical as it dictates the processing sequence when multiple matching rules exist for a student; lower numbers are evaluated first. The table houses numerous conditional attributes for rule matching, such as PID_GROUP_CD (Person ID Group), ORG_UNIT_CD (Organization Unit), PROGRAM_CD, CLASS_STANDING, RESIDENCY_STATUS_CODE, and HOUSING_STATUS_CODE. The resulting calculation is defined by MULT_FACTOR_CODE and MULT_AMOUNT_NUM. Standard WHO columns track creation and modification history.

Common Use Cases and Queries

This table is central to scenarios requiring dynamic COA adjustments. A common use case is defining different tuition, fee, or living expense rates for in-state versus out-of-state students, or for on-campus versus off-campus housing. Administrators configure rules in this table to be evaluated during automated packaging. A typical reporting query involves listing all active COA rate rules for a given award year and item, ordered for processing:

  • SELECT * FROM igf.igf_aw_coa_rate_det WHERE ci_cal_type = '&AWARD_YEAR_TYPE' AND ci_sequence_number = &AWARD_YEAR_NUM AND item_code = '&ITEM_CODE' ORDER BY rate_order_num;

Another critical query identifies all rules that could apply to a specific student's profile for aid simulation or troubleshooting, joining on relevant student data tables.

Related Objects

The IGF_AW_COA_RATE_DET table is part of a larger financial aid data model. Its primary key is enforced by the unique index IGF_AW_COA_RATE_DET_PK. It is fundamentally related to the master Cost of Attendance definition tables, likely referenced via the CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and ITEM_CODE columns. The conditional columns (e.g., PROGRAM_CD, RESIDENCY_STATUS_CODE) typically have foreign key relationships to validation tables within the IGF or foundational Oracle Student Management (OSM) modules, such as lookup tables for residency statuses or program codes. The table is directly referenced by the financial aid packaging engine to retrieve and process the applicable rate rules when building a student's financial aid award.