Search Results igf_ap_asset_pc_dt




Overview
Explore in AI Chat

Overview

The table IGF_AP_ASSET_PC_DT is a data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). Its core function is to store detailed asset protection allowance data, which is a critical component in calculating a student's financial need. The table holds specific allowance values or percentages tied to defined methodologies, calendar instances, and table codes, enabling the system to determine the portion of a family's assets that is shielded from the financial aid calculation. According to the official ETRM documentation, this table is marked as OBSOLETE. This status indicates that while the table may still exist in the database schema for backward compatibility, its use is deprecated in versions 12.1.1 and 12.2.2, and it is likely superseded by newer data structures or logic within the application.

Key Information Stored

The table's structure is defined by its primary key, which consists of four columns. These columns collectively identify a unique asset protection allowance record. The CI_CAL_TYPE and CI_SEQUENCE_NUMBER columns establish a link to a specific academic calendar instance, allowing for time-based variations in allowance rules. The METHOD_CODE associates the record with a specific need analysis methodology (e.g., Federal Methodology). Finally, the TABLE_CODE serves as a key to differentiate between different allowance schedules or tiers within the defined method and calendar period. While the specific data columns holding the allowance values are not detailed in the provided metadata, the table's purpose implies it would contain numeric fields for allowance amounts or percentages.

Common Use Cases and Queries

In an operational context prior to obsolescence, this table was queried during the automated packaging or need analysis processes. A typical use case would involve retrieving the applicable asset protection allowance for a student based on their application year (calendar instance) and the mandated need analysis methodology. A sample query pattern would join this table with the calendar and methodology tables to fetch the correct value.

SELECT pc.allowance_value
FROM igf_ap_asset_pc_dt pc,
     igs_ca_inst_all cal,
     igf_ap_need_mth_typ mth
WHERE pc.ci_cal_type = cal.cal_type
  AND pc.ci_sequence_number = cal.sequence_number
  AND pc.method_code = mth.method_code
  AND cal.cal_type = '&CAL_TYPE'
  AND cal.sequence_number = &SEQ_NUM
  AND mth.method_code = '&METHOD'
  AND pc.table_code = '&TABLE_CODE';

Given its obsolete status, direct reporting or integration from this table is strongly discouraged. Any new development should utilize the current, supported APIs or data models as defined by Oracle.

Related Objects

The ETRM documentation explicitly defines the following key relationships for the IGF_AP_ASSET_PC_DT table:

  • Primary Key: IGF_AP_ASSET_PC_DT_PK on columns (CI_CAL_TYPE, CI_SEQUENCE_NUMBER, METHOD_CODE, TABLE_CODE).
  • Foreign Key Reference to IGS_CA_INST_ALL: The columns CI_CAL_TYPE and CI_SEQUENCE_NUMBER reference the IGS_CA_INST_ALL table, which stores calendar instance details. This ensures asset protection rules are valid for a specific academic period.
  • Foreign Key Reference to IGF_AP_NEED_MTH_TYP: The METHOD_CODE column references the IGF_AP_NEED_MTH_TYP table, which defines the various need analysis methodologies available in the system.

These relationships enforce data integrity, ensuring that allowance data is only stored for valid calendar instances and established need analysis methods.