Results for “chg_rate”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_FI_FEE_AS_RATE_F_TYPE_V is a database view historically shipped within the Oracle iGS (Student System) product family, a component of the Oracle E-Business Suite 12.1.1 and 12.2.2 application stacks. The view exposes assessment rate definitions for fee types, joining fee rate records to their fee category labels and to the owning organization party. In the ETRM documentation the object is classified under IGS – Student System (Obsolete) and carries the description "No longer used," with the accompanying DBA data noting that it is "Not implemented in this database." This means the view may still be present in a legacy installation but is not created or maintained by current AD deliverables, and Oracle does not support its use in new development, reporting, or integration.

The functional purpose is to present, per fee type and fee calendar instance, the applicable rate, unit class, attendance attributes, government contribution options, and the currency in which the rate is denominated. It is therefore an assessment-rate reference view rather than a transactional view, intended to support inquiry and downstream extracts of fee assessment configuration.

Underlying Base Objects

The view text is defined over three base objects:

The view is a UNION ALL of two structurally identical queries, the first filtering on FAR.S_RELATION_TYPE = 'FCFL' and excluding logically deleted rows (LOGICAL_DELETE_DT IS NULL), and the second covering the remaining relation types. Currency is not stored directly on the rate table; it is derived by calling the database function IGS_FI_GEN_001.FINP_GET_CURRENCY with the fee calendar type, calendar instance sequence, relation type, fee type, and fee category, truncated to fifteen characters and aliased CURRENCY_CD.

Key Columns

Because the user search term was currency_cd, that column is of principal interest. CURRENCY_CD is not a physical column of any base table; it is a computed expression returned by the FINP_GET_CURRENCY function. Any query filtering or joining on currency must account for the function call overhead and the SUBSTR(...,1,15) truncation.

Other significant columns include FEE_TYPE, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER, which identify the fee and its calendar instance; FEE_CAT from the label table; RATE_NUMBER, LOCATION_CD, ATTENDANCE_TYPE, ATTENDANCE_MODE, and ORDER_OF_PRECEDENCE; the government-related attributes GOVT_HECS_PAYMENT_OPTION and GOVT_HECS_CNTRBTN_BAND; CHG_RATE and UNIT_CLASS describing the charge; and the standard audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. Residency, course, version, class standing, unit set, and organization unit context are supplied by RESIDENCY_STATUS_CD, COURSE_CD, VERSION_NUMBER, CLASS_STANDING, UNIT_SET_CD, and ORG_UNIT_CD (derived from HZ_PARTIES.PARTY_NUMBER).

Common Use Cases and Queries

Typical legacy scenarios include verifying the currency in which a fee rate is assessed, auditing rate configuration across calendar instances, and extracting rate data for reporting on government contribution bands. The following sample illustrates a currency-oriented query:

  • SELECT fee_type, fee_cal_type, fee_ci_sequence_number, currency_cd, chg_rate FROM igs_fi_fee_as_rate_f_type_v WHERE currency_cd = 'AUD' ORDER BY fee_type, fee_cal_type;
  • SELECT fee_type, fee_cat, org_unit_cd, chg_rate FROM igs_fi_fee_as_rate_f_type_v WHERE logical_delete_dt IS NULL; — note that LOGICAL_DELETE_DT is used in the view definition but is not projected as an output column, so it cannot be referenced in an outer query.

Given the "No longer used" designation, these accesses should be treated as read-only reference queries against a legacy schema. New development should target supported Student System or Financials fee and charge objects instead of this view.