Search Results igs_he_code_assoc_pk

Overview

The IGS_HE_CODE_ASSOC table is a core reference table within the Oracle E-Business Suite (EBS) Student System (IGS), specifically designed to support Higher Education Statistics Agency (HESA) reporting requirements. Its primary role is to serve as a master repository for all defined Association Codes. These codes are used to categorize and classify various data mappings and validations within the HESA reporting framework. It is critical to note that the IGS product line, including this table, is marked as obsolete within the provided ETRM documentation. Furthermore, the metadata explicitly states this object is "Not implemented in this database," indicating it may not be present in a standard installation or may be a legacy artifact from a previous implementation.

Key Information Stored

The table's structure is centered on the Association Code itself. The primary and only explicitly documented column is ASSOCIATION_CODE, which serves as the unique identifier (Primary Key: IGS_HE_CODE_ASSOC_PK) for each code definition. While the ETRM excerpt does not list additional columns, typical code tables in EBS often include descriptive fields such as MEANING, DESCRIPTION, ENABLED_FLAG, and START_DATE/END_DATE to manage the code's lifecycle and usage. The data held in this table is foundational, providing the valid list of codes that other transactional and mapping tables reference to ensure data integrity in HESA submissions.

Common Use Cases and Queries

The primary use case for this table is the administration and validation of HESA reporting codes. System administrators would use this table to define and maintain the list of permissible association codes. In practice, this table is queried to populate lists of values (LOVs) in application forms or to validate data during the creation of HESA code mappings and returns. A typical query would retrieve all active codes for use in a setup interface or report.

Sample Query:
SELECT association_code
FROM igs_he_code_assoc
WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE)
ORDER BY 1;

Given the table's "not implemented" status, direct operational use in reporting or processes may be limited, and any existing data would be for historical reference or migration purposes.

Related Objects

As documented in the ETRM metadata, the IGS_HE_CODE_ASSOC table is referenced as a parent table by three key HESA-related entities via foreign key relationships. These relationships enforce that codes used in downstream tables must first be defined in the master code table.

• IGS_HE_CODE_ASS_VAL: References IGS_HE_CODE_ASSOC via IGS_HE_CODE_ASS_VAL.ASSOCIATION_CODE. This table likely stores specific validation rules or values associated with each association code.
• IGS_HE_CODE_MAP_VAL: References IGS_HE_CODE_ASSOC via IGS_HE_CODE_MAP_VAL.ASSOCIATION_CODE. This table is presumably used for mapping internal values to HESA-specific codes based on the association type.
• IGS_HE_SYS_RT_CL_ASS: References IGS_HE_CODE_ASSOC via IGS_HE_SYS_RT_CL_ASS.ASSOCIATION_CODE. This table likely associates system return or classification data with the relevant HESA association codes.

These relationships form a critical part of the HESA data model, ensuring consistency across code validations, mappings, and reporting classifications.