Results for “coa_code”

50+ results




Overview
Explore in AI Chat

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

Overview

IGF_AW_COA_LD_ALL is a table within the Oracle E-Business Suite Financial Aid module (IGF), which is designated as obsolete in Oracle EBS 12.1.1 and 12.2.2. The table stores the default load percentage split for a given Cost of Attendance (COA). In practical terms, it defines how an award or disbursement amount tied to a Cost of Attendance record is divided across load calendar instances, expressed as a percentage (LD_PERCT). The IGF product line historically supported the administration of student financial aid processing; tables such as this one supported the older Oracle Student System (OSS) integration rather than the current Oracle Student Financial Planning offering, which explains its obsolete status and the "Not implemented in this database" note in the ETRM metadata.

From a Data Vault modeling perspective, the mined FK structure suggests classifying this object as a link. The table connects a Cost of Attendance group definition (IGF_AW_COA_GROUP_ALL) to load calendar instances (IGS_CA_INST_ALL), with the percentage value acting as a link attribute rather than a standalone hub. This classification should be treated as a heuristic suggestion derived from foreign key topology, not as a formally documented Data Vault design.

Key Information Stored

The table comprises 13 documented columns. The most significant are:

The business-key candidate is defined by the composite unique index IGF_AW_COA_LD_ALL_U2 covering COA_CODE, CI_CAL_TYPE, CI_SEQUENCE_NUMBER, LD_CAL_TYPE, LD_SEQUENCE_NUMBER, and ORG_ID. This uniqueness guarantees that each Cost of Attendance/load-calendar combination exists only once per operating unit.

Common Use Cases and Queries

Because this table is obsolete and typically not implemented in current databases, use cases are primarily historical or migration-oriented. Typical reporting patterns include reconciling percentages across a Cost of Attendance group to verify they total 100%, and joining to IGS_CA_INST_ALL to enrich the load calendar context.

  • Verifying percentage integrity: SELECT COA_CODE, SUM(LD_PERCT) FROM IGF_AW_COA_LD_ALL WHERE ORG_ID = :org GROUP BY COA_CODE HAVING SUM(LD_PERCT) <> 100;
  • Retrieving the split for a specific COA and load calendar by joining LD_CAL_TYPE/LD_SEQUENCE_NUMBER to IGS_CA_INST_ALL.
  • Extracting historical load distributions for data migration into Oracle Student Financial Planning or a target data warehouse, filtering on ORG_ID and CREATION_DATE.
  • Auditing configuration changes using the WHO columns, comparing LAST_UPDATE_DATE to prior snapshots.

Related Objects

  • IGF_AW_COA_GROUP_ALL — Parent Cost of Attendance group; joined via COA_CODE, CI_CAL_TYPE, and CI_SEQUENCE_NUMBER.
  • IGS_CA_INST_ALL — Academic calendar instance table; joined via LD_CAL_TYPE and LD_SEQUENCE_NUMBER.
  • IGF_AW_COA_LD_ALL_PK and unique indexes IGF_AW_COA_LD_ALL_U1/U2 — Constrain the surrogate and business keys respectively.
  • Other IGF_AW_COA_* tables — Sibling Cost of Attendance configuration objects that share the same group and calendar reference patterns.
  • IGS_CA_* calendar hierarchy tables — Broader context for calendar instance resolution supporting both the COA and load calendar references.