Search Results year_of_program

Overview

IGS_HE_FTE_PROPRT is a table within the IGS — Student System product family, which Oracle classifies as obsolete in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The table is documented in the ETRM repository with the description "To hold FTE calendar proportions." Its purpose is to store the proportional weighting applied to full-time-equivalent (FTE) calendar periods, enabling the Student System to attribute FTE counts across defined calendar types, career-and-program-instance combinations, and academic years. This kind of proportion record underpins calculations such as pro-rating a student's workload across overlapping or partial calendar periods.

An important documented caveat is that the object is not implemented in the reference database ("Not implemented in this database"). This typically indicates that the table is a legacacy or seed-only definition, present in the data dictionary definition set but never physically created in a particular environment because the corresponding Student System functionality was never licensed, installed, or migrated. From a modeling standpoint, the metadata's heuristic Data Vault classification is satellite-leaning, suggesting the table behaves as a descriptive satellite — storing measured attributes (notably proportions) attached to a business key rather than acting as a hub of unique entities or a link resolving relationships between hubs.

Key Information Stored

The documented physical schema contains twelve columns. The primary key is IGS_HE_FTE_PROPRT_PK, comprising five columns: FTE_CAL_TYPE, FTE_SEQUENCE_NUM, CAL_TYPE, CI_SEQUENCE_NUMBER, and YEAR_OF_PROGRAM. A single unique index, IGS_HE_FTE_PROPRT_U1, covers the identical column set, so the primary key also serves as the business-key candidate — there is no distinct surrogate key column in the documented schema.

• FTE_CAL_TYPE — the FTE calendar type that anchors the record; also the leading foreign key column.
• FTE_SEQUENCE_NUM — sequence number qualifying the FTE calendar period; paired with FTE_CAL_TYPE in the foreign key to IGS_HE_FTE_CAL_PRD.
• CAL_TYPE — the (ordinary) calendar type to which the proportional weighting applies.
• CI_SEQUENCE_NUMBER — sequence number for the career/instance context of the proportion.
• YEAR_OF_PROGRAM — the academic year of the program to which the proportion belongs.
• FTE_PERC — the FTE percentage or proportion value, the principal payload of the table.
• CLOSED_IND — indicator of whether the proportion record is closed for further maintenance.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns tracking who created and last modified each row and when.

The combination of the five key columns with FTE_PERC defines the essential fact: for a given FTE calendar period and academic program year, which calendar type receives what proportion of the FTE total.

Common Use Cases and Queries

Because the table is obsolete and not implemented, real-world querying is primarily diagnostic or migration-oriented. Typical investigative patterns include confirming existence, verifying column definitions, and examining dependency metadata:

• Existence check: select table_name from all_tables where table_name = 'IGS_HE_FTE_PROPRT' and owner = 'IGS'; returns no rows in environments where the object was never created.
• Definition review: query all_tab_columns from the IGS owner to confirm the twelve documented columns and their datatypes.
• Proportion reporting (where implemented): join IGS_HE_FTE_PROPRT to IGS_HE_FTE_CAL_PRD on FTE_CAL_TYPE and FTE_SEQUENCE_NUM, filter by YEAR_OF_PROGRAM and CI_SEQUENCE_NUMBER, and aggregate FTE_PERC by CAL_TYPE to reconcile the FTE distribution across calendar periods.
• Data quality validation: check FTE_PERC totals per (FTE_CAL_TYPE, FTE_SEQUENCE_NUM, YEAR_OF_PROGRAM, CI_SEQUENCE_NUMBER) group to confirm proportions sum to the expected base.
• Retirement assessment: identify remaining dependencies before decommissioning legacy Student System objects.

Reports that depend on FTE proportionalization — workload summaries, funding-eligibility extracts, and enrollment census reporting — would consume FTE_PERC, but only in installations where the table was actually built.

Related Objects

The documented foreign key relationship identifies IGS_HE_FTE_CAL_PRD as the parent reference table. IGS_HE_FTE_PROPRT.FTE_CAL_TYPE and IGS_HE_FTE_PROPRT.FTE_SEQUENCE_NUM point to the corresponding calendar period definition in IGS_HE_FTE_CAL_PRD. The PK/unique index dependency means the referenced combination must exist before proportion rows can be inserted.

• IGS_HE_FTE_CAL_PRD — the primary related object, supplying valid FTE calendar periods through the composite foreign key.
• IGS_HE_FTE_CAL_PRD (same table, alternate role) — also the source of period-level attributes used when validating YEAR_OF_PROGRAM and CAL_TYPE context.
• The broader IGS_HE_* family of FTE and calendar tables — including FTE calendar and period definitions — forms the surrounding schema within the obsolete Student System module.
• Standard Oracle EBS concurrent program and report definitions that reference the IGS schema, which will fail resolution if invoked against an environment lacking this object.

Because IGS as a product is documented as obsolete, integrators should treat IGS_HE_FTE_PROPRT, IGS_HE_FTE_CAL_PRD, and associated FTE calendar objects as deprecated, using the ETRM definitions solely for upgrade impact analysis and historical data archival rather than for new development.