Search Results igf_ap_attend_map_all_u2




Overview
Explore in AI Chat

Overview

IGF.IGF_AP_ATTEND_MAP_ALL is a Financial Aid mapping table in Oracle EBS Release 12.1.1 and 12.2.2, owned by the IGF schema and registered under FND Design Data as IGF.IGF_AP_ATTEND_MAP_ALL. Its documented purpose is to store the mapping from Attendance Types, which are user-defined in OSS (Oracle Student System, IGS schema), to the government attendance and enrollment status classifications used in Financial Aid processing: Pell Grants, FFELP Loans, and Application Processing. The table therefore acts as a translation layer between institutionally defined attendance classifications and the codes required for federal aid reporting and disbursement logic.

The object resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and its indexes reside in APPS_TS_TX_IDX, consistent with standard Oracle EBS transactional and reference data conventions. The metadata classifies this object heuristically as satellite-leaning in Data Vault terms. As a modeling suggestion, this reflects a structure that hangs off a business key and a foreign-key parent rather than originating transactional activity on its own: it carries descriptive attributes (the Pell, loan, and application-processing mapping codes) attached to an institutional attendance type within an operating unit and award calendar context.

Key Information Stored

The table contains 13 documented columns. The most significant are:

  • ATM_ID — A sequence-generated NUMBER(15) that serves as the surrogate primary key (IGF_AP_ATTEND_MAP_ALL_PK) and is enforced by unique index IGF_AP_ATTEND_MAP_ALL_U1.
  • ATTENDANCE_TYPE — VARCHAR2(30) holding the code of an institution-defined attendance type. This identifies whether a student is classified as part-time or full-time in the program based on study load in the reference year.
  • PELL_ATT_CODE — VARCHAR2(30) holding the Pell Grant mapping code for the attendance type or enrollment status.
  • CL_ATT_CODE — VARCHAR2(30) holding the FFELP Loan mapping code for the attendance type or enrollment status.
  • AP_ATT_CODE — VARCHAR2(30) holding the application-processing mapping code for the attendance type or enrollment status.
  • ORG_ID — NUMBER(15) identifying the Operating Unit, supporting multi-org data partitioning.
  • CAL_TYPE — VARCHAR2(10) identifying the Award Calendar Type; documented as a foreign key to IGS_CA_INST_ALL.
  • SEQUENCE_NUMBER — The Award Calendar Sequence Number, used to distinguish calendar instances.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Who columns providing auditing information.

The business-key candidate is unique index IGF_AP_ATTEND_MAP_ALL_U2, defined across ATTENDANCE_TYPE, ORG_ID, CAL_TYPE, and SEQUENCE_NUMBER. The user's search term "igf_ap_attend_map_all_u2" resolves to exactly this composite uniqueness constraint, which guarantees that a given institutional attendance type maps only once per operating unit, award calendar type, and calendar sequence.

Common Use Cases and Queries

Typical usage centers on validating and reporting the mapping between institutional attendance types and aid category codes. A common query pattern retrieves the full mapping for a given operating unit and award calendar:

  • Query the table by business key: SELECT attendance_type, pell_att_code, cl_att_code, ap_att_code FROM igf.igf_ap_attend_map_all WHERE org_id = :org AND cal_type = :cal AND sequence_number = :seq.
  • Reverse-lookup from a government code to institution codes: SELECT attendance_type FROM igf.igf_ap_attend_map_all WHERE pell_att_code = :pell_code AND org_id = :org.
  • Diagnostic scripts to detect unmapped or null mapping codes: SELECT * FROM igf.igf_ap_attend_map_all WHERE pell_att_code IS NULL OR cl_att_code IS NULL OR ap_att_code IS NULL — useful auditing for Financial Aid setup.
  • Reporting joins to IGS tables to reconcile institutional attendance definitions (IGS_CA_INST_ALL and related Student System attendance views) with aid category requirements.

Related Objects

The documented foreign key relationship is on CAL_TYPE, referencing IGS_CA_INST_ALL in the IGS schema, which supplies the award calendar instance context for each mapping row. IGS_CA_INST_ALL is the primary external dependency. Related objects of significance include:

  • IGF.IGF_AP_ATTEND_MAP_ALL_PK / U1 / U2 — the primary key and unique indexes enforcing row identity and business-key uniqueness on ATM_ID and (ATTENDANCE_TYPE, ORG_ID, CAL_TYPE, SEQUENCE_NUMBER) respectively.
  • IGS.IGS_CA_INST_ALL — parent award calendar instance table joined via CAL_TYPE.
  • IGS.IGS_CA_INST and calendar setup views — providing the award calendar and sequence context used in the business key.
  • IGS attendance type setup and OSS student enrollment views — supplying the institutional ATTENDANCE_TYPE values that this table maps to government codes.
  • Financial Aid Pell and loan processing entities in the IGF schema — consuming PELL_ATT_CODE, CL_ATT_CODE, and AP_ATT_CODE during awarding and disbursement processing.