Search Results students_in_household

Overview

The IGF_FC_INC_PRCT table is a core reference table within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It functions as the Income Protection Allowance (IPA) table, a critical component in the federal methodology for calculating a student's Expected Family Contribution (EFC). The IPA is an allowance against income that protects a portion of a family's earnings from being considered available for educational expenses. This table stores the pre-defined allowance amounts based on household composition and the award year, ensuring standardized and regulatory-compliant calculations across the financial aid system in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to uniquely identify an allowance amount through a composite key and associated demographic factors. The primary columns include:

• S_AWARD_YEAR and TABLE_CODE: These VARCHAR2 columns, part of the primary key, define the academic award year and specific table version (e.g., for different calculation types or regulatory updates).
• PEOPLE_IN_HOUSEHOLD and STUDENTS_IN_HOUSEHOLD: These NUMBER columns, also part of the primary key, specify the total number of individuals in the household and the subset who are postsecondary students. These are the direct lookup criteria for the user's search term.
• IP_ALLOWANCE_AMT: The core data element; a NUMBER column storing the monetary value of the Income Protection Allowance for the specified household profile and award year.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns tracking the creation and modification history of each row.

The primary key constraint IGF_FC_INC_PRCT_PK enforces uniqueness on the combination of these four demographic and temporal columns.

Common Use Cases and Queries

The primary use case is the automated retrieval of the correct IPA during EFC calculation processing within the financial aid packaging engine. A typical query involves joining student-specific household data to this table. For example, to find the allowance for a specific scenario:

SELECT ip_allownace_amt
FROM igf.igf_fc_inc_prct
WHERE s_award_year = '2024-2025'
  AND table_code = 'DEPENDENT'
  AND people_in_household = 4
  AND students_in_household = 2;

Reporting use cases include validating the allowance tables for a new award year or auditing calculation results. Administrators may run queries to extract the entire matrix for a given year and table code to review the allowance schedule. Data maintenance is performed via the application's administrative forms, which maintain referential integrity and business rules.

Related Objects

Based on the provided metadata, the IGF_FC_INC_PRCT table is a standalone reference table. It does not reference other objects via foreign keys. However, it is referenced by the APPS synonym IGF_FC_INC_PRCT, which provides public access to the table within the EBS context. The primary relationship is functional rather than declarative; the table is read by the financial aid calculation engine (likely within packages or views in the IGF schema) using the primary key columns (S_AWARD_YEAR, TABLE_CODE, PEOPLE_IN_HOUSEHOLD, STUDENTS_IN_HOUSEHOLD) as the lookup criteria. Other objects, such as forms and reports, will reference this synonym to access the standardized allowance data.