Results for “extract_date”

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

Overview

The IGS_FI_1098T_DATA table is a component of the Oracle E-Business Suite Student System (IGS) module, which is classified as obsolete in Oracle EBS 12.1.1 and 12.2.2. The table stores 1098-T tuition statement details, which are used for reporting tuition-related information to the Internal Revenue Service (IRS). In the EBS context, this table served as the master record-holder for individual student 1098-T statements generated during a tax year, capturing both the student's identity and the financial amounts reported on the statement.

Based on the foreign key relationships, the heuristic Data Vault classification for this table is satellite-leaning. Its primary key (STU_1098T_ID) is a surrogate key, and the table's columns describe descriptive attributes surrounding a student statement rather than representing an independent business entity on its own. This suggests a satellite structure anchored to the student party and tax-year setup entities. Note that ETRM records indicate this table is not implemented in the reference database, consistent with the obsolescence of the IGS financial aid 1098-T reporting feature.

Key Information Stored

The table contains 47 documented columns. The most significant are listed below:

• STU_1098T_ID — Surrogate primary key (IGS_FI_1098T_DATA_PK), unique per 1098-T statement record.
• TAX_YEAR_NAME — The reporting tax year; foreign key to IGS_FI_1098T_SETUP.
• PARTY_ID — Foreign key referencing HZ_PARTIES, identifying the student/party.
• PARTY_NAME / STU_NAME_CONTROL / TAXID — Student identity attributes including name and taxpayer identifier.
• BILLED_AMT, ADJ_AMT, FIN_AID_AMT, FIN_AID_ADJ_AMT — The core tuition and financial-aid amounts reported on the IRS statement.
• PAYMENT_AMT, REFUND_AMT — Payment and refund totals associated with the statement.
• NEXT_ACAD_FLAG, HALF_TIME_FLAG, GRAD_FLAG — Reporting indicators for academic period, enrollment status, and graduation.
• IRS_FILED_FLAG, CORRECTION_FLAG, CORRECTION_TYPE_CODE, STMNT_PRINT_FLAG — Filing and correction status indicators.
• BATCH_ID — Groups statements into a processing/extract run.
• EXTRACT_DATE, FILE_NAME, STATUS_CODE, ERROR_CODE — Extract processing metadata.

Address fields (ADDRESS1–ADDRESS4, CITY, STATE, POSTAL_CODE, COUNTRY, etc.) and standard EBS WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_ID) are also present.

Common Use Cases and Queries

In deployments where this table was active, the primary use cases centered on IRS 1098-T generation and reconciliation. Typical patterns include:

• Retrieving all statements for a tax year: SELECT * FROM IGS_FI_1098T_DATA WHERE TAX_YEAR_NAME = :year;
• Reconciling a batch: SELECT BATCH_ID, COUNT(*) FROM IGS_FI_1098T_DATA GROUP BY BATCH_ID;
• Identifying unfiled or corrected statements: SELECT * WHERE IRS_FILED_FLAG = 'N' OR CORRECTION_FLAG = 'Y';
• Joining to party data for student lookups: ... JOIN HZ_PARTIES hp ON hp.PARTY_ID = d.PARTY_ID;

Related Objects

• IGS_FI_1098T_SETUP — Joined on TAX_YEAR_NAME; provides tax-year configuration.
• HZ_PARTIES — Joined on PARTY_ID; supplies party/student identity.
• IGS_FI_1098T_DTLS — Child detail table referencing this table via STU_1098T_ID.
• IGS_FI_1098T_DATA_PK — Unique index/primary key constraint on STU_1098T_ID.

Because the module is obsolete, replacement or archival strategies should be considered for current EBS implementations.