Search Results igs_fi_1098t_setup




Overview
Explore in AI Chat

Overview

The IGS_FI_1098T_SETUP table is a core configuration entity within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master control table for defining annual 1098-T Tuition Statement reporting requirements, as mandated by the U.S. Internal Revenue Service (IRS). This table acts as the central repository for the setup parameters that govern how the institution calculates, aggregates, and reports qualified tuition and related expenses for each tax year. Its role is foundational; the configurations stored here drive the entire 1098-T data generation and reporting process within the application.

Key Information Stored

The table's primary key structure centers on the tax year, ensuring unique setup per reporting period. The critical columns include TAX_YEAR_NAME and TAX_YEAR_CODE, which uniquely identify the reporting year. Another significant column is PERSON_ID_TYPE, which is a foreign key to IGS_PE_PERSON_ID_TYP. This defines the type of identifier (e.g., SSN, ITIN) to be used for reporting on the 1098-T forms. While the provided metadata does not list all columns, typical setup data in such a table would include flags for reporting methods (e.g., Box 1 vs. Box 2 reporting), institution-specific reporting thresholds, and control parameters for batch processing and form generation.

Common Use Cases and Queries

The primary use case is the annual configuration and review of 1098-T reporting rules before executing the population and printing processes. Administrators query this table to verify or update setup for the current tax year. Common SQL operations include retrieving the active setup for a specific year or validating the configured person identifier type.

  • Retrieve setup for a specific tax year: SELECT * FROM igs.igs_fi_1098t_setup WHERE tax_year_name = '2024';
  • Join with the person ID type description: SELECT s.*, t.description FROM igs.igs_fi_1098t_setup s, igs.igs_pe_person_id_typ t WHERE s.person_id_type = t.person_id_type AND s.tax_year_code = '2024';
  • Identify all configured tax years: SELECT tax_year_name, tax_year_code FROM igs.igs_fi_1098t_setup ORDER BY tax_year_code DESC;

Related Objects

The IGS_FI_1098T_SETUP table has a central, parent relationship with numerous child tables that store the detailed transactional data and processing records for 1098-T reporting. As per the documented foreign keys:

These relationships demonstrate that the TAX_YEAR_NAME from IGS_FI_1098T_SETUP is propagated throughout the 1098-T subsystem to tie all processed data and batches back to the specific annual configuration.