10:30Welcome and introduction to day

1
Welcome
2
Agenda

• 1030 Welcome and introduction to day
• 1100 NROSH introduction
• 1120 NROSH targets and progress
• 11.30 Supplying NROSH data
• 1200 QA
• 1230 Lunch
• 1315 Using NROSH data
• 1345 Extracting data through NROSH-Online
• 1415 Next steps including move to TSA
• 1430 General questions/discussion time
• 1445 Close

3
Introduction

• 1. What is NROSH?
• 2. NROSH Benefits
• 3. Modernising data collection
• 4. Which data are we collecting?
• 5. How does NROSH data collection work?
• 6. NROSH data and analysis

4
What is NROSH?

• A single consistent national social housing
  database
• Property level data rather than summary data
• Once set up it will extract automatically
  rather than requiring a manual summary
• RSR HSSA migration to NROSH

5
Introduction

• 1. What is NROSH?
• 2. NROSH Benefits
• 3. Modernising data collection
• 4. Which data are we collecting?
• 5. How does NROSH data collection work?
• 6. NROSH data and analysis

6
NROSH benefits
More flexible data

More efficient collection
7
More flexible data

• Versatile
• Up to date
• Consistent
• Accurate
• Accessible
• Transparent

8
Enhanced analysis

• Data can be analysed at any geographical level
• Postcode
• Ward
• Neighbourhood
• LA
• Region or sub-region
• It can be combined with other datasets to present
  a more complete picture
• Environment Agency
• CORE
• Valuation Office Agency

9
Enhanced analysis

• Innovation
• Investment planning
• Benchmarking
• National Strategy for Neighbourhood Statistics

10
Introduction

• 1. What is NROSH?
• 2. NROSH Benefits
• 3. Modernising data collection
• 4. Which data are we collecting?
• 5. How does NROSH data collection work?
• 6. NROSH data and analysis

11
Modernising data collection

• The data stored in your HMS can be used to fill
  NROSH data fields at the touch of a button,
  replacing the need for a lot of data re-entry.
• NROSH is based on sound methodology for
  collecting and analysing data at a unit level.
• NROSH data can be used for many different
  purposes such as filling the property-related
  fields for the
• RSR
• HSSA
• BPSA-AM
• CORE (future)
• This reduces the amount of time and effort
  required for statutory returns.

12
Saving you time and effort
The amount of time and effort saved differs
depending onthe nature of your organisation.

• Consider
• RSLs - How much time does your organisation
  currently spend on submitting the RSR or
  providing information to LAs?
• LAs - How long does it take you to identify all
  the RSLs operating in the area and collect HSSA
  data from them?
• This will give an estimate of the amount of time
  that NROSH could save you in the medium to longer
  term.

13
Introduction

• 1. What is NROSH?
• 2. NROSH Benefits
• 3. Modernising data collection
• 4. Which data are we collecting?
• 5. How does NROSH data collection work?
• 6. NROSH data and analysis

14
Which data are we collecting?

• NROSH data requirements have been devised to
  align with existing data collections.
• We are currently asking for around 40 data items
  that are already collected and returned.
• Data requirements vary slightly for LAs/ALMOs and
  RSLs.

15
Introduction

• 1. What is NROSH?
• 2. NROSH Benefits
• 3. Modernising data collection
• 4. Which data are we collecting?
• 5. How does NROSH data collection work?
• 6. NROSH data and analysis

16
How does NROSH data collection work?
Data is extracted from housing managementsystems
via a toolkit
Housing Management System
HA/LA
Mapping
Toolkit
NROSH
17
Introduction

• 1. What is NROSH?
• 2. NROSH Benefits
• 3. Modernising data collection
• 4. Which data are we collecting?
• 5. How does NROSH data collection work?
• 6. NROSH data and analysis

18
Data analysis example 1

• Sample business case for a potential development
  site on the border of two local authorities

19
Data analysis example 2

• Distribution of council housing stock by age of
  dwelling

