Results for “mult_factor_code”

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

Overview

IGF_AW_COA_RATE_DET_V is a reporting view within the Oracle E-Business Suite IGF (Financial Aid) product family. It exposes the detail rows of the Cost of Attendance (COA) Rate Table, a configuration structure used by financial aid administrators to define the per-unit and per-term rates applied when calculating a student's cost of attendance budget. The view is documented in the ETRM as "Cost of Attendance Rate Table Detail" under the IGF – Financial Aid (Obsolete) module designation.

The view is not a transactional entity in its own right; it is a read-oriented projection that denormalizes the rate detail table against the item master and the academic calendar instance tables. This design allows downstream reports, award packaging logic, and integration extracts to resolve item descriptions and calendar alternate codes without performing multi-table joins at the reporting layer. Because the module is flagged as obsolete, the view is retained primarily for historical reporting and for compatibility with legacy extracts; the documented metadata indicates it is not implemented in the reference database used to generate the ETRM entry.

Underlying Base Objects

The view text is defined over the following objects:

• IGF_AW_COA_RATE_DET RD — the primary Cost of Attendance rate detail table, supplying all rate-qualification attributes and the ROWID.
• IGF_AW_ITEM IT — the financial aid item master, joined on ITEM_CODE to supply IT.DESCRIPTION.
• IGS_CA_INST CA — the academic calendar instance table, joined on CI_CAL_TYPE and CI_SEQUENCE_NUMBER to supply the CI alternate code.
• IGS_CA_INST CALD — the same calendar instance table, outer-joined on LD_CAL_TYPE and LD_SEQUENCE_NUMBER to resolve the load calendar alternate code, permitting null load calendar references.

The CA join is inner, meaning a rate detail row is only visible when its cost-instance calendar exists. The CALD join is outer (+), so rows without a matching load calendar are still returned. Note that the ETRM documents no referenced base objects for this view and records it as "not implemented in this database," so the join behavior described here derives from the published view text.

Key Columns

• ROW_ID — the row identifier from the rate detail table, exposed via ROWID; useful for direct row addressing and reconciliation.
• CI_CAL_TYPE / CI_SEQUENCE_NUMBER / CI_ALTERNATE_CODE — the cost-instance academic calendar identity and its alternate (user-facing) code.
• ITEM_CODE / ITEM_DESCRIPTION — the financial aid item and its description from IGF_AW_ITEM.
• RATE_ORDER_NUM — the evaluation sequence when multiple rates could apply.
• PID_GROUP_CD, ORG_UNIT_CD — the person/identifier group and organizational unit qualifying the rate.
• PROGRAM_TYPE, PROGRAM_LOCATION_CD, PROGRAM_CD — program-level qualifiers restricting rate applicability.
• CLASS_STANDING — the academic standing (for example, freshman, sophomore) to which the rate applies.
• RESIDENCY_STATUS_CODE — residency classification used to differentiate in-state and out-of-state rates.
• HOUSING_STATUS_CODE — the housing classification (for example, on-campus, off-campus, or with parents) that drives distinct COA components.
• ATTENDANCE_TYPE, ATTENDANCE_MODE — attendance qualifiers such as full-time/part-time and delivery mode.
• LD_CAL_TYPE, LD_SEQUENCE_NUMBER, LD_ALTERNATE_CODE — the load calendar identity and its alternate code, resolved through the outer join.
• MULT_FACTOR_CODE, MULT_AMOUNT_NUM — the multiplier factor and amount applied to the item base rate.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical uses include auditing rate table configuration before an award cycle, extracting rate matrices for data warehouse loads, and troubleshooting why a particular COA component resolved to an unexpected amount. Because HOUSING_STATUS_CODE was the search term of interest, the following query returns all rate detail rows for a given housing classification alongside the item and calendar context:

• SELECT item_code, item_description, ci_alternate_code, program_cd, class_standing, residency_status_code, housing_status_code, attendance_type, mult_factor_code, mult_amount_num
• FROM igf_aw_coa_rate_det_v
• WHERE housing_status_code = :p_housing_status
• ORDER BY rate_order_num, item_code;

A second common pattern enumerates the distinct housing and residency combinations configured for a program, supporting validation that no qualification gap exists:

• SELECT DISTINCT program_cd, housing_status_code, residency_status_code, class_standing
• FROM igf_aw_coa_rate_det_v
• WHERE program_cd = :p_program_code;

Because the module is obsolete, queries should be treated as read-only reporting statements and verified against the owning base tables in environments where the view has been dropped or is unavailable.