Search Results load_sequence_number




Overview
Explore in AI Chat

Overview

IGFBV_STUDENT_PAYROLL_DETAILS is a read-only database view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the IGF — Financial Aid product family and serves as the base view for the entity that holds Student Payroll Details. In practice, the view exposes the payroll disbursement records generated when financial aid funds are paid to students through payroll processing, typically under a Federal Work-Study or similar campus employment program. Because the view is defined WITH READ ONLY, it is intended purely for querying and reporting rather than for DML operations, which preserves the integrity of the underlying payroll transaction data.

Underlying Base Objects

The documented view text reveals that IGFBV_STUDENT_PAYROLL_DETAILS is defined over a single base table, IGF_SE_PAYMENT, aliased as SEPY. No other base objects are documented in the ETRM metadata. The view projects a subset of the columns from IGF_SE_PAYMENT and applies minimal transformation — most notably, the fourth column position is populated with a literal NULL rather than a stored value, and the record source is generated through a lookup expression referencing IGF_LOOKUPS_VIEW with the lookup type IGF_SE_SOURCE. Because it is a straight projection view with a read-only constraint, joins, filters, and functional predicates added by report authors are applied against IGF_SE_PAYMENT directly at runtime.

Key Columns

The column list maps closely to the IGF_SE_PAYMENT structure. Notable columns include:

Common Use Cases and Queries

The view is typically used in financial aid reporting, work-study disbursement reconciliation, and integration extracts that feed downstream payroll or general ledger systems. A representative query retrieves payroll details for a specific student:

SELECT person_id, payroll_date, paid_amount, organizational_unit_code, fund_id
FROM apps.igfbv_student_payroll_details
WHERE person_id = :p_person_id
ORDER BY payroll_date;

A reconciliation query aggregating disbursements by fund and organizational unit is equally common:

SELECT fund_id, organizational_unit_code, SUM(paid_amount) total_paid
FROM apps.igfbv_student_payroll_details
WHERE payroll_date BETWEEN :p_start AND :p_end
GROUP BY fund_id, organizational_unit_code;

Because HOURS_WORKED is returned as NULL, users who need hours data should not rely on this view alone; they must join to the underlying payroll or timesheet objects to obtain that information. This limitation is the single most important caveat when the view is selected for hours-worked reporting requirements.