Results for “igf_ap_inst_ver_item_all”

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

Overview

IGF_AP_INST_VER_ITEM_ALL is a table within the Oracle E-Business Suite Financial Aid module (IGF), a product line now classified as obsolete in Oracle EBS 12.1.1 and 12.2.2. The table stores verification values for all user-defined ISIR (Institutional Student Information Record) fields. In the context of financial aid processing, ISIR data is received from the U.S. Department of Education and must be verified against institutional rules before aid eligibility is confirmed. This table holds the specific verification outcomes, mapped values, and processing flags that institutions establish for each user-defined ISIR field associated with a financial aid applicant base record.

From a Data Vault modeling perspective, the heuristic classification for this object is link. This classification is derived from the foreign key structure, where IGF_AP_INST_VER_ITEM_ALL resolves relationships between a base financial aid record (IGF_AP_FA_BASE_REC_ALL) and a user-defined ISIR field definition (IGF_AP_USR_DEF_FLDS_ALL). The table functions as an associative entity connecting these two parent entities while carrying descriptive verification attributes. This is presented as a modeling suggestion rather than a definitive architectural assertion.

Note that the ETRM metadata indicates this object is "Not implemented in this database" in the reference environment, meaning the table may only exist in configurations where the obsolete Financial Aid module was previously deployed. Nonetheless, its documented schema remains relevant for upgrade analysis, data migration planning, and legacy system assessment.

Key Information Stored

The table contains 14 documented columns. The most significant include:

• BASE_ID — Foreign key to IGF_AP_FA_BASE_REC_ALL; identifies the financial aid applicant base record to which the verification item belongs.
• UDF_VERN_ITEM_SEQ_NUM — Foreign key to IGF_AP_USR_DEF_FLDS_ALL; identifies the user-defined ISIR field definition being verified.
• ITEM_VALUE — The actual verification value captured for the user-defined ISIR field.
• WAIVE_FLAG — Indicates whether verification for this item has been waived.
• ISIR_MAP_COL — Maps the verification item to the corresponding ISIR data column; participates in the unique business key.
• INCL_IN_TOLERANCE — Controls whether the item is included in tolerance-based verification comparisons.
• USE_BLANK_FLAG — Determines whether blank values are treated as valid for this item.
• LEGACY_RECORD_FLAG — Identifies records migrated from prior or legacy systems.
• ORG_ID — Multi-organization partitioning column for operating unit isolation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking record creation and modification.

The surrogate primary key is IGF_AP_INST_VERN_ITEM_ALL_PK, composed of UDF_VERN_ITEM_SEQ_NUM and BASE_ID. A unique index, IGF_AP_INST_VERN_ITEM_ALL_U1, spans UDF_VERN_ITEM_SEQ_NUM, BASE_ID, and ISIR_MAP_COL, representing the business-key candidate that enforces uniqueness across the verification item and its ISIR mapping.

Common Use Cases and Queries

Typical reporting scenarios involve retrieving verification values for a given applicant or auditing waivers and tolerance settings. For example, to list all verified items for an applicant base record:

• SELECT v.ITEM_VALUE, v.WAIVE_FLAG, f.FIELD_NAME FROM IGF_AP_INST_VER_ITEM_ALL v, IGF_AP_USR_DEF_FLDS_ALL f WHERE v.UDF_VERN_ITEM_SEQ_NUM = f.UDF_VERN_ITEM_SEQ_NUM AND v.BASE_ID = :base_id;
• Identify waived verification items for audit: SELECT * FROM IGF_AP_INST_VER_ITEM_ALL WHERE WAIVE_FLAG = 'Y';
• Report items excluded from tolerance checks: SELECT * FROM IGF_AP_INST_VER_ITEM_ALL WHERE INCL_IN_TOLERANCE = 'N';
• Legacy data assessment: SELECT COUNT(*) FROM IGF_AP_INST_VER_ITEM_ALL WHERE LEGACY_RECORD_FLAG = 'Y';

These queries support financial aid audit preparation, verification tracking, and migration validation.

Related Objects

The most significant related objects, derived from documented foreign keys, include:

• IGF_AP_FA_BASE_REC_ALL — Parent table referenced via BASE_ID; stores the applicant base financial aid record.
• IGF_AP_USR_DEF_FLDS_ALL — Parent table referenced via UDF_VERN_ITEM_SEQ_NUM; defines the user-defined ISIR fields.

These two tables are the primary dependency targets. The obsolete status of the IGF module suggests limited active API integration, and any additional dependent views or concurrent programs specific to the Financial Aid module would require confirmation against the deployed environment, as the ETRM metadata does not enumerate further referencing objects beyond the documented foreign keys.