Results for “upper_enr_load_range”

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

Overview

The view IGF_AP_AWYR_ATMAP_V is a component of the Oracle E-Business Suite Financial Aid module (IGF), a product line now classified as obsolete within the ETRM reference set for releases 12.1.1 and 12.2.2. The view is documented as storing Student System Attendance Types for award year, indicating that its purpose is to associate attendance type definitions maintained in the Student System with the award-year mapping constructs used by the Financial Aid award-processing engine.

In EBS reporting and integration terms, the view functions as a denormalized join surface: it exposes attendance-type attributes alongside the award-year calendar context so that downstream consumers—such as award-letter generation, enrollment load validation, and third-party Student System integration extracts—can resolve a given attendance type within a specific award year without issuing multi-step joins themselves. The view name follows the naming convention of the IGF module, with the _V suffix denoting a database view rather than a base table.

Because the underlying module is obsolete, the view should be treated as a legacy artifact. ETRM explicitly records the object as Not implemented in this database, meaning it will not appear in every environment and may be absent entirely in newer or freshly provisioned instances.

Underlying Base Objects

The view text defines the object over two base tables using an inner join driven by an implicit equijoin condition on attendance type:

• IGF_AP_BATCH_AW_MAP (aliased BAMV) — the award-year mapping table for Financial Aid batch processing. It contributes ROWID, CI_CAL_TYPE, and CI_SEQUENCE_NUMBER, which provide the calendar instance context for the award year.
• IGS_EN_ATD_TYPE (aliased ENAT) — the Student System attendance type table. This is the object referenced by the user search term igs_en_atd_type and supplies the descriptive and enrollment-load attributes exposed by the view.

Notably, the ETRM metadata records Referenced base objects: none documented and lists no owner, even though the view text itself clearly names both source tables. This discrepancy reflects the incomplete implementation status of the object in the documented database and should be understood as a metadata gap rather than an absence of dependencies. Both tables reside in the IGS/IGF schema family and are subject to the same obsolete-module classification.

Key Columns

The view exposes the following columns, drawn from the two base tables:

• ROW_ID — the ROWID of the award-year mapping row; useful for row-level identification in ad hoc extracts.
• CAL_TYPE, SEQUENCE_NUMBER — the calendar type and sequence number identifying the award year's calendar instance.
• ATTENDANCE_TYPE — the code identifying the student attendance category.
• DESCRIPTION — the descriptive text for the attendance type.
• GOVT_ATTENDANCE_TYPE — the corresponding government-reported attendance classification, used for regulatory/statutory reporting.
• LOWER_ENR_LOAD_RANGE, UPPER_ENR_LOAD_RANGE — the enrollment load boundaries associated with the attendance type, used to validate or band a student's enrollment intensity.
• RESEARCH_PERCENTAGE — the research-component percentage applicable to the attendance type.
• CLOSED_IND — indicator that the attendance type is inactive or closed for use.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns inherited from the attendance type table.

Common Use Cases and Queries

Typical uses of this view center on resolving attendance type definitions within an award year context, and on feeding extracts where both dimensions are required simultaneously.

SELECT ATTENDANCE_TYPE, DESCRIPTION, GOVT_ATTENDANCE_TYPE,
       LOWER_ENR_LOAD_RANGE, UPPER_ENR_LOAD_RANGE
FROM   IGF_AP_AWYR_ATMAP_V
WHERE  CAL_TYPE = :p_cal_type
AND    SEQUENCE_NUMBER = :p_seq
AND    CLOSED_IND = 'N';

To enumerate only active attendance types for a given award year, filter on CLOSED_IND as above. To compare government classifications against internal descriptions for reporting reconciliation:

SELECT ATTENDANCE_TYPE, DESCRIPTION, GOVT_ATTENDANCE_TYPE
FROM   IGF_AP_AWYR_ATMAP_V
ORDER  BY GOVT_ATTENDANCE_TYPE, ATTENDANCE_TYPE;

Because the view is documented as not implemented and the module is obsolete, any query against it should be guarded—for example, by verifying the object exists in ALL_VIEWS—before being embedded in production concurrent programs or integrations. Where the object is absent, equivalent logic must be reconstructed directly from IGF_AP_BATCH_AW_MAP and IGS_EN_ATD_TYPE.