Results for “igf_aw_coa_ld”

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

Overview

IGF_AW_COA_LD is a reporting view in the Oracle E-Business Suite (EBS) Financial Aid module (product code IGF), which Oracle has classified as obsolete. In EBS 12.1.1 and 12.2.2 installations, this object exists primarily to expose a multi-organization-secured read of the underlying Award Chart of Accounts to Line Distribution (COA/LD) assignment data. The view's name reflects its function: "COA_LD" denotes the mapping between a chart-of-accounts award record and its line distribution (LD) calendar and percentage allocations.

The view is not a base table. It is a layered query intended to be consumed by forms, concurrent programs, and reporting tools that need to retrieve award distribution rows filtered by the organization context of the connected user. Because it is documented as obsolete and is not implemented in the shipped database in many environments, consultants should treat it as a legacy artifact whose usefulness depends entirely on whether the underlying IGF_AW_COA_LD_ALL table has been created and populated in a given instance.

Underlying Base Objects

The view text reveals a single referenced base object: IGF_AW_COA_LD_ALL. The "_ALL" suffix confirms this is a multi-organization (MOAC) table holding rows for multiple operating units, distinguished by the ORG_ID column. The view selects the table's ROWID along with the full set of business columns and applies a WHERE clause that restricts output to the organization identifier resolved from the session's CLIENT_INFO value.

No other tables, synonyms, or views are referenced in the documented definition, and ETRM records no additional base objects. Consequently, the view is a thin projection and row-level security wrapper over IGF_AW_COA_LD_ALL rather than a join across multiple award or accounting tables.

Key Columns

• ROWID — the physical row identifier of the underlying IGF_AW_COA_LD_ALL record, useful for direct row addressing in update and validation logic.
• COALD_ID — the primary key of the COA/LD assignment row.
• COA_CODE — the chart-of-accounts code identifying the award's accounting structure.
• CI_CAL_TYPE / CI_SEQUENCE_NUMBER — the "CI" (commencement/instructional) calendar type and sequence used in the mapping.
• LD_CAL_TYPE / LD_SEQUENCE_NUMBER — the line distribution calendar type and sequence.
• LD_PERCT — the percentage of the line distribution allocated to the assignment.
• ORG_ID — the operating unit identifier driving MOAC filtering.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns for change tracking.

Common Use Cases and Queries

The view is typically queried when validating that award distribution percentages roll up correctly for a given operating unit, or when building extracts that must respect the MOAC security applied to the session. A representative query is:

SELECT coald_id, coa_code, ci_cal_type, ld_cal_type, ld_perct, org_id FROM igf_aw_coa_ld ORDER BY coa_code;

Because the WHERE clause depends on USERENV('CLIENT_INFO'), the result depends on the CLIENT_INFO value set by the calling application or by an initialization routine. A direct SQL*Plus session without that value initialized will return only rows matching the fallback organization identifier (-99) and may appear empty.

Practically, consultants should confirm the existence of IGF_AW_COA_LD_ALL before relying on this view, and should prefer base tables where the view is not implemented. Given the obsolete status of the Financial Aid product, this view is best treated as documentation of legacy design rather than a supported integration point.