Data Warehouse

& Property HUB

The TrustMark Data Warehouse aims to address several recommendations in the Each Home Counts review commissioned by the Government in 2015 and published in December 2016.

The Review identified 27 recommendations, including the development of the Data Warehouse to enable consumers to access more accurate data and information about their homes, which can be used to provide stronger and more bespoke advice. It also highlighted the importance of how this system should be developed to help industry understanding of the market and to support compliance monitoring of the quality mark. 

The longer-term aim of the Data Warehouse is to act as a place where information is held about work undertaken on a property, together with the improvements made. This can inform a Property Hub to act as the consumer-facing platform to access a ‘log book’ about their property – helping establish who did what and when.

Email data@trustmark.org.uk providing an outline of your areas on interest and one of the team will get in touch to discuss.

TrustMark takes Privacy and security of your data very seriously our Data Warehouse and Property Hub - Privacy Notice informs how your data will be used. We have engaged with various industry sectors during its development. 

 

Data Warehouse Overview

 

  • Lodgement populates Data Warehouse and Risk Model for the work undertaken through Government Initiatives
  • Helps get installation right 1st time through combining knowledge
  • Underpins compliance and enforcement across Schemes
  • Reduces risks from Phoenix Companies
  • It will help provide industry insights and continual feedback

Lodgement:

Work can be lodged into the Data Warehouse via an on-screen form or for ECO via automated routes for those with the capability.

Data Dictionary:

Our Data Dictionary contains details on the information required to lodge data in the Data Warehouse.

API:

We have created an API so that users can use the screens to enter data or integrate their existing systems with the Data Warehouse to lodge data. We have created a sample project and will update the information on our GitHub page as necessary.

Help & Support:

Guidance and answers to Frequently Asked Questions can be found on our Data Warehouse - Support Page.

PAS2035 Structured Data supporting ECO 4

Objectives:

  • Support ECO 4 staged delivery
  • Facilitate staged lodgement for PAS 2035
  • Improve provision and utilisation of data behind retrofit processes

Key Concepts:

  • A Retrofit Project will be created
  • A Retrofit project will require a Retrofit Assessment
  • It will be possible for a Retrofit Assessor to lodge an Assessment or for the Retrofit Coordinator to create it if appropriate.
  • Retrofit Assessments will be accompanied with RdSAP xml data
  • Before a Project id can be generated, certain requirements must be met.
  • Defects in the property can be recorded at both Assessment and mid Project
  • Designs must indicate who created them, which measures they cover and what property defect are addressed/
  • A Project can be completed and lodged in stages
  • Each lodged stage can contain one or more measure
  • To complete a project an updated RdSAP xml must be provided

 

Timelines:

  • API documentation to be made available early Q2 2022
  • Lodgement mechanism to be launched to support ECO 4 delivery

 

Draft Data Model:

In progress shared for early visibility. Lodgement API and documentation will be provided at a later point.

TrustMark Structured Retrofit Data Model - v0_6 Draft

 

Structured Retrofit Cooridinator Journey

Property HUB (Passport)

The homeowner facing a view of relevant information from the Data Warehouse:

  • Secure repository to find information about a property, including who did what when and any guarantees etc.
  • Will contain routes to advise on further home improvements and funding options
  • Initial focus on dwellings, small commercial property a possibility

More details will be provided throughout the development process

Downloads