Results for “igf_aw_career_map”

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

Overview

The IGF_AW_CAREER_MAP view is a Financial Aid (IGF) reporting object owned by the APPS schema. Its documented purpose is to retrieve records that map Program Type to Class Standing, providing the informational bridge between a student's career level and the academic standing required or associated with a given financial aid program type. Because it is a view rather than a table, it exposes no independent storage; instead it presents a filtered, multi-tenant-aware read of its underlying base object to consumers such as Oracle Forms inquiry windows, concurrent program extracts, and custom reports.

The view participates in the standard EBS multi-organization security model. Rather than exposing every row of the base table, it applies an ORG_ID predicate derived from the session context, so a user querying the view sees only the mapping rows belonging to the organization currently established in their session. This makes it suitable for use in OAF pages, Oracle Reports, BI Publisher data templates, and ad-hoc SQL without requiring the developer to add explicit organization filters.

Underlying Base Objects

The view text selects from IGF_AW_CAREER_MAP_ALL, aliased as CMA. This is the documented base object referenced by the view; the ETRM 12.2.2 metadata records no further referenced objects. The _ALL table is the intersection-free, multi-org table that holds every mapping row across all organizations, while the view supplies the organization-level restriction.

The organization filter compares the ORG_ID column of the base row against the operating unit derived from USERENV('CLIENT_INFO'). The expression strips the first character of CLIENT_INFO when it is a space, otherwise takes the first ten characters, converts the result to a number, and falls back to the sentinel value -99 when no context is available. The NVL-on-both-sides pattern means that a session with no organization context matches only rows whose ORG_ID also evaluates to -99, effectively hiding unrestricted data. In 12.1.1 the same CLIENT_INFO technique is used for Multi-Org (formerly Multiple Organizations) views; in 12.2.2 it continues to function, though newer development typically favors the MO_GLOBAL / ORG_SEC security framework.

Key Columns

• ROWID / ROW_ID — The physical row identifier of the underlying _ALL record. It is not a stable business key across reorganizations, but it allows a consumer to fetch, lock, or update the source row by ROWID.
• CAREER_LEVEL_ID — Foreign key identifying the career level (academic career) associated with the mapping, corresponding to the user's search term. It links to the career level definition used elsewhere in Student Systems / Financial Aid.
• PROGRAM_TYPE — The financial aid program type being mapped, such as a loan, grant, or work-study category.
• CLASS_STANDING — The class standing (for example freshman, sophomore, junior, senior, graduate) mapped to the program type and career level combination.
• ORG_ID — The operating unit that owns the mapping row; this is the column filtered by the view's WHERE clause.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns providing auditability of the mapping record.

Common Use Cases and Queries

The view is most often used to validate or display the permitted class standings for a program type within a given career level, for example when defaulting award eligibility rules or when building an inquiry page. A representative query for a specific career level is:

• SELECT career_level_id, program_type, class_standing FROM igf_aw_career_map WHERE career_level_id = :p_career_level_id ORDER BY program_type, class_standing;
• SELECT program_type, class_standing FROM igf_aw_career_map WHERE org_id = :p_org_id; — although the view already restricts by session organization, an explicit predicate is useful for extract routines running with a defined operating unit.
• SELECT DISTINCT program_type FROM igf_aw_career_map ORDER BY 1; — to enumerate mapped program types for a lookup or LOV.

Because the view applies organization security implicitly, joins to career level or program type reference tables should be performed on the exposed ID and code columns rather than by re-querying the _ALL base table, which would otherwise bypass the security predicate and return data for foreign operating units.