Search Results igs_fi_fee_as_rate




Overview
Explore in AI Chat

Overview

The IGS_FI_FEE_AS_RATE table is a core entity within the Oracle E-Business Suite Student System (IGS), specifically for the Financials module. It defines the method and parameters required to calculate the monetary amount to be charged for a specific fee category during the fee assessment process. This table acts as a rule engine, storing the various rate structures and qualifying criteria that determine how a fee liability is computed for a student. Its role is critical for automating and ensuring accurate fee generation based on a complex set of academic and demographic attributes.

Key Information Stored

The table stores configuration data that links fee definitions to specific charge rates. Key columns include identifiers for the fee itself (FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_CAT) and a RATE_NUMBER to sequence multiple rates. Crucially, it holds numerous foreign key columns that serve as qualifiers to determine which rate applies to a given student's enrollment context. These qualifiers include COURSE_CD, VERSION_NUMBER, ATTENDANCE_MODE, ATTENDANCE_TYPE, LOCATION_CD, UNIT_CLASS, UNIT_SET_CD, RESIDENCY_STATUS_ID, CLASS_STANDING, ORG_PARTY_ID, and government contribution bands (GOVT_HECS_CNTRBTN_BAND). The primary keys enforce uniqueness on combinations of the fee identifier, rate number, and, in one case, the student relationship type (S_RELATION_TYPE).

Common Use Cases and Queries

The primary use case is the backend assessment of fees during processes like enrollment or invoicing, where the system queries this table to find the applicable rate rule matching a student's profile. For reporting and analysis, administrators may query it to audit fee rate structures. A common query pattern involves joining to related fee definition tables and filtering on key attributes. For example, to list all rate rules for a specific fee type, one might use:

  • SELECT fee_type, fee_cat, rate_number, location_cd, attendance_mode FROM igs_fi_fee_as_rate WHERE fee_type = :p_fee_type ORDER BY rate_number;

Another critical query involves finding the precise rate applicable to a student by matching their course, attendance mode, residency, and other attributes against the qualifier columns in this table.

Related Objects

