Search Results govt_hecs_cntrbtn_band




Overview
Explore in AI Chat

Overview

The IGS_FI_GV_DSP_HEC_CN table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Higher Education (IGS) product family. It serves a critical function in the financial aid and student fee management modules by defining the official mapping between government-defined discipline groups and Higher Education Contribution Scheme (HECS) bands. This mapping is essential for calculating accurate student contribution amounts for government-supported study in jurisdictions like Australia. The table acts as a lookup to determine the correct financial band for a unit of study based on its government discipline classification, ensuring institutional compliance with national funding policies.

Key Information Stored

The table's structure is designed to manage effective-dated mappings between two key identifiers. The primary business columns are:

  • GOVT_DISCIPLINE_GROUP_CD: A VARCHAR2 code representing the government's official classification for an academic discipline (e.g., Law, Engineering, Humanities).
  • GOVT_HECS_CNTRBTN_BAND: A NUMBER representing the associated HECS contribution band, which directly influences the student's financial liability.
  • START_DT and END_DT: DATE columns that provide effective dating for each mapping, allowing for historical tracking and future changes to band assignments.
The table is completed by standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for audit purposes. Data integrity is enforced by a unique composite index (IGS_FI_GV_DSP_HEC_CN_U1) on the combination of GOVT_DISCIPLINE_GROUP_CD, GOVT_HECS_CNTRBTN_BAND, and START_DT.

Common Use Cases and Queries

This table is primarily used during student enrollment and billing processes. When a student enrolls in a unit, the system references the unit's assigned government discipline group code against this table to determine the applicable HECS band for the current date. This band value is then used in downstream fee calculations. A typical operational query to find the active mapping for a specific discipline would be: 

SELECT GOVT_HECS_CNTRBTN_BAND
FROM IGS.IGS_FI_GV_DSP_HEC_CN
WHERE GOVT_DISCIPLINE_GROUP_CD = '&DISCIPLINE_CODE'
  AND SYSDATE BETWEEN START_DT AND NVL(END_DT, SYSDATE+1);
For reporting and administrative maintenance, a comprehensive view of all mappings, including their effective periods, is often required. This is achieved using the standard query pattern provided in the ETRM documentation, often joined with descriptive value sets or other IGS reference tables for the discipline group and band descriptions.

Related Objects

Based on the provided dependency information, the IGS_FI_GV_DSP_HEC_CN table is a referenced object within the APPS schema. This indicates it is likely accessed by public synonyms, views, or application programming interfaces (APIs) within the EBS application tier to support fee calculation logic. While the specific referencing objects are not listed, it is logically connected to other IGS tables storing unit offering details, student course attempts, and fee assessment records, where the resolved HECS contribution band is applied. Its role is as a foundational lookup within the financial aid data model.