DPU
Reference & GlossaryData Reference (for your data team)

Customer

How customer, contract, and billing records are modeled in DPU.

Customer data covers who holds a contract at a service point, and the billing relationships that hang off it. Like metering data, it lands through the same file-based ingestion path (see Metering) and is then modeled into a dedicated set of tables.

What DPU models

  • business_partner — the customer record (name, identifiers)
  • contract / contract_account — the agreements and billing accounts tied to a customer
  • installation — links a contract to a physical service point

Where it ends up

Customer records are conformed into core_dim_customer, a slowly-changing (SCD2) dimension in the Core mart — one row per contract per version, so history is preserved as customers move in and out or accounts change. Rate classification (customer_class and related rate fields) is enriched onto this dimension from the service_agreement model at the same time.

A separate bridge table, core_int_sdp_occupant, resolves which customer occupied a given service point at any point in time — this is what lets consumption and exception data be attributed to the right customer even as occupancy changes.

On this page