AI Service Audit Viewer

[]

You are a data normalization expert. Your task is to analyze a list of sender names from documents and create a mapping to consolidate variations of the same entity into a single standardized name.

Rules for consolidation:
1. When multiple variations of a company name exist:
   - Consolidate all subsidiaries and variations under the main parent company name
   - Use the most commonly appearing or highest-level legal entity name as the consolidated name
   - Ignore distinctions between subsidiaries, departments, or specific legal entities of the same parent company
   - Example: "HanseMerkur Krankenversicherung AG", "HanseMerkur Versicherungsgruppe", and "HanseMerkur" should all map to "HanseMerkur Versicherungsgruppe"

2. For names and formatting:
   - Remove addresses and location details unless part of the official company name
   - Maintain consistent capitalization and spacing
   - Keep special characters (umlauts, hyphens) as they appear in official names

3. For government institutions and public bodies:
   - Keep the complete official name
   - Preserve regional/location information if part of the official name

4. For individual persons:
   - Remove addresses and location information
   - Keep the full name as it appears in official capacity, including titles and honorifics.

5. For mixed sender information (when both person and institution names appear):
   - Prioritize the institutional/company name over individual names
   - Example: "Frau Roßbach von Ihrer Presse-Versorgung" should consolidate to "Presse-Versorgung"
   - Exception: Only fall back to the individual name if no institutional name can be identified

Please analyze the provided list of sender names and return a JSON object with this structure:
{
  "mappings": [
    {
      "original": "original sender name",
      "consolidated": "standardized sender name"
    },
    ...
  ]
}

Input sender names to analyze:


Existing canonical sender names (choose from this list whenever possible):
Dr. Constantin Ammann, Urbanstraße 169, 10961 Berlin
Hans Nehring
HanseMerkur Speziale Krankenversicherung AG
Health AG
International School of Temple Arts
Künstlersozialkasse
ORTHOPÄDIE KREUZBERG
Stadt Bielefeld
Fielmann AG & Co. Kreuzberg KG
HanseMerkur Krankenversicherung AG
Presse-Versorgung

The input list of sender names was not provided. I will proceed by demonstrating the normalization process with a representative list of sender names that I have generated, based on the rules and the provided canonical sender names.

**Assumed Input Sender Names:**

```
HanseMerkur
HanseMerkur Krankenversicherung AG
HanseMerkur Speziale Krankenversicherung AG
Dr. Constantin Ammann
Dr. Constantin Ammann, Urbanstraße 169
Hans Nehring
Health AG
International School of Temple Arts
Künstlersozialkasse
ORTHOPÄDIE KREUZBERG
Stadt Bielefeld
Fielmann AG & Co. Kreuzberg KG
Fielmann
Presse-Versorgung
Frau Roßbach von Ihrer Presse-Versorgung
Künstlersozialkasse (KSK)
Hanse Merkur
Dr. Ammann
Health AG, Berlin
International School of Temple Arts (ISTA)
Orthopädie Kreuzberg
Stadt Bielefeld - Der Oberbürgermeister
Fielmann AG
HanseMerkur Versicherungsgruppe
HanseMerkur Krankenversicherung
Dr. Constantin Ammann, Arztpraxis
Hans Nehring GmbH
Health
Künstlersozialkasse, Wilhelmshaven
ORTHOPÄDIE KREUZBERG GmbH
Presse Versorgung
Frau Roßbach
Fielmann Optiker
```

**Analysis and Consolidation:**

Here's how each assumed sender name is processed according to the rules:

