Search Results igf_gr_rfms_enrol_stat




Overview
Explore in AI Chat

Overview

IGF_GR_ALT_COA_V is a reporting view in the Oracle E-Business Suite database, owned by the APPS schema and defined over objects in the Oracle Student System (formerly Oracle iLearning / Student Information) family. Its name reflects the "IGF" (Financial Aid / Grants) module prefix combined with "GR" (grantor) and "ALT_COA" (alternate chart of accounts). The view exposes alternate chart-of-accounts assignments together with the calendar instance metadata for each assignment and a decoded enrollment status description. It is used primarily for reporting on the financial aid grantor responsibility, allowing operational and federal reporting extracts to display readable enrollment statuses and the trading calendar period during which a given alternate chart-of-accounts mapping was effective.

Because the view resolves lookup codes into descriptive text through IGF_AW_GEN.LOOKUP_DESC, it eliminates the need for downstream reporting tools to re-join to the lookup tables, making it suitable for ADI, Oracle XML Publisher, and BI Publisher data templates used in the Grants/Financial Aid domain.

Underlying Base Objects

The view is defined by a join between two base tables:

  • IGF_GR_ALT_COA (aliased as ALTCOA) — the primary alternate chart-of-accounts table, holding the row identifier, enrollment status code, calendar type and sequence number, chart-of-accounts start and end dates, and standard WHO audit columns.
  • IGS_CA_INST (aliased as CI) — the calendar instance table from the Student System / calendar data model, supplying the calendar alias, alternate code, and the calendar instance start and end dates.

The join condition is ALTCOA.CI_CAL_TYPE = CI.CAL_TYPE AND ALTCOA.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER, meaning each ALS row is paired with the exact calendar instance it references. The documented metadata lists no separately documented base objects, but the view text confirms these two physical tables.

Key Columns

  • ROW_ID — surrogate row identifier for the alternate chart-of-accounts record; used as a unique key in reporting queries.
  • ALTCOA_ID — identifier of the alternate chart-of-accounts assignment record.
  • ENRL_STAT — the raw enrollment status lookup code stored on the base row (for example, an RFMS enrollment status).
  • LOOKUP_DESC('IGF_GR_RFMS_ENROL_STAT', ALTCOA.ENRL_STAT) — the decoded, human-readable description of the enrollment status. This is the column returned when a user searches for the lookup type igf_gr_rfms_enrol_stat.
  • CI_CAL_TYPE, CI_SEQUENCE_NUMBER — the calendar type and sequence number of the linked calendar instance.
  • ALTERNATE_CODE, START_DT, END_DT — the calendar instance's alternate code and its effective start and end dates.
  • COA_START, COA_END — the effective start and end dates of the chart-of-accounts assignment itself.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — standard Oracle Applications audit trail columns.

Common Use Cases and Queries

This view is typically queried to report grantor alternate chart-of-accounts assignments with readable enrollment statuses and the associated calendar instance period. A common query lists active rows by enrollment status:

SELECT ALTCOA_ID, ROW_ID, ENRL_STAT, LOOKUP_DESC FROM APPS.IGF_GR_ALT_COA_V WHERE ENRL_STAT = 'ACTIVE';

Reporting extracts often join the view to other IGF/IGS tables on ALTCOA_ID or on the calendar instance pair, or restrict results to a specific calendar period using CI_CAL_TYPE, START_DT, and END_DT. Because the view is owned by APPS and depends on the IGF_AW_GEN lookup function, queries must be executed under a responsibility with access to the APPS schema and the appropriate lookup type IGF_GR_RFMS_ENROL_STAT. Users searching for "igf_gr_rfms_enrol_stat" should reference the decoded LOOKUP_DESC column in this view, since that column is the sole place within this view where the lookup type is applied.