20
Data analysis example 3

• Energy efficiency of social housing in defined
  area

21
Social housing at risk of flooding
Proportion of stockin flood zone 2 12.5
22
Agenda

• 1030 Welcome and introduction to day
• 1100 NROSH introduction
• 1120 NROSH targets and progress
• 11.30 Supplying NROSH data
• 1200 QA
• 1230 Lunch
• 1315 Using NROSH data
• 1345 Extracting data through NROSH-Online
• 1415 Next steps including move to TSA
• 1430 General questions/discussion time
• 1445 Close

23
NROSH targets and progress
1. Data requirements and target dates 2. RSL data
fields 3. LA data fields 4. How much stock is in
NROSH? 5. Regional participation
24
Data requirements / target dates
25
NROSH targets and progress
1. Data requirements and target dates 2. RSL data
fields 3. LA data fields 4. How much stock is in
NROSH? 5. Regional participation
26
RSLs required data fields

• Approx 80 of RSR cells can be derived from the
  39 mandatory/priority NROSH fields
• 8 mandatory fields
• Address, LA area, LA/HA property reference
• Ownership type, owning organisation, managing
  organisation
• Data provider reference number, report date
• 31 priority data fields
• Provision category, tenure
• Physical characteristics
• Vacancies and stock flows
• Rents and service charges
• Accessibility for wheelchair users
• SAP and Decent Homes

27
NROSH targets and progress
1. Data requirements and target dates 2. RSL data
fields 3. LA data fields 4. How much stock is in
NROSH? 5. Regional participation
28
LAs required data fields

• 8 mandatory fields
• Address, LA area, LA/HA property reference
• Ownership type, owning organisation, managing
  organisation
• Data provider reference number, report date
• 42 priority data fields
• Provision category, tenure
• Physical characteristics
• Vacancies
• Rents and service charges
• Stock flows
• Decent homes
• Energy efficiency
• 13 additional fields
• Accessibility including wheelchair standards,
  steps, lifts, floor level, adaptations

29
NROSH targets and progress
1. Data requirements and target dates 2. RSL data
fields 3. LA data fields 4. How much stock is in
NROSH? 5. Regional participation
30
How much stock is in NROSH?
At 5th November 08 NROSH held
31
Details of NROSH stock
Engagement how many organisations are
participating?
Data Quantity how much data is currently in
NROSH?
Data source NROSH database
32
Completeness of Data
33
Completeness of Data
34
NROSH targets and progress
1. Data requirements and target dates 2. RSL data
fields 3. LA data fields 4. How much stock is in
NROSH? 5. Regional participation
35
Stock in NROSH by local authority area
Over the last quarter, the number of
localauthority areas withat least two thirds
oftheir data in NROSHhas increased from25 to
33
36
NROSH Data Capture September 2008 of Stock by
Region
37
NROSH Data Capture September 2008 of Stock by
LAs HAs by Region
38
Data Providers September 2008 of LAs LSVT
HAs by Region
39
Agenda

• 1030 Welcome and introduction to day
• 1100 NROSH introduction
• 1120 NROSH targets and progress
• 11.30 Supplying NROSH data
• 1200 QA
• 1230 Lunch
• 1315 Using NROSH data
• 1345 Extracting data through NROSH-Online
• 1415 Next steps including move to TSA
• 1430 General questions/discussion time
• 1445 Close

40
Supplying data

• Data Standards
• Toolkits
• Getting started
• Validations Reports
• Case study
• Help desks websites
• Q A

41
Data standards

• Release 3 - June 2005
• Release 4 - January 2007
• Release 5 - ?

42
Supplying data

• Data Standards
• Toolkits
• Getting started
• Validations Reports
• Case study
• Help desks websites
• Q A

43
Toolkits

• What is a toolkit?
• A software component that attaches to, or is
  included with housing management systems (HMS)
  that creates a NROSH data file
• History
• CLG contracted toolkits signed off in 2005
  following user acceptance testing
