Search Results igf_ap_attend_map




Overview
Explore in AI Chat

Overview

The IGF_AP_ATTEND_MAP view is a reporting and integration object owned by the APPS schema within the Financial Aid (IGF) product module of Oracle E-Business Suite, valid in releases 12.1.1 and 12.2.2. Its purpose is to expose the mapping that translates Attendance Types defined by the user in Oracle Student System (OSS) into the standardized attendance classifications required for federal financial aid processing. These federal classifications cover the enrollment status used for Pell Grants, for FFELP (Federal Family Education Loan Program) Loans, and for Application Processing. The view therefore acts as a translation layer between institutionally defined attendance values and the codes the financial aid engine expects. Because attendance status directly drives disbursement eligibility, satisfactory academic progress evaluation, and award recalculation, the view is central to any reporting requirement that reconciles institutional attendance designations against federal categories. The view is also multi-tenant aware: it applies an ORG_ID predicate against the session context, so queries return only the records belonging to the operating unit in which the session is running.

Underlying Base Objects

The view is defined over a single base table, IGF_AP_ATTEND_MAP_ALL, aliased as ATM in the view text. Rather than reproducing the table structure directly, the view performs one essential transformation: it injects an ORG_ID filter derived from USERENV('CLIENT_INFO'). The predicate reads the first ten characters of the client information string, converts them to a number, and matches that against NVL(ATM.ORG_ID, -99), so records with a null operating unit are treated as global. This is the conventional Oracle multi-org secured view pattern used throughout EBS applications. No other referenced base objects are documented for this view in the ETRM metadata. The _ALL table retains rows across all operating units, and the view is the secured access path that end users and application code should query instead of the table itself.

Key Columns

  • ROW_ID — the base table ROWID, projected for uniqueness and row-level identification.
  • ATM_ID — the primary identifier of the mapping record.
  • ATTENDANCE_TYPE — the institutionally defined attendance type maintained in OSS.
  • PELL_ATT_CODE — the corresponding federal attendance code used for Pell Grant processing.
  • CL_ATT_CODE — the corresponding federal attendance code used for FFELP Loan processing.
  • AP_ATT_CODE — the corresponding federal attendance code used for Application Processing.
  • ORG_ID — the operating unit that owns the mapping; null indicates a global mapping.
  • CAL_TYPE — the calendar type associated with the mapping.
  • SEQUENCE_NUMBER — the ordering value applied when evaluating or presenting mappings.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical uses include validating that every OSS attendance type has a complete federal mapping, troubleshooting financial aid award or disbursement discrepancies caused by missing or incorrect mappings, and extracting attendance configuration for audit or migration. A basic listing returns all mappings visible to the current operating unit:

  • SELECT ATM_ID, ATTENDANCE_TYPE, PELL_ATT_CODE, CL_ATT_CODE, AP_ATT_CODE, CAL_TYPE, SEQUENCE_NUMBER FROM IGF_AP_ATTEND_MAP ORDER BY ATTENDANCE_TYPE, SEQUENCE_NUMBER;
  • To find mappings missing a Pell or loan code: SELECT ATTENDANCE_TYPE FROM IGF_AP_ATTEND_MAP WHERE PELL_ATT_CODE IS NULL OR CL_ATT_CODE IS NULL;
  • To isolate mappings for a specific calendar type: SELECT ATTENDANCE_TYPE, PELL_ATT_CODE FROM IGF_AP_ATTEND_MAP WHERE CAL_TYPE = :cal_type;

Because the view is ORG_ID secured, callers that must inspect all operating units simultaneously — such as cross-org comparison reports — should query IGF_AP_ATTEND_MAP_ALL directly, or set the client info context appropriately before querying the view.