Search Results dai_alias_val

Overview

The view APPS.IGS_FI_TP_RET_SCHD_V is a Student Retention and Fee Schedule inquiry view delivered within the Oracle E-Business Suite (EBS) Financials/Student Information components, specifically the IGS (Campus Solutions / Student System) schema family. It surfaces teaching-based retention schedule records held in the base entity IGS_FI_TP_RET_SCHD, which stores the relationship between a teaching calendar instance and the fee-related retention percentage or retention amount that applies to it. The view is defined over that single base table but enriches each row with a dynamically derived alias value, resolved at runtime by the PL/SQL function IGS_CA_GEN_001.CALP_GET_ALIAS_VAL. This dynamic column, exported as DAI_ALIAS_VAL, is the distinguishing feature of the view, and it is the reason queries referencing this object are often located by searching for the function name calp_get_alias_val.

In practical terms, the view presents retention schedule data in a form suitable for reporting and integration without requiring the caller to invoke the calendar alias API directly. It is exposed under the APPS schema and is therefore reachable through standard EBS responsibilities and custom reports. Because it carries the standard EBS WHO columns, it also supports audit and concurrent-program traceability. The object is relevant to 12.1.1 and 12.2.2 environments alike; the view definition and its dependency on IGS_CA_GEN_001 are unchanged between those releases.

Underlying Base Objects

According to the documented view metadata, the view is defined exclusively over a single base object:

• IGS_FI_TP_RET_SCHD — aliased as TPRS in the view text, the primary source of all retention schedule attributes.
• IGS_CA_GEN_001.CALP_GET_ALIAS_VAL — a database package function invoked in the select list, not a table. It accepts the date/time alias (DT_ALIAS), the alias sequence number (DAI_SEQUENCE_NUMBER), the teaching calendar type (TEACH_CAL_TYPE), and the teaching calendar sequence number (TEACH_CI_SEQUENCE_NUMBER), returning the resolved alias value.

No additional documented base objects are referenced. The view is a simple projection with a scalar function call, with no joins, unions, or aggregates. Consequently, its cardinality matches the underlying rows in IGS_FI_TP_RET_SCHD, and row-level filtering or joins against other calendar or fee entities must be supplied by the calling query.

Key Columns

• ROWID — pseudo-column identifying the physical row in the base table, usable for updates and debugging.
• FTCI_TEACH_RETENTION_ID — primary key of the retention schedule record.
• TEACH_CAL_TYPE / TEACH_CI_SEQUENCE_NUMBER — teaching calendar type and instance sequence number.
• FEE_CAL_TYPE / FEE_CI_SEQUENCE_NUMBER — fee calendar type and instance sequence number.
• FEE_TYPE — the fee classification to which the retention rule applies.
• DT_ALIAS / DAI_SEQUENCE_NUMBER — date/time alias code and alias sequence number.
• DAI_ALIAS_VAL — the resolved alias value returned by CALP_GET_ALIAS_VAL.
• RET_PERCENTAGE / RET_AMOUNT — the retention percentage and monetary retention amount.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical uses include retention schedule reporting, fee calculation reconciliation, and integration extracts that must supply the resolved alias value alongside the retention percentage or amount.

Listing retention rules for a teaching instance, including the resolved alias value:

• SELECT FTCI_TEACH_RETENTION_ID, TEACH_CAL_TYPE, TEACH_CI_SEQUENCE_NUMBER, FEE_TYPE, DT_ALIAS, DAI_ALIAS_VAL, RET_PERCENTAGE, RET_AMOUNT FROM APPS.IGS_FI_TP_RET_SCHD_V WHERE TEACH_CAL_TYPE = :p_cal_type AND TEACH_CI_SEQUENCE_NUMBER = :p_seq;

Extracting audit and alias information for reconciliation against concurrent program runs:

• SELECT REQUEST_ID, PROGRAM_ID, DAI_ALIAS_VAL, RET_AMOUNT FROM APPS.IGS_FI_TP_RET_SCHD_V WHERE PROGRAM_UPDATE_DATE >= :p_since;

Because DAI_ALIAS_VAL is computed per row through CALP_GET_ALIAS_VAL, queries returning large row sets should be filtered on calendar type or sequence number to limit function invocations and avoid unnecessary overhead. The view should be treated as read-only for reporting purposes; DML against retention schedules must target the base table through supported APIs.