Knowledge Matters Volume 1 Issue 1

Knowledge Management Team, South East Coast Strategic Health Authority Knowledge.management@southeastcoast.nhs.uk

INSIDE THIS ISSUE 1

Welcome to Knowledge Matters

1

Plans for the year

2

Meet the Team

3

Focus On … Workforce

4 4 4

A : Ask an Analyst

4 4 4

Coming soon…

3

Useful Links News and Events

Fun Fact Quick Quiz

May 2007 Volume 1 Issue 1

Welcome to Knowledge Matters

By Samantha Riley Welcome to the first issue of Knowledge Matters – a bi monthly newsletter aimed at information analysts and all folk interested in data and statistics.

Knowledge Matters is intended to be fun but informative, providing you with both national and local news, alongside details of key dates and upcoming events. Each issue will focus on a topic in more detail – in this issue the spot light is on workforce.

This issue provides an opportunity for you to ‘meet the team’.

During June, I will be setting up a range of meetings across Kent, Surrey and Sussex that will provide an opportunity for you to meet us in person.

If you have any comments or suggestions regarding future issues and topics that you would like us to cover, please do get in touch. Happy reading!

Samantha Riley

Our plans for the year ….

Key areas of work for coming year include: -

“Monitoring, helping, creating and facilitating – that’s what we’re about”

•

Expansion of the comparative benchmarking information provided so far to cover the acute sector, primary /community care and mental health.

•

The development of a range of ‘how to’ guides and a training programme for analysts.

•

The creation of local commissioning rules for application across South East Coast.

•

Supporting commissioners to identify requirements for the commissioning management of services.

•

The development of a range of practical tools to support the implementation of priority programmes including 18 weeks.

their information and performance

Knowledge Matters

Pag Page 2

Head of Knowledge Management

Samantha Riley

Performance Analysts

Fiona Cantrell

Kate Cheema

Development Analysts

Meet the Team ….

The Head of Knowledge Management – Samantha Riley Samantha previously worked at Surrey & Sussex SHA as Deputy Director for Service Improvement. Samantha is committed to ensuring that good quality, robust information drives decision making across South East Coast.

Key roles include identifying the information needs of commissioners and providers, specifying products to meet these needs and in marketing work undertaken by analysts within the team.

The Performance Analysts – Fiona Cantrell and Kate Cheema We’re both poachers turned gamekeepers, coming from West Sussex and Hampshire PCTs respectively, working on the commissioning side of the business, helping to develop reporting systems and making sure that all our returns are in on time and correct! Previous to that Fiona worked in the travel industry and Kate was at Southampton General trying to make sense of their commissioning and finance systems. You’ll probably hear a lot from us but we’re nice people (honest!) and won’t bite.

The Development Analysts – Simon Berry and Adam Cook

Simon Berry

Adam Cook

Workforce Analyst

Adam and Simon are here to develop useful tools, toys and models that add value to local work in Trusts and PCTs. Simon and Adam have both worked at the SHA for nearly two years. Previously Simon has worked for Brighton PCT and in the exciting industries of bricks and road construction. Adam has been analysing NHS data for over a decade in HAs, the acute sector and academia. He has devolved responsibility for central returns to Kate and Fiona, and is now immersed in the murky depths of Mental Health and Community Hospital information.

The Workforce Analyst – Kiran Cheema

Kiran Cheema

Public Health Analyst

Hi, I am the workforce analyst, before taking on this role I worked at a national strategic level as an analyst for the NHS workforce review team, as well as having worked for Norwich Union in their medical health insurance branch doing workflow/workforce analysis and KPI monitoring.

I look forward to working with you all and am here to help and support on all things workforce.

The Public Health Analyst – Graham Evans

Graham Evans

Business Intelligence and Information Advisor

I’m the Public Health Analyst here having been both an Information Analyst and then Public Health Analyst at the former Surrey & Sussex SHA. Before that I worked at West Sussex Health Authority as their Public Health Analyst. My work covers all things public health: smoking, childhood obesity, sexual health, health inequalities, health outcomes, LDP and the like.

The Business Intelligence and Information Advisor – Andrew Wilk

Andrew Wilk

Andrew has worked for NHS, the Department of Health, and the Private Health care sector. Andrew’s work areas include Commissioning Rules, Fit for the Future and input into national reference groups. Andrew has a special interest in data quality and geographical information systems.

“Much learnt, but much still to learn” is his philosophy.