• Software suppliers contacted in 2007 to assess
  progress on updating to NROSH R4

44
Commissioned Toolkits
45
Other toolkits
46
Toolkit costs

• Commissioned toolkits free
• Anite, Academy, IBS, MIS SASSHA can charge
• Set up costs installation getting it working
• Mapping

47
Choosing a toolkit

• All data suppliers have toolkit options
• Identify your options
• research them, and
• decide on an appropriate toolkit
• Longer term toolkits will be absorbed into the
  HMS (some are already)
• Check the CLG website for toolkit information
• HMS / toolkit supplier contact details
• compatibility with HMS
• NROSH data standards release currently in
  operation
• when NROSH data standards R4 is likely to be
  available
• help available from software suppliers
• user group details

48
Toolkit information online
49
Small RSLs without a HMS

• If you have a HMS/toolkit please use it!
• If not
• we have developed a spreadsheet which is being
  piloted now and will be released shortly

50
Small RSLs without a HMS
51
Supplying data

• Data Standards
• Toolkits
• Getting started
• Validations Reports
• Case study
• Help desks websites
• Q A

52
Getting Started Guide

• General information on NROSH benefits
• Responsibility for submitting data
• NROSH Targets
• Mandatory priority data items
• NROSH to RSR Facility
• NROSH to HSSA/BPSA-AM Facility
• How should I get started
• get a toolkit (including what is a toolkit)
• configuration mapping
• data collection and cleansing
• submitting your data
• Key documents, further information and help

53
Helpful hints for getting started

• Identify who will supply data if there is more
  than one option (eg manager different to owner or
  group structures)
• Skills both IT housing management knowledge
  is helpful
• Resources initially high, then reducing
  considerably
• Toolkits help is available from software
  suppliers
• If possible use a small amount of data (eg an
  estate) to validate
• Map the data you already have, then prioritise

54
10 steps to getting started (i)
55
10 steps to getting started (ii)
56
Supplying data

• Data Standards
• Toolkits
• Getting started
• Validations Reports
• Case study
• Help desks websites
• Q A

57
Automated reports
58
(No Transcript)
59
NROSH data exportsRSR/HSSA/BPSA-AM

• What is it?
• An interface allowing submission of NROSH data
  to automatically populate sections of existing
  statistics collection forms
• Benefits?
• Automatic population of the time consuming
  elements of these forms will significantly
  reduce overall effort!
• Checking times should be reduced
• When is it available?
• The system is currently being updated to
  reflect the RSR 2009 forms
• Release scheduled for beginning of October

60
NROSH to RSRMain screen
61
NROSH to RSRData selection screen
62
Supplying data

• Data Standards
• Toolkits
• Getting started
• Validations Reports
• Case study
• Help desks websites
• Q A

63
CASE STUDY New Charter Housing Trust Group
64
New Charter Housing Trust Group
NEW CHARTER PROPERTY SERVICES LIMITED
NEW CHARTER BUILDING COMPANY LIMITED
NEW CHARTER HOUSING TRUST GROUP LTD
Data source RSR 2008/ New Charter Housing Trust
Group
65
Data submission journey
Data source New Charter
66
New Charter North Data quantity and quality
Data source Dataspring
67
Benefits and challenges
Biggest benefit RSR replacement
improvements in data management processes
Improvements in MI
More data available
Easier to produce MI reports
MI more up to date
Biggest challenge new data standards releases
68
CASE STUDY South Kesteven District Council
69
South KestevenCapturing missing data

• Integrate data capture into the routine visits to
  dwellings
• Incorporate NROSH fields in any large scale
  surveys that are being conducted
• Use cloning where appropriate

70
South KestevenData loading

• DATA GATHERED OVER SURVEY PERIOD
• STOCK SURVEY DATA HELD AT PIMSS
• 1000 PROPERTY UPLOAD
• 1 II
• 2 II
• 3 II
• 4 II
• 5 II
• 6 II

