Results for “igf_ap_td_item_inst_v”

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

Overview

The IGF_AP_TD_ITEM_INST_V view is a reporting and integration object owned by the APPS schema within the Oracle E-Business Suite Financial Aid (IGF) product family. It exposes data related to "To Do" item instances associated with a financial aid applicant's base record, combining item instance details with descriptive lookup information, master item definitions, preferred lender relationships, and applicant identity. The view is documented as VALID in ETRM for both EBS 12.1.1 and 12.2.2.

The object serves as a denormalized read layer that joins a child item-instance table to several parent and lookup objects. Its primary function is to present a single, queryable row per To Do item instance, enriched with human-readable status meanings and item descriptions. Users frequently search this view by the STATUS_DESC column, which resolves the internal STATUS code into its lookup meaning (lookup type IGF_TD_ITEM_STATUS), making it valuable for status-driven reporting without requiring a separate join to lookup tables.

Underlying Base Objects

The view text documents the following base objects and join conditions:

• IGF_AP_TD_ITEM_INST TDII — the primary "To Do" item instance table, joined on TDM.TODO_NUMBER = TDII.ITEM_SEQUENCE_NUMBER and FA.BASE_ID = TDII.BASE_ID; the outer preference lender join uses PREFLEND.CLPRL_ID(+) = TDII.CLPRL_ID.
• IGF_LOOKUPS_VIEW LV — the lookup view supplying STATUS_DESC, joined where LV.LOOKUP_TYPE = 'IGF_TD_ITEM_STATUS' and LV.LOOKUP_CODE = TDII.STATUS.
• IGF_AP_TD_ITEM_MST TDM — the master To Do item definition, supplying item code, description, system To Do type code, application code, and career item.
• IGF_SL_CL_PREF_LENDERS_V PREFLEND — a preferred lender view brought in via an outer join to provide relationship code and description.
• IGF_AP_FA_BASE_REC_ALL FA — the financial aid base record, supplying the applicant PERSON_ID.

The metadata notes no separately documented base objects beyond those embedded in the view definition.

Key Columns

The view returns 28 columns. Notable columns include:

• ROW_ID, BASE_ID, ITEM_SEQUENCE_NUMBER — identity and foreign key columns linking the instance to its base record and master item.
• ITEM_CODE, ITEM_DESCRIPTION — descriptive attributes sourced from the master item table.
• STATUS, STATUS_DESC — the internal status code and its lookup meaning; STATUS_DESC is the column most commonly used in filters and reports.
• STATUS_DATE, ADD_DATE, CORSP_DATE, CORSP_COUNT — lifecycle and correspondence tracking dates.
• INACTIVE_FLAG, REQUIRED_FOR_APPLICATION, FREQ_ATTEMPT, MAX_ATTEMPT, LEGACY_RECORD_FLAG — control and eligibility flags.
• SYSTEM_TODO_TYPE_CODE, APPLICATION_CODE, CAREER_ITEM — classification attributes from the master item.
• CLPRL_ID, RELATIONSHIP_CD, RELATIONSHIP_CD_DESC — preferred lender relationship attributes (nullable due to outer join).
• PERSON_ID — the applicant identifier from the financial aid base record.
• Audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

Typical scenarios include tracking outstanding To Do items per applicant, reporting by status description, and enriching downstream integrations with lender relationship data.

SELECT base_id, item_code, item_description,
       status, status_desc, status_date, person_id
FROM   apps.igf_ap_td_item_inst_v
WHERE  status_desc = :p_status
ORDER  BY status_date DESC;

To find active items for an applicant:

SELECT item_code, item_description, status_desc,
       required_for_application, freq_attempt, max_attempt
FROM   apps.igf_ap_td_item_inst_v
WHERE  person_id = :p_person_id
AND    inactive_flag = 'N';

To review preferred lender relationships on To Do items:

SELECT base_id, item_code, status_desc,
       relationship_cd, relationship_cd_desc
FROM   apps.igf_ap_td_item_inst_v
WHERE  clprl_id IS NOT NULL;

Because it resolves lookup meanings inline, the view is well suited for ad hoc reporting and interface extraction within the Financial Aid module.