Search Results igs_fi_fee_as_items




Overview
Explore in AI Chat

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.
  • Table: IGS_FI_FEE_AS_ITEMS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FEE_AS_ITEMS,  object_name:IGS_FI_FEE_AS_ITEMS,  status:VALID,  product: IGS - Student System ,  description: This entity stores an itemized list of assessment items that have contributed to the student's assessment. ,  implementation_dba_data: IGS.IGS_FI_FEE_AS_ITEMS , 

  • Table: IGS_FI_FEE_AS_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FEE_AS_ALL,  object_name:IGS_FI_FEE_AS_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the fee assessments against a person for a fee category fee liability. ,  implementation_dba_data: IGS.IGS_FI_FEE_AS_ALL , 

  • Table: IGS_AS_UNIT_CLASS_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AS_UNIT_CLASS_ALL,  object_name:IGS_AS_UNIT_CLASS_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes available unit classes, which map to unit mode ,  implementation_dba_data: IGS.IGS_AS_UNIT_CLASS_ALL , 

  • Table: IGS_PS_UNIT_TYPE_LVL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT_TYPE_LVL,  object_name:IGS_PS_UNIT_TYPE_LVL,  status:VALID,  product: IGS - Student System ,  description: This table stores the unit program type level code and description. These would be associated with units. ,  implementation_dba_data: IGS.IGS_PS_UNIT_TYPE_LVL , 

  • Table: IGS_FI_FAI_DTLS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FAI_DTLS,  object_name:IGS_FI_FAI_DTLS,  status:VALID,  product: IGS - Student System ,  description: Fee Assessment Item Detail table, which stores Unit Information of a fee assessment item record. ,  implementation_dba_data: IGS.IGS_FI_FAI_DTLS , 

  • Table: IGS_AS_UNIT_MODE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AS_UNIT_MODE,  object_name:IGS_AS_UNIT_MODE,  status:VALID,  product: IGS - Student System ,  description: Describes available university unit offering modes ,  implementation_dba_data: IGS.IGS_AS_UNIT_MODE , 

  • Table: IGS_PS_UNIT_LEVEL_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT_LEVEL_ALL,  object_name:IGS_PS_UNIT_LEVEL_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the available university unit levels. ,  implementation_dba_data: IGS.IGS_PS_UNIT_LEVEL_ALL , 

  • Table: IGS_RU_RULE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_RU_RULE,  object_name:IGS_RU_RULE,  status:VALID,  product: IGS - Student System ,  description: Rules ,  implementation_dba_data: IGS.IGS_RU_RULE , 

  • Table: IGS_EN_UNIT_SET_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_UNIT_SET_ALL,  object_name:IGS_EN_UNIT_SET_ALL,  status:VALID,  product: IGS - Student System ,  description: This field describes a unit-set, being a logical sub-grouping of course. e.g. Major, Minor, Stream, Strand. A unit-set is typically related to the rules which govern its completion via the Rules Sub-system. ,  implementation_dba_data: IGS.IGS_EN_UNIT_SET_ALL ,