SAVILLS PROVIDE UPDATED ATTRIBUTE CODE TO PIMSS
ON SITE SURVEY
SAVILLS
PROVIDE SAVILLS WITH UPDATED CAPITAL WORKS /
ATTRIBUTE CODE (CONVERT OLD CODE TO NEW CODE
STRUCTURE)
RDSAP HHSRS
100 DATA INCLUDES SURVEY DATA UPDATEDCODES.
TRANSFER DATA INTO A/M AND ANITE
ANITE DATABASE ORIGONAL CODES CAPITAL WORKS
COMPLETED . NEW ATTRIBUTE CODE
INPUT SKDC TO LOAD CODE SET. ACCEPT SURVEY
DATA AS PER NEW CODE SET
ASSET MANAGEMENT SYSTEM
D/H RESULT,RDSAP RATING AND NROSH DATA
CODE EXTRACT TO FULFILL DECENT HOMES
71
South KestevenLevel 2 - context
INFO IN
RESULTS
UPDATES
SUPPLY DATA
SAVILLS SURVEY DATA (ONE TIME ONLY)
UPDATES MAIN PROPERTY ATTRIBUTES ASBESTOS
ATTRIBUTES GAS UPDATES GAS SERVICING
MODELS REPORTS COST FORCASTS, 1-30YRS
HHSRS RDSAP (RAW DATA)
CONDITION CODES, INC NROSH, ASBESTOS
ASSET MANAGEMENT CALCS FOR RDSAP, DECENT HOMES
etc (NROSH)
ANITE
REGULAR ATTRIBUTE UPDATE INC ELEMENTS FOR DECENT
HOMES, EPC RDSAP DATA SET
SAVILLS TO CHECK PROPERTY DATA. DONE!
RATINGS EPC, NROSH SAP
SINGLE EXTRACT FROM ANITE TO FULLFIL 2010 NROSH
REQUIREMENTS
PROGRAM MAINTENANCE UPDATES ATTRIBUTES FOR
PROGRAMMED WORKS. IN USE NOW
RESULTS CERTS DECENT HOMES CRITERIA FIGURE
(NROSH), EPC RDSAP
NROSH
72
(No Transcript)
73
South KestevenWheelchair standards

• Wheelchair Design Guide
• Housing Corporation Scheme Design Standards (now
  the Design Quality Standards)
• Lifetime Homes
• DoE Wheelchair Standard 1974
• Housing Corporation Mobility Standard
• Building Regulations Part M
• Other

74
Supplying data

• Data Standards
• Toolkits
• Getting started
• Validations Reports
• Help desks websites
• Q A

75
Help desks

• HMS help desks
• available from most HMS suppliers
• compatibility issues
• release update information
• toolkit installation mapping issues
• HMS user groups
• available from most HMS suppliers
• meet a few times a year
• most circulate information
• Contact details
• refer to toolkit information on CLG NROSH website

76
Help desks

• NROSH Technical Help Desk
• Interform XML queries
• Toolkit installation mapping issues
• NROSH-Online login, passwords issues
• Testing of data for new data standards releases
• Contact details
• 020 7944 3294
• nrosh.helpdesk_at_communities.gsi.gov.uk
• Email Subject line - NROSH 'Your subject
  heading'

77
Help desks

• LA Data Support Help Desk
• Encourage NROSH data supply
• Data standards queries
• Queries related to using NROSH data to complete
  parts of CLG collections (ie HSSA, BPSA)
• Contact details
• nrosh.helpdesk_at_communities.gsi.gov.uk
• Email subject line NROSH 'Your subject
  heading'

78
Help desks

• RSL Data Support Help Desk
• Encourage NROSH data supply
• Data standards queries
• Increase data quality
• Queries related to using NROSH data to
  completeparts of the RSR
• Contact details
• 020 7627 5117
• NROSHHADataSupport_at_Forvus.co.uk

79
Websites

• CLG NROSH web pages
• www.communities.gov.uk/ nationalregisterofsocialho
  using
