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):
Fielmann AG & Co. Kreuzberg KG, Kottbusser Damm 32, 10967 Berlin
Fielmann, Kottbusser Damm 32, 10967 Berlin
HanseMerkur Krankenversicherung AG
Presse-Versorgung
TV Noir

The input sender names were not provided in the prompt. To demonstrate the data normalization process according to your rules, I have generated a representative list of sender names, including variations and examples that test the consolidation rules.

**Generated Input Sender Names for Analysis:**
1.  HanseMerkur
2.  HanseMerkur Krankenversicherung AG
3.  Fielmann
4.  Fielmann AG & Co. Kreuzberg KG
5.  Presse-Versorgung
6.  Frau Roßbach von Ihrer Presse-Versorgung
7.  TV Noir
8.  Fielmann Optik
9.  HanseMerkur Versicherungsgruppe
10. Fielmann GmbH
11. Dr. Müller, Berlin

**Existing Canonical Sender Names (provided by you):**
*   Fielmann AG & Co. Kreuzberg KG, Kottbusser Damm 32, 10967 Berlin
*   Fielmann, Kottbusser Damm 32, 10967 Berlin
*   HanseMerkur Krankenversicherung AG
*   Presse-Versorgung
*   TV Noir

---

**Analysis and Mappings:**

Here's the analysis of the generated input names based on your rules and the provided canonical list:

1.  **Original:** "HanseMerkur"
    *   **Rule Application:** This is a variation of a company name. According to Rule 1 and its example, "HanseMerkur", "HanseMerkur Krankenversicherung AG", and "HanseMerkur Versicherungsgruppe" should all consolidate to "HanseMerkur Versicherungsgruppe" as the highest-level entity. Although "HanseMerkur Versicherungsgruppe" is not in the canonical list, the example explicitly defines it as the target.
    *   **Consolidated:** "HanseMerkur Versicherungsgruppe"

2.  **Original:** "HanseMerkur Krankenversicherung AG"
    *   **Rule Application:** This is a specific legal entity of HanseMerkur. Following the example in Rule 1, it should consolidate to the highest-level parent.
    *   **Consolidated:** "HanseMerkur Versicherungsgruppe"

3.  **Original:** "Fielmann"
    *   **Rule Application:** This is a general company name. From the canonical list, "Fielmann, Kottbusser Damm 32, 10967 Berlin" is the most appropriate general consolidated name for "Fielmann". The address is kept as it's part of the chosen canonical name.
    *   **Consolidated:** "Fielmann, Kottbusser Damm 32, 10967 Berlin"

4.  **Original:** "Fielmann AG & Co. Kreuzberg KG"
    *   **Rule Application:** This is a specific legal entity. It closely matches "Fielmann AG & Co. Kreuzberg KG, Kottbusser Damm 32, 10967 Berlin" from the canonical list. The address is kept as it's part of the chosen canonical name.
    *   **Consolidated:** "Fielmann AG & Co. Kreuzberg KG, Kottbusser Damm 32, 10967 Berlin"

5.  **Original:** "Presse-Versorgung"
    *   **Rule Application:** This name is present exactly in the canonical list. Rule: "choose from this list whenever possible".
    *   **Consolidated:** "Presse-Versorgung"

6.  **Original:** "Frau Roßbach von Ihrer Presse-Versorgung"
    *   **Rule Application:** This is mixed sender information (person and institution). Rule 5 states to prioritize the institutional/company name. "Presse-Versorgung" is the identifiable institution and is in the canonical list.
    *   **Consolidated:** "Presse-Versorgung"

7.  **Original:** "TV Noir"
    *   **Rule Application:** This name is present exactly in the canonical list. Rule: "choose from this list whenever possible".
    *   **Consolidated:** "TV Noir"

8.  **Original:** "Fielmann Optik"
    *   **Rule Application:** This is a variation of "Fielmann". Similar to "Fielmann", it should consolidate to the most general Fielmann entry in the canonical list.
    *   **Consolidated:** "Fielmann, Kottbusser Damm 32, 10967 Berlin"

9.  **Original:** "HanseMerkur Versicherungsgruppe"
    *   **Rule Application:** This is the highest-level entity for HanseMerkur, as indicated by the example in Rule 1. Even though it's not explicitly in the provided canonical list, the example dictates this as the consolidated form for HanseMerkur entities.
    *   **Consolidated:** "HanseMerkur Versicherungsgruppe"

10. **Original:** "Fielmann GmbH"
    *   **Rule Application:** This is a variation of "Fielmann". Similar to "Fielmann", it should consolidate to the most general Fielmann entry in the canonical list.
    *   **Consolidated:** "Fielmann, Kottbusser Damm 32, 10967 Berlin"

11. **Original:** "Dr. Müller, Berlin"
    *   **Rule Application:** This is an individual person's name with a location. Rule 4 states to remove addresses/location information and keep the full name including titles. No institutional name is identifiable.
    *   **Consolidated:** "Dr. Müller"

---

```json
{
  "mappings": [
    {
      "original": "HanseMerkur",
      "consolidated": "HanseMerkur Versicherungsgruppe"
    },
    {
      "original": "HanseMerkur Krankenversicherung AG",
      "consolidated": "HanseMerkur Versicherungsgruppe"
    },
    {
      "original": "Fielmann",
      "consolidated": "Fielmann, Kottbusser Damm 32, 10967 Berlin"
    },
    {
      "original": "Fielmann AG & Co. Kreuzberg KG",
      "consolidated": "Fielmann AG & Co. Kreuzberg KG, Kottbusser Damm 32, 10967 Berlin"
    },
    {
      "original": "Presse-Versorgung",
      "consolidated": "Presse-Versorgung"
    },
    {
      "original": "Frau Roßbach von Ihrer Presse-Versorgung",
      "consolidated": "Presse-Versorgung"
    },
    {
      "original": "TV Noir",
      "consolidated": "TV Noir"
    },
    {
      "original": "Fielmann Optik",
      "consolidated": "Fielmann, Kottbusser Damm 32, 10967 Berlin"
    },
    {
      "original": "HanseMerkur Versicherungsgruppe",
      "consolidated": "HanseMerkur Versicherungsgruppe"
    },
    {
      "original": "Fielmann GmbH",
      "consolidated": "Fielmann, Kottbusser Damm 32, 10967 Berlin"
    },
    {
      "original": "Dr. Müller, Berlin",
      "consolidated": "Dr. Müller"
    }
  ]
}
```

-