Search Results fte_perc

Overview

IGS.IGS_HE_FTE_PROPRT is a transactional table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 product family known as iGS (Intelligent Grants System / Higher Education). It holds Financially Responsible Time Equivalency (FTE) calendar proportions — that is, the percentage contribution that each academic calendar makes toward a total FTE calculation for a given student program year. The table therefore supports the rules engine used to determine how full-time-equivalent enrollment is apportioned across multiple academic calendars (for example, a semester-based calendar, a quarter-based calendar, or an overlapping program calendar).

From a modeling perspective, the metadata provided yields a heuristic Data Vault classification of satellite-leaning. This suggests the table stores descriptive, time-attributed attributes (proportion percentages and Who columns) that depend on one or more parent business keys, rather than acting as an independent hub or a relationship link. In practice, the primary key columns anchor the key structure, while columns such as FTE_PERC, CLOSED_IND, and the standard Who columns behave as satellite attributes. This classification should be treated as a modeling suggestion, not a declared Oracle design.

Key Information Stored

The table contains 12 documented columns. The most significant are summarized below.

• FTE_CAL_TYPE — the academic calendar for which FTE is to be calculated; part of the primary key and a foreign key to IGS_HE_FTE_CAL_PRD.
• FTE_SEQUENCE_NUM — the sequence number of that FTE calendar; also a key column.
• CAL_TYPE — the academic calendar type contained within the FTE calculation period.
• CI_SEQUENCE_NUMBER — the academic calendar type sequence number.
• YEAR_OF_PROGRAM — the year of program for which the FTE calculation applies.
• FTE_PERC — the percentage contribution of the referenced academic calendar to the overall FTE calculation. This is the column behind the user's search term "fte_perc."
• CLOSED_IND — a closed indicator that flags whether the proportion record is active or retired.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the five standard Oracle "Who" columns that audit record creation and modification.

The surrogate-level primary key is IGS_HE_FTE_PROPRT_PK, defined over FTE_CAL_TYPE, FTE_SEQUENCE_NUM, CAL_TYPE, CI_SEQUENCE_NUMBER, and YEAR_OF_PROGRAM. The unique index IGS_HE_FTE_PROPRT_U1 shares the same column set, making it the principal business-key candidate. No separate numeric surrogate column exists; the composite key itself serves as the access path.

Common Use Cases and Queries

Typical uses include FTE proportion validation, reporting on how program years are apportioned across calendars, and integration with iGS FTE calculation batches. A common pattern is to filter active proportions for a given FTE calendar and program year:

• Proportion lookup by calendar and year: select FTE_PERC alongside FTE_CAL_TYPE and YEAR_OF_PROGRAM, filtering on CLOSED_IND to exclude retired rows.
• Sum validation: aggregate FTE_PERC by FTE_CAL_TYPE, FTE_SEQUENCE_NUM, and YEAR_OF_PROGRAM to confirm the contributions total the expected 100 percent.
• Audit reporting: select LAST_UPDATED_BY and LAST_UPDATE_DATE to trace changes to proportion records.

The canonical query text — SELECT CAL_TYPE, CI_SEQUENCE_NUMBER, YEAR_OF_PROGRAM, FTE_CAL_TYPE, FTE_SEQUENCE_NUM, FTE_PERC, CLOSED_IND and the Who columns FROM IGS.IGS_HE_FTE_PROPRT — remains the best starting point for any custom extract.

Related Objects

• IGS_HE_FTE_CAL_PRD — referenced by the FTE_CAL_TYPE foreign key; the parent calendar period definition for FTE calculation.
• APPS.IGS_HE_FTE_PROPRT — the APPS synonym/view layer through which the majority of runtime queries and forms access this table; listed as a dependent reference.

The documented dependency footprint is intentionally narrow: the table references only the FTE calendar period object and is referenced by the APPS synonym. Consumers should therefore join primarily to IGS_HE_FTE_CAL_PRD on FTE_CAL_TYPE (and FTE_SEQUENCE_NUM) when navigating from proportion to calendar context.