Search Results igf_ap_fa_setup_all_uk

Overview

The IGF.IGF_AP_FA_SETUP_ALL table resides in the IGF (Financial Aid) product schema of Oracle E-Business Suite and is documented as a VALID object in the ETRM repository for releases 12.1.1 and 12.2.2. The internal ETRM description references the legacy document FA126_3102439_CS_DP2.doc and marks the object as Obsolete, meaning it belongs to an earlier generation of the Financial Aid setup model and may no longer be actively maintained by current application code paths. It stores financial-aid configuration records that associate a financial aid office with the identifiers and processing parameters used when interfacing with external student-aid and funding authorities.

From a Data Vault modeling perspective, the ETRM relationship metadata classifies this object heuristically as standalone. In Data Vault terms this suggests it behaves closer to a satellite holding descriptive setup attributes over a natural key, rather than a pure hub or link. The mined relationship data is sparse, and the object references only one other table, so the classification should be treated as a suggestion rather than a definitive architectural statement.

Key Information Stored

The table contains 25 documented columns. The most significant ones are summarized below, distinguishing the surrogate primary key from the business-key candidates identified through unique indexes.

• FAS_ID — Surrogate primary key, enforced by IGF_AP_FA_SETUP_ALL_PK and additionally protected by unique index IGF_AP_FA_SETUP_ALL_U1. This is the technical identifier for each setup row.
• FAO_ID — Financial aid office identifier; together with ORG_ID it forms the alternate unique key IGF_AP_FA_SETUP_ALL_U2, and therefore represents the primary business-key candidate.
• ORG_ID — Operating unit / organization identifier, providing multi-org partitioning and completing the business key.
• FAO_NAME — Descriptive name of the financial aid office record.
• PARTY_ID — Reference to the trading-party or party record associated with the setup.
• OPE_ID, PELL_ID — Identifiers for the Office of Postsecondary Education and Pell grant programs respectively.
• DUNS_ID — Data Universal Numbering System identifier used for federal reporting.
• CSS_ID — Foreign-key reference into IGF_AP_CSS_INTERFACE_ALL, the only documented foreign-key relationship.
• STATE_AGENCY_ID — Identifier for the state agency associated with the aid configuration.
• CAMPUS_ID, CRS_ID — Campus and course/school identifiers for downstream processing.
• LOW_DEFAULT, QA_SCHOOL, EXPERIMENTAL, GRADE_CALC_OPT — Configuration flags controlling default and calculation behavior.
• FSEOG_MATCH_MTHD, FSEOG_FED_PCT, FSEOG_WAIVER — Parameters governing Federal Supplemental Educational Opportunity Grant matching.
• DEST_NUM — Destination number used in outbound reporting.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage centers on resolving setup configurations for a given financial aid office and operating unit, and on reporting the federal and state identifiers required for aid processing. Because the object is flagged Obsolete, queries are most often historical or diagnostic rather than transactional.

• Retrieving the complete setup for an office and org: SELECT * FROM igf.igf_ap_fa_setup_all WHERE fao_id = :fao_id AND org_id = :org_id;
• Joining to the CSS interface to validate the relationship: SELECT a.fas_id, a.fao_name, c.css_id FROM igf.igf_ap_fa_setup_all a JOIN igf.igf_ap_css_interface_all c ON a.css_id = c.css_id;
• Reporting federal identifiers (DUNS, OPE, Pell) for compliance extracts.
• Auditing FSEOG matching configuration across campuses and org units.
• Data migration or decommissioning analysis, since the object is obsolete.

Related Objects

• IGF_AP_CSS_INTERFACE_ALL — The sole documented foreign-key target; joined on CSS_ID.
• IGF_AP_FA_SETUP_ALL_PK — Primary-key constraint on FAS_ID.
• IGF_AP_FA_SETUP_ALL_UK — Business-key constraint spanning FAO_ID and ORG_ID.
• IGF_AP_FA_SETUP_ALL_U1 / U2 — Unique indexes underpinning the above keys.
• FAO-based setup tables in the IGF schema — likely referenced via FAO_ID for financial aid office configuration.
• ORG_ID-dependent multi-org views — Reporting objects filtered by operating unit.