Search Results igs_fi_f_cat_fee_lbl_all




Overview
Explore in AI Chat

Overview

The table IGS_FI_F_CAT_FEE_LBL_ALL is a core entity within the Oracle E-Business Suite Student System (IGS) module, specifically for financial management. It functions as a mapping or assignment table that defines the specific fee types (FEE_TYPE) that are applicable to a given fee category period within a fee calendar instance. This relationship is fundamental for configuring the institution's fee structure, linking broad fee categories to the detailed, chargeable fee types under specific academic calendar periods. The table supports the multi-org architecture through its '_ALL' suffix, meaning it can store data for multiple operating units. Its primary role is to establish the valid fee liabilities that can be assessed to students based on their enrollment and the applicable fee category rules.

Key Information Stored

The table's structure centers on identifying the unique combination of a fee category, calendar instance, and fee type. The primary key is a composite of four columns: FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FEE_TYPE. This ensures that a specific fee type can only be associated once with a particular fee category calendar instance. Other significant columns include FEE_LIABILITY_STATUS, which references a lookup (IGS_FI_FEE_STR_STAT) to define the status of the fee liability (e.g., active, inactive), and RUL_SEQUENCE_NUMBER, which can link to a rule (IGS_RU_RULE) for conditional application. The columns START_DT_ALIAS and START_DAI_SEQUENCE_NUMBER form a foreign key to the calendar date alias table (IGS_CA_DA_INST), potentially defining an effective start date for the fee type assignment within the period.

Common Use Cases and Queries

This table is central to fee setup and inquiry processes. A common use case is validating which fee types are available for assessment when generating charges for a student in a specific academic period and fee category. Administrators use this data to maintain fee structures during calendar setup. Typical reporting queries involve joining to related setup tables to list all configured fees. For example:

  • Listing all fee types for a fee category in the current charge calendar: SELECT fee_type FROM igs_fi_f_cat_fee_lbl_all WHERE fee_cat = :p_cat AND fee_cal_type = :p_cal_type AND fee_ci_sequence_number = :p_ci_seq;
  • Identifying the fee liability status for a specific fee type assignment to determine if it is currently assessable.
  • Troubleshooting fee assessment errors by verifying that the expected fee type is correctly linked to the student's applicable fee category and calendar instance.

Related Objects

