Skip to content

Electrical create DW tables

Generated page — confirm before relying on it

Written automatically from the Versaa export of 20/08/2026. It has not been reviewed by anyone, and it describes what was exported on that date — not what is in Management Studio right now.

Version numbers are deliberately omitted. The export filename does not reliably identify the active version and can carry a Test or Live record, so any number here would be untrustworthy. Check the version in Management Studio.

Purpose

This workflow is designed to create the necessary Data Warehouse (DW) tables for electrical records in the database. It is triggered to run only once, ensuring that the required tables for Electrical Installation Condition Reports (EICR), Installation Certificates, and Minor works are established. The outcome is a set of empty DW tables ready for data entry.

Key Steps

  • Load an empty EICR table.
  • Create the EICR Data Warehouse table.
  • Load an empty Installation Certificate table.
  • Create the Installation Certificate Data Warehouse table.
  • Load an empty Minor works table.
  • Create the Minor works Data Warehouse table.

Notes

No special notes.

Raw Export

Versaa_Exports_md/workflows/Electrical_create_DW_tables_2.md