NROSH Regional Seminar Autumn 2006 Benefit Realisation

1
NROSH Regional SeminarAutumn 2006Benefit
Realisation
2
Project Elements

• Data Standards
• Database infrastructure
• Toolkits
• Data capture
• Output system (NROSH Online)

3
DATA STANDARDS

• Defined Standards
• Review procedure
• 109 Fields
• XML schema

4
Database Infrastructure

• Servers and backup
• Database configuration
• Interform

5
NROSH ToolkitContract Delivery
6
NROSH Non Contract Toolkits
7
Data Delivered So Far

• 743,000 Units
• 18 of total

8
NROSH Data Received September 06
9
NROSH DataReceived September 06
10
NROSH Data Received September 06 Overview 1
11
NROSH Data Received September 06 Overview 2
12
NROSH-Online

• Procurement
• User acceptance testing
• Live database connection and testing
  September/October
• Launch November 2006

13
The Benefits

• Reducing the burden on data providers-
• LAs DCLG replacing parts of HSSA, BPSA
  HRASC forms
• RSLs HC replacing parts of the RSR
• LAs, RSLs, DCLG HC linking NROSH to CORE

14
The Benefits 2

• Better Information
• Neighbourhood Statistics
• Monitoring output of affordable housing (PSA5)
• Strategic data for investment planning
• Strategic information for LAs regions
• Monitoring the Disability Discrimination Act

15
DCLG Forms Key Sections

• HSSA Total social housing stock and number
  vacant
• BPSA LA stock profile - age/type/size
• BPSA Vacant LA stock time vacant/reason
• HRASCF Rents/size of dwellings

16
LA Forms - Strategy

• Two stage approach
• 1st year, April 2007 forms Pre-fill selected
  fields from NROSH. Flexibility for LAs to
  overwrite.
• During ,1st year (2007) Iron out any problems,
  get higher completion of priority fields by all
  LAs and ALMOs
• 2nd year, April 2008 forms NROSH pre-fills
  selected fields. No flexi Any changes required by
  LA made by amending their NROSH upload.

17
LA Forms- HSSA,BPSA,HRASCF

• Need to ensure NROSH data meets acceptable
  quality standards
• Set up processes for pre-filling selected fields
  with NROSH data / truncating existing forms
• Work closely with LAs case studies
  volunteers - to complete key fields ready for
  April 2007
• Volunteer LAs Required

18
LA Forms
Stage One Development Programme

• Identify key NROSH fields
• Create test paths to map NROSH data to existing
  forms - Oct to Dec 2006
• Compare analyse data from NROSH with existing
  forms Feb 2007
• Adopt issue completeness standards required for
  NROSH fields - March 2007
• Start pre-filling parts of existing forms -
  May 2007

19
Completeness of Data -
20
Completeness of Data -
21
Exclusivity

22
Number of Rent Payments

23
Year Built Counts
24
Number of Bedrooms by of stock

25
Number of Bedspaces

Number of bedspaces
26
Purpose Built or Conversion

27
Type of Dwelling

28
Form of Layout

29
NROSH Data Received September 06 Regional
Overview
30
SW Data Providers
31
Why Should Landlords Participate?

• New DCLG Guidance on housing needs assessments
• New DCLG guidance on LAs housing strategies
• KLOEs
• DDA Disability Equality Schemes

32
Landlords Perspectives as
Data Providers
33
Previous Speakers

• Liz Branson Anchor Trust
• Roger Piller Fenland District Council
• Roger East Milton Keynes Council
• Les Harrison Amber Valley Housing
• Suzanne Bowes Castle Morpeth Council
• Elaine Pierce Wigan Leigh Housing

34
Skills Needed

• Consistent message from Landlords
• Skills are the same for both LAs and RSLs
• IT knowledge and housing knowledge are essential
• The skills may be found in one person, or
  separate departments

35
Everyone is Different

• Each implementation of each system is unique
• Some toolkits are easier than others
• Start with the data you find easy
• The average effort to get up and running for
  pilots was
• 4.5 days!
• Post pilot Landlords suggest less

36
User Acceptance Time to install

• Orchard - 0.5 to 1 day to install
• Aareon Simdell - 1 day to install
• CHICS - less than half a day
• Omniledger - 1 day
• SX3 - 0.75 of a day
• Quovadx - 1.5 days
• Enterprise - 1 day
• Comino Saffron - 1 day
• Comino In-House - 1 day
• Comino Context - 1 day
• Average 1 day for any toolkit

37
User Acceptance Time to Implement