• HC NROSH web pages
• www.housingcorp.gov.uk/nrosh
• NROSH to RSR Facility
• www.rsrsurvey.co.uk
• Beware of pirate NROSH websites!

80
Supplying data

• Data Standards
• Toolkits
• Getting started
• Validations Reports
• Help desks websites
• Q A

81
Agenda

• 10.00 Registration and coffee
• 1030 NROSH introduction
• 1050 NROSH targets
• 11.00 Supplying NROSH data
• 1200 QA
• 1230 Lunch
• 1315 Using NROSH data
• 1345 Extracting data through NROSH-Online
• 1415 Next steps including move to TSA
• 1430 General questions/discussion time
• 1445 Close

82
Age profile of councilhousing stock in York
83
York council housing stockby age of dwellings
84
Energy efficiency of social housingNorth West
London
85
Energy efficiency of social housingNW London by
super output area
86
2-bedroom flatsCamden Islington
87
Social housing stockin ad hoc areas
88
Social housing stockin ad hoc areas by size/type
89
Loss of council housing by sizeCamden 2006
90
Reasons for loss of council housing Camden 2006
Total Losses - 66
91
Dwellings failing Decent Homes Standardfor state
of repair
92
Council housing re-let timesby size/type of
dwelling
93
Council housing turnover rate (LA)by size/type
of dwelling
94
Letting by ethnic groupand type of dwelling
95
Housing stock by tenure and council tax band
Joining NROSH data to VOA data
96
Social housing at risk of flooding
Proportion of stockin flood zone 2 12.5
97
NROSH flood risk statisticsby GOR
98

• NROSH-Online

99
NROSH-Online

• Your access to all the data
• Standard reports
• Download raw data
• Your way of checking the data you sent
• Your way to get extra information about your
  stock Flood risk/NLPG UPRN

100
NROSH-Online Standard Reports

• Rents
• Target rents
• Rent loss
• Decent Homes Standard
• Stock by age
• Stock by category of provision
• Stock by ownership
• Stock by facilities
• Supported housing
• Wheelchair and accessible housing

101
NROSH-Online Filters

• Region
• Local authority administrative area
• Electoral ward
• MSOA
• Landlord by name
• Type of landlord LA/HA/ALMO
• Type of HA
• Category of provision GN/Care home/SO
• Owned or managed

102
Protection of Sensitive Data

• Records of sensitive addresses are removed
  completely
• Offenders hostels
• Accommodation for women at risk of violence
• Accommodation for people with HIV/AIDS

103
NROSH-Online User Guidance

• Quick guide to producing a standard report
• Tips on checking the data you sent
• User manual downloadable from the site
• Help buttons on the web pages
• Step by step guide to downloading the floodrisk
  and NLPG UPRN for each of your dwelling
• Index to database tables

104
(No Transcript)
105
NROSH-OnlineStandard reports
106
Agenda

• 10.00 Registration and coffee
• 1030 NROSH introduction
• 1050 NROSH targets
• 11.00 Supplying NROSH data
• 1200 QA
• 1230 Lunch
• 1315 Using NROSH data
• 1345 Extracting data through NROSH-Online
• 1415 Next steps including move to TSA
• 1430 General questions/discussion time
• 1445 Close

107
The national projectStrategic context

• Ends and Means The Future Roles of Social
  Housing in England (Hills)
• Every Tenant Matters A Review of Social Housing
  Regulation (Cave)
• Delivering Housing and Regeneration Communities
  England and the Future of Social Housing
  Regulation (CLG)

108
The national projectStrategic context

• Every Tenant Matters A Review of Social Housing
  Regulation.
• Information Strategy reducing and rationalising
  regulatory statistical data collection
• Stock data potential for NROSH to substantially
  replace these requirements, subject to review of
  the extent of NROSH data requirements and
  minimisation of administrative burdens. Annex
  5a, 5b

109
The national projectStrategic context
Communities and Local Government
Homes and Communities Agency
Housing Corporation
Tenant Services Authority
English Partnerships