Knowledge Matters

Page 3

Focus On – Workforce …..

By Kiran Cheema With the completion of the electronic staff records (ESR) system rollout looming on the horizon, Can the promise of a better brighter future with a smaller reporting burden required for South East Coast NHS organisations be delivered?

“ESR is the Operational system… ESRDW is a database to support strategic decision making”

ESR, defined as “a single integrated HR and payroll system”, is currently being rolled out to all NHS organisations in England and Wales, with the aim of standardising human resources (HR) and Payroll process across the NHS. ESR is the operational system and provides facilities for local reporting by NHS Trusts. Alongside the development of the operational system it was realised that there would be a requirement for a repository of HR, payroll and training information from all organisations for centralised strategic reporting by SHA’s, WDD/WDC’s, Deaneries, DH, IC. To this end the ESR Data Warehouse (ESRDW) was developed as a database to support strategic decision making, and is structured to facilitate reporting rather than the transactional processing of the operational system.

The ESRDW was envisaged to support activities such as: • Long term staff forecasting.

• Understanding geographical distributions and movement patterns.

• The planning of future workforce training and development.

So the big question is, does this mean no more central returns? Errm … well the short answer is … No. There a few things to realise about the ESR Data Warehouse, firstly not all data from ESR is transferred to the Data Warehouse, only data items that have been initially specified are extracted from ESR, so there maybe occasions when the information just isn’t available centrally through the ESRDW. Secondly there is a time lag to consider, as a strategic database the ESRDW is not continually updated with the changes to ESR, ESRDW is updated once a month for the period one month in arrears. This means that data warehouse users are continually using data that is between one to two months old.

For example data up to the end of January will be loaded into ESRDW in the first weekend of March. Any reports for which the return date (the date the collection is returned to collecting organisation) and the reporting date (the period for which the information is collected) fall within the time lag between ESR and the DW will still need to be manually collected.

Further information: National Workforce Dataset (NWD) available online from www.healthcareworkforce.nhs.uk K-75500 Data Warehouse overview and data item description document available through the ESR Knowledgebase website at http://esr.knowledgebasesolutions.com

ESR and ESRDW

“ESRDW is updated once a month for the period one month in arrears”

The Time Lag Explained

Knowledge Matters

Pag Page 4

In development & coming soon…

Mental health benchmarking (end May) Annual health check scoring tool (end May) Programme budget analyses (end May) BADS benchmarking tool (end May) Critical care benchmarking update (June) Suite of A&E tools (June)

This Issues Useful Links …

Public Health Clicking on ‘Go directly to the indicators’ at the link below will take you to a wonderful world of Public Health related statistics from fertility rates to mortality rates and a lot in between. http://nww.nchod.nhs.uk/ Workforce The link below will take you to the National Workforce Projects (NWP) and Workforce Review Team (WRT) site featuring resources, guidance and tools. www.healthcareworkforce.nhs.uk General Below is the link to the Information centre for health and social care website, including workforce, performance, population and social care information. www.ic.nhs.uk

In South East Coast trusts nearly three times as many people were treated for attacks by reptiles than for rat-bites in 2005-2006

News and Events …

May 07 Q3 Better Care Better Value indicators published: http://www.productivity.nhs.uk/ SHA deadlines-Timetable published mandatory central returns for organizations.

Results of 2006 Inpatient Survey published: http://www.healthcarecommission.org.uk 18th Unify 2 go-live. Account details sent to all users; any issues with access should be referred to unify2@dh.gsi.gov.uk in the first instance.

SHA wins bid to work with the Information Centre for Health and Social Care on a programme to promote the use of information with clinicians. More details to follow.

June 07

Analyst network meetings – further details to follow.

Fit for Purpose Database launch.

A3: ASK AN ANALYST Coming soon…if you have a question for the team please e-mail: Knowledge.management@southeastcoast.nhs.uk

Knowledge matters is the newsletter of NHS South East Coast’s Knowledge Management Team to discuss any items raised in this publication or for further information contact: Knowledge Matters C/O Knowledge Management Team NHS South East Coast York House 18-20 Massetts Road Horley,Surrey, RH6 7DE Phone: 01293 778899 E-mail: Knowledge.management@southeastcoast.nhs.uk To contact a team member: firstname.surname@southeastcoast.nhs.uk

for all

Quick Quiz Which line on the graph below represents a standardised normal distribution?