Search Results enrl_stat




Overview
Explore in AI Chat

Overview

IGF.IGF_GR_ALT_COA_ALL is a table in the IGF schema within Oracle E-Business Suite, part of the Grants / Awards (formerly Oracle Grants Accounting, or "IGF") product family. It stores rules that map a combination of enrollment status and award-year calendar context to a range of Chart of Accounts (COA) values, with each rule scoped to an operating unit. In practice it defines which COA segments should be applied when awarding or processing a grant for a student at a given enrollment status (for example, full-time, part-time, withdrawn) within a specific award-year calendar instance.

The ETRM metadata explicitly annotates this object with the note "No longer used," indicating it is a legacy or deprecated structure retained in the schema for backward compatibility but no longer actively maintained by current Grants functionality. Its physical storage remains in the APPS_TS_TX_DATA tablespace with its unique indexes in APPS_TS_TX_IDX.

From a heuristic Data Vault perspective, the table is classified as hub-leaning: its surrogate primary key and its role as the referenced parent of a foreign key from IGF_GR_ALT_EXP_ALL suggest it functions as a core reference entity around which dependent detail records are organized.

Key Information Stored

The table contains twelve documented columns. The most significant are:

  • ALTCOA_ID (NUMBER, 15) — Sequence-generated surrogate primary key, enforced by unique index IGF_GR_ALT_COA_ALL_U1 and the primary key constraint IGF_GR_ALT_COA_ALL_PK. This is the stable technical identifier used by child records.
  • ENRL_STAT (VARCHAR2, 30) — Enrollment Status. This is the column the user searched for; it is the primary business attribute describing student enrollment state and forms the leading column of the business-key index.
  • CI_CAL_TYPE (VARCHAR2, 10) — Calendar type code for the award year, interpreted within the operating unit.
  • CI_SEQUENCE_NUMBER (NUMBER) — Unique identifier for a specific award-year calendar instance.
  • COA_START (NUMBER, 12) — Start of the COA value range.
  • COA_END (NUMBER, 12) — End of the COA value range.
  • ORG_ID (NUMBER, 15) — Operating unit identifier, enforcing multi-org data isolation.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard "Who" audit columns.

The composite unique index IGF_GR_ALT_COA_ALL_U2 spans ENRL_STAT, CI_CAL_TYPE, CI_SEQUENCE_NUMBER, COA_START, COA_END, ORG_ID, making this combination the documented business-key candidate. The distinction matters: ALTCOA_ID is the technical join key, while the U2 column set is the semantic business identity of a COA-range rule.

Common Use Cases and Queries

Typical reporting scenarios involve resolving the COA range that applies to a particular combination of enrollment status, award-year calendar, and operating unit, then joining those results to dependent award details. A representative query filtering on the searched attribute:

  • SELECT ALTCOA_ID, ENRL_STAT, CI_CAL_TYPE, CI_SEQUENCE_NUMBER, COA_START, COA_END, ORG_ID FROM IGF.IGF_GR_ALT_COA_ALL WHERE ENRL_STAT = :p_enrl_stat AND ORG_ID = :p_org_id;
  • Range validation: verify that a known COA value falls between COA_START and COA_END for the relevant enrollment status and calendar instance.
  • Data-quality and migration audits: enumerate distinct ENRL_STAT values and confirm no overlapping COA ranges exist within the same ORG_ID, CI_CAL_TYPE, and CI_SEQUENCE_NUMBER combination.
  • Impact analysis: join to IGF_GR_ALT_EXP_ALL through ALTCOA_ID to identify which awards or expenditures reference a given COA rule. Because the table is marked "No longer used," such queries are typically diagnostic or archival rather than part of active transaction processing.

Related Objects

The documented dependency data identifies one direct dependent: IGF_GR_ALT_EXP_ALL.ALTCOA_ID references IGF.IGF_GR_ALT_COA_ALL.ALTCOA_ID, establishing a parent-child relationship in which the COA-range definition supplies the key used by grant/award expenditure records. Beyond this documented foreign key, related objects within the Grants schema typically include the calendar and enrollment-status reference structures that supply CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and ENRL_STAT values, and the standard FND and multi-org ORG_ID views (such as ORG_ORGANIZATION_DEFINITIONS) used to resolve operating unit context. The APPS synonym IGF_GR_ALT_COA_ALL provides the customary access path for application code and queries.