Results for “efc_start”

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

Overview

IGF_GR_PELL_RNG_AMT_V is a reporting view owned by the APPS schema within the IGF — Financial Aid product family of Oracle E-Business Suite. In both 12.1.1 and 12.2.2, the object carries a VALID status and is implemented as a standard relational view rather than a materialized view or synonym. Its documented purpose is to expose the cost of attendance ranges used for Pell grant processing against corresponding Expected Family Contribution (EFC) amounts.

Pell award determination depends on several interdependent inputs: the student's EFC, the institutionally defined cost of attendance (COA), and the enrollment status. The view consolidates a range-amount configuration table with its associated academic calendar instance so that each Pell range record is presented alongside the calendar's descriptive attributes, such as its alternate code and its start and end dates. This makes the view suitable as a read-only source for reporting, extracts, and downstream award-calculation logic that must associate a Pell range with a specific academic period. It is not intended for direct transactional maintenance; the underlying configuration table should be maintained through the Financial Aid setup forms.

Underlying Base Objects

The view text documents a two-table join. The driving table is IGF_GR_PELL_RNG_AMT, aliased CRNGD, which stores the Pell range and amount configuration. It is joined to IGS_CA_INST, aliased CI, the calendar instance table, on the compound key of calendar type and sequence number:

• CI.CAL_TYPE = CRNGD.CI_CAL_TYPE
• CI.SEQUENCE_NUMBER = CRNGD.CI_SEQUENCE_NUMBER

IGS_CA_INST supplies the calendar alternate code, start date, and end date, while IGF_GR_PELL_RNG_AMT supplies the enrollment status, COA and EFC range boundaries, the amount, and the standard audit columns. Because the join is an inner join, only Pell range rows whose calendar type and sequence number resolve to a valid calendar instance are returned. The ETRM metadata for 12.2.2 lists no additional referenced base objects beyond these two, and the view is read-only, inheriting no insert, update, or delete capability of its own.

Key Columns

• ROW_ID — the ROWID of the underlying IGF_GR_PELL_RNG_AMT row, providing a unique identifier for the configuration record.
• CI_ALTERNATE_CODE — the user-facing alternate code of the calendar instance, typically the academic year or term label.
• ENROLLMENT_STAT — the enrollment status to which the Pell range applies, such as full-time or part-time.
• CI_CAL_TYPE, CI_SEQUENCE_NUMBER — the calendar type and sequence number forming the join key and identifying the academic period.
• CI_START_DT, CI_END_DT — the start and end dates of the associated calendar instance.
• COA_START, COA_END — the lower and upper bounds of the cost-of-attendance range. This is the column most often referenced when searching on "coa_start".
• EFC_START, EFC_END — the lower and upper bounds of the Expected Family Contribution range.
• AMOUNT — the Pell award amount associated with the intersecting COA, EFC, and enrollment status combination.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns propagated from the base configuration table.

Common Use Cases and Queries

The view is typically queried to inspect or extract the Pell award matrix for a given academic period, to validate that range configurations do not overlap, or to feed downstream award estimation logic. A common access pattern restricts by calendar and returns the ranges in ascending order of COA and EFC boundaries.

SELECT ci_alternate_code, enrollment_stat, coa_start, coa_end, efc_start, efc_end, amount
FROM igf_gr_pell_rng_amt_v
WHERE ci_alternate_code = :p_calendar
ORDER BY coa_start, efc_start;

To locate the amount applicable to a specific COA and EFC combination, the query filters on the range boundaries:

SELECT enrollment_stat, amount
FROM igf_gr_pell_rng_amt_v
WHERE coa_start <= :p_coa AND coa_end >= :p_coa
AND efc_start <= :p_efc AND efc_end >= :p_efc
AND enrollment_stat = :p_enrollment_stat;

A third frequent use is a coverage check across all configured calendars, ordering by calendar start date to confirm which periods have Pell ranges defined. When referencing ROW_ID, note that it is a ROWID of the base configuration row and should be treated as an internal identifier rather than a stable business key.