Results for “igs_he_code_map_val_u1”

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

Overview

IGS_HE_CODE_MAP_VAL is a table within the IGS (Student System) schema of Oracle E-Business Suite, and it forms part of the broader HESA (Higher Education Statistics Agency) reporting infrastructure delivered with Oracle Student System. The table stores the Oracle Student System mapping values that correspond to HESA association codes. In practical terms, it acts as a decoding and translation layer between the internal codes and classifications used by Oracle Student System and the external code values required by HESA statutory returns. Each row associates a HESA association code with up to ten discrete mapping values, allowing a single association definition to resolve to multiple coded outputs.

From a data modeling perspective, the heuristic Data Vault classification for this object is satellite-leaning. This characterization is derived from the foreign key structure, in which IGS_HE_CODE_MAP_VAL references the parent association definition table IGS_HE_CODE_ASSOC. The table therefore behaves less like an independent hub of business keys and more like a descriptive satellite attached to the association code entity, holding the varying attribute values that qualify and extend each association.

Key Information Stored

The table comprises 18 documented columns. The most significant elements are the following:

• SEQUENCE — The surrogate primary key column, enforced through the primary key constraint IGS_HE_CODE_MAP_VAL_PK. It provides the unique row identifier.
• ASSOCIATION_CODE — The foreign key linking each mapping row back to IGS_HE_CODE_ASSOC. This is the anchor that ties mapping values to their parent association definition, and it participates in the business-key unique index.
• MAP1 through MAP10 — Ten positional mapping value columns that hold the actual Oracle Student System codes or values corresponding to the associated HESA association code. Together with ASSOCIATION_CODE these columns form the unique index IGS_HE_CODE_MAP_VAL_U1, which serves as the principal business-key candidate and prevents duplicate mapping combinations.
• MAP_DESCRIPTION — A descriptive label that documents the purpose or meaning of the mapping row, supporting both user comprehension and reporting readability.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording who created and last modified the row and when, along with the login context of the most recent change.

The distinction between the surrogate key (SEQUENCE) and the business-key candidate (ASSOCIATION_CODE plus MAP1 through MAP10) is important: the surrogate guarantees row-level uniqueness, while the unique index enforces the semantic rule that a given association cannot map to the same combination of values more than once.

Common Use Cases and Queries

Typical usage centers on HESA return preparation, validating that every Oracle Student System code in scope resolves to the expected association value, and diagnosing mismatches that cause records to fail statutory validation. A representative query retrieves all mapping values for a given association:

• SELECT association_code, map_description, map1, map2, map3 FROM igs_he_code_map_val WHERE association_code = :code;
• Joining to the parent association table to display the descriptive context of each mapping: SELECT a.association_code, a.description, m.map1, m.map2 FROM igs_he_code_assoc a, igs_he_code_map_val m WHERE a.association_code = m.association_code;
• Detecting duplicate or conflicting mappings by grouping on the business-key columns and counting occurrences.
• Audit reporting on recent maintenance activity using LAST_UPDATED_BY and LAST_UPDATE_DATE.

Related Objects

The most significant relationship is with the parent association definition table, which the foreign key explicitly documents:

• IGS_HE_CODE_ASSOC — referenced by IGS_HE_CODE_MAP_VAL.ASSOCIATION_CODE; this is the primary parent object and the mandatory join path.
• IGS_HE_CODE_MAP_VAL_PK / IGS_HE_CODE_MAP_VAL_U1 — the primary key constraint and the unique business-key index that govern integrity of the table.
• Other IGS HESA code and mapping tables that share the ASSOCIATION_CODE conventions used by IGS_HE_CODE_ASSOC, which are commonly joined during HESA extract processing.
• Student System HESA extract and validation concurrent programs that read these mapping values to produce statutory returns.