Search Results igf_ap_tax_all




Overview
Explore in AI Chat

Overview

IGF_AP_TAX_ALL is a table in the IGF (Financial Aid) product module of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the tax values associated with financial aid students processed through the Oracle Financial Aid application. Within the Oracle EBS data model, the table functions as a dependent detail store keyed to a financial aid base record rather than as an independent transactional entity.

The ETRM documentation classifies the table's physical schema with nine documented columns owned by the IGF schema and a single primary key constraint, IGF_AP_TAX_ALL_PK, defined on BASE_ID. A unique index, IGF_AP_TAX_ALL_U1, is also defined on BASE_ID, which indicates that the column serves simultaneously as the surrogate primary key and as the only documented business-key candidate.

Applying a heuristic Data Vault classification, the foreign key topology — a single inbound reference to IGF_AP_FA_BASE_REC_ALL with no tables depending on it — suggests a satellite-leaning structure. In this modeling view, IGF_AP_TAX_ALL would be positioned as a satellite attached to the financial aid base record hub, carrying descriptive tax attributes rather than defining new business entities or relationships.

Key Information Stored

The table's content centers on a small set of tax-related and administrative attributes tied to a single financial aid base record. The most significant columns documented are:

  • BASE_ID — The primary key column and the foreign key to IGF_AP_FA_BASE_REC_ALL. It associates each tax row with exactly one financial aid base record and is the basis of both IGF_AP_TAX_ALL_PK and the unique index IGF_AP_TAX_ALL_U1.
  • TAXES_PAID — The tax amount paid in connection with the financial aid record, representing the primary business measure held in the table.
  • AGI — Adjusted gross income associated with the student, used as an input to tax and need calculations.
  • ORG_ID — The operating unit identifier, supporting multi-org security and filtering by organization in EBS.
  • CREATED_BY, CREATION_DATE — Standard WHO audit columns capturing the creating user and creation timestamp.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns capturing the last modifying user, timestamp, and login session.

Because BASE_ID is the sole column in the primary key and the sole column in the unique index, the table maintains a one-row-per-base-record relationship in the documented schema, with no additional composite uniqueness defined.

Common Use Cases and Queries

Typical use cases involve reporting and reconciliation of tax and income values against the financial aid base record, and extraction of tax attributes for compliance, audit, and financial aid packaging analysis. Queries generally join to the parent record to obtain student and base context.

  • Retrieve tax values for a specific financial aid base record: SELECT base_id, taxes_paid, agi FROM igf.igf_ap_tax_all WHERE base_id = :base_id;
  • Report tax and income data with parent context: SELECT t.base_id, t.taxes_paid, t.agi FROM igf.igf_ap_tax_all t, igf.igf_ap_fa_base_rec_all b WHERE t.base_id = b.base_id;
  • Filter by operating unit: SELECT * FROM igf.igf_ap_tax_all WHERE org_id = :org_id;
  • Audit recently changed records: SELECT base_id, last_updated_by, last_update_date FROM igf.igf_ap_tax_all WHERE last_update_date >= :since_date;

Reporting against this table is most reliable when joined through the financial aid base record, since business-meaningful student identifiers are not held locally.

Related Objects

The documented relationship data identifies a single foreign key, which anchors the table to the wider financial aid schema:

  • IGF_AP_FA_BASE_REC_ALL — Referenced by IGF_AP_TAX_ALL.BASE_ID; the parent base record that provides student and application context. This is the primary join path for all reporting.
  • IGF_AP_TAX_ALL_PK — The primary key constraint on BASE_ID, enforcing one row per base record.
  • IGF_AP_TAX_ALL_U1 — The unique index on BASE_ID, the documented business-key candidate.

No downstream dependencies on IGF_AP_TAX_ALL are documented, consistent with its satellite-leaning classification. Queries should therefore treat it as a descriptive extension of the financial aid base record rather than as an independent subject area.