Search Results igs_fi_govt_hec_cntb




Overview
Explore in AI Chat

Overview

The IGS_FI_GOVT_HEC_CNTB table is a foundational data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the now-obsolete IGS (Student System) module. Its primary role is to store the master list of government-defined HECS (Higher Education Contribution Scheme) contribution bands. These bands are a critical component of the Australian higher education funding model, representing different levels of student financial contribution based on the field of study. The table acts as a reference entity, enabling the system to map institutional fee structures and student liabilities to the official government bands for reporting, compliance, and calculation purposes.

Key Information Stored

While the provided ETRM metadata does not list individual columns, the table's description and primary/foreign key relationships define its core data elements. The central piece of information is the government HECS contribution band identifier, stored in the primary key column, typically named GOVT_HECS_CNTRBTN_BAND. Each record represents a distinct band defined by the government. The table would logically contain additional descriptive columns to fully define each band, such as a band description, an effective date range, and potentially a monetary value or rate associated with the band. Crucially, the table's purpose is to map these bands to corresponding government discipline groups, implying columns or a related structure to maintain this association.

Common Use Cases and Queries

This table is primarily used in administrative and financial processes within the student lifecycle. A core use case is the configuration and assessment of student fees, where institutional fee rates (in IGS_FI_FEE_AS_RATE) are linked to a government band for standardized reporting. System queries would typically retrieve the valid bands for a given discipline or academic period. For example, an administrator might run a query to list all active HECS bands: SELECT govt_hecs_cntrbtn_band, description FROM igs_fi_govt_hec_cntb WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);. Another critical use case is generating government compliance reports that detail student enrollments and associated liabilities categorized by the official HECS contribution bands.

Related Objects

The IGS_FI_GOVT_HEC_CNTB table is referenced by key financial tables in the IGS module, as indicated by its foreign key relationships. The primary dependencies are:

  • IGS_FI_FEE_AS_RATE: This table stores assessed fee rates and uses GOVT_HECS_CNTRBTN_BAND to link a specific fee assessment to a government HECS band.
  • IGS_FI_GV_DSP_HEC_CN: This table, likely storing government discipline-specific HECS contributions, also references the band via the GOVT_HECS_CNTRBTN_BAND foreign key to maintain the mapping between disciplines and contribution bands.
These relationships underscore the table's role as a central reference point for standardizing fee data against the government's HECS framework.

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

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_GV_DSP_HEC_CN,  object_name:IGS_FI_GV_DSP_HEC_CN,  status:VALID,  product: IGS - Student System ,  description: This table describes the mappings of government discipline groups to contribution bands. ,  implementation_dba_data: IGS.IGS_FI_GV_DSP_HEC_CN , 

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