Results for “igf_aw_awd_prd_term”

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

Overview

IGF_AW_AWD_PRD_TERM is a valid table in the IGF schema, belonging to the Oracle E-Business Suite Financial Aid (IGF) product family. As its description states, it holds Awarding Period Term Definitions, acting as the intersection that binds an awarding period to the academic terms (calendar instances) during which that award period is active. In Oracle EBS 12.1.1 and 12.2.2 the object is documented with eleven columns and a single unique index, IGF_AW_AWD_PRD_TERM_PK.

From a data-modeling perspective, the mined Data Vault classification for this object is a link. This is a heuristic suggestion rather than a delivered classification: the table resolves a many-to-many relationship between award period definitions and calendar instances, so it is best modeled as a link table carrying the composite keys of the two parent hubs rather than as an independent hub or a descriptive satellite.

Key Information Stored

The table's identifying and relational columns form its business content:

• CI_CAL_TYPE and CI_SEQUENCE_NUMBER — the calendar type and sequence number identifying the calendar instance (term) associated with the award period. These two columns participate in the foreign key to IGF_AW_AWARD_PRD.
• AWARD_PRD_CD — the award period code, the third component of the foreign key to IGF_AW_AWARD_PRD.
• LD_CAL_TYPE and LD_SEQUENCE_NUMBER — the calendar type and sequence number for the load or definition calendar instance, forming a foreign key to IGS_CA_INST_ALL.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS WHO columns capturing audit and user context for each row.
• OBJECT_VERSION_NUMBER — the optimistic locking column used by the EBS framework to detect concurrent updates.

The surrogate primary key is IGF_AW_AWD_PRD_TERM_PK, defined over (CI_CAL_TYPE, CI_SEQUENCE_NUMBER, AWARD_PRD_CD, LD_CAL_TYPE, LD_SEQUENCE_NUMBER). Because this unique index is composed entirely of the foreign-key columns, it also serves as the principal business-key candidate; no separate single-column surrogate identifier is documented.

Common Use Cases and Queries

Typical usage centers on resolving which terms fall inside a given awarding period, and conversely which award periods are valid for a given term. A reporting query joining back to the award period table might read:

• SELECT t.award_prd_cd, t.ci_cal_type, t.ci_sequence_number FROM igf.igf_aw_awd_prd_term t WHERE t.award_prd_cd = :award_prd_cd;
• Joining to IGS_CA_INST_ALL on LD_CAL_TYPE and LD_SEQUENCE_NUMBER to retrieve term start and end dates for scheduling or disbursement windows.
• Feeding Financial Aid award-period-to-term mappings into enrollment or disbursement reporting, and validating that each awarding period maps to at least one term.

Because OBJECT_VERSION_NUMBER is present, any programmatic update should include it in the WHERE clause to honor optimistic locking.

Related Objects

The following objects are the most significant dependencies:

• IGF_AW_AWARD_PRD — the parent award period definition, referenced via CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and AWARD_PRD_CD.
• IGS_CA_INST_ALL — the calendar instance table supplying the term definition, referenced via LD_CAL_TYPE and LD_SEQUENCE_NUMBER.
• IGF_AW_AWD_PRD_TERM_PK — the primary key index enforcing uniqueness across the five key columns.

Together these relationships place IGF_AW_AWD_PRD_TERM as the bridging link between award period configuration and the academic calendar in the Financial Aid module.