Search Results igs_he_fte_cal_prd_u1

Overview

IGS.IGS_HE_FTE_CAL_PRD is a transactional configuration table within the Oracle E-Business Suite IGS (Intelligent Graduate System / Higher Education) schema. Its documented purpose is to store Full-Time Equivalent (FTE) calculation setup data, associating an academic calendar period with the default teaching calendar used to derive FTE figures for that period. The table sits on the configuration side of the FTE subsystem rather than the transactional results side: it defines which calendar periods participate in FTE calculation and which teaching calendar supplies the reference load, not the computed FTE values themselves.

The table is created in the APPS_TS_TX_DATA tablespace with PCTFREE 10, consistent with an application-owned transactional configuration object rather than a reference or interface table. Heuristic Data Vault classification of this object is hub-leaning. In Data Vault terms, (FTE_CAL_TYPE, FTE_SEQUENCE_NUM) functions as a business key that identifies a single FTE calculation period, and dependent descriptive attributes such as TEACH_CAL_TYPE and TEACH_SEQUENCE_NUM would naturally be modelled as satellite attributes attached to that hub. This is a modeling suggestion only; in the physical EBS schema the data is denormalized into a single table.

Key Information Stored

The table contains nine documented columns. The most significant are:

• FTE_CAL_TYPE (VARCHAR2(10)) — the academic calendar period for which FTE is to be calculated. This is the primary business identifier of the row.
• FTE_SEQUENCE_NUM (NUMBER) — the academic calendar sequence number for which FTE is calculated. This is the column most frequently referenced by external queries.
• TEACH_CAL_TYPE (VARCHAR2(10)) — the default teaching calendar associated with the FTE calculation period.
• TEACH_SEQUENCE_NUM (NUMBER) — the sequence number of the default teaching calendar associated with the FTE calculation period.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS Who columns, providing auditability and enabling incremental extraction by date.

The documented primary key is IGS_HE_FTE_CAL_PRD_PK on (FTE_CAL_TYPE, FTE_SEQUENCE_NUM). A unique index, IGS_HE_FTE_CAL_PRD_U1, is defined on the identical column pair in the APPS_TS_TX_IDX tablespace. Because the primary key and the unique business key are the same columns, there is no separate system-generated surrogate key here: the natural key is the identifier, and FTE_SEQUENCE_NUM is therefore essential rather than incidental. The calendar type and sequence number pair should always be supplied together in queries, since the same calendar type may legitimately repeat across many sequence numbers.

Common Use Cases and Queries

The primary reporting scenario is resolving which teaching calendar underpins an FTE calculation for a given academic period. A representative query joining period setup to dependent FTE property rows is:

• SELECT p.FTE_CAL_TYPE, p.FTE_SEQUENCE_NUM, p.TEACH_CAL_TYPE, p.TEACH_SEQUENCE_NUM FROM IGS.IGS_HE_FTE_CAL_PRD p WHERE p.FTE_CAL_TYPE = :cal_type AND p.FTE_SEQUENCE_NUM = :seq_num;
• SELECT pr.FTE_CAL_TYPE, pr.FTE_SEQUENCE_NUM, pr.TEACH_CAL_TYPE FROM IGS.IGS_HE_FTE_PROPRT pr, IGS.IGS_HE_FTE_CAL_PRD p WHERE pr.FTE_CAL_TYPE = p.FTE_CAL_TYPE AND pr.FTE_SEQUENCE_NUM = p.FTE_SEQUENCE_NUM;
• SELECT * FROM IGS.IGS_HE_FTE_CAL_PRD WHERE LAST_UPDATE_DATE >= :incremental_date;

Typical uses include configuring a new academic year's FTE setup, auditing which teaching calendar was defaulted for historic periods, and validating that every FTE calculation period has a corresponding teaching calendar definition before running FTE batch processes. Because the table is small and configuration-oriented, full extracts are inexpensive; incremental extracts keyed on LAST_UPDATE_DATE are appropriate for data-warehouse loads.

Related Objects

• IGS.IGS_HE_FTE_PROPRT — the most significant dependent object and the only documented foreign key relationship. It references this table via FTE_CAL_TYPE and FTE_SEQUENCE_NUM, and holds FTE property data defined per calculation period.
• APPS.IGS_HE_FTE_CAL_PRD — the APPS-layer synonym or view, which is the recommended access point for application and reporting SQL rather than querying the IGS base table directly.
• FTE_CAL_TYPE and TEACH_CAL_TYPE calendar reference objects — the calendar type and sequence columns imply reference to the IGS calendar definitions used across the product, providing the descriptive calendar names and date boundaries.
• Standard Who column audit queries — used in conjunction with FND audit facilities against CREATED_BY / LAST_UPDATED_BY.

No database objects are documented as being referenced by IGS_HE_FTE_CAL_PRD; the dependency direction flows outward to dependent configuration and property tables.