Search Results aitm_uk

Overview

The IGS_FI_FEE_AS_ITEMS table is a core data entity within the Oracle E-Business Suite (EBS) Student System (IGS). It functions as a detailed line-item repository for student fee assessments. Its primary role is to store the granular, itemized breakdown of the specific academic components—such as units, unit sets, and fee rules—that have been evaluated and aggregated to form a student's total financial assessment. This table provides the essential audit trail and detail behind summarized assessment totals, enabling detailed analysis, reporting, and reconciliation of student fees.

Key Information Stored

The table's structure captures the linkage between a financial transaction and the academic items assessed. Its primary key (AITM_UK) is a composite key combining the transaction identifier (TRANSACTION_ID) with student (PERSON_ID) and fee definition details (FEE_TYPE, FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER), and specific academic context (COURSE_CD, CRS_VERSION_NUMBER, LOCATION_CD, UOO_ID, ORG_UNIT_CD). A surrogate primary key, FEE_ASS_ITEM_ID, is also defined. Critical columns include UNIT_SET_CD and US_VERSION_NUMBER for unit sets, UNIT_TYPE_ID, UNIT_CLASS, UNIT_MODE, and UNIT_LEVEL for unit details, and SCOPE_RUL_SEQUENCE_NUM and ELM_RNG_ORDER_NAME for linking to the rule engine (IGS_RU_RULE) that determined the assessment inclusion.

Common Use Cases and Queries

This table is central to generating detailed fee assessment reports and troubleshooting assessment calculations. A common use case is querying all assessed items for a specific student transaction to verify the assessment logic. For example:

• Detailed Assessment Breakdown: SELECT * FROM igs_fi_fee_as_items WHERE person_id = &student_id AND transaction_id = &txn_id;
• Fee Analysis by Academic Component: Reports aggregating fees by unit mode or unit level across a cohort often join this table to the parent assessment header (IGS_FI_FEE_AS_ALL) and reference code tables (e.g., IGS_AS_UNIT_MODE).
• Reconciliation: The data is used to reconcile the sum of itemized charges in IGS_FI_FEE_AS_ITEMS with the total assessed amount in IGS_FI_FEE_AS_ALL for audit purposes.

Related Objects

The table maintains extensive foreign key relationships, primarily with the Student System's academic and financial modules. Key documented relationships include:

• IGS_FI_FEE_AS_ALL: The parent assessment header table, joined via PERSON_ID and TRANSACTION_ID.
• HZ_PARTIES: The Trading Community Architecture (TCA) foundation table for the student (PERSON_ID).
• IGS_EN_UNIT_SET_ALL: For assessed unit set details (UNIT_SET_CD, US_VERSION_NUMBER).
• IGS_PS_UNIT_TYPE_LVL, IGS_AS_UNIT_CLASS_ALL, IGS_AS_UNIT_MODE, IGS_PS_UNIT_LEVEL_ALL: Reference tables for academic attributes of the assessed item.
• IGS_RU_RULE: Links to the rule (SCOPE_RUL_SEQUENCE_NUM) that triggered the item's inclusion.
• IGS_FI_FAI_DTLS: A child table that may hold further fee detail, linked by FEE_ASS_ITEM_ID.