Search Results igf_ap_grade_level

Overview

IGF_AP_CLASS_STD_MAP_V is a VALID Oracle Application Object Library view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is registered in FND Design Data as IGF.IGF_AP_CLASS_STD_MAP_V and is classified as a multi-org view, meaning that queries against it automatically return data for the session's current operating unit while excluding data belonging to other operating units. The view exists within the Financial Aid (IGF) product family and serves as the integration bridge between the student information system's class standing definitions and the class standing codes required by the downstream loan and application processing systems.

Its stated purpose in the ETRM documentation is to hold the class standing mapping of OSS user-defined class standing values to Financial Aid class standing values, expressed as Grade Level Codes. The user search term "dl_std_code" corresponds directly to one of the view's exposed columns, DL_STD_CODE, which carries the class standing mapping used by the Direct Loan process.

Underlying Base Objects

The documented view metadata does not enumerate referencing base tables; the ETRM dependency record lists no documented base objects. The view is nevertheless defined over the class standing mapping structures maintained by the Financial Aid Credit Point and Class Standing setup, as reflected in the leading columns IGS_PR_CSS_CLASS_STD_ID and IGS_PR_CS_SCHDL_ID. The first holds the foreign key to the class standing mapping for a credit point range and academic year combination, scoped per program type and period. The second references the class standing schedule. The view therefore projects a denormalized, descriptive representation of those base mapping rows rather than introducing data of its own.

As a multi-org view, its definition includes the operating unit predicate applied through the standard multi-org mechanism, ensuring operating unit isolation without requiring the caller to add filtering predicates.

Key Columns

• IGS_PR_CSS_CLASS_STD_ID (NUMBER 15) — Foreign key to the class standing mapping for the credit point range and academic years for each program type and period.
• IGS_PR_CS_SCHDL_ID (NUMBER 15) — Identifier linking the mapping to the class standing schedule.
• CLASS_STANDING (VARCHAR2 50) — The class standing value; CLASS_STANDING_DESC (VARCHAR2 90) provides its description.
• AP_STD_CODE (VARCHAR2 30) and AP_STD_DESC (VARCHAR2 4000) — Class standing mapping used by Application Processing and its description.
• DL_STD_CODE (VARCHAR2 30) and DL_STD_DESC (VARCHAR2 4000) — Class standing mapping used by Direct Loan and its description.
• CL_STD_CODE (VARCHAR2 30) and CL_STD_DESC (VARCHAR2 4000) — Class standing mapping used by CommonLine Loan and its description.
• IPCS_ID (NUMBER 15) and PPT_ID (NUMBER 15) — Sequence-generated identifiers; ROW_ID (ROWID) exposes the row identifier.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

Typical uses include validating that every OSS class standing has a corresponding Direct Loan or CommonLine code before loan origination, and driving integration extracts that translate internal class standings into the codes expected by external loan servicers. Because the view is multi-org, the query returns only rows belonging to the current operating unit.

To locate the code mapped for Direct Loan for a given class standing:

• SELECT CLASS_STANDING, CLASS_STANDING_DESC, DL_STD_CODE, DL_STD_DESC FROM APPS.IGF_AP_CLASS_STD_MAP_V WHERE DL_STD_CODE IS NOT NULL;
• SELECT IGS_PR_CSS_CLASS_STD_ID, CLASS_STANDING, AP_STD_CODE, DL_STD_CODE, CL_STD_CODE FROM APPS.IGF_AP_CLASS_STD_MAP_V WHERE CLASS_STANDING = :p_class_standing;
• SELECT CLASS_STANDING, DL_STD_CODE FROM APPS.IGF_AP_CLASS_STD_MAP_V WHERE LAST_UPDATE_DATE >= :p_since ORDER BY CLASS_STANDING;

These patterns support setup verification, mapping reconciliation, and incremental integration loads across the Financial Aid modules that consume class standing data.