Results for “igf_aw_coa_rate_det”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGF_AW_COA_RATE_DET (Cost of Attendance Rate Table Detail) is a child detail table within the Oracle E-Business Suite Financial Aid (IGF) module. It stores the individual cost components that make up a student's Cost of Attendance (COA) budget for a specific award term or rate definition. This table works in conjunction with its parent header table, IGF_AW_COA_RATE, to define how award amounts are calculated and disbursed based on a student's enrollment characteristics, program, residency, and housing status.

In Oracle EBS 12.1.1 and 12.2.2, this table is owned by the IGF schema and resides in the Financial Aid application. It holds 23 documented columns and is a foundational configuration object used by financial aid administrators to set up institution-specific cost components such as tuition, fees, books, room, board, and personal expenses. Based on heuristic Data Vault classification mined from its foreign key structure, this table can be modeled as a link table, as it primarily connects business entities (calendar instances, item codes, program attributes, and student characteristics) rather than serving as a standalone hub or satellite.

Key Information Stored

The primary key of IGF_AW_COA_RATE_DET is defined by the unique index IGF_AW_COA_RATE_DET_PK, composed of four columns: CI_CAL_TYPE, CI_SEQUENCE_NUMBER, ITEM_CODE, and RATE_ORDER_NUM. This composite key uniquely identifies each cost detail record within a calendar instance and item context.

• CI_CAL_TYPE / CI_SEQUENCE_NUMBER – Reference the calendar instance (term or academic period) for which the cost rate applies.
• ITEM_CODE – Foreign key to IGF_AW_ITEM, identifying the specific cost item or budget component (e.g., tuition, books).
• RATE_ORDER_NUM – Sequence number controlling the order in which rate components are processed or displayed.
• PROGRAM_TYPE / PROGRAM_CD / PROGRAM_LOCATION_CD – Define the academic program, its type, and the location where the cost applies.
• CLASS_STANDING – Foreign key to IGS_PR_CLASS_STD, used to differentiate costs by student classification (e.g., freshman, senior).
• RESIDENCY_STATUS_CODE / HOUSING_STATUS_CODE – Distinguish costs for in-state vs. out-of-state students and on-campus vs. off-campus housing.
• ATTENDANCE_TYPE / ATTENDANCE_MODE – Reference enrollment attendance patterns and delivery modes affecting cost calculation.
• LD_CAL_TYPE / LD_SEQUENCE_NUMBER – Reference load calendar instances used for enrollment load calculations.
• MULT_FACTOR_CODE / MULT_AMOUNT_NUM – Define multiplication factors or amounts applied when computing costs.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE – Standard audit columns tracking record creation and modification.

Common Use Cases and Queries

Financial aid administrators and technical consultants query this table to verify cost of attendance configuration, troubleshoot award calculation discrepancies, and generate budget reports. A typical query retrieves all cost components for a specific calendar instance and item:

• Verifying that all cost items are properly configured for a term before running award processes.
• Reporting on cost variations by residency, housing, and class standing for compliance and auditing.
• Debugging award calculations by tracing which rate detail records were used.
• Extracting COA budget data for integration with third-party financial aid systems.

Sample SQL pattern:

SELECT d.ITEM_CODE, d.RATE_ORDER_NUM, d.PROGRAM_CD, d.CLASS_STANDING, d.RESIDENCY_STATUS_CODE, d.MULT_AMOUNT_NUM FROM IGF_AW_COA_RATE_DET d WHERE d.CI_CAL_TYPE = :cal_type AND d.CI_SEQUENCE_NUMBER = :seq_num ORDER BY d.RATE_ORDER_NUM;

Related Objects

The following tables are directly referenced by foreign keys from IGF_AW_COA_RATE_DET and are essential for joins and data validation:

• IGF_AW_ITEM – Joined on ITEM_CODE; defines the cost item master.
• IGS_PR_CLASS_STD – Joined on CLASS_STANDING; defines student classification codes.
• IGS_CA_INST_ALL – Joined on CI_CAL_TYPE/CI_SEQUENCE_NUMBER and LD_CAL_TYPE/LD_SEQUENCE_NUMBER; defines calendar instances.
• IGS_EN_ATD_TYPE_ALL – Joined on ATTENDANCE_TYPE; defines attendance type codes.
• IGS_EN_ATD_MODE_ALL – Joined on ATTENDANCE_MODE; defines attendance mode codes.
• IGS_PS_TYPE_ALL – Joined on PROGRAM_TYPE; defines program type codes.
• IGS_PS_COURSE – Joined on PROGRAM_CD; defines program codes.
• IGS_AD_LOCATION_ALL – Joined on PROGRAM_LOCATION_CD; defines location codes.

Together with its parent header table IGF_AW_COA_RATE, these relationships form the complete Cost of Attendance configuration framework used throughout Oracle Financial Aid processing.