IGS_FI_FEE_AS_RATE has extensive relationships with other Student System entities, as indicated by its foreign keys. It is centrally dependent on the fee definition tables IGS_FI_F_CAT_FEE_LBL_ALL and IGS_FI_F_TYP_CA_INST_ALL. Its qualifier columns reference fundamental academic structures like IGS_PS_VER_ALL (Course Version), IGS_EN_ATD_MODE_ALL, IGS_EN_ATD_TYPE_ALL, IGS_AS_UNIT_CLASS_ALL, and IGS_EN_UNIT_SET_ALL. It also links to party (HZ_PARTIES), location (IGS_AD_LOCATION_ALL), and government contribution tables (IGS_FI_GOVT_HEC_CNTB). This web of relationships underscores its role as a nexus between fee policies and the operational data of students and programs.

  • 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 , 

  • View: IGS_FI_FEE_AS_RATE_F_TYPE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_FEE_AS_RATE_F_TYPE_V,  object_name:IGS_FI_FEE_AS_RATE_F_TYPE_V,  status:VALID,  product: IGS - Student System ,  description: No longer used ,  implementation_dba_data: APPS.IGS_FI_FEE_AS_RATE_F_TYPE_V , 

  • Table: IGS_FI_ELM_RANGE_RT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_ELM_RANGE_RT,  object_name:IGS_FI_ELM_RANGE_RT,  status:VALID,  product: IGS - Student System ,  description: Describes charge rates specific to a range of charge elements ,  implementation_dba_data: IGS.IGS_FI_ELM_RANGE_RT , 

  • 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_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_FI_SUB_ER_RT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_SUB_ER_RT,  object_name:IGS_FI_SUB_ER_RT,  status:VALID,  product: IGS - Student System ,  description: This table describes charge rates specific to a sub range of charge elements ,  implementation_dba_data: IGS.IGS_FI_SUB_ER_RT , 

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

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_GOVT_HEC_CNTB,  object_name:IGS_FI_GOVT_HEC_CNTB,  status:VALID,  product: IGS - Student System ,  description: This table describes the list of government defined HECS, Higher Education Contribution Scheme, contribution bands. These bands are mapped against government discipline groups. ,  implementation_dba_data: IGS.IGS_FI_GOVT_HEC_CNTB , 

  • Table: IGS_PS_UNIT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT,  object_name:IGS_PS_UNIT,  status:VALID,  product: IGS - Student System ,  description: This attribute describes the code allocated to a unit offered by the university. ,  implementation_dba_data: IGS.IGS_PS_UNIT , 

  • Table: IGS_PE_CODE_CLASSES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_CODE_CLASSES,  object_name:IGS_PE_CODE_CLASSES,  status:VALID,  product: IGS - Student System ,  description: This entity describes the various code classes. ,  implementation_dba_data: IGS.IGS_PE_CODE_CLASSES , 

  • Table: IGS_PR_CLASS_STD 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_CLASS_STD,  object_name:IGS_PR_CLASS_STD,  status:VALID,  product: IGS - Student System ,  description: Maintains the institution defined Class Standing set-up values ,  implementation_dba_data: IGS.IGS_PR_CLASS_STD , 

  • Table: IGS_FI_GOV_HEC_PA_OP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_GOV_HEC_PA_OP,  object_name:IGS_FI_GOV_HEC_PA_OP,  status:VALID,  product: IGS - Student System ,  description: This entity describes the list of government defined contribution payment options. These options are what is reported to the government in the submissions, so the institutionally defined options must map back onto these for that purpose. ,  implementation_dba_data: IGS.IGS_FI_GOV_HEC_PA_OP , 

  • 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 , 

  • View: IGS_FI_SUB_ER_RT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_SUB_ER_RT_V,  object_name:IGS_FI_SUB_ER_RT_V,  status:VALID,  product: IGS - Student System ,  description: Fetches Sub Element Range Rates records ,  implementation_dba_data: APPS.IGS_FI_SUB_ER_RT_V , 

  • Table: IGS_EN_ATD_MODE_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_ATD_MODE_ALL,  object_name:IGS_EN_ATD_MODE_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes available university program attendance modes ,  implementation_dba_data: IGS.IGS_EN_ATD_MODE_ALL , 

  • Table: IGS_EN_ATD_TYPE_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_ATD_TYPE_ALL,  object_name:IGS_EN_ATD_TYPE_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes available university program attendance types ,  implementation_dba_data: IGS.IGS_EN_ATD_TYPE_ALL , 

  • Table: IGS_AD_LOCATION_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_LOCATION_ALL,  object_name:IGS_AD_LOCATION_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes available geographic locations at which programs and units may be offered or taught ,  implementation_dba_data: IGS.IGS_AD_LOCATION_ALL , 

  • 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 , 

  • View: IGS_FI_ELM_RNG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_ELM_RNG_V,  object_name:IGS_FI_ELM_RNG_V,  status:VALID,  product: IGS - Student System ,  description: This view determines the elements range rate specific to a given fee category fee liability. ,  implementation_dba_data: APPS.IGS_FI_ELM_RNG_V , 

  • 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 , 

  • 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 , 

  • Table: IGS_PS_UNIT_VER_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT_VER_ALL,  object_name:IGS_PS_UNIT_VER_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a version of a unit, which is offered by the university. ,  implementation_dba_data: IGS.IGS_PS_UNIT_VER_ALL , 

  • View: IGS_FI_FEE_AS_RATE_V 12.1.1

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

  • Table: IGS_PS_VER_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_VER_ALL,  object_name:IGS_PS_VER_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the versions of programs which are offered by the university, covering both award and non-award programs. ,  implementation_dba_data: IGS.IGS_PS_VER_ALL ,