Results for “half_time_flag”

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

Overview

IGS_FI_1098T_LPS is a table in the IGS (Student System) product schema within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented description is "Stores Load Periods for 1098-T reporting requirements." The 1098-T form is the U.S. IRS tuition statement used by eligible educational institutions to report qualified tuition and related expenses, along with adjustments and scholarship or grant amounts, for enrolled students. Because eligibility for 1098-T reporting depends on a student's enrollment load (for example, full-time versus half-time) during defined reporting periods, this table persists the load-period definitions that drive that determination.

From a data-modeling perspective, the supplied metadata classifies this object heuristically as a link table. This is a modeling suggestion rather than a physical design attribute: the table functions as a join or association entity that connects tax-year reporting setup to academic calendar instances, carrying period-specific attributes as its payload. It is not the top-level 1098-T setup or student-level reporting hub, nor is it purely a descriptive satellite; it associates reference entities and repeats per reporting unit.

Key Information Stored

The table contains 12 documented columns. Its primary key is IGS_FI_1098T_LPS_PK, a composite key on TAX_YEAR_NAME, CAL_TYPE, and SEQUENCE_NUMBER. There is no separate single-column surrogate identifier; the three-column composite business key also serves as the enforced primary key and as the only documented unique index.

• TAX_YEAR_NAME — The reporting tax year for the load period, and the primary key's first column. It also acts as a foreign key to IGS_FI_1098T_SETUP, tying the period to that year's 1098-T configuration.
• CAL_TYPE — The academic calendar type (for example, the calendar designation used by the institution's enrollment or academic calendar records). It is both a primary key component and a foreign key to IGS_CA_INST_ALL.
• SEQUENCE_NUMBER — Ordinal that distinguishes multiple load periods under the same tax year and calendar type, completing the primary key.
• NEXT_ACAD_FLAG — Indicates whether a load period relates to the next academic period; used when determining which enrollment records qualify for the tax year being reported.
• HALF_TIME_FLAG — Indicates whether the period qualifies the student at half-time load status, a common threshold for 1098-T eligibility and reporting.
• GRAD_FLAG — Indicates a graduate-related qualification for the period, affecting how enrollment status is evaluated for reporting.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the application to detect concurrent updates.
• CREATED_BY / CREATION_DATE — Standard audit columns recording the creating user and creation timestamp.
• LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — Standard audit columns recording the most recent modification, its user, and the login session.

Common Use Cases and Queries

Typical usage centers on retrieving the load periods defined for a given tax year so that enrollment status and eligibility flags can be applied to 1098-T preparation. A representative query joins the setup table on TAX_YEAR_NAME to return periods for a specific reporting year:

• SELECT l.TAX_YEAR_NAME, l.CAL_TYPE, l.SEQUENCE_NUMBER, l.HALF_TIME_FLAG, l.GRAD_FLAG, l.NEXT_ACAD_FLAG FROM IGS.IGS_FI_1098T_LPS l WHERE l.TAX_YEAR_NAME = '2024' ORDER BY l.CAL_TYPE, l.SEQUENCE_NUMBER;
• Joining to IGS_CA_INST_ALL on CAL_TYPE to enrich periods with calendar-instance context for validation or reporting extracts.
• Filtering on HALF_TIME_FLAG or GRAD_FLAG to isolate periods used in at-half-time or graduate enrollment reporting logic.
• Reconciliation queries that verify sequence continuity within a tax year and calendar type, or that detect overlapping/duplicated period definitions.

Related Objects

The following objects are the most significant references recorded in the ETRM metadata:

• IGS_FI_1098T_SETUP — Referenced by TAX_YEAR_NAME; parent setup record for the tax year's 1098-T configuration.
• IGS_CA_INST_ALL — Referenced by CAL_TYPE and SEQUENCE_NUMBER; the academic calendar instance that the load period aligns to.
• IGS_FI_1098T_LPS_PK — The primary key constraint/index on TAX_YEAR_NAME, CAL_TYPE, SEQUENCE_NUMBER, enforcing uniqueness of load periods.
• IGS.IGS_FI_1098T_LPS — The table owner-qualified object itself, used in all direct DML and reporting SQL.