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

Accessing NJR Data PowerPoint PPT Presentation


  • 110 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

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 ?

  • What is the data used for ?

  • How do we access the data ?

  • How do we save the data ?

4


WHAT HAPPENS TO THE DATA ?


NJR

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

  • Annual Report


  • 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

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

    • Stats Online

    • Reports Online

    • Clinician Feedback


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

  • 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


  • 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


  • 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

  • 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

  • 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 UseStatsonline Online


Slide 12


Slide 13


Slide 14


Slide 14


Slide 14


Slide 14


How To UseReports Online


(1) Enter your date range

(2) Choose the report you want to run

(3) Click “show report”


  • 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


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


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


  • 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


  • 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.


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.


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