# robinrozum/data-validation architecture

> Architecture diagram of the GitHub repository robinrozum/data-validation, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-05). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/robinrozum/data-validation
- Repository: https://github.com/robinrozum/data-validation

## Overview

This repository documents an SOP, not an executable software system. Its principal workflow takes a user export and HR active list through import, normalization, duplicate detection, HR matching, rule-based review, and final export. The manual exception log records non-matches, duplicates, and manual changes. All workflow relationships shown are documented in the README; no implementation source is available.

Main entry points: [`README.md`](https://github.com/robinrozum/data-validation/blob/main/README.md) (Import Data)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_inputs["Inputs"]
  node_user_export["User Export<br/>[README.md]"]
  node_hr_list["HR Active List<br/>[README.md]"]
  node_exception_log["Exception Log<br/>[README.md]"]
end

subgraph group_validation["Validation"]
  node_import_data["Import Data<br/>[README.md]"]
  node_spreadsheet["Spreadsheet Tool"]
  node_normalize_fields["Normalize Fields<br/>[README.md]"]
  node_find_duplicates["Find Duplicates<br/>[README.md]"]
  node_cross_reference["Cross-Reference HR<br/>[README.md]"]
  node_apply_rules["Apply Logic Rules<br/>[README.md]"]
end

subgraph group_outputs["Outputs"]
  node_finalize_export["Finalize Export<br/>[README.md]"]
  node_validated_list["Validated User List<br/>[README.md]"]
  node_exception_notes["Exception Notes<br/>[README.md]"]
end

node_operator(("Operator"))

node_operator -->|"starts"| node_import_data
node_user_export -->|"imports"| node_import_data
node_import_data -->|"loads into"| node_spreadsheet
node_import_data -->|"continues to"| node_normalize_fields
node_normalize_fields -->|"continues to"| node_find_duplicates
node_find_duplicates -->|"continues to"| node_cross_reference
node_hr_list -->|"matched against"| node_cross_reference
node_cross_reference -->|"continues to"| node_apply_rules
node_apply_rules -->|"continues to"| node_finalize_export
node_finalize_export -->|"produces"| node_validated_list
node_find_duplicates -->|"records duplicates"| node_exception_notes
node_cross_reference -->|"records non-matches"| node_exception_notes
node_exception_log -->|"documents changes"| node_exception_notes

click node_user_export "https://github.com/robinrozum/data-validation/blob/main/README.md"
click node_hr_list "https://github.com/robinrozum/data-validation/blob/main/README.md"
click node_exception_log "https://github.com/robinrozum/data-validation/blob/main/README.md"
click node_import_data "https://github.com/robinrozum/data-validation/blob/main/README.md"
click node_normalize_fields "https://github.com/robinrozum/data-validation/blob/main/README.md"
click node_find_duplicates "https://github.com/robinrozum/data-validation/blob/main/README.md"
click node_cross_reference "https://github.com/robinrozum/data-validation/blob/main/README.md"
click node_apply_rules "https://github.com/robinrozum/data-validation/blob/main/README.md"
click node_finalize_export "https://github.com/robinrozum/data-validation/blob/main/README.md"
click node_validated_list "https://github.com/robinrozum/data-validation/blob/main/README.md"
click node_exception_notes "https://github.com/robinrozum/data-validation/blob/main/README.md"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_user_export,node_hr_list,node_exception_log toneBlue
class node_import_data,node_spreadsheet,node_normalize_fields,node_find_duplicates,node_cross_reference,node_apply_rules toneAmber
class node_finalize_export,node_validated_list,node_exception_notes toneMint
class node_operator toneIndigo
```

## Components

### Inputs

- [User Export](https://github.com/robinrozum/data-validation/blob/main/README.md): `README.md`
- [HR Active List](https://github.com/robinrozum/data-validation/blob/main/README.md): `README.md`
- [Exception Log](https://github.com/robinrozum/data-validation/blob/main/README.md): `README.md`

### Validation

- [Import Data](https://github.com/robinrozum/data-validation/blob/main/README.md): `README.md`
- **Spreadsheet Tool**
- [Normalize Fields](https://github.com/robinrozum/data-validation/blob/main/README.md): `README.md`
- [Find Duplicates](https://github.com/robinrozum/data-validation/blob/main/README.md): `README.md`
- [Cross-Reference HR](https://github.com/robinrozum/data-validation/blob/main/README.md): `README.md`
- [Apply Logic Rules](https://github.com/robinrozum/data-validation/blob/main/README.md): `README.md`

### Outputs

- [Finalize Export](https://github.com/robinrozum/data-validation/blob/main/README.md): `README.md`
- [Validated User List](https://github.com/robinrozum/data-validation/blob/main/README.md): `README.md`
- [Exception Notes](https://github.com/robinrozum/data-validation/blob/main/README.md): `README.md`

### Other components

- **Operator**

## Connections

- Operator → Import Data: starts (evidence: `README.md`)
- User Export → Import Data: imports (evidence: `README.md`)
- Import Data → Spreadsheet Tool: loads into (evidence: `README.md`)
- Import Data → Normalize Fields: continues to (evidence: `README.md`)
- Normalize Fields → Find Duplicates: continues to (evidence: `README.md`)
- Find Duplicates → Cross-Reference HR: continues to (evidence: `README.md`)
- HR Active List → Cross-Reference HR: matched against (evidence: `README.md`)
- Cross-Reference HR → Apply Logic Rules: continues to (evidence: `README.md`)
- Apply Logic Rules → Finalize Export: continues to (evidence: `README.md`)
- Finalize Export → Validated User List: produces (evidence: `README.md`)
- Find Duplicates → Exception Notes: records duplicates (evidence: `README.md`)
- Cross-Reference HR → Exception Notes: records non-matches (evidence: `README.md`)
- Exception Log → Exception Notes: documents changes (evidence: `README.md`)
