create_extDataSource

by

Overview The stored procedure dbo.[create_extDataSource] procedure manages the creation of credentials for the management of Access Tokens in SQL Whilst the solution imports data from the Azure Blob as json formatted files into the SQL import Tables, a connection has to be made between the SQL Database and the Blob Storage This connection is made … Read more

Overview

by

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

by

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

by

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

(Special) Category Codes

by

Descriptions, special category codes and valuation scheme references These data items are used to enable ratepayers to compare their rateable value with the rateable values of similar properties valued the same way.Descriptions and description codes of the same type are a primary means of comparing properties we have valued the same way. You may also … Read more

Ratings List

by

There are typically around 2 million properties shown in English and Welsh local rating lists at any one time.Over the life of a list some properties will come and go, whilst other may see changes made to their descriptions and addresses, and of course to their rateable values with effect from specified dates.Every entry in … Read more

Actuals

by

GET statement Gets Actuals (timesheet data) in Runn for the purpose of comparison with WFM Dates Requires start and end date Format: YYYY-MM-DD. Include Actuals on or before/after date Start Date This is associated with a Business Requirement as the regular Runn ingestion process only spans 4 weeks Typically the start date is set to … Read more