Search Results igf_gr_payment_method

Overview

IGF_GR_PELL_SETUP_V is a database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGF (Financial Aid) product family. Its stated purpose within the ETRM repository is to show the federal Pell grant setup details configured for an institution. As a view rather than a base table, it does not store data of its own; it presents a denormalized, read-only projection of Pell Grant setup records joined with calendar and course version reference data, and it enriches coded values with descriptive lookups along the way.

In the Oracle EBS 12.1.1 and 12.2.2 environments the view is reported as VALID. It functions primarily as a reporting and inquiry construct: it gives financial aid administrators, report developers, and integration interfaces a single stable row per Pell Grant setup sequence, with human-readable descriptions substituted for internal codes. Because the view consolidates configuration attributes that would otherwise require several joins across the Student Systems schema (IGS) and the Financial Aid schema (IGF), it is convenient for both online inquiry and extract-style reporting.

Underlying Base Objects

The view definition references three physical objects:

• IGF_GR_PELL_SETUP PELL — the driving table holding the actual Pell Grant setup records, keyed by ROW_ID and PELL_SEQ_ID. It supplies the bulk of the columns, including payment method, funding method, enrollment calculation codes, and cross-reference identifiers.
• IGS_CA_INST CI — the calendar instance table, joined on CI_CAL_TYPE and CI_SEQUENCE_NUMBER to the setup record's calendar type and sequence. It contributes ALTERNATE_CODE, START_DT, and END_DT for the academic calendar instance.
• IGS_PS_VER PSV — the course version table, outer-joined on COURSE_CD and VERSION_NUMBER, supplying the program version TITLE.

All three are non-ETRM-documented base tables in this metadata record, but the view text clearly identifies them as the sources. The joins between PELL and CI are inner joins on calendar type and sequence, while the PSV join is an outer join, meaning the view still returns rows when no matching course version exists.

Key Columns

The view exposes identity columns such as ROW_ID, PELL_SEQ_ID, and REP_PELL_ID, which uniquely identify a Pell setup sequence. Calendar context comes from CI_CAL_TYPE, CI_SEQUENCE_NUMBER, CI_ALTERNATE_CODE, CI_START_DT, and CI_END_DT. Configuration attributes include PAYMENT_METHOD, FUNDING_METHOD, USE_CENSUS_DTS, WK_INST_TIME_CALC_PYMT, WK_INT_TIME_PRG_DEF_YR, LOW_TUTION_FEE, ALT_COA_LIMIT, EFC_MAX, and PELL_ALT_EXP_MAX.

Several columns present decoded descriptions rather than raw codes, generated via IGF_AW_GEN.LOOKUP_DESC: ACAD_CAL_DESC, PYMT_METHOD_DESC, ENR_BEFORE_TS_CODE_DESC, ENR_IN_MT_CODE_DESC, and ENR_AFTER_TC_CODE_DESC, plus descriptions for RESPONSE_OPTION_CODE and FUNDING_METHOD. The FIRST_YEAR, SECOND_YEAR, and THIRD_YEAR style enrollment timing columns (enrollment before term start, in mid-term, after term completion) are also exposed. Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN are carried through, along with the joined PSV.TITLE for the program version.

Common Use Cases and Queries

Typical uses include auditing Pell Grant configuration, verifying payment and funding method assignments, and feeding downstream disbursement or regulatory reporting processes. A simple inquiry lists all setup sequences with their decoded attributes:

• SELECT pell_seq_id, acad_cal_desc, pymt_method_desc, funding_method, start_dt, end_dt FROM igf_gr_pell_setup_v ORDER BY pell_seq_id;

Filtering by calendar instance supports period-specific reporting:

• SELECT pell_seq_id, title, payment_method, use_census_dts FROM igf_gr_pell_setup_v WHERE ci_cal_type = :cal_type AND ci_sequence_number = :seq;

Integration extracts commonly select the descriptive columns and audit fields together, using PELL_SEQ_ID as the stable business key, while reports comparing institution cross-reference codes rely on INST_CROSS_REF_CODE. Attempts to join PELL_SEQ_ID to the base setup table remain valid since the view preserves that key. Queries that filter on the outer-joined TITLE should account for NULL when no matching course version exists.