Results for “igf_ap_fa_ant_data_pk”
8 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.
- BASE_ID — Identifier of the parent Financial Aid Base Record. This is the principal business-key component and the primary link back to IGF_AP_FA_BASE_REC_ALL.
- LD_CAL_TYPE and LD_SEQUENCE_NUMBER — The load calendar type and sequence, identifying the academic period against which the anticipated data applies. Together with BASE_ID they constitute the unique business key.
- ATTENDANCE_TYPE and ATTENDANCE_MODE — Anticipated attendance classification and delivery mode (for example full-time, part-time, on-campus), referenced from IGS_EN_ATD_TYPE_ALL and IGS_EN_ATD_MODE_ALL respectively.
- PROGRAM_TYPE, PROGRAM_CD, and PROGRAM_LOCATION_CD — The anticipated program of study, its type, and the location at which it is delivered.
- CLASS_STANDING — The student's anticipated class standing (for example freshman, sophomore, graduate).
- RESIDENCY_STATUS_CODE and HOUSING_STATUS_CODE — Anticipated residency and housing status, both frequently used in cost-of-attendance calculations.
- MONTHS_ENROLLED_NUM and CREDIT_POINTS_NUM — Anticipated enrollment duration and credit load, central inputs to enrollment-intensity and award proration logic.
- PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE — Program application linkage and the associated program version, supporting traceability of the anticipated program record.
- ORG_UNIT_CD — The organizational unit responsible for the record.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and REQUEST_ID — Standard Oracle WHO columns and concurrent request context.
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.
-
Financial Aid Base Record Anticipated Data
-
Table: IGF_AP_FA_ANT_DATA 12.2.2
Financial Aid Base Record Anticipated Data
Not implemented in this database·Explore IGF module →
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - IGF Tables and Views 12.1.1
Holds pays only unit details for a pays only program
-
eTRM - IGF Tables and Views 12.1.1
Holds pays only unit details for a pays only program