Search Results igs_fi_gv_dsp_hec_cn

Overview

The IGS_FI_GV_DSP_HEC_CN table is a core data structure within the Oracle E-Business Suite's Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It serves a critical configuration role in the financial management of student fees, particularly in regions with government-regulated higher education contribution schemes, such as Australia's HECS-HELP system. The table's primary function is to maintain the official mappings between government-defined academic discipline groups and their corresponding student contribution bands. This mapping is essential for accurately calculating the financial liability for students based on their enrolled course of study, ensuring institutional compliance with governmental funding and reporting mandates.

Key Information Stored

The table stores the historical and current relationships between discipline groups and contribution bands. Its structure is defined by a composite primary key and temporal validity, ensuring precise and auditable mappings. The key columns include:

• GOVT_DISCIPLINE_GROUP_CD: The code representing a government-classified academic discipline or field of study (e.g., Law, Engineering, Humanities).
• GOVT_HECS_CNTRBTN_BAND: The code for the associated government-mandated contribution band, which determines the fee amount or rate.
• START_DT: The effective date from which this specific mapping becomes valid, enabling historical tracking and future-dated changes.

Common Use Cases and Queries

This table is central to automated fee assessment processes. During enrollment or billing batch runs, the system queries this table to determine the correct contribution band for a student's units based on their discipline. It is also crucial for generating statutory reports to government bodies, demonstrating compliance with funding rules. A typical query would retrieve the active mapping for a given set of discipline codes, often joining to student enrollment data. For example:

SELECT gdsp.GOVT_DISCIPLINE_GROUP_CD, gdsp.GOVT_HECS_CNTRBTN_BAND, gdsp.START_DT
FROM IGS_FI_GV_DSP_HEC_CN gdsp
WHERE gdsp.GOVT_DISCIPLINE_GROUP_CD IN ('010101', '030101')
AND gdsp.START_DT <= SYSDATE
AND NOT EXISTS (
SELECT 'x' FROM IGS_FI_GV_DSP_HEC_CN gdsp2
WHERE gdsp2.GOVT_DISCIPLINE_GROUP_CD = gdsp.GOVT_DISCIPLINE_GROUP_CD
AND gdsp2.START_DT > gdsp.START_DT AND gdsp2.START_DT <= SYSDATE
);

This pattern finds the most recent, currently effective mapping for the specified disciplines, which is a standard requirement for real-time fee calculation.

Related Objects

The IGS_FI_GV_DSP_HEC_CN table does not operate in isolation; it is part of a tightly integrated schema for managing government discipline and fee data. The documented foreign key relationships are:

• IGS_PS_GOVT_DSCP: The GOVT_DISCIPLINE_GROUP_CD column is a foreign key to this table, which holds the master list and descriptions of all government-recognized discipline groups.
• IGS_FI_GOVT_HEC_CNTB: The GOVT_HECS_CNTRBTN_BAND column is a foreign key to this table, which defines the valid contribution bands and their associated monetary values or rules.

These relationships enforce data integrity, ensuring that mappings are only created for valid, predefined discipline groups and contribution bands. Any downstream processes, such as fee assessment engines or compliance reports, will typically join through these related tables to obtain descriptive names and financial details.