Search Results awd_cert_txt

Overview

The IGF.IGF_AW_AWARD_CERTS table is a core setup and reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Internet Financial Aid (IGF) module. It serves as the master repository for award certification texts, which are formal statements or disclosures presented to students during the financial aid awarding process. These certifications are critical for regulatory compliance and student communication, often outlining terms, conditions, and responsibilities associated with receiving financial aid. The table's primary role is to store the configurable text blocks that can be associated with specific award years, awarding periods, and certification types, enabling administrators to manage the precise language presented to students via self-service or official correspondence.

Key Information Stored

The table's structure is defined by a composite primary key and descriptive columns that control the certification's application and behavior. The key uniquely identifies a certification record through the combination of CI_CAL_TYPE (Award Year Calendar Type), CI_SEQUENCE_NUMBER (Award Year Calendar Instance), AWARD_PRD_CD (Awarding Period Code), and AWD_CERT_CODE (Award Certification Code). The substantive content is held in the AWD_CERT_TXT (VARCHAR2(4000)) column, which contains the full certification text. Supporting columns include AWD_CERT_DESC for a descriptive name, ACTIVE_FLAG to control visibility to students, and UPDATE_FUNDS_AUTH_FLAG, a critical functional flag indicating whether accepting this certification updates the student's funds authorization status. Standard WHO columns and an OBJECT_VERSION_NUMBER for data integrity are also present.

Common Use Cases and Queries

A primary use case is the retrieval of active certification texts for display within the student self-service portal during the award acceptance workflow. Administrators also query this table for setup, audit, and reporting purposes to ensure correct certifications are in place for each award cycle. Common SQL patterns include fetching all certifications for a specific award year and period, or identifying certifications that impact funds authorization.

• Retrieve Active Certifications for a Period:
  SELECT AWD_CERT_CODE, AWD_CERT_DESC, AWD_CERT_TXT FROM IGF.IGF_AW_AWARD_CERTS WHERE CI_CAL_TYPE = 'ACADEMIC' AND CI_SEQUENCE_NUMBER = 2024 AND AWARD_PRD_CD = 'FALL' AND ACTIVE_FLAG = 'Y';
• List Certifications that Update Funds Authorization:
  SELECT * FROM IGF.IGF_AW_AWARD_CERTS WHERE UPDATE_FUNDS_AUTH_FLAG = 'Y';
• Standard Full Record Query: The query provided in the ETRM documentation serves as the foundational SELECT statement for all data extraction from this table.

Related Objects

Based on the provided dependency and relationship data, the IGF_AW_AWARD_CERTS table is a referenced lookup table within the financial aid data model. It is defined by its primary key constraint, IGF_AW_AWARD_CERT_PK, on the columns (CI_CAL_TYPE, CI_SEQUENCE_NUMBER, AWARD_PRD_CD, AWD_CERT_CODE). The ETRM states that the table "is referenced by" the APPS synonym IGF_AW_AWARD_CERTS, which is the standard method for accessing the table within the EBS application context. While specific foreign key relationships from transactional tables (like award records) are not detailed in the excerpt, this setup table is typically referenced by award processing logic to attach the correct certification text to a student's financial aid package.