• Orchard - 10 days
• Aareon Simdell - 5 days
• CHICS - less than half a day
• Omniledger - at least 5 days
• SX3 - 3 days average
• Quovadx - 10 days average
• Enterprise - 3 days
• Comino Saffron - 3 days average
• Comino In-House - 4 days average
• Comino Context - 3.5 days average
• Average 4.5 days for any toolkit

38
User Acceptance Ease of Data Mapping

• 3 for Orchard
• 4 for Aareon
• 4 for Omniledger
• 4 for SX3
• 2 for Quovadx
• 3 for Enterprise
• 2 for Comino Saffron
• 4 for Comino In-House
• 3 for Comino Context
• Average mark of 4 for Data Mapping for any toolkit

1 is bad 5 is good
39
Lessons to Learn

• The right skills are important
• Management buy in can be difficult to obtain
• The task is not trivial, but
• Its easier than you think!

40
NROSH Benefit Realisation The
Housing Corporation Vision

41
NROSHNational Register of Social Housing

• Centre for Research and Market Intelligence
• CRMI

42
The vision

• Long term better data to improve policy
  development, decision making and business
  planning
• Short term reduce the burden of data
  collection
• phase out the RSR for HAs
• simplify CORE for HAs and LAs

43
The problem

• Where is the social housing?
• Most national data does not go below local
  authority level
• Collecting the data is a burden on HAs and LAs
• Definitions are not consistent across sectors and
  among agencies

44
NROSH

• The answer to all our problems ----
• Better data
• Lighter burden
• Greater consistency

45
Strategic planning and decision making

• Risk asset management
• Market intelligence
• Sustainable communities
• Offering choice

46
Current data sources for housing associations

• RSR Regulatory and Statistical Return
• Only to LA level
• CORE COntinuous REcording of Lettings and Sales
• To postcode level, but only captures stock when a
  transaction takes place

47
Regulatory burden

• RSR

48
RSR reducing the burden

• 615 RSR fields are derived from only 34 NROSH
  fields
• Breakdown of General Needs rents at LA level
• - RSR 80 fields per LA
• - NROSH 5 fields
• Immediate business benefits
• A threshold which has to be cleared before the
  full benefits of NROSH can be realised by HAs or
  the Corporation
• NROSH elements of the RSR identified on website
  www.rsrsurvey.co.uk

49
RSR compatibility with NROSH

• Priority fields for RSR identified (RSR website)
• Program to recreate RSR
• Aggregation facility introduced for 2006 RSR to
  help pilot HAs use their NROSH data in compiling
  RSR - will remain for future surveys
• Tolerances defined by Dataspring, University of
  Cambridge acceptable levels of variance on
  individual records and full dataset and between
  RSR aggregated NROSH www.rsrsurvey.co.uk

50
Phasing out the RSR

• IDEAL timetable
• - Some HAs drop RSR from 2007
• - RSR discontinued from 2009 or 2010
• Corporation cannot set mandatory targets until
  NROSH data is fit for purpose for the regulatory
  system

51
Next phase

• Improve coverage data quality
• Landlords systems links to toolkits
• NROSH validations
• RSR aggregations - test compatibility between RSR
  NROSH
• Liaison between landlords, Housing Corporation,
  DCLG - substantial investment of time and
  resources required
• Incorporate into CORE as NROSH develops

52
Feedback from HAs- data collection

• Much of the data for NROSH is not held on housing
  management systems and a business case would need
  to be made internally to collect it
• Insufficient feedback on results once data is
  submitted

53
Feedback from HAs- data mapping

• Relating the housing management systems to the
  toolkits can be
• Lengthy
• Time consuming
• Require a high level of technical IT know-how
  which smaller housing associations may not
  possess

54
Feedback from HAs - toolkits

• Toolkits vary in ease of use, extent of data
  mapping required, time taken to validate and
  upload data
• Different strategies and different timescales may
  be needed for different toolkits
• Encourage non-pilot HAs to pick up and test the
  working toolkits

55
Feedback from HAs resources and project
management

• Most HAs said NROSH had to be tackled by teams
  which draw together skills from across the
  organisation
• - IT specialisms, housing management, strategic
  planning, familiarity with RSR and performance
  reporting
• These resources may not be forthcoming unless a
  formal project is set up with a top management
  sponsor such as the Chief Executive or a Board
  member

56
Some problematic fields

• 7.1 - Owner Confirmation several HAs have most
  or all of their properties classified as All of
  the Above
• 23.2 23.16 Provision Category Housing for
  Older People and Supported housing much data
  missing
• 87 Tenure often missing
• 101 102 Service Charge Amount and Service
  Charge Payment Count Service charges
  consistently higher in NROSH than the RSR
