Search Results award_prd_cd




Overview
Explore in AI Chat

Overview

The IGF_AW_AWARD_PRD table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Grants and Funds (IGF) module. It serves as the master repository for defining awarding periods within the context of an award year. An awarding period is a critical time-based construct used to manage the distribution of financial aid, grants, or other funds to students. The table's primary role is to establish and maintain the distinct periods (e.g., Fall, Spring, Summer) during which awards can be processed for a given academic calendar instance, enabling structured and controlled award management throughout the year.

Key Information Stored

The table's structure combines key identifiers, descriptive data, and control flags. The primary key is a composite of three columns: CI_CAL_TYPE (the calendar type), CI_SEQUENCE_NUMBER (the calendar sequence), and AWARD_PRD_CD (the unique period code). This enforces uniqueness per award year. The AWARD_PRD_DESC column, central to the user's search, stores the descriptive name of the period. Key operational flags include DEFAULT_FLAG, which identifies the default period for its award year; INCLUDE_IN_SS_FLAG, controlling visibility in Student Self-Service; and BBAY_FLAG, indicating a "Budget/Beginning Award Year" period. Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, etc.) and an OBJECT_VERSION_NUMBER for data versioning are also present.

Common Use Cases and Queries

This table is fundamental for setup, reporting, and integration. Administrators use it to define the awarding calendar during implementation. Common reporting needs include listing all active periods for a specific award year or identifying the default period. A frequent query pattern involves joining to calendar tables using CI_CAL_TYPE and CI_SEQUENCE_NUMBER. For instance, to retrieve all periods for a specific award year description, one might use:

  • SELECT aprd.award_prd_cd, aprd.award_prd_desc, aprd.default_flag FROM igf.igf_aw_award_prd aprd JOIN igs_ca_inst ci ON aprd.ci_cal_type = ci.cal_type AND aprd.ci_sequence_number = ci.sequence_number WHERE ci.description = '2024-2025 Academic Year';

Another common query retrieves all periods configured for display in Student Self-Service: SELECT award_prd_cd, award_prd_desc FROM igf.igf_aw_award_prd WHERE include_in_ss_flag = 'Y';

Related Objects

Based on the provided dependency information, the IGF_AW_AWARD_PRD table is referenced by other objects within the APPS schema, though specific foreign key relationships are not detailed in the excerpt. Its primary key (CI_CAL_TYPE, CI_SEQUENCE_NUMBER, AWARD_PRD_CD) is almost certainly referenced by child tables in the awards processing workflow, such as those storing individual award transactions or disbursements. These child tables would use this composite key to associate each award record with its specific awarding period. The table's definition is intrinsically linked to the award year calendar instance, implying a relationship with the IGS_CA_INST (Calendar Instance) table or similar, joined on CI_CAL_TYPE and CI_SEQUENCE_NUMBER.