Export all stored procedures
You can extract the definitions of all stored procedures with this simple script.
LHL
Tone
Quote 1: The VOA may refer to the tone of the list. Tone is the general level of bands which have been established in an area for a particular type of property. This is where a number of similar properties have bandings which, over time, have not been challenged or changed. A tone is also … Read more
Create SQL table from parquet files
https://stackoverflow.com/questions/62935557/create-sql-table-from-parquet-files
CheckExtract
Manages status of the ‘extractlock’ based on extract type Has potential as entity_extract_(type) Actions 1.Rename Table 2. ADD New columns 3. Alter Code CheckExtract.txt
AzUnzipEverything
https://github.com/FBoucher/AzUnzipEverything A simple Azure Function to Unzip files from a blob storage container to another one The following features are supported in this current version: Supported Archive Types: .zip, .rarArchive support is currently implemented using the sharpcompress library Password protetected zip filesThe current solution provisions an Azure KeyVault instance for storing the zip archive(s) password used during … Read more
VOA Table Specification
https://voaratinglists.blob.core.windows.net/html/documents/2017%20Compiled%20List%20and%20SMV%20Data%20Specification.pdf
Tables
Listings To assemble the sequence of historic entries for a property, you should find all historic entries sharing thesame UARN and sort them into ascending List Alteration Date. Entries that are alterations have HistoricFrom and To Dates. Entries that revise alterations will not. You can then add the current entry for the sameUARN to complete … Read more
Overview
Physical changes within a locality may have an impact on the rateable value of property. The rateable value is the Valuation Office Agency assessment of the open market rental value of your property and is used by local councils to calculate business rates. What is a “material change of circumstances”? If there are physical changes … Read more
MCC Calculation & Implementation
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 … Read more
Key Values
List Year Number (4) List year of the rating list. Property Identifiers Billing Authority Code Character (4)Code representing Billing Authority (can have a leading zero).A list of BA codes is provided at Appendix 1 BA Reference Number Character (25) Reference number supplied by BA and normally used for billingpurposes. SCAT Code And Suffix Character (4)Code … Read more