Mapping Thomson Reuters taxonomy values to OpenPages field values

You can map values in the Thomson Reuters taxonomy to values in IBM OpenPages® with Watson™. You define the mappings by editing the taxonomy mapping file.

Before you begin

  • Ensure that each field group that you want to use is associated with the TRRI Regulatory Event object type.
  • Ensure that each field that you want to use is an enumerated string field. The values that you want to use in the mapping file must be available in the enumerated string field.

About this task

To do this task, you need the SOX > Administration > TRRI Feed permission.

Procedure

  1. Click Primary menu icon to open the Primary menu.
  2. Click Regulatory Compliance > TRRI Regulatory Events.
  3. Click Configure.
  4. Click Download the latest mapping file (.csv) and save the file.
  5. Create a backup of the trri_taxonomy_map.csv file.
  6. Open the trri_taxonomy_map.csv file.
    Figure 1. Example of the taxonomy file in Microsoft Excel
    The trri_taxonomy_map.csv file is shown in Microsoft Excel.
  7. In column E, locate the Thomson Reuters value that you want to map to a field value in OpenPages.
  8. For each value that you want to map, enter the following information:
    • In column F, type the field group.
    • In column G, type the field name.
    • In column H, type the field value.

    The Thomson Reuters value in column E will be mapped to the OpenPages value in column H.

    Note: Do not edit the values in columns A to E.
  9. Save the file as a CSV text file.
  10. Return to OpenPages.
  11. On the TRRI Regulatory Events page, click Configure.
  12. Click Upload.

Results

The taxonomy mapping file is uploaded. The next time that you import data from Thomson Reuters, your taxonomy mappings are applied to the incoming regulatory events.