Search Results adjusted_gross_amt

Overview

IGF.IGF_AP_LI_CSS_INTS is a public, active interface table in the Oracle E-Business Suite IGF schema (Financial Aid / Student Aid product family), shipped in both 12.1.1 and 12.2.2. Its documented purpose is to hold profile data uploaded into the system through the Legacy Profile Import Process, described in ETRM as a "Legacy - PROFILE Import Process using Legacy Interface Tables." The table is a wide, staging-oriented structure — 719 documented columns — that persists raw records extracted from a College Board CSS PROFILE submission, including student demographics, income and asset figures, institutional budgets, FNAR computation messages, and calculated need analysis values, prior to validation and promotion into the application tables.

The table lives in the APPS_TS_INTERFACE tablespace with 10 percent PCTFREE, a standard placement that signals bulk load and batch processing rather than transactional OLTP activity. Records are staged by BATCH_NUM so that a set of rows can be processed, reported on, or purged as a unit. The mined relationship structure suggests a satellite-leaning Data Vault classification, since the table is anchored to a single batch identifier via a foreign key rather than forming a many-to-many hub-link pattern. Modeling note: the batch reference behaves more like a parent grouping than a true hub, so the structure can reasonably be treated as a satellite containing descriptive PROFILE attributes keyed to a batch parent.

Key Information Stored

The surrogate primary key is CSSINT_ID, enforced by unique index IGF_AP_LI_CSS_INTS_PK; no alternate unique index is documented, so CSSINT_ID is the only documented business-key candidate. Columns central to the user's search term and to any need-analysis query include:

• ADJUSTED_GROSS_AMT — the adjusted gross income figure reported for the student on the CSS PROFILE; this is the column directly relevant to the searched term, and its parent-side counterpart is P_ADJUSTED_GROSS_INC_AMT.
• BATCH_NUM — batch identifier used to isolate a processing set; documented foreign key to IGF.IGF_AP_LI_BAT_INTS.
• CSSINT_ID — unique per-row identifier and primary key.
• PERSON_NUMBER — the student identifier used to align imported data with the person record.
• COLLEGE_CD and ACADEMIC_YEAR_TXT — the receiving institution and the aid year the record is valid for.
• STU_RECORD_TYPE and CSS_ID_NUMBER_TXT — record classification and the CSS PROFILE record identifier.
• ORIGINAL_FNAR_COMPUTE_TXT and REVISION_FNAR_COMPUTE_DATE — derived Original and Revision FNAR output and its compute date.
• P_ADJUSTED_GROSS_INC_AMT, P_PRIOR_AGI_AMT — custodial parent AGI variants used in the Federal Methodology and Institutional Methodology need formulas.
• IM_P_BAS_AGI_TAXABLE_AMT, IM_P_OPT_AGI_TAX_INCOME_AMT — Institutional Methodology parent AGI under baseline and optimized analyses.
• FM_P_AGI_TAXABLE_INCOME_AMT — Federal Methodology parent AGI-taxable income.
• IM_S_BAS_AGI_TAX_INCOME_AMT, IM_S_EST_AGI_TAX_INCOME_AMT — student-side Institutional Methodology AGI variants.
• IM_P_BAS_AVAIL_INCOME_AMT, FM_P_AVAIL_INCOME_AMT — available income derived downstream from the AGI figures.
• IM_INST_1_EST_FINAN_NEED_AMT — institutional budget level estimated financial need.
• IMPORT_STATUS_TYPE — processing status for the staged row.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_ID — standard concurrent-program audit columns for import traceability.