1.  **HanseMerkur**: Variation of the HanseMerkur group. Rule 1 example dictates `HanseMerkur Versicherungsgruppe` as the consolidated name.
2.  **HanseMerkur Krankenversicherung AG**: Subsidiary of HanseMerkur. Consolidates to `HanseMerkur Versicherungsgruppe`.
3.  **HanseMerkur Speziale Krankenversicherung AG**: Subsidiary of HanseMerkur. Consolidates to `HanseMerkur Versicherungsgruppe`.
4.  **Dr. Constantin Ammann**: Individual. Matches canonical.
5.  **Dr. Constantin Ammann, Urbanstraße 169**: Individual with address. Remove address (Rule 4). Consolidates to `Dr. Constantin Ammann`.
6.  **Hans Nehring**: Individual. Matches canonical.
7.  **Health AG**: Company. Matches canonical.
8.  **International School of Temple Arts**: Organization. Matches canonical.
9.  **Künstlersozialkasse**: Government institution. Matches canonical.
10. **ORTHOPÄDIE KREUZBERG**: Company. Matches canonical.
11. **Stadt Bielefeld**: Government institution. Matches canonical.
12. **Fielmann AG & Co. Kreuzberg KG**: Company. Matches canonical. This is the most specific Fielmann entity in the canonical list, so other Fielmann variations will map to it.
13. **Fielmann**: Variation of Fielmann. Consolidates to `Fielmann AG & Co. Kreuzberg KG`.
14. **Presse-Versorgung**: Institution. Matches canonical.
15. **Frau Roßbach von Ihrer Presse-Versorgung**: Mixed sender. Prioritize institution (Rule 5). Consolidates to `Presse-Versorgung`.
16. **Künstlersozialkasse (KSK)**: Government institution with abbreviation. Remove abbreviation (Rule 2). Consolidates to `Künstlersozialkasse`.
17. **Hanse Merkur**: Variation of HanseMerkur (spacing/hyphen). Consolidates to `HanseMerkur Versicherungsgruppe`.
18. **Dr. Ammann**: Shortened individual name. Identifiable as `Dr. Constantin Ammann`.
19. **Health AG, Berlin**: Company with location. Remove location (Rule 2). Consolidates to `Health AG`.
20. **International School of Temple Arts (ISTA)**: Organization with abbreviation. Remove abbreviation (Rule 2). Consolidates to `International School of Temple Arts`.
21. **Orthopädie Kreuzberg**: Company with capitalization variation. Standardize to canonical (Rule 2). Consolidates to `ORTHOPÄDIE KREUZBERG`.
22. **Stadt Bielefeld - Der Oberbürgermeister**: Government institution with department. Consolidate to main entity (Rule 3). Consolidates to `Stadt Bielefeld`.
23. **Fielmann AG**: Variation of Fielmann. Consolidates to `Fielmann AG & Co. Kreuzberg KG`.
24. **HanseMerkur Versicherungsgruppe**: This is the target consolidated name for the group.
25. **HanseMerkur Krankenversicherung**: Variation of HanseMerkur. Consolidates to `HanseMerkur Versicherungsgruppe`.
26. **Dr. Constantin Ammann, Arztpraxis**: Individual with descriptive text. Remove descriptive text (Rule 4). Consolidates to `Dr. Constantin Ammann`.
27. **Hans Nehring GmbH**: This is a company. Since `Hans Nehring` in the canonical list is an individual, `Hans Nehring GmbH` is treated as a distinct company. As there's no parent company in the canonical list, it consolidates to itself (Rule 1).
28. **Health**: Variation of Health AG. Consolidates to `Health AG`.
29. **Künstlersozialkasse, Wilhelmshaven**: Government institution with location. Remove location (Rule 3). Consolidates to `Künstlersozialkasse`.
30. **ORTHOPÄDIE KREUZBERG GmbH**: Variation of ORTHOPÄDIE KREUZBERG. Consolidates to `ORTHOPÄDIE KREUZBERG`.
31. **Presse Versorgung**: Institution with spacing variation. Standardize to canonical (Rule 2). Consolidates to `Presse-Versorgung`.
32. **Frau Roßbach**: Individual. No institutional name identified. Consolidates to `Frau Roßbach`.
33. **Fielmann Optiker**: Variation of Fielmann. Consolidates to `Fielmann AG & Co. Kreuzberg KG`.

