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.
- 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 →
-
View: IGF_AP_FA_ANT_DATA_V 12.1.1
Financial Aid Base Record Anticipated Data View
APPS.IGF_AP_FA_ANT_DATA_V·↳ IGF_AP_FA_ANT_DATA·↳ IGS_CA_INST·Explore IGF module →
-
Table: IGS_PR_CLASS_STD 12.2.2
Maintains the institution defined Class Standing set-up values
Not implemented in this database·Explore IGS module →
-
Table: IGS_EN_ATD_MODE_ALL 12.2.2
Describes available university program attendance modes
Not implemented in this database·Explore IGS module →
-
Table: IGS_PS_COURSE 12.2.2
This entity describes the programs which are offered by the university, covering both award and non-award programs.
Not implemented in this database·Explore IGS module →
-
View: IGF_AP_FA_ANT_DATA_V 12.2.2
Financial Aid Base Record Anticipated Data View
Not implemented in this database·Explore IGF module →
-
Table: IGS_EN_ATD_TYPE_ALL 12.2.2
Describes available university program attendance types
Not implemented in this database·Explore IGS module →
-
Table: IGS_AD_LOCATION_ALL 12.2.2
Describes available geographic locations at which programs and units may be offered or taught
Not implemented in this database·Explore IGS module →
-
Holds the summarized information of all the financial aid processes for a student for an academic year
Not implemented in this database·Explore IGF module →
-
Table: IGS_PS_TYPE_ALL 12.2.2
This entity describes the university set of program types. This set is not limited to the DEET set and values, which are reported to DEET, will be mapped onto DEET equivalent values.
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGF_AP_GEN_001 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
PACKAGE: APPS.IGF_AW_COA_GEN 12.1.1
-
12.1.1 DBA Data 12.1.1