Search Results crel_id

Overview

The table IGF_AW_CAL_REL_ALL is a data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically belonging to the IGF (Financial Aid) module, which is documented as obsolete. Its core function is to store and manage the relationships between two distinct award years. This relationship mapping is a foundational element for processes that require continuity or comparison across academic periods, such as multi-year award tracking, regulatory reporting, and the carry-forward of financial aid data. As a table suffixed with '_ALL', it is designed to operate in a multi-organization context, storing data partitioned by the ORG_ID column.

Key Information Stored

The table's structure is centered on defining a relationship between calendar instances. Its primary identifiers and key columns include:

• CREL_ID: The unique primary key identifier for each relationship record, as defined by the IGF_AW_CAL_REL_PK constraint.
• CR_CAL_TYPE and CR_SEQUENCE_NUMBER: Together, these columns form a unique key (IGF_AW_CAL_REL_ALL_UK) and constitute a foreign key reference to a specific calendar instance in the IGS_CA_INST_ALL table. They identify one award year within the relationship.
• Implied related columns: While not explicitly listed in the provided metadata, a logical design would include a parallel set of columns (e.g., RELATED_CAL_TYPE, RELATED_SEQUENCE_NUMBER) to store the identifier for the second, related award year. The table may also contain descriptive attributes and audit columns (CREATION_DATE, CREATED_BY, etc.).

Common Use Cases and Queries

This table supports operational and analytical functions within the Financial Aid lifecycle. A primary use case is validating and enforcing business rules that govern how aid packages can span or transition between consecutive award years. For reporting, it enables comparative analysis of aid distribution, fund utilization, or student eligibility across related periods. A typical query would join this table to the calendar master to retrieve descriptive information for related years.

SELECT rel.crel_id,
       cr_cal.cal_type AS cr_cal_type,
       cr_cal.sequence_number AS cr_seq_num,
       -- Assuming related columns exist
       rel_cal.cal_type AS related_cal_type,
       rel_cal.sequence_number AS related_seq_num
FROM   igf_aw_cal_rel_all rel,
       igs_ca_inst_all cr_cal,
       igs_ca_inst_all rel_cal
WHERE  rel.cr_cal_type = cr_cal.cal_type
AND    rel.cr_sequence_number = cr_cal.sequence_number
AND    rel.related_cal_type = rel_cal.cal_type  -- Hypothetical column
AND    rel.related_sequence_number = rel_cal.sequence_number -- Hypothetical column
AND    rel.org_id = 123;

Related Objects

The table's integrity is maintained through defined relationships with other core EBS objects. Based on the provided metadata:

• Primary Keys: The table has two primary key constraints: IGF_AW_CAL_REL_PK on CREL_ID and IGF_AW_CAL_REL_ALL_UK on the composite of (CR_CAL_TYPE, CR_SEQUENCE_NUMBER).
• Foreign Key (Outgoing): The table contains a foreign key that references the IGS_CA_INST_ALL (Calendar Instance) table. This links the CR_CAL_TYPE and CR_SEQUENCE_NUMBER columns to a valid calendar entry, ensuring referential integrity for one side of the award year relationship.