• 103 Eligibility for Housing Benefit large
  discrepancies between NROSH and RSR

57
Some successful fields

• Property count the total number of properties in
  NROSH is generally similar to the RSR
• 23.1 - Provision Category General Needs
• 97.1 Rent per Payment
• 44 24 Bedroom Count and Exclusivity (self
  contained/shared)
• Many HAs report that the main problem is missing
  fields rather than inaccurate data

58
The future

• Long-term strategic benefits of NROSH will not be
  realised until coverage is complete
• Short-term administrative benefits of abandoning
  RSR will be realised by individual HAs as soon as
  they are able to implement NROSH
• Investing the time and resources now will pay
  dividends in the short and long term
• as quickly as possible but only if it works

59
(No Transcript)
60
NROSH Data Standards Review

61
Terms of Reference and Method

• Minimum change necessary
• Resolve problems in the XML Schema
• Consistency with CORE field definitions
• Incorporate any new DCLG policy requirements
• Small working group with DCLG, HC,LA RSL reps

62
Fields to be Deleted

• 46.1,46.2 Bathrooms by floor
• 60 Street parking
• 94 Projected date available
• 95 Low demand indicator
• 99,103.1 Service charge categories and amounts
  charged

63
Fields to be Split

• Split existing Category of Provision field into
  four fields-
• General Needs
• Older Peoples Housing
• Supported Housing
• Shared Ownership
• Split 87,Tenure into two fields-
• Rented tenures
• Vacancy status

64
New Fields to be Added

• LA in which the dwelling is located
• Supported housing project reference number
• Onward leases identifying holder of the lease
• of ownership shared
• Concierge
• Intercom entry system
• Hostel accommodation
• Choice based lettings

65
Changes to Existing Fields

• Updating decent homes sub categories
• Updating affordable housing categories and add
  missing ones
• Add missing stock flow categories
• Add missing reason for vacancy categories
• Add indicator for whether the old or new SAP
  rating is used
• Delete the five percentage shared ownership
  categories

66
Timetable

• Finalise changes September 2006
• Amend the XML Schema and issue it October 2006
• Implement by software suppliers and landlords
  April 2007

67
NROSH-Online

68
Aim of NROSH Online

• To give LAs RSLs and regional agencies direct
  access to the NROSH data

69
Consultations

• Workshops with LAs and RSLs at the last round of
  regional seminars
• Small consultation group made up of LA and RSL
  volunteers.
• User acceptance testing of the draft system by
  the consultation group

70
The Requirements of LAs RSLs

• Standard reports
• Downloading raw data
• Filtering
• Time series
• GIS

71
What NROSH-Online Delivers

• Fifteen standard reports
• Filters
• A range of geographical filter (not all yet
  operational)
• Type of landlord
• Size of stock
• Category of provision
• Raw data downloads
• Of data which goes into a specified standard
  report
• Of data specified from the full database

72
NLPG UPRNs

• We want you to provide them because-
• More stable basis long term for matching your new
  data uploads with your old ones
• To match with your CORE data
• To enable us to match your data with data from
  other sources e.g. Council Tax bands from the VOA
  
• If you dont have the NLPG UPRN you will be able
  to get it from NROSH-Online for dwellings that
  you have uploaded

73
NLPG UPRN Availability

• 320,000 dwellings on the database now have the
  NLPG UPRN attached
• We are working on the rest but are having
  difficulty with the address matching. Reasons-
• Quality of address postcode provided by
  landlords
• Inconsistencies between NROSH addresses and NLPG
  addresses
• New dwellings which have not yet got an NLPG UPRN
  
• Something else?

74
NROSH Address Matching
75
The Standard Reports 1

• Simple snapshot data
• Stock statistics owned/managed, by facilities
• Stock owned type of dwelling by age band by
  traditional/non-traditional construction (BPSA)
• Stock by age bands
• Stock by category of provision
• Supported housing by category
• Non-decent dwellings
• Wheelchair and accessibility standard dwellings

76
The Standard Reports 2

• Complex reports
• Average rents and service charges by size of
  dwelling (HRASCF,RSR)
• Average weekly target rents
• Annual rent loss
• Demand supply vacant dwellings by time
  vacant, reason for vacancy and property type
• Demand supply vacant dwellings by time
  vacant, reason for vacancy and property size
• Stock flow Gains and losses by cause of change
• Sales of Low Cost Home Ownership Dwellings

77
The Standard Reports 3

• Validity of Data Shows for a range of the
  fields used in the other tables the completeness
  of data in the fields which are used to produce
  them.