Search Results igf_ap_class_std_map_v

Overview

The view IGF_AP_CLASS_STD_MAP_V is an Oracle E-Business Suite database object owned by the APPS schema and classified under the IGF (Financial Aid) product family. Its purpose, as documented in the ETRM repository, is to hold the class standing mapping that links an OSS user-defined class standing to the Financial Aid class standing, expressed through the Grade Level Code. In practice, the view flattens the association between institutional student class standing records and the financial aid grade level attributes maintained against a student's aid record.

The object is reported with a status of VALID in both the 12.1.1 and 12.2.2 release contexts. Because it is a view rather than a base table, it carries no independent data of its own; it is a read-only projection assembled at runtime from its constituent tables. This makes it suitable for reporting, inquiry screens, and integration extracts that require a denormalized representation of class standing mapping without persisting redundant rows. It is commonly consumed by Financial Aid processing that must translate a registrar-side class standing into the grade level codes used by the packaging and disbursement logic.

Underlying Base Objects

The view text, as documented, defines an inner join across three objects:

• IGF_AP_CLASS_STD_MAP (aliased IPCS) — the Financial Aid side of the mapping, holding the grade level codes and related identifiers such as PPT_ID and IPCS_ID.
• IGS_PR_CSS_CLASS_STD (aliased PCSS) — the Student Systems class standing association table, providing the schedule and class standing identifiers.
• IGS_PR_CLASS_STD (aliased PCS) — the class standing definition table, supplying the CLASS_STANDING value and its DESCRIPTION.

The join conditions are: PCSS.IGS_PR_CLASS_STD_ID = PCS.IGS_PR_CLASS_STD_ID and PCSS.IGS_PR_CSS_CLASS_STD_ID = IPCS.IGS_PR_CSS_CLASS_STD_ID. This structure confirms that the view bridges the Student Systems (IGS) class standing model with the Financial Aid (IGF) grade level model. The ETRM metadata for 12.2.2 does not independently document referenced base objects, so the view text remains the authoritative source for its dependency chain.

Key Columns

The projection exposes identifiers, descriptive attributes, and audit columns. Notable columns include:

• IGS_PR_CSS_CLASS_STD_ID — primary identifier for the class standing association record.
• IGS_PR_CS_SCHDL_ID — identifier of the related class standing schedule.
• CLASS_STANDING and CLASS_STANDING_DESC — the OSS user-defined class standing code and its description.
• IPCS_ID and ROW_ID — identifiers for the Financial Aid mapping row.
• AP_STD_CODE / AP_STD_DESC — the applicant grade level code and its decoded description, produced by IGF_AW_GEN.LOOKUP_DESC('IGF_AP_GRADE_LEVEL', ...).
• DL_STD_CODE / DL_STD_DESC — the dependent grade level code and description, decoded from IGF_AP_GRADE_LEVEL.
• CL_STD_CODE / CL_STD_DESC — the class grade level code and description, decoded from IGF_SL_CL_GRADE_LEVEL.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.
• PPT_ID — the associated Financial Aid record identifier.

The decoded description columns rely on the IGF_AW_GEN.LOOKUP_DESC function, meaning the view returns human-readable values alongside stored codes.

Common Use Cases and Queries

Typical scenarios include verifying grade level mappings during implementation, diagnosing packaging errors where a student's class standing fails to resolve, and building extracts that reconcile registrar data against Financial Aid grade levels.

A representative query retrieving all mappings for a schedule:

SELECT class_standing,
       class_standing_desc,
       ap_std_code,
       ap_std_desc,
       cl_std_code,
       cl_std_desc
FROM   apps.igf_ap_class_std_map_v
WHERE  igs_pr_cs_schdl_id = :p_schedule_id;

To inspect a single mapping record:

SELECT ipcs_id, ppt_id, ap_std_code, dl_std_code, cl_std_code
FROM   apps.igf_ap_class_std_map_v
WHERE  igs_pr_css_class_std_id = :p_css_class_std_id;

Because the view performs inner joins, rows appear only where a Financial Aid mapping exists for the class standing; unmatched class standing definitions will not be returned. Queries should therefore account for this filtering behavior when used for reconciliation reporting.