Results for “person_number”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGF_AW_STUD_AWD_TOTAL_V is an Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 database view owned by the APPS schema and delivered as part of the IGF — Financial Aid product family. As its name indicates, the view presents a single aggregated row per student that consolidates financial aid award activity across all award years. Rather than exposing individual award records, it applies SUM aggregation over the underlying award table so that offered, accepted, and paid amounts are rolled up to a student-level total. Because it is a view and not a table, it carries no data of its own; it is a reporting and integration convenience object that shields callers from the multi-table join logic required to resolve a student's party identity, financial aid base record, and award transactions. In ETRM metadata the object is documented as VALID and is described succinctly as "This view sums up awards for a given student for all Award Years."

Underlying Base Objects

The view is defined over three APPS base tables, joined in a single SELECT with a GROUP BY clause:

The join path is AWD.BASE_ID = FA.BASE_ID and FA.PERSON_ID = PE.PARTY_ID. Only award rows whose AWARD_STATUS is one of ACCEPTED, OFFERED, or REVISED are included; all other statuses are silently excluded. The ETRM object metadata does not document explicit foreign-key or base-object registrations, so the relationships above are derived from the delivered view text.

Key Columns

The view exposes four columns. The first aliases the TCA party number as PERSON_NUMBER, which is directly relevant to the user's person_number lookup — this column is the student identifier used for grouping and would typically be joined to other person-based views or tables.

  • PERSON_NUMBER — the HZ_PARTIES party number for the student; the sole grouping key.
  • TOT_OFFRD_AMT — sum of NVL(OFFERED_AMT, 0) across qualifying awards for all award years.
  • TOT_ACCPT_AMT — sum of NVL(ACCEPTED_AMT, 0) across qualifying awards for all award years.
  • TOT_PAID_AMT — sum of NVL(PAID_AMT, 0) across qualifying awards for all award years.

The NVL wrapping ensures that null award amounts contribute zero rather than nullifying the aggregate, which keeps the three totals numeric for any student having at least one qualifying award row.

Common Use Cases and Queries

Typical uses include student-level financial aid dashboards, award summary reporting, reconciliation of offered versus accepted versus paid totals, and integration extracts where a downstream system requires a single lifetime award figure per party number. Because the view is already aggregated, it is not suitable for award-year-specific or award-level detail; use IGF_AW_AWARD directly for that granularity.

Retrieve a specific student's consolidated totals:

  • SELECT person_number, tot_offrd_amt, tot_accpt_amt, tot_paid_amt FROM apps.igf_aw_stud_award_total_v WHERE person_number = :p_person_number;

Report students with an outstanding offered-versus-accepted gap:

  • SELECT person_number, tot_offrd_amt, tot_accpt_amt FROM apps.igf_aw_stud_award_total_v WHERE tot_offrd_amt > tot_accpt_amt ORDER BY tot_offrd_amt DESC;

Join the view back to TCA for student attributes such as name:

  • SELECT v.person_number, p.party_name, v.tot_paid_amt FROM apps.igf_aw_stud_award_total_v v, apps.hz_parties p WHERE p.party_number = v.person_number;

All queries should be qualified with the APPS schema and executed with the appropriate IGF Financial Aid responsibility or a read-only integration account.