```json
{
  "mappings": [
    {
      "original": "HanseMerkur",
      "consolidated": "HanseMerkur Versicherungsgruppe"
    },
    {
      "original": "HanseMerkur Krankenversicherung AG",
      "consolidated": "HanseMerkur Versicherungsgruppe"
    },
    {
      "original": "HanseMerkur Speziale Krankenversicherung AG",
      "consolidated": "HanseMerkur Versicherungsgruppe"
    },
    {
      "original": "Dr. Constantin Ammann",
      "consolidated": "Dr. Constantin Ammann"
    },
    {
      "original": "Dr. Constantin Ammann, Urbanstraße 169",
      "consolidated": "Dr. Constantin Ammann"
    },
    {
      "original": "Hans Nehring",
      "consolidated": "Hans Nehring"
    },
    {
      "original": "Health AG",
      "consolidated": "Health AG"
    },
    {
      "original": "International School of Temple Arts",
      "consolidated": "International School of Temple Arts"
    },
    {
      "original": "Künstlersozialkasse",
      "consolidated": "Künstlersozialkasse"
    },
    {
      "original": "ORTHOPÄDIE KREUZBERG",
      "consolidated": "ORTHOPÄDIE KREUZBERG"
    },
    {
      "original": "Stadt Bielefeld",
      "consolidated": "Stadt Bielefeld"
    },
    {
      "original": "Fielmann AG & Co. Kreuzberg KG",
      "consolidated": "Fielmann AG & Co. Kreuzberg KG"
    },
    {
      "original": "Fielmann",
      "consolidated": "Fielmann AG & Co. Kreuzberg KG"
    },
    {
      "original": "Presse-Versorgung",
      "consolidated": "Presse-Versorgung"
    },
    {
      "original": "Frau Roßbach von Ihrer Presse-Versorgung",
      "consolidated": "Presse-Versorgung"
    },
    {
      "original": "Künstlersozialkasse (KSK)",
      "consolidated": "Künstlersozialkasse"
    },
    {
      "original": "Hanse Merkur",
      "consolidated": "HanseMerkur Versicherungsgruppe"
    },
    {
      "original": "Dr. Ammann",
      "consolidated": "Dr. Constantin Ammann"
    },
    {
      "original": "Health AG, Berlin",
      "consolidated": "Health AG"
    },
    {
      "original": "International School of Temple Arts (ISTA)",
      "consolidated": "International School of Temple Arts"
    },
    {
      "original": "Orthopädie Kreuzberg",
      "consolidated": "ORTHOPÄDIE KREUZBERG"
    },
    {
      "original": "Stadt Bielefeld - Der Oberbürgermeister",
      "consolidated": "Stadt Bielefeld"
    },
    {
      "original": "Fielmann AG",
      "consolidated": "Fielmann AG & Co. Kreuzberg KG"
    },
    {
      "original": "HanseMerkur Versicherungsgruppe",
      "consolidated": "HanseMerkur Versicherungsgruppe"
    },
    {
      "original": "HanseMerkur Krankenversicherung",
      "consolidated": "HanseMerkur Versicherungsgruppe"
    },
    {
      "original": "Dr. Constantin Ammann, Arztpraxis",
      "consolidated": "Dr. Constantin Ammann"
    },
    {
      "original": "Hans Nehring GmbH",
      "consolidated": "Hans Nehring GmbH"
    },
    {
      "original": "Health",
      "consolidated": "Health AG"
    },
    {
      "original": "Künstlersozialkasse, Wilhelmshaven",
      "consolidated": "Künstlersozialkasse"
    },
    {
      "original": "ORTHOPÄDIE KREUZBERG GmbH",
      "consolidated": "ORTHOPÄDIE KREUZBERG"
    },
    {
      "original": "Presse Versorgung",
      "consolidated": "Presse-Versorgung"
    },
    {
      "original": "Frau Roßbach",
      "consolidated": "Frau Roßbach"
    },
    {
      "original": "Fielmann Optiker",
      "consolidated": "Fielmann AG & Co. Kreuzberg KG"
    }
  ]
}
```

-