Search Results coald_id

Overview

The table IGF_AW_COA_LD_ALL is a core data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). Its primary function is to store the default load percentage distribution for a given Cost of Attendance (COA). This configuration is essential for accurately calculating and distributing financial aid awards across different academic terms or load periods within an award year. The table supports the multi-org architecture of EBS through its ORG_ID column, allowing data segregation by operating unit. It plays a critical role in ensuring that aid packaging aligns with institutional policies regarding how a student's total cost of attendance is proportioned based on their enrollment load in specific calendar periods.

Key Information Stored

The table stores the relationship between a Cost of Attendance group, its associated academic calendars, and the designated load calendars for splitting the cost. Key columns include the surrogate primary key COALD_ID and the unique constraint columns that define the business rule: COA_CODE, CI_CAL_TYPE, and CI_SEQUENCE_NUMBER (identifying the COA group and its base calendar instance), along with LD_CAL_TYPE and LD_SEQUENCE_NUMBER (identifying the specific load calendar for the split). The ORG_ID is integral for multi-org partitioning. While the metadata explicitly names these structural columns, the table presumably contains at least one percentage column to store the actual load split value, which is implied by the table's description.

Common Use Cases and Queries

This table is primarily accessed during the financial aid packaging process to determine how to allocate a student's total COA across terms. A common operational query would retrieve the load percentage for a specific COA and load calendar to perform calculations in batch or online processes. For reporting and validation, administrators might query the table to audit or maintain default load rules. A typical SQL pattern involves joining to the related calendar and COA group tables:

• Retrieving Load Rules for a COA: SELECT coa_code, ld_cal_type, ld_sequence_number, load_percentage FROM igf_aw_coa_ld_all WHERE coa_code = 'UNDERGRAD' AND ci_cal_type = 'ACADEMIC' AND org_id = :p_org_id;
• Validation during Packaging: The system uses this data internally to split a packaged award's COA component according to the student's enrollment load in the defined periods.

Related Objects

IGF_AW_COA_LD_ALL maintains defined foreign key relationships with other EBS foundation tables, as documented in the metadata:

• IGS_CA_INST_ALL (Calendar Instance): The columns LD_CAL_TYPE and LD_SEQUENCE_NUMBER reference this table to validate and describe the specific load calendar period used for the percentage split.
• IGF_AW_COA_GROUP_ALL (Cost of Attendance Group): The columns COA_CODE, CI_CAL_TYPE, and CI_SEQUENCE_NUMBER reference this table, linking the load rule to a specific Cost of Attendance definition and its associated base calendar instance.

These relationships ensure data integrity, linking load percentages to valid calendar structures and approved COA definitions within the institution's configuration.