Load Dependency data

Required:

Once (this is a one-time import)

Load VoA Special Category Table

Special Category and Primary Description codes for property descriptions

Source:

2017 Compiled List and SMV Data Specification (Appendix 2 (pages 37-68)) See… Appendix 1: VoA SCatCodes.csv

Create Effective date table

Identify Candidate Properties/Localities

Required:

Every Time … After refresh of [ratinglistdetails])

Identify Properties with Reductions (by UARN)

Candidate properties meet the requirements of the selection group … in this case

• of the type ‘Shop’ (primary category = ‘CS’)
• A max net-value date less than min net-value date (represents a reduction over time)
• Identify Net Saving

Constraint:	List Year & Primary Category
Source:	See… Appendix 3.1: Identify Properties (UARN)

Collate properties by Location (Postcode Short)

Locations with …

• two or more properties,
• In the same locality, (defined as LEN(postcode) -1)
• Calculate Average Saving

Source

See…Appendix 3.2: Collate Localities

Assess other Properties in Locality

Current Query

It would be preferable to collate the Extract Notes in a single table, therefore it is anticipated that the current table [extractnotes] would be utilised.  Also there is a potential for the [mcc_extract_summary] table to be replaced

Create Extract Summary

Required:	Every Time … After refresh of [ratinglistdetails])
Source:	See…Appendix 4.1: Extract Summary

Create Extract Properties

Required:	Every Time … After refresh of [ratinglistdetails])
Source:	See…Appendix 4.2: Extract Properties
Constraint:	List Year & Primary Category