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.

  • Table: IGS_FI_1098T_SETUP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_1098T_SETUP,  object_name:IGS_FI_1098T_SETUP,  status:VALID,  product: IGS - Student System ,  description: Stores 1098-T reporting requirements setup information ,  implementation_dba_data: IGS.IGS_FI_1098T_SETUP , 

  • Table: IGS_FI_1098T_SFTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_1098T_SFTS,  object_name:IGS_FI_1098T_SFTS,  status:VALID,  product: IGS - Student System ,  description: Stores those System Fund Types, which would be considered as 1098-T scholarships or grants. ,  implementation_dba_data: IGS.IGS_FI_1098T_SFTS , 

  • Table: IGS_FI_1098T_BATCHS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_1098T_BATCHS,  object_name:IGS_FI_1098T_BATCHS,  status:VALID,  product: IGS - Student System ,  description: Stores information regarding the Filing reported to the Internal Revenue Service ,  implementation_dba_data: IGS.IGS_FI_1098T_BATCHS , 

  • Table: IGS_PE_PERSON_ID_TYP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_PERSON_ID_TYP,  object_name:IGS_PE_PERSON_ID_TYP,  status:VALID,  product: IGS - Student System ,  description: This entity describes the type of person ids which may be attributed to a person. eg. OLAA id, VTAC id, old id. ,  implementation_dba_data: IGS.IGS_PE_PERSON_ID_TYP , 

  • Table: IGS_FI_1098T_FTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_1098T_FTS,  object_name:IGS_FI_1098T_FTS,  status:VALID,  product: IGS - Student System ,  description: Stores Qualified Tuition and related expense Fee Types for 1098-T reporting requirements ,  implementation_dba_data: IGS.IGS_FI_1098T_FTS , 

  • Table: IGS_FI_1098T_ATS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_1098T_ATS,  object_name:IGS_FI_1098T_ATS,  status:VALID,  product: IGS - Student System ,  description: Stores those Attendance Types which are considered as half time attendance types for 1098-T reporting requirements ,  implementation_dba_data: IGS.IGS_FI_1098T_ATS , 

  • Table: IGS_FI_1098T_LPS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_1098T_LPS,  object_name:IGS_FI_1098T_LPS,  status:VALID,  product: IGS - Student System ,  description: Stores Load Periods for 1098-T reporting requirements ,  implementation_dba_data: IGS.IGS_FI_1098T_LPS , 

  • Table: IGS_FI_1098T_DATA 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_1098T_DATA,  object_name:IGS_FI_1098T_DATA,  status:VALID,  product: IGS - Student System ,  description: Stores 1098-T tuition statement details, used for reporting to the Internal Revenue Service ,  implementation_dba_data: IGS.IGS_FI_1098T_DATA , 

  • Table: IGS_FI_1098T_PTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_1098T_PTS,  object_name:IGS_FI_1098T_PTS,  status:VALID,  product: IGS - Student System ,  description: Stores those Program Types which would be considered Graduate Level programs for 1098-T reporting requirements ,  implementation_dba_data: IGS.IGS_FI_1098T_PTS , 

  • View: IGSFV_PARTY_CHARGES 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PARTY_CHARGES,  object_name:IGSFV_PARTY_CHARGES,  status:VALID,  product: IGS - Student System ,  description: Contains details of charges for a person ,  implementation_dba_data: APPS.IGSFV_PARTY_CHARGES , 

  • View: IGSFV_PARTY_CREDITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PARTY_CREDITS,  object_name:IGSFV_PARTY_CREDITS,  status:VALID,  product: IGS - Student System ,  description: Stores all Party Credits in Student Finance ,  implementation_dba_data: APPS.IGSFV_PARTY_CREDITS ,