Results for “igf_ap_fa_ant_data”

50+ results




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

Overview

IGF_AP_FA_ANT_DATA is a base table within the Oracle E-Business Suite Financial Aid (IGF) module, documented in the ETRM repository for releases 12.1.1 and 12.2.2. The table stores anticipated data associated with a Financial Aid Base Record, capturing the enrollment and program attributes that a financial aid award is assessed against. Within the IGF schema, this object acts as an attribute-bearing child of the Financial Aid base record, holding anticipated (as opposed to actual) attendance, program, residency, and study-load characteristics used during needs analysis and award packaging.

Two important caveats apply. First, the product classification is IGF – Financial Aid (Obsolete), and the ETRM entry states that the table is Not implemented in this database. In practice this object is encountered only in legacy or partially implemented Financial Aid installations, and in many 12.1.1 and 12.2.2 environments it exists only as a seeded, empty structure or is absent entirely. Second, the heuristic Data Vault classification mined from its foreign key structure is link. From a modeling perspective, this suggests the table functions primarily as a relationship-bearing construct, joining a financial aid base record to a set of institutional reference entities rather than acting as an independent hub or a purely descriptive satellite.

Key Information Stored

The documented physical schema comprises 23 columns owned by the IGF schema. The most significant are summarized below.

The surrogate primary key is defined by IGF_AP_FA_ANT_DATA_PK over (BASE_ID, LD_CAL_TYPE, LD_SEQUENCE_NUMBER). Because this single unique index also carries the business meaning of the row, there is no separate artificial surrogate column; the same columns serve as both the unique index and the FK-bearing link key.

Common Use Cases and Queries

Typical usage centers on reconstructing the anticipated enrollment profile used for a financial aid award package, and comparing anticipated against actual enrollment for disbursement adjustment.

  • Retrieving all anticipated records for a base record:
    SELECT BASE_ID, LD_CAL_TYPE, LD_SEQUENCE_NUMBER,
           PROGRAM_CD, ATTENDANCE_TYPE, MONTHS_ENROLLED_NUM,
           CREDIT_POINTS_NUM
    FROM   IGF_AP_FA_ANT_DATA
    WHERE  BASE_ID = :p_base_id;
  • Joining to the base record for student-level reporting:
    SELECT b.BASE_ID, a.PROGRAM_CD, a.CLASS_STANDING,
           a.RESIDENCY_STATUS_CODE
    FROM   IGF_AP_FA_BASE_REC_ALL b,
           IGF_AP_FA_ANT_DATA     a
    WHERE  b.BASE_ID = a.BASE_ID;
  • Cost-of-attendance and packaging extracts that aggregate MONTHS_ENROLLED_NUM and CREDIT_POINTS_NUM by LD_CAL_TYPE to derive enrollment intensity.
  • Reconciliation reports comparing anticipated attendance attributes against actual enrollment, used to trigger award recalculation before disbursement.

Because the table is documented as obsolete and not implemented in many instances, queries should be preceded by a data dictionary check such as SELECT COUNT(*) FROM ALL_TAB_COLUMNS WHERE TABLE_NAME='IGF_AP_FA_ANT_DATA' before inclusion in production reporting.

Related Objects

Relationship data identifies the following principal foreign key targets and dependencies.

  • IGF_AP_FA_BASE_REC_ALL — Parent Financial Aid base record; joined on BASE_ID. This is the primary dependency.
  • IGS_CA_INST_ALL — Calendar instance; joined on LD_CAL_TYPE and LD_SEQUENCE_NUMBER to resolve the academic period.
  • IGS_EN_ATD_TYPE_ALL — Attendance type reference for ATTENDANCE_TYPE.
  • IGS_EN_ATD_MODE_ALL — Attendance mode reference for ATTENDANCE_MODE.
  • IGS_PS_TYPE_ALL — Program type reference for PROGRAM_TYPE.
  • IGS_PS_COURSE — Program definition for PROGRAM_CD.
  • IGS_AD_LOCATION_ALL — Location reference for PROGRAM_LOCATION_CD.
  • IGS_PR_CLASS_STD — Class standing reference for CLASS_STANDING.

These relationships confirm the table's role as a link between a financial aid base record and the institutional reference structures that define anticipated enrollment, and any dependency analysis or upgrade impact assessment should treat the parent base record table as the highest-priority relationship.