Accessing NJR Data
This presentation is the property of its rightful owner.
Sponsored Links
1 / 38

Accessing NJR Data PowerPoint PPT Presentation


  • 105 Views
  • Uploaded on
  • Presentation posted in: General

Accessing NJR Data. Inez Dunn NJR Regional Coordinator North West England. About Me. Worked in NHS for over 25 years Team Leader & Regional Co-ordinator for North West England Registered Nurse Trauma & Orthopaedics. 4. Questions. What happens to NJR data ?

Download Presentation

Accessing NJR Data

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Accessing njr data

Accessing NJR Data

Inez Dunn

NJR Regional Coordinator

North West England


About me

About Me

  • Worked in NHS for over 25 years

  • Team Leader & Regional Co-ordinator for North West England

  • Registered Nurse

  • Trauma & Orthopaedics

4


Questions

Questions

  • What happens to NJR data ?

  • What is the data used for ?

  • How do we access the data ?

  • How do we save the data ?

4


Accessing njr data

WHAT HAPPENS TO THE DATA ?


Accessing njr data

NJR

Data


What happens to the data

What Happens To The Data

  • NJR database

    • If saved in your edit stack it is not fully submitted

  • Analysis & Reports

  • Accessible to HDM’s

  • Surgeons can access their own data

4


Analysis reports

Analysis & Reports

  • Annual Report


Accessing njr data

  • Public & Patient Guide To The NJR

  • Trust Level Annual Report – goes to the CEO

  • Feedback to regulatory authorities – MHRA etc.

  • Outlier Analysis

  • Reports from your RC


Reporting mechanisms

Reporting Mechanisms

  • 3 main methods Healthcare staff can access data at different levels

    • Stats Online

    • Reports Online

    • Clinician Feedback


Statsonline

Statsonline

  • A web-based facility for viewing and downloading NJR statistics for English and Welsh independent healthcare providers, NHS hospitals and treatment centres

  • Accessible by everyone

  • Shows how much data hospitals and treatment centres have submitted to the NJR since the 1st April 2003.

  • The statistics are based on the operation date.

  • Data at the hospital level is supplied by both operation date and the date the operation record was submitted to the NJR database.

5


Reports online

Reports Online

  • Provides information to surgeons, hospital data managers and suppliers on case totals, case mix and implant usage

  • Offers the opportunity to view and download detailed and summarised reports on:

    • the procedures performed

    • implant usage

    • patients (currently available to surgeons only).

  • Accessed via the data entry page

3


Accessing njr data

  • Consultants must give permission for their data to be seen by the HDM – This will change with the next database upgrade

  • Consultants & surgeons can view and download reports on procedures performed/patient details

    Need own login & password to access this

3


Accessing njr data

  • Operations reports

  • Components reports

    Split this way because several components may be implanted during one operation and this generates too much data to download for easy display in one spreadsheet

  • Procedure Type Case Mix

  • Brand Usage

    These reports include all operations performed at your hospital, irrespective of whether the Lead Consultants have consented to share data

3


Available reports

Available Reports

  • MDS1 Hips Operations

  • MDS2 Hips Operations

  • MDS3 Hips Operations

  • MDS1 Knees Operations

  • MDS2 Knees Operations

  • MDS3 Knees Operations

  • MDS4 Ankles Operations

  • MDS1 Components Hips

  • MDS2 Components Hips

  • MDS3 Components Hips

  • MDS1 Components Knees

  • MDS2 Components Knees

  • MDS3 Components Knees

  • MDS4 Components Ankles

  • Procedure Type Casemix

  • Brand Usage

  • MDS5 Elbow Operations

  • MDS5 Component Elbows

  • MDS5 Shoulder Operations

  • MDS5 Component Shoulders

  • Time periods for the minimum data sets are:

  • • MDS1 from 1st April 2003 (Hips & Knees)

  • • MDS2 from 1st April 2004 (Hips & Knees)

  • • MDS3 from 1st December 2007 (Hips & Knees)

  • • MDS4 from 1st April 2010 (Ankles)

  • MDS5 from 1st April 2012 (Elbows & Shoulders)


Reports available to surgeons

Reports available to Surgeons

  • Operation Summary Statistics

  • Patient procedure mix as consultant in charge

  • • Patient procedure mix as lead operating surgeon

  • • Hip indications for implantation as consultant in charge

  • • Hip indications for implantation as lead operating surgeon

  • • Knee indications for implantation as consultant in charge

  • • Knee indications for implantation as lead operating surgeon

  • • Ankle indications for implantation as consultant in charge

  • • Ankle indications for implantation as lead operating surgeon

  • Elbow indications for implantation as consultant in charge

  • Shoulder indications for implantation as lead operating surgeon

  • • Hip indications for revision as consultant in charge

  • • Hip indications for revision as lead operating surgeon

  • • Knee indications for revision as consultant in charge

  • • Knee indications for revision as lead operating surgeon

  • • Ankle indications for revision as consultant in charge

  • • Ankle indications for revision as lead operating surgeon

  • Elbow indications for revision as consultant in charge

  • Shoulder indications for revision as lead operating surgeon


How to use statsonline online

How To UseStatsonline Online


Accessing njr data

Slide 12


Accessing njr data

Slide 13


Accessing njr data

Slide 14


Accessing njr data

Slide 14


Accessing njr data

Slide 14


Accessing njr data

Slide 14


How to use reports online

How To UseReports Online


Accessing njr data

(1) Enter your date range

(2) Choose the report you want to run

(3) Click “show report”


Accessing njr data

  • Remember :-

    If a Surgeon has not sent the NJR a signed Change of Permission form giving consent for the HDM to see their data, apart from Procedure Casemix & Brand usage, none of their information will appear in any reports.


How to save the reports

How to save the reports


Accessing njr data

With the report displayed on screen, click ‘This data is available to download as a CSV file’.


Accessing njr data

  • A ‘File Download’ window will appear where you are given the choice to Open or Save the CSV file.


Accessing njr data

  • Opening the CSV file will display your data on screen in a Microsoft Excel spreadsheet which can then be saved to a file location of your choice.

  • If you choose the Save option, a ‘Save As’ window will appear which allows you to save the file to a location of your choice. The saved file can then be opened and viewed as Microsoft Excel spreadsheet


Accessing njr data

  • In conclusion:-

    • Everything you enter for your hospital can be accessed.

    • Surgeons can access their own information, including patient details.

    • Results can be saved to use as you wish.


Accessing njr data

Slide 38

If you would like training on how to use any of the reporting mechanisms used by the NJR contact your Regional Coordinator who will be happy to organise this with you.


Accessing njr data

Regional Coordinators: ([email protected])

  • North – Maggie Tate

  • North Wales & West Midlands – Chris Hipkiss

  • Eastern England – Lorna Watson

  • London & Essex – Sue Campey

  • Southern England – Anita Cannon

  • Central England – Marian Gibson

  • Mid & South Wales & SW England – Edward Caton/Carol Maskrey (April ’14)

  • North West – Inez Dunn

    [email protected]

    0845 345 9991


  • Login