Search Results igf_ap_fa_setup_all_u2

Overview

The IGF.IGF_AP_FA_SETUP_ALL table is a Financial Aid setup table within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment. It resides in the IGF schema and stores configuration data for Financial Aid Offices (FAO), particularly in the context of the U.S. Department of Education's Title IV federal student aid programs. The table holds identifiers and attributes associated with institutions that disburse financial aid, including Pell grant identifiers, OPE identifiers, DUNS numbers, and CSS identifiers, as well as operating unit context and setup flags that govern disbursement behavior.

The table is stored in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its indexes are stored in APPS_TS_TX_IDX. Based on the heuristic Data Vault classification derived from foreign key analysis, this table is modeled as a standalone structure rather than a hub, link, or satellite. This suggests that the table primarily serves as a reference or setup entity without strict parent-child relationships to other business entities within the Data Vault model, though it does maintain a foreign key relationship to the CSS interface table.

Key Information Stored

The table contains 25 documented columns. The most important identifiers and attributes include:

• FAS_ID — The surrogate primary key (number) that uniquely identifies each Financial Aid setup record. It is the single-column unique key enforced by the index IGF_AP_FA_SETUP_ALL_U1.
• FAO_ID — A unique identifier (VARCHAR2) for the Financial Aid Office, forming part of the composite business key in index IGF_AP_FA_SETUP_ALL_U2 alongside ORG_ID.
• ORG_ID — The operating unit identifier (number) that provides multi-org context, also part of the unique business key U2.
• FAO_NAME — The descriptive name of the Financial Aid Office.
• PARTY_ID — The organization identifier linked to the financial aid office.
• OPE_ID — The Office of Postsecondary Education identifier assigned by the U.S. Department of Education.
• PELL_ID — The Pell grant institution identifier assigned by the Department of Education.
• DUNS_ID — The Data Universal Numbering System identifier assigned to the institution.
• CSS_ID — The College Scholarship Service identifier, which also participates in a foreign key relationship to IGF_AP_CSS_INTERFACE_ALL.
• STATE_AGENCY_ID — Identifier assigned by the state in which the institution is located.
• CAMPUS_ID — Identifier for the school campus.
• CRS_ID — A unique identifier associated with the setup record.
• LOW_DEFAULT, QA_SCHOOL, EXPERIMENTAL — Setup attribute flags indicating whether the organization is a low default school, a quality assurance school, or associated with experimental attributes.

The standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide audit tracking consistent with Oracle EBS conventions.

Common Use Cases and Queries

This table supports financial aid setup and reporting processes. Typical scenarios include retrieving all financial aid offices for a specific operating unit, validating Pell and OPE identifiers during disbursement processing, and reporting on institutional attributes such as low-default or quality assurance status. A common query pattern retrieves setup records by operating unit:

• SELECT fas_id, fao_id, fao_name, ope_id, pell_id, duns_id FROM igf.igf_ap_fa_setup_all WHERE org_id = :p_org_id;
• SELECT * FROM igf.igf_ap_fa_setup_all WHERE fao_id = :p_fao_id AND org_id = :p_org_id;
• SELECT fas_id, campus_id, low_default, qa_school, experimental FROM igf.igf_ap_fa_setup_all WHERE fas_id = :p_fas_id;

These queries leverage the unique indexes IGF_AP_FA_SETUP_ALL_U1 and IGF_AP_FA_SETUP_ALL_U2 for efficient access. Reporting use cases include generating institutional compliance reports, validating federal school codes, and auditing financial aid office configurations across multiple operating units.

Related Objects

The most significant related objects supported by the documented foreign key relationship and schema context include:

• IGF.IGF_AP_CSS_INTERFACE_ALL — Referenced via the CSS_ID foreign key, this table interfaces with College Scholarship Service data and is the primary documented dependency.
• IGF.IGF_AP_FA_SETUP_ALL_U1 / U2 — The unique indexes providing direct access paths by FAS_ID and by FAO_ID plus ORG_ID.
• Financial Aid Office disbursement tables — Tables in the IGF schema that consume FAO_ID and FAS_ID for processing Title IV aid.
• ORG_ID-dependent operating unit tables — Multi-org views and setup tables that validate the ORG_ID context.
• Party/Organization tables — Entities that resolve PARTY_ID to institution records.

Because the table is classified as standalone, its dependency footprint is relatively limited, with the CSS_ID foreign key representing the principal documented relationship.