creating custom reports in nhsn - aqaf · 10 october 26, 2012. 11 october 26, 2012 select...
TRANSCRIPT
![Page 1: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/1.jpg)
Creating Custom Reports in NHSN
Elizabeth Pruitt, MSPH
October 26, 2012
![Page 2: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/2.jpg)
Objectives
• Review current report options
• Create custom report templates
• Set up to run multiple reports at once on
a regular basis
October 26, 20122
![Page 3: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/3.jpg)
Practice Makes Perfect
• Log in to NHSN
– https://sdn.cdc.gov
• Reminder: Turn off pop-up blocker
• Examples adapted from October 2012
NHSN Training Course
October 26, 20123
![Page 4: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/4.jpg)
October 26, 20124
Select the
Patient
Safety
component
![Page 5: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/5.jpg)
October 26, 20125
Select Generate
Data Sets
If “Not generated”
or old date, rerun
before analysis
Click Generate New
before analysis
![Page 6: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/6.jpg)
Frequency Table
• Event level data
• Try it: Obtain a count of specific SSI
events that were identified following
COLO, HYST, and KPRO procedures
performed in 2011
October 26, 20126
![Page 7: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/7.jpg)
October 26, 20127
Click on Output Options
under Analysis
![Page 8: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/8.jpg)
October 26, 20128
![Page 9: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/9.jpg)
October 26, 20129
Results Pop Up Window
Want to See this based
on Procedure Date
instead of Event Date?
![Page 10: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/10.jpg)
October 26, 201210
![Page 11: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/11.jpg)
October 26, 201211
Select procDateYr to
sort by procedure date
for a year’s time period.
Enter time
period of interest
![Page 12: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/12.jpg)
Results Pop Up Window of Modified Table
October 26, 201212
![Page 13: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/13.jpg)
Complex 30-day SSI model
• Used for CMS IPPS– Run and print 7 days before submission deadline
• Only in-plan, inpatient COLO and
HYST procedures in adult patients
• Only deep incisional primary and
organ/space SSIs with an event date
within 30 days of the procedure
October 26, 201213
![Page 14: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/14.jpg)
Example: SSI data for CMS IPPS
• Verify completeness and accuracy of
data to be submitted to CMS for Q2
• Confirm monthly reporting plans include
inpatient COLO and HYST procedures
for SSI
• Confirm all procedures have been
reported to NHSN for the full quarter
• Now, try running the reportOctober 26, 201214
![Page 15: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/15.jpg)
October 26, 20121
5
Click on Output Options
under Analysis
![Page 16: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/16.jpg)
October 26, 201216
![Page 17: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/17.jpg)
Results Pop Up Window
October 26, 201217
![Page 18: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/18.jpg)
Results Pop Up Window (part 2)
October 26, 201218
![Page 19: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/19.jpg)
October 26, 201219
First,
check
the
alerts
![Page 20: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/20.jpg)
October 26, 201220
Check “Report No Events”
to include in SIR
calculation
![Page 21: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/21.jpg)
October 26, 20122
1
Click on Output Options
under Analysis
![Page 22: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/22.jpg)
October 26, 201222
![Page 23: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/23.jpg)
October 26, 201223
![Page 24: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/24.jpg)
Results Pop Up Window
October 26, 201224
![Page 25: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/25.jpg)
Reasons for Exclusion
• Line item records where risk is not
calculated will be excluded from the SIR
(include modelRiskComplex30d
variable)– Indicated by a .
• SIR exclusion criteria is listed in
Appendix C of the SIR newsletter– http://www.cdc.gov/nhsn/PDFs/Newsletters/NHSN
_NL_OCT_2010E_final.pdf
October 26, 201225
![Page 26: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/26.jpg)
Custom Output
• Produce a single report showing CMS
IPPS program data– CLABSI
– CAUTI
– SSI
October 26, 201226
![Page 27: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/27.jpg)
October 26, 20122
7
Click on Output Options
under Analysis
![Page 28: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/28.jpg)
October 26, 20122
8
![Page 29: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/29.jpg)
October 26, 20122
9
Enter a name and
title for your report
Click Add Output Options
![Page 30: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/30.jpg)
October 26, 20123
0
![Page 31: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/31.jpg)
October 26, 201231
![Page 32: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/32.jpg)
October 26, 201232
Publish allows other users at your
facility to use this output set
![Page 33: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/33.jpg)
October 26, 201233
![Page 34: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/34.jpg)
Advanced Output Options
• CMS-related reports
• See your facility’s data as they would be
submitted to CMS
October 26, 201234
![Page 35: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/35.jpg)
October 26, 201235
![Page 36: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/36.jpg)
Additional Resources
• Introduction to NHSN Analysis– http://www.cdc.gov/nhsn/PDFs/training/intro-AnalysisBasics-
PSC.pdf
• Advanced NHSN Analysis– http://www.cdc.gov/nhsn/PDFs/training/AnalysisAdvanced_P
SC.pdf
• Details for CMS reporting within NHSN– http://www.cdc.gov/nhsn/library.html#cms
• NHSN Annual Reports– http://www.cdc.gov/nhsn/dataStat.html
October 26, 201236
![Page 37: Creating Custom Reports in NHSN - AQAF · 10 October 26, 2012. 11 October 26, 2012 Select procDateYr to sort by procedure date ... •Confirm monthly reporting plans include inpatient](https://reader036.vdocuments.us/reader036/viewer/2022080718/5f78a546876aa431f7291186/html5/thumbnails/37.jpg)
Questions?
• Analysis questions– Elizabeth Pruitt
• 205-970-1600 Ext. 3514
• Help with NHSN– [email protected]
October 26, 20123
7