Search Results oss_seq

Overview

The IGS.IGS_HE_SYS_RT_CL_ASS table is a core data definition table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Higher Education (HE) product family. Its primary role is to manage the mapping and association rules for fields within a System Return Class. A System Return Class defines the structure and format of data extracts, typically for statutory reporting to external bodies like the UK's Higher Education Statistics Agency (HESA) or the Office for Students (OfS). This table stores the specific association codes that dictate how a particular field in the return should be populated or validated, linking system data elements to standardized external coding frameworks.

Key Information Stored

The table's structure is designed to capture both the mapping definition and standard audit information. The IGS_HE_SYS_RT_CL_ASS_ID column serves as the unique primary key identifier for each association record. The logical mapping is defined by the combination of SYSTEM_RETURN_CLASS_TYPE and FIELD_NUMBER, which identifies a specific field within a return class. The ASSOCIATION_CODE is the critical value that links this field to a specific code in an external or internal classification (e.g., a HESA cost centre code or a student domicile code). The OSS_SEQ and HESA_SEQ columns provide sequence numbers for ordering within the respective agency's mapping logic. The table also includes standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) for tracking data changes.

Common Use Cases and Queries

This table is central to the configuration and generation of statutory data returns. Administrators use it to define and maintain the extract logic for reports. A common operational query involves retrieving the full mapping definition for a specific return class to validate or audit configurations. For example:

SELECT SYSTEM_RETURN_CLASS_TYPE, FIELD_NUMBER, ASSOCIATION_CODE, OSS_SEQ, HESA_SEQ FROM IGS.IGS_HE_SYS_RT_CL_ASS WHERE SYSTEM_RETURN_CLASS_TYPE = 'HESA_STUDENT' ORDER BY FIELD_NUMBER;

During the batch process of generating a return file, the extract engine references this table to determine the correct association code to apply for each data field. Troubleshooting often involves querying this table to verify that the expected association code is mapped to the correct field number for a given return type, ensuring data integrity in external submissions.

Related Objects

Based on the provided relationship data, the IGS_HE_SYS_RT_CL_ASS table has defined foreign key relationships and is a referenced entity within the EBS schema. Its primary key is enforced by the constraint IGS_HE_SYS_RT_CL_ASS_PK. It references two key code validation tables:

• IGS_HE_CODE_ASSOC via the ASSOCIATION_CODE column. This validates that the association code stored is a legitimate value within the system's code association repository.
• IGS_HE_SYS_RT_CL_FLD via the SYSTEM_RETURN_CLASS_TYPE column (and implicitly FIELD_NUMBER). This ensures the association record is linked to a valid, defined field within an existing system return class.

Furthermore, the dependency information confirms that an APPS synonym named IGS_HE_SYS_RT_CL_ASS exists, pointing to this IGS-owned table, which is the standard method for granting secure access to the underlying data from the application tier.