Results for “minimum_credit_points”

44 results




Overview
Explore in AI Chat

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

Overview

The view IGSFV_STUDENT_SPNSR_RELATIONS belongs to the IGS – Student System product family within Oracle E-Business Suite. As the description states, it holds sponsor–student relation details, presenting a denormalized, read-only projection of data that describes the financial relationship between a sponsor (funding party) and a student. In the ETRM documentation the object is flagged as Obsolete and noted as "Not implemented in this database," meaning the view is retained for reference and backward compatibility but is not created in a standard, newly provisioned 12.1.1 or 12.2.2 environment.

Its role in reporting and integration is to consolidate sponsor funding attributes (award amounts, minimum credit and attendance thresholds), student party identity, load calendar context, award-year calendar context, and fund master details into a single row per sponsor–student relation. This makes it convenient for downstream reporting and for extracting award-year-keyed data, which is directly relevant to the user's search term award_year_calendar_type — that column is exposed here as AWARD_YEAR_CALENDAR_TYPE. Because the view is defined WITH READ ONLY, it is a query-only construct that cannot be used for DML.

Underlying Base Objects

The view text joins six base tables. These are the documented underlying objects:

  • IGF_SP_STDNT_REL_ALL — sponsor–student relation records; supplies load calendar type/sequence, total sponsor amount, minimum credit points, minimum attendance type, sponsor student identifier, fund and base identifiers, and person identifier.
  • HZ_PARTIES — the student's party record; supplies party number and party name.
  • IGS_CA_INST_ALL (aliased CI1) — the load calendar instance; supplies load calendar start/end dates, description, and alternate code.
  • IGF_AP_FA_BASE_REC_ALL — the award/fund base record; supplies the award-year calendar type and sequence (CI_CAL_TYPE, CI_SEQUENCE_NUMBER).
  • IGS_CA_INST_ALL (aliased CI2) — the award-year calendar instance; supplies award-year start/end dates, description, and alternate code.
  • IGF_AW_FUND_MAST_ALL — the fund master; supplies fund code and description.

The joins link person to party, fund to fund master, base to base record, load calendar type/sequence to instance CI1, and award-year calendar type/sequence to instance CI2. All joins are inner joins, so a row appears only where every referenced parent record exists.

Key Columns

The columns divide into four logical groups:

Common Use Cases and Queries

The view supports sponsor-funding reporting, student financial-aid reconciliation, and integration extracts keyed by award year. A typical query filters by award-year calendar type:

  • Listing sponsors and amounts for a given award year:
    SELECT person_number, person_name, fund_code, total_sponsor_amount, award_year_calendar_type FROM igsfv_student_spnsr_relations WHERE award_year_calendar_type = :p_cal_type;
  • Reconciling minimum thresholds per student:
    SELECT person_number, minimum_credit_points, minimum_attendance_type FROM igsfv_student_spnsr_relations WHERE fund_code = :p_fund;
  • Extracting award-year effective dates for a student:
    SELECT award_year_calendar_type, award_yr_cal_sequence_number, award_yr_start_effective_date, award_yr_end_effective_date FROM igsfv_student_spnsr_relations WHERE person_number = :p_party_number;

Because the object is documented as not implemented and obsolete in 12.1.1/12.2.2, these queries should be validated against the target instance; where the view is absent, equivalent results are obtained by joining the six base tables directly.