Results for “association_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_HE_SYS_RT_CL_ASS is a table within the IGS (Student System) product family of Oracle E-Business Suite, historically associated with the Higher Education extension used to support statutory student returns and related regulatory reporting. The table stores association codes for each field within a system return class, effectively acting as a cross-reference that binds a field belonging to a return class to a specific association code.

The ETRM metadata classifies this object as Obsolete under the IGS - Student System product. The documentation excerpt explicitly notes "Not implemented in this database," and the object does not appear in supported Oracle EBS 12.1.1 or 12.2.2 installations unless a legacy Higher Education module has been retained. Its presence should be treated as a legacy artefact rather than a supported functional component.

Applying the heuristic Data Vault classification supplied in the metadata, IGS_HE_SYS_RT_CL_ASS is best modelled as a link table. It resolves a many-to-many style association between return-class fields (identified through SYSTEM_RETURN_CLASS_TYPE and FIELD_NUMBER) and association codes (ASSOCIATION_CODE). This modelling suggestion reflects the table's role as a junction carrying relationships rather than descriptive attributes of a single business entity.

Key Information Stored

The table contains eleven documented columns, of which the most significant are summarised below.

• IGS_HE_SYS_RT_CL_ASS_ID — Surrogate primary key, enforced by the IGS_HE_SYS_RT_CL_ASS_PK constraint. It uniquely identifies each association row and is the column to use for single-row lookups.
• SYSTEM_RETURN_CLASS_TYPE — Identifies the system return class to which the associated field belongs. Part of the foreign key referencing IGS_HE_SYS_RT_CL_FLD.
• FIELD_NUMBER — Identifies the specific field within the system return class. Together with SYSTEM_RETURN_CLASS_TYPE it forms the field-level reference into IGS_HE_SYS_RT_CL_FLD.
• ASSOCIATION_CODE — The association code applied to the field. This column is a foreign key to IGS_HE_CODE_ASSOC.
• OSS_SEQ — A sequence column supporting ordering or positioning of association entries.
• HESA_SEQ — A sequence column associated with HESA (Higher Education Statistics Agency) return processing conventions.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified each row and when.

The unique index IGS_HE_SYS_RT_CL_ASS_U1 covers SYSTEM_RETURN_CLASS_TYPE, FIELD_NUMBER, ASSOCIATION_CODE, OSS_SEQ and HESA_SEQ. This is the principal business-key candidate, distinguishing the surrogate IGS_HE_SYS_RT_CL_ASS_ID from the meaningful business combination that guarantees uniqueness of an association assignment.

Common Use Cases and Queries

Because the object is obsolete, practical use cases are limited to legacy migration, data archaeology, and historical reporting. Typical scenarios include extracting the association codes attached to fields of a given system return class, and reconciling those against the underlying code definitions.

A representative query joining the association to its code definition is:

• SELECT a.SYSTEM_RETURN_CLASS_TYPE, a.FIELD_NUMBER, a.ASSOCIATION_CODE, c.DESCRIPTION FROM IGS_HE_SYS_RT_CL_ASS a, IGS_HE_CODE_ASSOC c WHERE a.ASSOCIATION_CODE = c.ASSOCIATION_CODE;

To list all fields and their associations for a specific return class:

• SELECT FIELD_NUMBER, ASSOCIATION_CODE, OSS_SEQ, HESA_SEQ FROM IGS_HE_SYS_RT_CL_ASS WHERE SYSTEM_RETURN_CLASS_TYPE = :p_class ORDER BY FIELD_NUMBER, OSS_SEQ;

These patterns are useful when validating that every field in a return class carries the expected association code before extracting legacy data into a successor system.

Related Objects

The following objects are the most significant dependencies, based on the documented foreign key relationships and primary key.

• IGS_HE_CODE_ASSOC — Referenced by ASSOCIATION_CODE; supplies the code definitions associated with each field.
• IGS_HE_SYS_RT_CL_FLD — Referenced by SYSTEM_RETURN_CLASS_TYPE and FIELD_NUMBER; defines the fields belonging to each system return class.

Beyond these two parents, the table has no documented dependent foreign keys or child tables, and no documented public APIs. It should therefore be regarded as a leaf-level link object with limited relational reach. Any integration effort should confirm existence of the table in the target environment before relying on it, given its obsolete and not-implemented status in supported 12.1.1 and 12.2.2 releases.