On this page
Follow the Aurelia customer data
Trace the sample records, catalog relationships, and data defects before reviewing quality or duplicates.
Installed tables and records
GET /api/entities/sample-customer-entity
Records in sample_customer | 378 — 294 from the CRM, 84 from billing |
| Buckets | 1,129, of which 245 hold a possible duplicate |
| Records with a possible duplicate | 212 |
| Entity type | DUPLICATES, status READY |
| Resources | 23 |
The installation also creates three lookup tables:
| Table | Rows | What it is |
|---|---|---|
sample_customer | 378 | The unified customer master. Keeps history and audit |
sample_supply_point | 1200 | Supply points (CUPS), the master a customer’s meter points at |
sample_province | 20 | Provinces. A master table that itself references another master table |
sample_region | 17 | Autonomous communities |
Lookup relationships
sample_province carries a FOREIGN_ID column resolving against
sample_region.regionCode, and sample_customer carries two of them —
province against sample_province.province, and supplyPoint against
sample_supply_point.cups. These relationships let you inspect a lookup from a customer to a province
and from that province to a region.
A record form presents lookup catalogs of up to 500 values as a select control. Larger catalogs use a search input. The 1,200 supply-point records let you test the search behavior alongside the smaller province and region catalogs.
Sample quality issues
The CRM and billing records include differences in formatting, incomplete emails, and missing identifiers or phone numbers. Use these cases to inspect quality findings and candidate comparisons.
Three records for Ana García Muñoz
| Source | Reference | Full name | Tax ID | Phone | |
|---|---|---|---|---|---|
| CRM | CRM-0001 | Ana García Muñoz | 12345678Z | ana.garcia@example.com | 611000000 |
| CRM | CRM-DUP-0001 | ANA Garcaí Muñoz | 12345678Z | Ana.Garcia@Example.com | +34 611 00 00 00 |
| BILLING | BILL-0001 | Ana Garcia Munoz | (empty) | ana.garcia@ | (none) |
The second CRM record represents Ana with differences in case, spacing, spelling, phone formatting, and street abbreviation. The billing record lacks a tax identifier and phone and has an incomplete email. The name-and-postcode mapping can still group it for comparison.
Two customers named Javier Torres Melgar
| Tax ID | Street | Postcode |
|---|---|---|
31415926R | Calle Zamora 14 | 37001 |
27182818W | Calle Zamora 16 | 37001 |
These records represent different people with the same name and postcode. The name-and-postcode index groups them as candidates. Their tax identifiers differ, and the classifier gives that field a weight of 3.0.
Inspect the comparison before making a decision. Candidate membership alone does not establish that the records describe the same customer.
Continue with Read sample quality.