Results for “igs_fi_fee_as_items”

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

Overview

IGS_FI_FEE_AS_ITEMS is a transactional table within the Oracle E-Business Suite Student System (IGS) product family. It stores an itemized list of assessment items that have contributed to a student's fee assessment. Each row represents an individual charge component — a fee element, course or unit charge, or adjustment — that the assessment engine has evaluated and applied during the assessment calculation process. The table functions as the granular detail layer beneath the aggregated assessment header, allowing institutions to audit exactly which rules, units, and charge elements produced a given assessed amount.

Within the IGS schema, the table is heavily referenced by downstream detail structures, most notably IGS_FI_FAI_DTLS, which records the application of individual formula items. Its wide foreign-key footprint (linking to unit sets, unit types, unit classes, unit modes, unit levels, rules, and party records) reflects its position as the intersection of fee assessment logic and institutional academic structure.

From a heuristic Data Vault modeling perspective, the table's FK structure suggests a satellite-leaning classification. Its business key comprises a composite of assessment context attributes (transaction, person, fee type, fee category, calendar, course, location, and organization unit), with an additional surrogate unique index on FEE_ASS_ITEM_ID.

Key Information Stored

The documented physical schema (ETRM 12.1.1) contains 50 columns. The most operationally significant include:

• FEE_ASS_ITEM_ID — The surrogate primary key, backed by unique index IGS_FI_FEE_AS_ITEMS_U1. This is the value users search for when cross-referencing assessment items.
• TRANSACTION_ID and PERSON_ID — The assessment transaction and student (party) identifiers forming the core linkage to IGS_FI_FEE_AS_ALL and HZ_PARTIES.
• FEE_TYPE, FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER — Fee definition, category, and calendar instance context.
• COURSE_CD, CRS_VERSION_NUMBER, UNIT_CD, UNIT_VERSION_NUMBER — Academic course and unit identifiers for which the charge was assessed.
• AMOUNT, CHG_RATE, CHG_ELEMENTS — The assessed monetary value, the rate applied, and the charge element definition.
• STATUS and LOGICAL_DELETE_DATE — Assessment item status and soft-delete tracking.
• ORG_UNIT_CD, LOCATION_CD, UOO_ID — Organizational and location context for the assessment.
• UNIT_SET_CD, UNIT_TYPE_ID, UNIT_CLASS, UNIT_MODE, UNIT_LEVEL — Academic structural attributes resolving against IGS_EN_UNIT_SET_ALL, IGS_PS_UNIT_TYPE_LVL, IGS_AS_UNIT_CLASS_ALL, IGS_AS_UNIT_MODE, and IGS_PS_UNIT_LEVEL_ALL.
• SCOPE_RUL_SEQUENCE_NUM, RUL_SEQUENCE_NUMBER — The assessment rule(s) responsible for generating the item.
• INVOICE_ID — Links the assessment item to the resulting fee invoice.

The business-key candidate IGS_FI_FEE_AS_ITEMS_U2 is a composite unique index spanning TRANSACTION_ID, PERSON_ID, FEE_TYPE, FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, COURSE_CD, CRS_VERSION_NUMBER, LOCATION_CD, UOO_ID, and ORG_UNIT_CD.

Common Use Cases and Queries

Typical reporting and reconciliation scenarios include auditing a student's itemized fee assessment, tracing a specific charge back to the rule and charge element that produced it, and reconciling assessment items against generated invoices. A frequently executed query retrieves all items for a given assessment transaction:

SELECT fee_ass_item_id, person_id, fee_type, fee_cat, amount, chg_rate, unit_cd, scope_rul_sequence_num FROM igs_fi_fee_as_items WHERE transaction_id = :p_transaction_id AND person_id = :p_person_id AND logical_delete_date IS NULL;

Because the surrogate key FEE_ASS_ITEM_ID is the unique-indexed identifier, ad-hoc lookups by that column are efficient:

SELECT * FROM igs_fi_fee_as_items WHERE fee_ass_item_id = :p_fee_ass_item_id;

Additional use cases include reconciliation of assessed amounts against INV_INVOICE lines via INVOICE_ID, drill-down reporting from the parent assessment header, and analytical summarization of assessed fees by fee type, organization unit, or residency status.

Related Objects

• IGS_FI_FEE_AS_ALL — The parent assessment header, joined on PERSON_ID (and TRANSACTION_ID), providing the summarized assessment context.
• HZ_PARTIES — The trading community party (student) record, joined via PERSON_ID.
• IGS_FI_FAI_DTLS — The detail table storing formula application line items; references IGS_FI_FEE_AS_ITEMS via FEE_ASS_ITEM_ID.
• IGS_EN_UNIT_SET_ALL — Unit set definition, joined on UNIT_SET_CD and US_VERSION_NUMBER.
• IGS_PS_UNIT_TYPE_LVL — Unit type level definition, joined on UNIT_TYPE_ID.
• IGS_AS_UNIT_CLASS_ALL — Unit classification, joined on UNIT_CLASS.
• IGS_AS_UNIT_MODE — Unit mode definition, joined on UNIT_MODE.
• IGS_PS_UNIT_LEVEL_ALL — Unit level definition, joined on UNIT_LEVEL.
• IGS_RU_RULE — Assessment rule definition, joined on SCOPE_RUL_SEQUENCE_NUM.

These relationships establish the table as the central residual of the fee assessment model, capable of being queried both upward toward the assessment header and outward toward academic and rule definitions.