Search Results ftci_teach_retention_id




Overview
Explore in AI Chat

Overview

The view IGS_FI_TP_RET_SCHD_V belongs to the Oracle E-Business Suite product family IGS – Student System, a module now classified as obsolete in the ETRM documentation set for releases 12.1.1 and 12.2.2. The view exposes retention schedule information defined at the level of the teaching period. In the Oracle Student System fee model, retention schedules determine how much of a fee is retained (or refunded) when a student withdraws or otherwise changes status within a teaching period, expressed as either a percentage or an absolute amount. The view therefore acts as a reporting-friendly projection of the underlying retention schedule table, joining calendar and date-alias context so that consumers can interpret retention rules without writing their own lookups.

As documented, the object is marked "Not implemented in this database," meaning the view is defined in the ETRM repository but is not deployed in the reference environment. It is a reporting and integration artifact rather than a transactional entity, and is intended for read-only consumption by queries, reports, and interfaces that need retention percentages and amounts tied to teaching period calendars.

Underlying Base Objects

The view is defined over a single documented base table, IGS_FI_TP_RET_SCHD TPRS. The ETRM metadata records no additional referenced base objects. All columns are drawn directly from that table, with the exception of the derived column DAI_ALIAS_VAL, which is computed by the function IGS_CA_GEN_001.CALP_GET_ALIAS_VAL. This function resolves a date alias and sequence number within a specified teaching calendar type and calendar instance, returning the concrete alias value.

Because the view is a straightforward column projection plus one functional call, it preserves the row identity of the base table through TPRS.ROWID and inherits no aggregation or filtering. Its relationship to the base object is therefore one-to-one: each row of IGS_FI_TP_RET_SCHD yields exactly one row in the view.

Key Columns

Common Use Cases and Queries

Typical usage includes fee-refund reporting, retention rule validation, and integration extracts that feed external billing or student-finance systems. The following query lists retention schedules for a given teaching calendar instance:

  • SELECT ftci_teach_retention_id, teach_cal_type, teach_ci_sequence_number, fee_type, dt_alias, dai_alias_val, ret_percentage, ret_amount FROM igs_fi_tp_ret_schd_v WHERE teach_cal_type = :cal AND teach_ci_sequence_number = :seq ORDER BY dt_alias;

A second common pattern filters on the retention identifier to retrieve a single rule and its audit context:

  • SELECT ftci_teach_retention_id, fee_cal_type, fee_type, ret_percentage, ret_amount, last_update_date, last_updated_by FROM igs_fi_tp_ret_schd_v WHERE ftci_teach_retention_id = :retention_id;

Because the view performs no filtering, callers should always constrain queries on teaching calendar type, calendar instance, or fee type to avoid full scans of the underlying retention schedule table.