Search Results sys_awd_yr

Overview

IGF.IGF_AW_FISAP_RANGES is a pre-seeded reference table within the Oracle E-Business Suite (EBS) IGF schema, which supports the Student Aid and Financial Aid processing modules (formerly part of Oracle Financial Aid / Student Systems). The table stores the FISAP (Fiscal Operations Report and Application to Participate) income ranges, which are used by the U.S. Department of Education's Title IV federal student aid programs to determine need-based eligibility and award calculations. Administrators and financial aid officers rely on these ranges to classify dependent and independent applicants into income brackets, which then feed into need analysis and packaging routines within the Oracle Student System (OSS) or its EBS-integrated components.

Because the object is seeded with delivered rows keyed by award year and part/section, it functions as a slowly changing reference dimension. In a Data Vault modeling perspective, this table is best classified as a satellite attached to a business-key hub defined by the combination of SYS_AWD_YR, PART_SECTION, DEPENDENCY_STATUS, START_RANGE_AMT, and END_RANGE_AMT. The table is standalone — it does not reference any other database object via foreign keys, though it is referenced by the APPS synonym IGF_AW_FISAP_RANGES.

Key Information Stored

The table contains 11 documented columns. The most significant are:

• SEQUENCE_TXT — the surrogate primary key (IGF_AW_FISAP_RANGES_PK), a VARCHAR2(15) unique identifier for each row.
• SYS_AWD_YR — the system award year (VARCHAR2(30)); the leading component of the unique business key, used to scope ranges to a specific processing year.
• PART_SECTION — Part number and section of the FISAP form to which the range belongs.
• DEPENDENCY_STATUS — a single-character flag: 'D' for dependent and 'I' for independent applicants.
• START_RANGE_AMT and END_RANGE_AMT — the numeric bounds of the FISAP income bracket.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard "Who" audit columns, essential for change tracking and troubleshooting seeded data.

The unique index IGF_AW_FISAP_RANGES_U1 spans the five business-key columns and enforces that no two rows define overlapping ranges for the same award year, part/section, and dependency status.

Common Use Cases and Queries

Typical usage includes looking up the correct income range for a given award year and dependency status during need analysis, and validating that ranges have been seeded for a new award year before running packaging.

A representative query to retrieve dependent ranges for a specific year:

• SELECT SEQUENCE_TXT, PART_SECTION, START_RANGE_AMT, END_RANGE_AMT FROM IGF.IGF_AW_FISAP_RANGES WHERE SYS_AWD_YR = :p_year AND DEPENDENCY_STATUS = 'D' ORDER BY START_RANGE_AMT;

Reporting scenarios include generating a matrix of income brackets per award year, auditing gaps or overlaps between START_RANGE_AMT and END_RANGE_AMT, and exporting the seeded ranges to compare against Department of Education published FISAP guidance. Because the object is pre-seeded and read-mostly, most activity is SELECT-based; DML is generally restricted to controlled updates by the IGF application schema or via concurrent programs that refresh tables by award year.

Related Objects

Per the ETRM metadata, IGF_AW_FISAP_RANGES does not reference any database object, so there are no outbound foreign keys. The dependency relationship is inbound: the APPS synonym IGF_AW_FISAP_RANGES resolves to this table and is the object most commonly queried by application logic and reports. In practice, the table is consumed alongside other IGF award-year driven reference objects (such as FISAP configuration and need-analysis parameter tables) that share SYS_AWD_YR as a join key. Joins to award or applicant data typically match on SYS_AWD_YR and DEPENDENCY_STATUS, with the applicant's income amount falling between START_RANGE_AMT and END_RANGE_AMT. The unique index IGF_AW_FISAP_RANGES_U1 acts as the enforced business key that any downstream ETL or Data Vault load process should honor when mapping this table into a satellite structure.