3.8 Managing Market Variable Data Mapping

The Market Variable Data Mapping feature allows users to define and manage how market variables are mapped to STSA variables. Use this configuration to define and manage how market variables are mapped to STSA variables.

Market Variable Data Mapping Interface Overview

The Market Variable Data Mapping page provides a structured layout for defining and maintaining variable mappings. It includes:

  • Summary Screen Displays all available variables, grouped by their logical reference and variable name.
    Status color indicators help users identify mapping completion status:
    • Red: No tables mapped to the logical reference
    • Orange: Some tables mapped
    • Green: All tables mapped
    • Neutral Gray: No tables mapped (but optional)

Mapping Screen – Guided Process

Follow these steps to complete the market variable data mapping using the guided screen:

  1. On the Mapping Screen, locate the two sections:
    • Primary Section
    • Non-Primary Section

    Each section lists the Column Name, Column Type, and a Value field where you must enter or select valid values. Enter all required values in the Primary Columns section, and provide values in the Non-Primary Columns section only if applicable.

  2. In the Primary Section, enter valid values in all required fields.
  3. In the Non-Primary Section, enter values only if applicable for your configuration.
  4. Use the Data Catalog screen to perform dimension mapping and retrieve the appropriate drop-down values. If a foreign key relationship exists, the drop-down values will appear automatically. If there is no foreign key relationship, you must configure the dimension mapping in the Data Catalog to populate the drop-down options. Alternatively, you can enter the value manually.

    Note:

    • When entering a value manually, ensure it is a valid raw value that precisely matches the required format.
    • If a mandatory glossary term is not mapped, the system displays an error. For example, the DIMENSION.DATE glossary term must be mapped to a valid FIC MIS Date column in the Data Catalog. The mapping cannot be saved until the error is resolved.
  5. After entering the values, click Save at the bottom of the page to confirm your mappings.

    Note:

    Saving is enabled at each step; however, you must resolve any validation errors (if displayed) before proceeding.