SchemaPage 45Generated 2026-05-17DAMA · Data Modeling & Design
Utilities & energy
343 leaves72.9% Declaration27.1% Evidence0.0% Derivation202 in overlays0 with worked example
What runs into and out of the building: heating, electricity, water, drainage, broadband, mobile. Plus the property's energy performance certificate (EPC). These leaves cluster because they share physics — they're all couplings between the property and an external utility network — and because they share enumerations (fuel types, meter identifiers, service grades).
Mentioned but not owned here. This page references but does not own councilTax (canonical home page 47).
Entity relationships
---
config:
layout: elk
elk:
direction: DOWN
nodePlacementStrategy: BRANDES_KOEPF
mergeEdges: false
---
erDiagram
Transaction ||--o| PropertyPack : "propertyPack"
PropertyPack ||--o| EnergyEfficiency : "energyEfficiency"
PropertyPack ||--o| Electricity : "electricity"
PropertyPack ||--o| WaterAndDrainage : "waterAndDrainage"
PropertyPack ||--o| Heating : "heating"
PropertyPack ||--o| Connectivity : "connectivity"
PropertyPack ||--o| ServicesCrossing : "servicesCrossing"
Connectivity ||--o| Telephone : "telephone"
Connectivity ||--o| CableSatelliteTV : "cableSatelliteTV"
Connectivity ||--o| Broadband : "broadband"
Connectivity ||--o| MobilePhone : "mobilePhone"
Broadband ||--o| PredictedSpeed : "predictedSpeed"
MobilePhone ||--o| KnownSignalIssues : "knownSignalIssues"
MobilePhone ||--o| PredictedCoverage : "predictedCoverage"
Electricity ||--o| MainsElectricity : "mainsElectricity"
Electricity ||--o| SolarPanels : "solarPanels"
Electricity ||--o| HeatPump : "heatPump"
Electricity ||--o| OtherSources : "otherSources"
MainsElectricity ||--o| ElectricityMeter : "electricityMeter"
SolarPanels ||--o| PanelsOwnedOutright : "panelsOwnedOutright"
SolarPanels ||--o| PanelProviderLease : "panelProviderLease"
SolarPanels ||--o| InGoodWorkingOrder : "inGoodWorkingOrder"
SolarPanels ||--o| PhotovoltaicMeterPanelLocation : "photovoltaicMeterPanelLocation"
SolarPanels ||--o| PhotovoltaicBatteriesLocation : "photovoltaicBatteriesLocation"
EnergyEfficiency ||--o| Certificate : "certificate"
EnergyEfficiency ||--o{ Recommendation : "recommendations"
EnergyEfficiency ||--o| GreenDealLoan : "greenDealLoan"
GreenDealLoan ||--o| HasGreenDealLoan : "hasGreenDealLoan"
Heating ||--o| HeatingSystem : "heatingSystem"
HeatingSystem ||--o| CentralHeatingDetails : "centralHeatingDetails"
CentralHeatingDetails ||--o| CentralHeatingFuel : "centralHeatingFuel"
CentralHeatingDetails ||--o| BoilerInstallationCertificate : "boilerInstallationCertificate"
CentralHeatingDetails ||--o| HeatingInGoodWorkingOrder : "heatingInGoodWorkingOrder"
CentralHeatingFuel ||--o| GasMeter : "gasMeter"
ServicesCrossing ||--o| PipesWiresCablesDrainsToProperty : "pipesWiresCablesDrainsToProperty"
ServicesCrossing ||--o| PipesWiresCablesDrainsFromProperty : "pipesWiresCablesDrainsFromProperty"
ServicesCrossing ||--o| FormalOrInformalAgreements : "formalOrInformalAgreements"
WaterAndDrainage ||--o| Maps : "maps"
WaterAndDrainage ||--o| Water : "water"
WaterAndDrainage ||--o| Drainage : "drainage"
WaterAndDrainage ||--o| MaintenanceAgreements : "maintenanceAgreements"
WaterAndDrainage ||--o| Charging : "charging"
Drainage ||--o| MainsSurfaceWaterDrainage : "mainsSurfaceWaterDrainage"
Drainage ||--o| MainsFoulDrainage : "mainsFoulDrainage"
Drainage ||--o| SurfaceDrainageCharge : "surfaceDrainageCharge"
Drainage ||--o| PublicDrainWithinBoundaries : "publicDrainWithinBoundaries"
Drainage ||--o| PublicPumpingStationWithinBoundaries : "publicPumpingStationWithinBoundaries"
Drainage ||--o| PublicSewerWithin100ft : "publicSewerWithin100ft"
Drainage ||--o| PublicPumpingStationWithin50mOfBuildings : "publicPumpingStationWithin50mOfBuildings"
Drainage ||--o| SewersSubjectOfAdoptionAgreement : "sewersSubjectOfAdoptionAgreement"
Drainage ||--o| SewerageUndertakerApproval : "sewerageUndertakerApproval"
Drainage ||--o| RiskOfInternalFlooding : "riskOfInternalFlooding"
MainsFoulDrainage ||--o| OffMainsDrainageSystem : "offMainsDrainageSystem"
OffMainsDrainageSystem ||--o| OtherConnectedProperties : "otherConnectedProperties"
OffMainsDrainageSystem ||--o| PlantOnOtherLand : "plantOnOtherLand"
OffMainsDrainageSystem ||--o| PlantRegistered : "plantRegistered"
OffMainsDrainageSystem ||--o| PlantDrainsIntoWaterway : "plantDrainsIntoWaterway"
Water ||--o| MainsWater : "mainsWater"
Water ||--o| WaterMainsWithinBoundaries : "waterMainsWithinBoundaries"
Water ||--o| WaterMainsSubjectOfAdoptionAgreement : "waterMainsSubjectOfAdoptionAgreement"
Water ||--o| LowWaterPressureRisk : "lowWaterPressureRisk"
MainsWater ||--o| Stopcock : "stopcock"
MainsWater ||--o| WaterMeter : "waterMeter"
Transaction {
}
PropertyPack {
}
Connectivity {
}
Broadband {
string typeOfConnection "Type of connection"
}
PredictedSpeed {
number maxBbPredictedDown "maxBbPredictedDown"
number maxBbPredictedUp "maxBbPredictedUp"
number maxPredictedDown "maxPredictedDown"
number maxPredictedUp "maxPredictedUp"
number maxSfbbPredictedDown "maxSfbbPredictedDown"
number maxSfbbPredictedUp "maxSfbbPredictedUp"
number maxUfbbPredictedDown "maxUfbbPredictedDown"
number maxUfbbPredictedUp "maxUfbbPredictedUp"
}
CableSatelliteTV {
string dateToBeConnected "Date to be connected"
string supplier "Supplier"
string yesNo "yesNo"
}
MobilePhone {
}
KnownSignalIssues {
string details "Details"
string yesNo "yesNo"
}
PredictedCoverage {
integer eeDataIndoor "eeDataIndoor"
integer eeDataIndoorNo4g "eeDataIndoorNo4g"
integer eeDataOutdoor "eeDataOutdoor"
integer eeDataOutdoorNo4g "eeDataOutdoorNo4g"
integer eeVoiceIndoor "eeVoiceIndoor"
integer eeVoiceIndoorNo4g "eeVoiceIndoorNo4g"
integer eeVoiceOutdoor "eeVoiceOutdoor"
integer eeVoiceOutdoorNo4g "eeVoiceOutdoorNo4g"
integer h3DataIndoor "h3DataIndoor"
integer h3DataIndoorNo4g "h3DataIndoorNo4g"
integer h3DataOutdoor "h3DataOutdoor"
integer h3DataOutdoorNo4g "h3DataOutdoorNo4g"
integer h3VoiceIndoor "h3VoiceIndoor"
integer h3VoiceIndoorNo4g "h3VoiceIndoorNo4g"
integer h3VoiceOutdoor "h3VoiceOutdoor"
integer h3VoiceOutdoorNo4g "h3VoiceOutdoorNo4g"
integer tfDataIndoor "tfDataIndoor"
integer tfDataIndoorNo4g "tfDataIndoorNo4g"
string _more_ "+14 more — see table"
}
Telephone {
string dateToBeConnected "Date to be connected"
string supplier "Supplier"
string yesNo "yesNo"
}
Electricity {
}
HeatPump {
string attachments "If after 2013 please provide Building Regulations approva…"
string dateInstalled "Date installed"
string dateToBeConnected "Date to be connected"
string details "Details"
string supplier "Supplier"
string yesNo "yesNo"
}
MainsElectricity {
string dateToBeConnected "Date to be connected"
string supplier "Supplier"
string yesNo "yesNo"
}
ElectricityMeter {
string attachments "Photograph of meter location"
string location "Describe the location of the meter"
integer mpan "Meter Point Administration Number (MPAN)"
}
OtherSources {
string dateToBeConnected "Date to be connected"
string details "Details"
string supplier "Supplier"
string yesNo "yesNo"
}
SolarPanels {
string dateToBeConnected "Date to be connected"
string isConnectedToNationalGrid "Is the system connected to the National Grid e.g. for fee…"
string lastMaintained "When was the system last maintained or serviced?"
string supplier "Supplier"
integer yearInstalled "What year were they installed?"
string yesNo "yesNo"
}
InGoodWorkingOrder {
string details "Details"
string yesNo "yesNo"
}
PanelProviderLease {
string attachments "Please supply copies of the relevant documents"
string details "Name of the provider"
string yesNo "yesNo"
}
PanelsOwnedOutright {
string attachments "Attachments"
string details "Provide details of who owns them and the relevant documen…"
string yesNo "yesNo"
}
PhotovoltaicBatteriesLocation {
string attachments "Photograph of batteries location"
string description "Describe the location of the batteries"
}
PhotovoltaicMeterPanelLocation {
string attachments "Photograph of meter location"
string description "Describe the location of the meter"
}
EnergyEfficiency {
string certificateIsSupplied "Please supply a copy of the EPC for the property"
}
Certificate {
string address "address"
string address1 "address1"
string address2 "address2"
string address3 "address3"
string buildingReferenceNumber "buildingReferenceNumber"
string builtForm "builtForm"
string certificateNumber "certificateNumber"
number co2EmissCurrPerFloorArea "co2EmissCurrPerFloorArea"
number co2EmissionsCurrent "co2EmissionsCurrent"
number co2EmissionsPotential "co2EmissionsPotential"
string constituency "constituency"
string constituencyLabel "constituencyLabel"
string constructionAgeBand "constructionAgeBand"
string county "county"
integer currentEnergyEfficiency "currentEnergyEfficiency"
string currentEnergyRating "Current energy efficiency rating"
integer energyConsumptionCurrent "energyConsumptionCurrent"
integer energyConsumptionPotential "energyConsumptionPotential"
string _more_ "+75 more — see table"
}
GreenDealLoan {
}
HasGreenDealLoan {
string attachments "Attachments"
string details "Please provide details below including any outstanding pa…"
string yesNo "yesNo"
}
Recommendation {
string improvementDescrText "improvementDescrText"
string improvementId "improvementId"
string improvementIdText "improvementIdText"
integer improvementItem "improvementItem"
string improvementSummaryText "improvementSummaryText"
string indicativeCost "indicativeCost"
string lmkKey "lmkKey"
}
Heating {
string[] otherHeatingFeatures "What other heating features does the property have?"
}
HeatingSystem {
string details "Communal heating system details"
string heatingType "heatingType"
}
CentralHeatingDetails {
string centralHeatingInstalled "When was the heating system installed?"
string heatingLastServicedDate "When was the heating system last serviced or maintained?"
string heatingLastServicedReport "Please provide a copy of the service or maintenance works…"
}
BoilerInstallationCertificate {
string attachments "Please supply a copy of the installation completion certi…"
string yesNo "yesNo"
}
CentralHeatingFuel {
string centralHeatingFuelType "centralHeatingFuelType"
string otherCentralHeatingFuelType "Please describe the other fuel type"
string supplier "Supplier"
}
GasMeter {
string attachments "Photograph of meter location"
string location "Describe the location of the meter"
integer mprn "Meter Point Reference Number (MPRN)"
}
HeatingInGoodWorkingOrder {
string details "Please provide details"
string yesNo "yesNo"
}
ServicesCrossing {
}
FormalOrInformalAgreements {
string attachments "Please supply a copy"
string details "Please provide details"
string yesNo "yesNo"
}
PipesWiresCablesDrainsFromProperty {
string attachments "Attachments"
string details "Please provide details"
string yesNo "yesNo"
}
PipesWiresCablesDrainsToProperty {
string attachments "Attachments"
string details "Please provide details"
string yesNo "yesNo"
}
WaterAndDrainage {
}
Charging {
string consequentialChargingBasis "Will the basis for charging for sewerage and water servic…"
string currentChargingBasis "What is the current basis for charging for sewerage and/o…"
string sewerageBills "Who bills the property for sewerage services?"
string sewerageProvider "Who are the sewerage undertakers for the property?"
string waterBills "Who bills the property for water services?"
string waterProvider "Who are the water undertakers for the property?"
}
Drainage {
string distanceToNearestSewerageTreatment "Please state the distance from the property to the neares…"
}
MainsFoulDrainage {
string dateToBeConnected "Date to be connected"
string details "Details"
string supplier "Supplier"
string yesNo "yesNo"
}
OffMainsDrainageSystem {
string attachments "If installed after Jan 1991 supply the Building Regulatio…"
string dateInstalled "Date installed"
string dateLastEmptied "Date last emptied"
string dateLastServiced "Date last serviced"
string dateReplaced "Date replaced or upgraded"
string details "Details"
string offMainsDrainageSystemType "offMainsDrainageSystemType"
}
OtherConnectedProperties {
string details "Provide details of the properties sharing the system and …"
integer numberOfPropertiesSharing "How many other properties?"
string yesNo "yesNo"
}
PlantDrainsIntoWaterway {
string dischargeCompliesWithGBR "Does it comply with the General Binding Rules for dischar…"
string yesNo "yesNo"
}
PlantOnOtherLand {
string attachments "Please supply a plan showing the location of the system a…"
string yesNo "yesNo"
}
PlantRegistered {
string attachments "Please supply the appropriate permit to discharge or exem…"
string yesNo "yesNo"
}
MainsSurfaceWaterDrainage {
string dateToBeConnected "Date to be connected"
string details "Details"
string yesNo "yesNo"
}
PublicDrainWithinBoundaries {
string details "Details"
string yesNo "yesNo"
}
PublicPumpingStationWithin50mOfBuildings {
string details "Details"
string yesNo "yesNo"
}
PublicPumpingStationWithinBoundaries {
string details "Details"
string yesNo "yesNo"
}
PublicSewerWithin100ft {
string details "Details"
string yesNo "yesNo"
}
RiskOfInternalFlooding {
string details "Details"
string yesNo "yesNo"
}
SewerageUndertakerApproval {
string details "Details"
string yesNo "yesNo"
}
SewersSubjectOfAdoptionAgreement {
string details "Details"
string yesNo "yesNo"
}
SurfaceDrainageCharge {
string details "Details"
string yesNo "yesNo"
}
MaintenanceAgreements {
string attachments "Attachments"
string details "Details"
string yesNo "yesNo"
}
Maps {
string publicSewerMapAttached "Where relevant, please include a copy of an extract from …"
string waterworksMapAttached "Where relevant, please include a copy of an extract from …"
}
Water {
string supplyClassification "What is the classification of the water supply for the pr…"
}
LowWaterPressureRisk {
string details "Details"
string yesNo "yesNo"
}
MainsWater {
string dateToBeConnected "Date to be connected"
string details "How is water supplied?"
string supplier "Supplier"
string yesNo "yesNo"
}
Stopcock {
string location "Describe the location of the stopcock"
string attachments "Photograph of stopcock location"
}
WaterMeter {
string attachments "Photograph of meter location"
string isSupplyMetered "isSupplyMetered"
string location "Describe the location of the meter"
}
WaterMainsSubjectOfAdoptionAgreement {
string details "Details"
string yesNo "yesNo"
}
WaterMainsWithinBoundaries {
string details "Details"
string yesNo "yesNo"
}
Physical model — every JSON object owned by this page is a node, every scalar field a row. 64 objects, 343 scalar fields. Generated from the schema walk; click any node to jump to its table.
Sequence
sequenceDiagram
autonumber
participant Seller
participant Assessor as Accredited energy assessor
participant EPBR as EPC Register (EPB)
participant Buyer
Seller->>Assessor: book inspection
Assessor->>Assessor: inspect (fabric · heating · lighting · ventilation)
Assessor->>Assessor: model in RdSAP / SAP
Assessor->>EPBR: lodge certificate
EPBR-->>Assessor: certificate ID + 10-year validity
Assessor-->>Seller: certificate (band A-G + recommendations)
Seller->>Buyer: provide EPC ref on listing
Buyer->>EPBR: lookup certificate by ref
EPBR-->>Buyer: signed JSON-LD + PDF
EPC issuance and retrieval. The certificate is issued by an
accredited assessor, lodged on the EPB Register, and retrievable
by reference for 10 years. PDTF captures the lodged values
(current/potential rating, fuel, cost projections, recommendations).
Diagram
pie title Typical EPC rating distribution (England & Wales, post-2018 stock)
"A (92+)" : 1
"B (81-91)" : 8
"C (69-80)" : 38
"D (55-68)" : 32
"E (39-54)" : 15
"F (21-38)" : 5
"G (1-20)" : 1
Indicative distribution of EPC ratings. The London flat in our
example sits in band D (62); the Manchester semi in band C (71).
Most existing stock is C–E; new-build typically B.
Please supply a copy of the installation completion certificate from a competent person qualified under the relevant self-certification scheme e.g. HETAS etc
You can find your property’ MPRN on your gas or dual fuel bill. It’ usually marked ‘Meter Point Reference Number’ and is between six and 10 digit long. Meter Point Reference Number (MPRN)
Your MPAN is on your electricity or dual fuel bill, usually in a box marked ‘Supply Number’. It’ 21 digit long and begin with ‘S’. You’ll only need the last 12 or 13 digits. Meter Point Administration Number (MPAN)
Please provide details below including any outstanding payments for the renewable devices and any feed-in tariffs and a copy of your last electricity bill
Comments