The IGS_FI_F_CAT_FEE_LBL_ALL table sits at the intersection of several key setup and transaction tables, as indicated by its foreign key relationships. It is a child of the fee category calendar instance table (IGS_FI_F_CAT_CA_INST) and the fee type calendar instance table (IGS_FI_F_TYP_CA_INST_ALL). It is referenced as a parent table by multiple fee trigger entities that initiate charge creation, including IGS_PS_FEE_TRG (Program Fee Trigger), IGS_PS_TYPE_FEE_TRG (Program Type Fee Trigger), IGS_PS_GRP_FEE_TRG (Program Group Fee Trigger), and their history tables. It is also referenced by IGS_FI_ELM_RANGE_H_ALL, which is involved in defining fee element ranges. These relationships underscore its critical function as the configured link between fee rules and the actual fee types that populate student financial accounts.

  • Table: IGS_FI_F_CAT_FEE_LBL_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_F_CAT_FEE_LBL_ALL,  object_name:IGS_FI_F_CAT_FEE_LBL_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the fee types applicable to a fee category period fee category calendar instance. ,  implementation_dba_data: IGS.IGS_FI_F_CAT_FEE_LBL_ALL , 

  • 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_FI_FEE_STR_STAT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FEE_STR_STAT,  object_name:IGS_FI_FEE_STR_STAT,  status:VALID,  product: IGS - Student System ,  description: This entity describes special contract based fee assessment rates ,  implementation_dba_data: IGS.IGS_FI_FEE_STR_STAT , 

  • Table: IGS_FI_F_RET_SCHD_HT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_F_RET_SCHD_HT_ALL,  object_name:IGS_FI_F_RET_SCHD_HT_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the history of changes to a fee retention schedule. ,  implementation_dba_data: IGS.IGS_FI_F_RET_SCHD_HT_ALL , 

  • Table: IGS_FI_ELM_RANGE_H_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_ELM_RANGE_H_ALL,  object_name:IGS_FI_ELM_RANGE_H_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes the history of changes to an elements range ,  implementation_dba_data: IGS.IGS_FI_ELM_RANGE_H_ALL , 

  • Table: IGS_FI_ELM_RANGE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_ELM_RANGE,  object_name:IGS_FI_ELM_RANGE,  status:VALID,  product: IGS - Student System ,  description: This entity describes ranges applied to elements derived from charge methods for the purpose of determining fee assessment rates. ,  implementation_dba_data: IGS.IGS_FI_ELM_RANGE , 

  • Table: IGS_PS_TYPE_FEE_TRG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_TYPE_FEE_TRG,  object_name:IGS_PS_TYPE_FEE_TRG,  status:VALID,  product: IGS - Student System ,  description: This entity describes the program type based fee triggers. It is used during fee assessment processing to indicate a program type based fee applies for a fee type. ,  implementation_dba_data: IGS.IGS_PS_TYPE_FEE_TRG , 

  • Table: IGS_EN_UNITSETFEETRG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_UNITSETFEETRG,  object_name:IGS_EN_UNITSETFEETRG,  status:VALID,  product: IGS - Student System ,  description: This entity describes the unit set fee triggers. It is used during fee assessment processing to indicate a unit set based fee applies for a fee type. ,  implementation_dba_data: IGS.IGS_EN_UNITSETFEETRG , 

  • Table: IGS_FI_FEE_AS_RT_H_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FEE_AS_RT_H_ALL,  object_name:IGS_FI_FEE_AS_RT_H_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes special contract based fee assessment rates ,  implementation_dba_data: IGS.IGS_FI_FEE_AS_RT_H_ALL , 

  • Table: IGS_FI_FEE_TRG_GRP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FEE_TRG_GRP,  object_name:IGS_FI_FEE_TRG_GRP,  status:VALID,  product: IGS - Student System ,  description: This entity describes special contract based fee assessment rates ,  implementation_dba_data: IGS.IGS_FI_FEE_TRG_GRP , 

  • Table: IGS_PS_GRP_FEE_TRG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_GRP_FEE_TRG,  object_name:IGS_PS_GRP_FEE_TRG,  status:VALID,  product: IGS - Student System ,  description: This entity describes the program group based fee triggers. It is used during fee assessment processing to indicate a program group based fee applies for a fee type. ,  implementation_dba_data: IGS.IGS_PS_GRP_FEE_TRG , 

  • 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_PS_FEE_TRG_HIST_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_FEE_TRG_HIST_ALL,  object_name:IGS_PS_FEE_TRG_HIST_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the history of changes to a program type/program group/program/program offering option fee trigger. ,  implementation_dba_data: IGS.IGS_PS_FEE_TRG_HIST_ALL , 

  • Table: IGS_FI_FEE_RET_SCHD 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FEE_RET_SCHD,  object_name:IGS_FI_FEE_RET_SCHD,  status:VALID,  product: IGS - Student System ,  description: This entity describes special contract based fee assessment rates ,  implementation_dba_data: IGS.IGS_FI_FEE_RET_SCHD , 

  • Table: IGS_PS_FEE_TRG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_FEE_TRG,  object_name:IGS_PS_FEE_TRG,  status:VALID,  product: IGS - Student System ,  description: This entity describes the program based fee triggers. It is used during fee assessment processing to indicate a program-based fee applies for a fee type. ,  implementation_dba_data: IGS.IGS_PS_FEE_TRG , 

  • Table: IGS_FI_UNIT_FEE_TR_H_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_UNIT_FEE_TR_H_ALL,  object_name:IGS_FI_UNIT_FEE_TR_H_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the history of changes to a unit/unit offering option fee trigger. ,  implementation_dba_data: IGS.IGS_FI_UNIT_FEE_TR_H_ALL , 

  • Table: IGS_FI_UNIT_FEE_TRG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_UNIT_FEE_TRG,  object_name:IGS_FI_UNIT_FEE_TRG,  status:VALID,  product: IGS - Student System ,  description: This entity describes the unit based fee triggers. It is used during fee assessment processing to indicate a unit based fee applies for a fee type. ,  implementation_dba_data: IGS.IGS_FI_UNIT_FEE_TRG , 

  • Table: IGS_FI_F_CAT_CA_INST 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_F_CAT_CA_INST,  object_name:IGS_FI_F_CAT_CA_INST,  status:VALID,  product: IGS - Student System ,  description: This entity describes the periods of fee assessment - fee calendar instances- applicable to a fee category. ,  implementation_dba_data: IGS.IGS_FI_F_CAT_CA_INST , 

  • View: IGS_FI_F_CAT_FEE_LBL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_F_CAT_FEE_LBL,  object_name:IGS_FI_F_CAT_FEE_LBL,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGS_FI_F_CAT_FEE_LBL , 

  • Table: IGS_CA_DA_INST 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_CA_DA_INST,  object_name:IGS_CA_DA_INST,  status:VALID,  product: IGS - Student System ,  description: Describes an instance of a date alias in a calendar instance ,  implementation_dba_data: IGS.IGS_CA_DA_INST , 

  • Table: IGS_FI_FEE_AS_RATE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FEE_AS_RATE,  object_name:IGS_FI_FEE_AS_RATE,  status:VALID,  product: IGS - Student System ,  description: This entity describes the method and parameters necessary for determining the amount to charge during fee assessment processing for a fee category fee liability. ,  implementation_dba_data: IGS.IGS_FI_FEE_AS_RATE , 

  • Table: IGS_FI_F_TYP_CA_INST_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_F_TYP_CA_INST_ALL,  object_name:IGS_FI_F_TYP_CA_INST_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the periods of fee assessment fee calendar instances applicable to a fee type. ,  implementation_dba_data: IGS.IGS_FI_F_TYP_CA_INST_ALL ,