Search Results career_item




Overview
Explore in AI Chat

Overview

APPS.IGF_AP_TD_ITEM_MST is a reporting and integration view in Oracle E-Business Suite that exposes the master definition of financial aid "to-do" items used by the Student Financial Aid component of Oracle iGovernment / Oracle Student System. The view is a filtered projection of the underlying entity table IGF_AP_TD_ITEM_MST_ALL, presenting the columns of the base table in a stable, read-only form intended for queries, reports, and interface extraction rather than for direct DML.

The defining characteristic of the view is its organizational security filter. The WHERE clause compares the ORG_ID column against the operating unit (or organization) value that Oracle EBS stores in the session attribute USERENV('CLIENT_INFO'). The expression NVL(ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) is applied on both sides of the equality, so that rows belonging to the current session organization are returned. Rows with a null ORG_ID are treated as organization-independent, or "global," definitions. This multi-org style filtering is what distinguishes the _MST view from its _ALL base table.

The user search term "career_item" corresponds directly to one of the columns exposed by this view. CAREER_ITEM is part of the to-do item master and indicates that the item is associated with a career or career-related requirement in the financial aid processing cycle. Users searching on this term are typically tracing how a to-do item is classified against a student's academic career.

Underlying Base Objects

The documented definition shows the view is defined over a single base object: the table IGF_AP_TD_ITEM_MST_ALL. No other referenced base objects are documented in the ETRM metadata. The projection is a direct column list, with no joins, unions, or computed expressions in the SELECT list; the only transformation is the ROWID pseudo-column and the organization filter in the WHERE clause.

Because IGF_AP_TD_ITEM_MST_ALL is the "_ALL" table in the Oracle multi-organization naming convention, it holds rows for every organization. IGF_AP_TD_ITEM_MST therefore acts as the organization-scoped access layer over that table. This means the base table is the authoritative source for inserts and updates, while the view is the appropriate access point for queries that must respect the current organization context.

Key Columns

Common Use Cases and Queries

The view is commonly used to report the catalogue of financial aid to-do items for the current organization, to validate whether an item is mandatory for an application, and to retrieve self-service instructions and document URLs.

To list career-related items currently visible to the session organization:

  • SELECT todo_number, item_code, description, career_item FROM apps.igf_ap_td_item_mst WHERE career_item IS NOT NULL;

To identify mandatory application items with attempt limits:

  • SELECT item_code, description, freq_attempt, max_attempt FROM apps.igf_ap_td_item_mst WHERE required_for_application = 'Y';

To retrieve self-service display information and document links:

  • SELECT item_code, ss_instruction_txt, document_url_txt FROM apps.igf_ap_td_item_mst WHERE display_in_ss_flag = 'Y';

Because the view applies the USERENV('CLIENT_INFO') organization filter, queries should be executed in a session whose CLIENT_INFO is initialized to the intended operating unit; otherwise the filter resolves to the -99 sentinel and returns only rows that satisfy the null-organization branch.