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
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
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
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
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
GET statement Gets all Projects in Runn for the purpose of comparison with WFM Example
GET statement Gets all people in Runn for the purpose of comparison with WFM Example Return
Runn is the TARGET for the solution This section runs the connections with runn.io … there are three fundamental modules People, Projects and Actuals. We operate three GET statements across the modules API Base URL: https://app.runn.io/api Swagger JSON: https://app.runn.io/api/swagger_doc Runn uses token authentication to access the API. Ensure all requests contain an authorization header as … Read more
GET statement The time API returns all the data required for the WFM part of the solution (i.e. People, Projects and Actuals) The major issue is resolving the 2 factor Authentication and maintaining the Refresh and Access tokens https://www.workflowmax.com/api/v3/time-methods Parameter Required? Description from=YYYYMMDD Required Return time sheet entries created on or after this date. to=YYYYMMDD … Read more