Search Results salary_based




Overview
Explore in AI Chat

Overview

IGFBV_STUDENT_AUTHORIZATIONS is a base database view within the IGF (Financial Aid) product family of Oracle E-Business Suite. The ETRM metadata classifies the owning module as IGF - Financial Aid (Obsolete), indicating that the functionality has been retired from the supported product line yet remains documented for historical, upgrade, and migration reference. The view is described as the "Base view for the entity that holds Student Work Authorizations." In practice, it presents a read-only projection of student employment authorization records, combining personal, demographic, visa, wage, and award-funding attributes into a single queryable structure suited to reporting and integration rather than transactional data entry.

The view is defined with a WITH READ ONLY clause, so it cannot be used as a DML target; it exists purely for retrieval. Because it collapses student identity, immigration status, hourly-rate thresholds, and funding references into one row per authorization, it is well suited to concurrent-program extracts, custom reports, and interfaces that downstream systems use to pull work-study or student payroll data.

Underlying Base Objects

Per the documented view text, IGFBV_STUDENT_AUTHORIZATIONS is defined over a single base table, IGF_SE_AUTH, aliased as SEAUT. The ETRM metadata records "Referenced base objects: none documented," but the view SQL explicitly establishes the dependency on IGF_SE_AUTH. All 39 projected columns map directly to columns on that table, and no joins, unions, or aggregations are present, making this a straightforward single-table view.

The ETRM entry also notes "Not implemented in this database," meaning the object may be absent in a given instance, particularly where the Financial Aid module was never installed or was removed during an upgrade. The view is documented against ETRM 12.2.2; because it is an IGF object, availability on 12.1.1 versus 12.2.2 depends on whether the obsolete Financial Aid schemas were carried forward in the instance.

Key Columns

The view exposes a broad set of attributes. Notable groups include:

Common Use Cases and Queries

Typical reporting retrieves salary-based authorizations or reconciles awards against funding. For example, listing active salary-based records:

SELECT AUTHORIZATION_ID, PERSON_ID, LAST_NAME, SALARY_BASED, GOVT_SHARE_PERCT
FROM IGFBV_STUDENT_AUTHORIZATIONS
WHERE SALARY_BASED = 'Y' AND ACTIVE_FLAG = 'Y';

Analysts also join on PERSON_ID, FUND_ID, or AW_CALANDAR_TYPE to enrich extracts, and use MIN_HR_RATE / MAX_HR_RATE to validate payroll against authorized thresholds. Because the view is read-only, all such usage is confined to query and extract operations.