Results for “bbay_flag”

9 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGF_AW_AWARD_PRD is a Financial Aid (IGF) module table that stores Awarding Period definitions within Oracle E-Business Suite 12.1.1 and 12.2.2. An awarding period represents a discrete interval, aligned to an academic calendar instance, during which awards are certified, disbursed, and tracked. The table anchors the configuration of the aid lifecycle by binding each awarding period to a specific calendar type and sequence number drawn from the institution's academic calendar hierarchy. This allows multiple awarding periods to be defined per calendar instance, supporting structures such as standard terms, quarters, semesters, or custom interval schemes.

From a dimensional modeling perspective, the mined foreign key structure suggests a hub-leaning Data Vault classification for IGF_AW_AWARD_PRD. Its primary key is a composite business key rather than a generated surrogate, and it is referenced by dependent child tables, which is characteristic of a hub entity surrounded by satellite and link structures. Analysts constructing a Data Vault should treat this table as a hub whose natural key is (CI_CAL_TYPE, CI_SEQUENCE_NUMBER, AWARD_PRD_CD), with descriptive attributes and flags suitable for a satellite.

Key Information Stored

The documented schema for IGF_AW_AWARD_PRD contains thirteen columns. The most consequential are described below.

  • CI_CAL_TYPE — Calendar type code identifying the academic calendar to which the awarding period belongs. Part of the composite primary key and foreign key to IGS_CA_INST_ALL.
  • CI_SEQUENCE_NUMBER — Sequence number identifying the specific calendar instance (for example, a particular academic year). Part of the composite primary key.
  • AWARD_PRD_CD — Code uniquely identifying the awarding period within the calendar instance. Completes the composite primary key.
  • AWARD_PRD_DESC — Descriptive name of the awarding period, used in inquiry screens and reports.
  • BBAY_FLAG — Flag indicating whether the awarding period is treated as a borrower-based academic year, relevant to loan processing rules.
  • DEFAULT_FLAG — Indicates the default awarding period for the associated calendar instance.
  • INCLUDE_IN_SS_FLAG — Flag controlling whether the awarding period participates in self-service or related processing flows.
  • OBJECT_VERSION_NUMBER — Optimistic locking column for concurrent update control.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns capturing who created and last modified the record and when.

The primary key IGF_AW_AWARD_PRD_PK (CI_CAL_TYPE, CI_SEQUENCE_NUMBER, AWARD_PRD_CD) is the sole documented unique index and therefore the definitive business-key candidate. No separate numeric surrogate key is documented; all relationships join through the composite business key.

Common Use Cases and Queries

Typical use cases center on listing awarding periods for a given academic calendar, identifying the default period, and joining period definitions to certification and term records.

A straightforward query retrieves all awarding periods for a calendar instance:

  • SELECT ci_cal_type, ci_sequence_number, award_prd_cd, award_prd_desc, default_flag, bbay_flag FROM igf.igf_aw_award_prd WHERE ci_cal_type = :cal_type AND ci_sequence_number = :seq ORDER BY award_prd_cd;

Locating the default awarding period within a calendar:

  • SELECT award_prd_cd, award_prd_desc FROM igf.igf_aw_award_prd WHERE ci_cal_type = :cal_type AND ci_sequence_number = :seq AND default_flag = 'Y';

Reporting on term distribution requires joining to IGF_AW_AWD_PRD_TERM:

  • SELECT p.award_prd_cd, p.award_prd_desc, t.term_code FROM igf.igf_aw_award_prd p JOIN igf.igf_aw_awd_prd_term t ON t.ci_cal_type = p.ci_cal_type AND t.ci_sequence_number = p.ci_sequence_number AND t.award_prd_cd = p.award_prd_cd;

These queries support financial aid setup validation, award certification processing, and period-driver configuration reporting.

Related Objects

The following tables are the most significant relationships documented for IGF_AW_AWARD_PRD.

  • IGS_CA_INST_ALL — Referenced by CI_CAL_TYPE (and effectively by the calendar instance). Provides the calendar instance context for each awarding period.
  • IGF_AW_AWD_CERT_RESPS — References IGF_AW_AWARD_PRD via CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and AWARD_PRD_CD. Stores award certification responsibilities tied to each awarding period.
  • IGF_AW_AWD_PRD_TERM — References IGF_AW_AWARD_PRD via the same composite key, mapping awarding periods to academic terms.

Because these dependent tables join on the full composite primary key, any change to calendar type, sequence number, or awarding period code must propagate consistently to preserve referential integrity across the Financial Aid configuration.