Search Results num_stud_household




Overview
Explore in AI Chat

Overview

The IGF_AP_INC_PC_AL_DT table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the Student Systems (IGF) module. It functions as a detailed child table within the financial aid subsystem, storing granular data related to the Income Protection Allowance (IPA). The IPA is a critical component in federal need analysis formulas, such as the Free Application for Federal Student Aid (FAFSA), where it represents an amount of parent or student income that is protected from being considered available for educational expenses. This table holds the specific allowance amounts correlated to different household sizes, enabling the system to accurately calculate a student's financial need.

Key Information Stored

The table's structure is designed to capture the relationship between household composition and the corresponding financial allowance. The primary data columns are the compound primary key and the calculated allowance amount. The IPA_ID column is a mandatory foreign key that links each detail record to its parent Income Protection Allowance definition. The NUM_STUD_HOUSEHOLD column stores the number of students in the household, which is a key determinant in the allowance calculation. The INCOME_ALV_AMT column holds the actual monetary value of the allowance for that specific household student count. The table is completed by the standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing and tracking data changes.

Common Use Cases and Queries

This table is primarily accessed during the automated packaging and need analysis processes within the Student Systems module. When determining a student's financial aid eligibility, the system queries this table to fetch the correct Income Protection Allowance amount based on the household data provided in the student's application. A typical query would join this table to its parent to retrieve the full set of allowances for a specific IPA definition or to look up a single value for a packaging calculation. For example, to retrieve all allowance details for a specific parent record, one would use:

  • SELECT NUM_STUD_HOUSEHOLD, INCOME_ALV_AMT FROM IGF.IGF_AP_INC_PC_AL_DT WHERE IPA_ID = :1 ORDER BY NUM_STUD_HOUSEHOLD;

Reporting use cases include auditing the allowance schedules used in aid years and validating the configuration of need analysis formulas against regulatory updates.

Related Objects

The IGF_AP_INC_PC_AL_DT table has a direct, dependent relationship with its parent table, which defines the overarching Income Protection Allowance context. As documented in the relationship data:

  • Primary Key: The table's unique identifier is the composite key IGF_AP_INC_PC_AL_DT_PK on columns (IPA_ID, NUM_STUD_HOUSEHOLD).
  • Foreign Key Relationship: The IPA_ID column is a foreign key referencing a parent table, logically inferred from the provided relationship note as IGF_AP_INC_PRCT_ALV or a similarly named table in the IGF schema. This establishes a master-detail link where the parent table holds the header-level definition (e.g., aid year, allowance type), and this detail table stores the variable amounts by household size.