Search Results ipa_id




Overview
Explore in AI Chat

Overview

The IGF_AP_INC_PRCT_ALV table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Grants and Financial Aid (IGF) module. It functions as a lookup or reference table designed to store the foundational parameters for calculating a student's financial need. The table holds key values, such as the number of people in a household, which are used in conjunction with income percentage tables to determine expected family contributions. Its status is marked as OBSOLETE in the provided metadata, indicating it may have been superseded in later application versions, but it remains a critical component for implementations running the specified releases. The table is stored in the APPS_TS_ARCHIVE tablespace.

Key Information Stored

The table's columns are central to defining the context and scope of its financial aid calculations. The primary identifier is the IPA_ID (Primary Key). Context is established by the award year columns CI_CAL_TYPE and CI_SEQUENCE_NUMBER, and the METHOD_CODE, which links to the contribution methodology. The TABLE_CODE specifies which matrix (A, B, or C) the record belongs to. Most critically for the user's search, the NUM_PPL_HOUSEHOLD column stores the integer value representing the number of people in the household, which is the primary dimension for the associated income percentage matrix. Standard "Who" columns (CREATED_BY, CREATION_DATE, etc.) track auditing information.

  • IPA_ID: Primary key sequence identifier.
  • CI_CAL_TYPE / CI_SEQUENCE_NUMBER: Define the award calendar year.
  • METHOD_CODE: Financial contribution method.
  • TABLE_CODE: Specifies the matrix type (A, B, or C).
  • NUM_PPL_HOUSEHOLD: The foundational value for the calculation matrix.

Common Use Cases and Queries

This table is primarily queried during the financial need analysis process to retrieve the correct parameters based on a student's household composition and award year. A typical use case involves joining this table to its detail table (IGF_AP_INC_PC_AL_DT) to fetch the full matrix of income percentages for a specific household size. For reporting, administrators may query it to audit or verify the calculation parameters active for a given year and method. A fundamental query to retrieve all parameters for a specific household size would be:

SELECT * FROM apps.igf_ap_inc_prct_alv WHERE num_ppl_household = <household_count> AND ci_cal_type = '<YEAR_TYPE>' AND method_code = '<METHOD>';

Another common pattern is to list all distinct household sizes available for a particular calculation year and table code to support front-end application drop-downs or validations.

Related Objects

The IGF_AP_INC_PRCT_ALV table exists within a defined relational schema, as evidenced by its foreign key relationships. It references master tables to ensure data integrity and is itself referenced by a detail table.

  • Referenced By (Child Table): The table IGF_AP_INC_PC_AL_DT references this table's primary key via a foreign key on IPA_ID. This establishes a one-to-many relationship where the header record in IGF_AP_INC_PRCT_ALV defines the context, and the detail records in IGF_AP_INC_PC_AL_DT store the corresponding income percentage values.
  • References (Parent Tables): This table has foreign key relationships to:
  • Primary Key: The table's primary key constraint is named IGF_AP_INC_PRCT_ALV_PK on the column IPA_ID.