Results for “payment_isir_id”

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

Overview

IGF_AP_FA_BASE_REC_ALL is a Financial Aid base record table within the Oracle E-Business Suite product family identified by the IGF application short name. Per the ETRM product classification, the object belongs to IGF - Financial Aid, which is flagged as obsolete in the documented metadata. The table is described as holding the summarized information of all the financial aid processes for a student for an academic year. It therefore acts as the central anchor record for a student's complete financial aid lifecycle within a given aid year, aggregating needs analysis, packaging, disbursement, verification, and compliance indicators into a single row per student per aid year context.

The ETRM metadata states that this object is not implemented in the reference database from which the documentation was extracted, meaning the physical table may not exist in every environment. This is consistent with the obsolete designation and indicates the module is legacy in the 12.1.1 and 12.2.2 releases. The heuristic Data Vault classification derived from the foreign key structure is hub. As a modeling suggestion, this classification reflects the table's role as a business-key-bearing entity: the unique index IGF_AP_FA_BASE_REC_ALL_U2 on CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and PERSON_ID represents the natural business key, while BASE_ID serves as the surrogate primary key. Numerous dependent tables reference this hub through BASE_ID, which is the hallmark of a hub-and-satellite structure.

The documented physical schema lists 148 columns under the IGF schema owner, confirming that the base record is intentionally wide because it summarizes many financial aid processes rather than storing detail transactions.

Key Information Stored

The table is keyed by BASE_ID through the primary key IGF_AP_FA_BASE_REC_ALL_PK, and by the composite unique index IGF_AP_FA_BASE_REC_ALL_U2 (CI_CAL_TYPE, CI_SEQUENCE_NUMBER, PERSON_ID), which establishes the business identity of a student's aid year.

• BASE_ID — surrogate primary key and the target of the many foreign keys pointing into this table.
• PERSON_ID — the student, referencing HZ_PARTIES; part of the business key.
• CI_CAL_TYPE and CI_SEQUENCE_NUMBER — the academic period context, referencing IGS_CA_INST_ALL; together with PERSON_ID they form the unique business key.
• ORG_ID — the operating unit or organizational context for multi-org reporting.
• EFC_F and EFC_I — Expected Family Contribution for federal (F) and institutional (I) methodologies, the core needs analysis outputs.
• NEED_F and NEED_I — computed need figures under federal and institutional rules.
• COA_F, COA_I, COA_PELL, COA_FIXED — cost of attendance amounts, including a fixed and Pell-specific value.
• ISIR_STATUS, PROFILE_STATUS, FED_VERIF_STATUS, INST_VERIF_STATUS — process status flags covering the ISIR, CSS Profile, and federal/institutional verification processes.
• PACKAGING_STATUS, FA_PROCESS_STATUS, NOTIFICATION_STATUS — high-level workflow states for packaging, process completion, and student notification.
• TOTAL_AID, TOTAL_PACKAGE_OFFERED, TOTAL_PACKAGE_ACCEPTED, TOLERANCE_AMOUNT — aggregated award totals used in summary reporting.
• GRADE_LEVEL and ENROLMENT_STATUS — eligibility-driving academic attributes.
• ADMSTRUCT_ID, PACKSTRUCT_ID, MISCSTRUCT_ID with their ADMSEGMENT_n, PACKSEGMENT_n, and MISCSEGMENT_n descriptor segments — reserved structures holding institution-defined attribute values.
• Standard WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and the concurrent program columns REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID.

Common Use Cases and Queries

Typical use is identifying and retrieving the aid year base record for a student, either to display a summary or to join to dependent detail tables.

• Student aid year lookup: query by PERSON_ID joined through HZ_PARTIES to resolve the party name, filtered on CI_CAL_TYPE and CI_SEQUENCE_NUMBER to select the correct academic period.
• Base record summarization: select BASE_ID together with EFC_F, COA_F, TOTAL_AID, and FA_PROCESS_STATUS to produce a one-row-per-aid-year snapshot.
• Discrepancy and reconciliation reporting: compare TOTAL_PACKAGE_OFFERED against TOTAL_PACKAGE_ACCEPTED, or compare PACKAGING_STATUS against FA_PROCESS_STATUS to identify records stalled in the workflow.
• Compliance extracts: filter on FED_VERIF_STATUS or INST_VERIF_STATUS to build verification follow-up lists.
• Detail drill-down: join BASE_ID to dependent tables such as IGF_AW_AWARD_ALL or IGF_AP_ISIR_MATCHED_ALL to move from summary to transaction detail.

Because the object is documented as not implemented in the reference database and carries an obsolete product designation, queries should be validated against the target installation before deployment.

Related Objects

The metadata documents two outbound foreign keys and a large number of inbound references through BASE_ID.

• HZ_PARTIES — referenced by IGF_AP_FA_BASE_REC_ALL.PERSON_ID, providing the student identity.
• IGS_CA_INST_ALL — referenced by IGF_AP_FA_BASE_REC_ALL.CI_CAL_TYPE and CI_SEQUENCE_NUMBER, providing the calendar instance context.
• IGF_AW_AWARD_ALL — references BASE_ID; holds award records for the base record.
• IGF_AP_APPL_STATUS_ALL — references BASE_ID; application status detail.
• IGF_AP_ISIR_MATCHED_ALL — references BASE_ID; ISIR matching results.
• IGF_AP_EFC_DET — references BASE_ID; EFC calculation detail.
• IGF_AW_COA_ITEMS — references BASE_ID; cost of attendance line items.
• IGF_AP_FA_BASE_H_ALL — references BASE_ID; the history table for the base record.
• IGF_SL_LOR_LOC_ALL — references BASE_ID; loan location/origination data.
• IGF_AP_TAX_ALL — references BASE_ID; tax-related financial aid data.

These relationships confirm the hub position of IGF_AP_FA_BASE_REC_ALL: the majority of financial aid detail tables carry BASE_ID as a foreign key back to this central record.