Search Results cr_cal_type




Overview
Explore in AI Chat

Overview

The IGF_AW_CAL_REL_ALL table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Grants and Funds (IGF) module. Its primary function is to manage the chronological relationship between award years, which is critical for processes like financial aid packaging, fund disbursement scheduling, and year-over-year award analysis. The table operates on a multi-org principle, as indicated by the ORG_ID column, allowing it to store relationships specific to different operating units within a single installation. By defining how a current award year relates to a succeeding year, it enables automated workflows and ensures consistency in award administration across academic cycles.

Key Information Stored

The table stores the logical link between two calendar instances used for awarding. The key columns defining this relationship are CR_CAL_TYPE and CR_SEQUENCE_NUMBER, which together uniquely identify the current award year calendar. The SC_SEQUENCE_NUMBER holds the identifier for the succeeding year's calendar. The ACTIVE flag ('Y' or 'N') controls whether the relationship is currently in use. The mandatory CREL_ID serves as a unique surrogate key for each record. Standard EBS WHO columns (CREATED_BY, CREATION_DATE, etc.) provide audit trails. Notably, the user's search for "cr_sequence_number" points to this column's role as a critical component of the table's unique identifier and its function in pinpointing a specific calendar instance for the current award year.

Common Use Cases and Queries

A primary use case is validating and retrieving the active award year succession path for a given operating unit and calendar. This is essential for batch processes that roll over awards or create projections. A common reporting query would fetch all active relationships for operational review. For instance, to find the succeeding year for a specific current award calendar, one might use:

  • SELECT sc_sequence_number FROM igf.igf_aw_cal_rel_all WHERE cr_cal_type = '&CAL_TYPE' AND cr_sequence_number = &SEQ_NUM AND active = 'Y' AND org_id = &ORG_ID;

Another critical pattern involves joining this table to calendar master tables (like IGS_CA_INST_ALL) via the sequence numbers to get descriptive calendar details for reporting. System administrators may query the table to deactivate obsolete relationships or insert new ones for an upcoming award cycle, ensuring the system's temporal logic remains accurate.

Related Objects

Based on the provided relationship data, the table's integrity is enforced through its primary key constraint, IGF_AW_CAL_REL_ALL_UK, on the columns (CR_CAL_TYPE, CR_SEQUENCE_NUMBER). A documented foreign key relationship exists where the CR_CAL_TYPE column in IGF_AW_CAL_REL_ALL references the IGS_CA_INST_ALL table, which is the master table for calendar instances in the Student Systems. This relationship ensures that the calendar types used in award year sequencing are valid and defined within the system. The dependency information notes that the table is referenced by the APPS synonym IGF_AW_CAL_REL_ALL, which is the standard access point for application code. This table is foundational, and while the metadata shows it does not reference other objects, it is likely referenced by various IGF package bodies and forms that manage award year transitions.