Search Results efc_max

Overview

IGF_GR_PELL_SETUP is a reporting view within the Oracle E-Business Suite Financial Aid module (product code IGF), a component of the Student Systems family that supported the administration of Title IV federal student aid. The view exposes Pell Grant setup configuration at the institution level, presenting a denormalized projection of the underlying IGF_GR_PELL_SETUP_ALL table. In EBS 12.1.1 and 12.2.2, the view is documented as obsolete and is marked "Not implemented in this database" in the ETRM repository, meaning it should be treated as historical metadata rather than an active, queryable object in current installations.

The view's principal role was to support Pell Grant processing rules — funding method, payment method, academic calendar mapping, cost-of-attendance limits, and enrollment timing codes — and to make those rules available to concurrent programs, reports, and integration interfaces without requiring the calling code to resolve multi-org partitions manually. The view embeds a row-level security predicate based on ORG_ID, dynamically resolving the operating unit from the session's CLIENT_INFO context.

Underlying Base Objects

The view is defined over a single base table, IGF_GR_PELL_SETUP_ALL, joined to no other documented objects. The _ALL suffix indicates a multi-organization table, requiring the ORG_ID filter applied in the view's WHERE clause. The predicate uses NVL(ORG_ID, NVL(TO_NUMBER(...), -99)) on both sides, so that sessions without an operating unit context default to -99 and match seeded or global rows.

Several column positions in the select list — PELL_PROFILE, BRANCH_CAMPUS, and ATTEND_CAMPUS_ID — are projected as literal NULL placeholders, indicating these attributes were retired or never populated in the shipped implementation. Their presence reflects an interface-compatibility decision, preserving positional stability for any dependent code.

Key Columns

• PELL_SEQ_ID — Primary surrogate key for a Pell setup record.
• CI_CAL_TYPE / CI_SEQUENCE_NUMBER — Calendar type and sequence identifying the academic calendar to which the setup applies.
• REP_PELL_ID — Reference to the Pell reporting entity or identifier used in COD/Title IV reporting.
• FUNDING_METHOD / PAYMENT_METHOD — Codes governing how Pell funds are disbursed.
• USE_CENSUS_DTS — Indicates whether census dates drive enrollment intensity calculations.
• LOW_TUTION_FEE, ALT_COA_LIMIT, EFC_MAX, PELL_ALT_EXP_MAX — Cost, alternative cost-of-attendance, EFC, and expense ceilings.
• ACADEMIC_CAL, WK_INST_TIME_CALC_PYMT, WK_INT_TIME_PRG_DEF_YR, CR_CLK_HRS_PRDS_SCH_YR, CR_CLK_HRS_ACAD_YR — Academic calendar and clock/credit-hour conversion parameters used for payment-period calculations.
• PAYMENT_PERIODS_NUM — Number of payment periods within the year.
• ENR_BEFORE_TS_CODE, ENR_IN_MT_CODE, ENR_AFTER_TC_CODE — Enrollment status codes before the term start, during the mid-term period, and after the term change.
• TERM_START_OFFSET_NUM — Numeric offset applied to determine the term start boundary for enrollment reporting; the column cited in the originating search.
• RESPONSE_OPTION_CODE, REP_ENTITY_ID_TXT — Reporting response option and reporting entity text.
• ORG_ID — Operating unit identifier driving row-level security.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

Because the view is documented as obsolete and not implemented, the primary use cases are diagnostic: identifying historical reporting logic and determining what the corresponding base table returns in legacy environments.

Retrieve all Pell setup rows for the session's operating unit:

SELECT pell_seq_id,
       ci_cal_type,
       ci_sequence_number,
       funding_method,
       payment_method,
       term_start_offset_num
  FROM igf_gr_pell_setup;

Inspect term-start offset behavior across setups:

SELECT pell_seq_id,
       academic_cal,
       payment_periods_num,
       term_start_offset_num,
       enr_before_ts_code,
       enr_in_mt_code,
       enr_after_tc_code
  FROM igf_gr_pell_setup
 WHERE term_start_offset_num IS NOT NULL;

Where the view is unavailable, query the base table directly and replicate the multi-org predicate, or filter explicitly by ORG_ID. All queries against this object should be treated as migration or reconciliation exercises, since the Financial Aid (IGF) product line is obsolete in current EBS releases.