Results for “ap_att_code”

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

Overview

The Oracle E-Business Suite view APPS.IGF_AP_ATTEND_MAP_V is a Financial Aid (IGF) object that presents the mapping between institution-defined Attendance Types and the standardized enrollment status codes required for federal student aid processing. Attendance Types are user-defined in the OSS (Oracle Student System) institution setup, while the Pell Grant, FFELP Loan, and Application Processing attendance categories are predefined federal values. This view resolves the two by exposing both the raw code and its decoded description, allowing reporting and integration processes to translate local institutional attendance terminology into the federal enrollment codes used by Financial Aid.

The view is documented as VALID in the APPS schema and forms part of the Financial Aid integration layer that supports disbursement eligibility and enrollment reporting to external agencies. It is read-only and does not store data itself; all persistence resides in the base mapping table.

Underlying Base Objects

The view is defined over two documented base objects:

• IGF_AP_ATTEND_MAP (aliased ATMMV) — the primary mapping table holding attendance type records, federal attendance codes, organizational context, and audit columns.
• IGS_CA_INST (aliased CA) — the OSS calendar instance table joined on CAL_TYPE and SEQUENCE_NUMBER to supply the calendar alternate code and validity dates (START_DT, END_DT).

The join is an equijoin on the calendar type and sequence number, meaning a mapping record is only returned when a corresponding calendar instance exists. This effectively binds each attendance mapping to a specific academic calendar instance and its effective date range. The lookup descriptions are not physical columns but are derived at runtime through calls to IGF_AW_GEN.LOOKUP_DESC.

Key Columns

• ROW_ID and ATM_ID — unique identifiers for the mapping record.
• ATTENDANCE_TYPE — the institution-defined (OSS) attendance type being mapped.
• PELL_ATT_CODE / PELL_ATT_DESC — federal Pell Grant enrollment status code and its decoded description (lookup IGF_GR_RFMS_ENROL_STAT).
• CL_ATT_CODE / CL_ATT_DESC — FFELP Loan enrollment status code and description (lookup IGF_SL_CL_ENROL_STATUS).
• AP_ATT_CODE / AP_ATT_DESC — Application Processing enrollment status code and description (lookup IGF_AP_ENRL_STAT).
• ORG_ID — the operating unit that owns the mapping record, supporting multi-org access control.
• CAL_TYPE and SEQUENCE_NUMBER — identify the OSS calendar instance the mapping applies to.
• ALTERNATE_CODE, START_DT, END_DT — calendar instance identification and effective period from IGS_CA_INST.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

This view is typically queried when validating that every institution-defined attendance type has a corresponding federal code before running Pell, loan, or application processing extracts, and when auditing the effective date range under which the mapping applies. A common query retrieves the decoded federal codes for a given calendar:

• Listing all mappings for an operating unit: SELECT attendance_type, pell_att_code, cl_att_code, ap_att_code FROM igf_ap_attend_map_v WHERE org_id = :p_org_id;
• Checking effective dates alongside calendar instance: SELECT attendance_type, alternate_code, start_dt, end_dt FROM igf_ap_attend_map_v WHERE cal_type = :p_cal_type AND sequence_number = :p_seq;
• Finding unmapped or incomplete records: SELECT attendance_type FROM igf_ap_attend_map_v WHERE pell_att_code IS NULL OR cl_att_code IS NULL OR ap_att_code IS NULL;
• Resolving descriptions for reporting: SELECT attendance_type, pell_att_desc, cl_att_desc, ap_att_desc FROM igf_ap_attend_map_v;

Because the view performs runtime lookups and a mandatory join to IGS_CA_INST, queries should filter by ORG_ID, CAL_TYPE, and SEQUENCE_NUMBER to reduce the lookup overhead and ensure only current calendar-instance mappings are returned.