QL Property Survey Base Data¶

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¶

The QL Property Survey Base Data workflow is designed to load essential base data for property surveys within Lincolnshire Housing Partnership. It is triggered by the need to gather and prepare various data components necessary for conducting property surveys. The outcome of this workflow is a comprehensive dataset that includes information on asbestos, component types, and other relevant survey data, which is crucial for effective property management and compliance.

Key Steps¶

Create a main components data list from the database.
Load first touch component types from the database.
Generate various lists, including DHSCodes, conditions, and program codes.
Create SQLite databases for category and general lookups, as well as component library lookups.
Import asbestos-related data, including scores, type multipliers, locations, and product types.
Create average time in use and extent of material data lists.
Import specific category and general code tables.
Notify users upon completion of the data loading process.

Notes¶

No special notes.

Raw Export¶

Versaa_Exports_md/workflows/QL_Property_Survey_Base_Data_4.md