Search Results igs_fi_a_hierarchies




Overview
Explore in AI Chat

Overview

The IGS_FI_A_HIERARCHIES table is a core data structure within the now-obsolete Student System (IGS) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as the master repository for application hierarchy definitions, which are critical for organizing and processing student financial applications. The table captures the complete setup information configured through the "Define Application Hierarchy" form, including a direct association to a specific credit type. This linkage is fundamental for enforcing business rules and determining the financial treatment of applications within the defined hierarchical structure. Its role is to provide a consistent, versioned framework that other financial application components reference to ensure proper workflow and data integrity.

Key Information Stored

The table stores metadata that defines the structure and validity of an application hierarchy. The primary identifier is the APPL_HIERARCHY_ID, a system-generated unique key. The logical identity of a hierarchy is defined by a composite unique key consisting of HIERARCHY_NAME, VERSION_NUMBER, and EFFECTIVE_START_DATE, allowing for multiple time-bound versions of a hierarchy with the same name. A crucial foreign key column is CREDIT_TYPE_ID, which links the hierarchy to a specific financial credit type defined in the IGS_FI_CR_TYPES_ALL table. This relationship dictates the type of credit (e.g., tuition waiver, grant) that applications within this hierarchy are associated with, centralizing a key business rule at the hierarchy level.

Common Use Cases and Queries

Primary use cases involve retrieving active hierarchy definitions for application processing, reporting, and integration. A common operational query would fetch the current effective hierarchy for a given name to validate a new financial application. For reporting purposes, a join to the credit types table is typical to display the hierarchy alongside its associated financial product. Administrators might query all versions of a hierarchy to audit changes over time. A sample SQL pattern to find the active hierarchy and its credit type would be:

  • SELECT h.hierarchy_name, h.version_number, ct.credit_type_name
  • FROM igs_fi_a_hierarchies h, igs_fi_cr_types_all ct
  • WHERE h.credit_type_id = ct.credit_type_id
  • AND h.effective_start_date <= SYSDATE
  • AND NVL(h.effective_end_date, SYSDATE) >= SYSDATE
  • AND h.hierarchy_name = '<Hierarchy_Name>';

Related Objects

IGS_FI_A_HIERARCHIES is a central reference point within the financial applications subsystem, as evidenced by its foreign key relationships. It is directly referenced by three key tables:

  • IGS_FI_APPLICATIONS: The APPL_HIERARCHY_ID in this table links individual student financial applications to their governing hierarchy.
  • IGS_FI_CR_TYPES_ALL: While the hierarchy holds a foreign key to the credit type (CREDIT_TYPE_ID), the credit types table also references back via its APPL_HIERARCHY_ID column, indicating a potential bidirectional relationship for default hierarchies.
  • IGS_FI_APP_RULES: The APPL_HIERARCHY_ID in this table associates specific processing or validation rules with a particular application hierarchy.

These relationships demonstrate that the hierarchy definition controls the setup of credit types, the creation of individual applications, and the application of business rules, forming an integral part of the obsolete financial aid data model.

  • Table: IGS_FI_A_HIERARCHIES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_A_HIERARCHIES,  object_name:IGS_FI_A_HIERARCHIES,  status:VALID,  product: IGS - Student System ,  description: Captures application hierarchies setup information from the Define Application Hierarchy form along with information about the credit type associated with this hierarchy. ,  implementation_dba_data: IGS.IGS_FI_A_HIERARCHIES , 

  • Table: IGS_FI_CR_TYPES_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_CR_TYPES_ALL,  object_name:IGS_FI_CR_TYPES_ALL,  status:VALID,  product: IGS - Student System ,  description: Stores information about the 'credit type' of a credit transaction. The credit type provides the debit and credit account information to a credit transaction along with some other information like credit class etc. ,  implementation_dba_data: IGS.IGS_FI_CR_TYPES_ALL , 

  • View: IGS_FI_A_HIERARCHIES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_A_HIERARCHIES_V,  object_name:IGS_FI_A_HIERARCHIES_V,  status:VALID,  product: IGS - Student System ,  description: This view is created to obtain credit type name from IGS_FI_CR_TYPES view resolving foreign keys ,  implementation_dba_data: APPS.IGS_FI_A_HIERARCHIES_V , 

  • View: IGS_FI_APP_RULES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_APP_RULES_V,  object_name:IGS_FI_APP_RULES_V,  status:VALID,  product: IGS - Student System ,  description: This view selects those records from the Application Hierarchy Rules table that are of Rule type 'ALLOW' only ,  implementation_dba_data: APPS.IGS_FI_APP_RULES_V , 

  • View: IGS_FI_ADL_APP_RUL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_ADL_APP_RUL_V,  object_name:IGS_FI_ADL_APP_RUL_V,  status:VALID,  product: IGS - Student System ,  description: This view selects those records from the application hierarchy rules table that are of Rule type 'ADDITION' ,  implementation_dba_data: APPS.IGS_FI_ADL_APP_RUL_V , 

  • Table: IGS_FI_APPLICATIONS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_APPLICATIONS,  object_name:IGS_FI_APPLICATIONS,  status:VALID,  product: IGS - Student System ,  description: Contains application information about credits and charges transaction that are applied. ,  implementation_dba_data: IGS.IGS_FI_APPLICATIONS , 

  • Table: IGS_FI_APP_RULES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_APP_RULES,  object_name:IGS_FI_APP_RULES,  status:VALID,  product: IGS - Student System ,  description: Contains information about each Application Rules associated to an Application Hierarchy that you define. The information captured here are Fee Types and sequence in which these Fee Types would be selected for application purposes. ,  implementation_dba_data: IGS.IGS_FI_APP_RULES , 

  • View: IGS_FI_CR_TYPES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_CR_TYPES_V,  object_name:IGS_FI_CR_TYPES_V,  status:VALID,  product: IGS - Student System ,  description: This view is created to be used in Credit Types form. All associated descriptions are obtained by joining with the setup tables. ,  implementation_dba_data: APPS.IGS_FI_CR_TYPES_V ,