creating custom reports in nhsn - aqaf · 10 october 26, 2012. 11 october 26, 2012 select...

Creating Custom Reports in NHSN

Elizabeth Pruitt, MSPH

October 26, 2012

Objectives

• Review current report options

• Create custom report templates

• Set up to run multiple reports at once on

a regular basis

October 26, 20122

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

October 26, 20124

Select the

Patient

Safety

component

October 26, 20125

Select Generate

Data Sets

If “Not generated”

or old date, rerun

before analysis

Click Generate New

before analysis

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

October 26, 20127

Click on Output Options

under Analysis

October 26, 20128

October 26, 20129

Results Pop Up Window

Want to See this based

on Procedure Date

instead of Event Date?

October 26, 201210

October 26, 201211

Select procDateYr to

sort by procedure date

for a year’s time period.

Enter time

period of interest

Results Pop Up Window of Modified Table

October 26, 201212

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

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

October 26, 20121

5

Click on Output Options

under Analysis

October 26, 201216

Results Pop Up Window

October 26, 201217

Results Pop Up Window (part 2)

October 26, 201218

October 26, 201219

First,

check

the

alerts

October 26, 201220

Check “Report No Events”

to include in SIR

calculation

October 26, 20122

1

Click on Output Options

under Analysis

October 26, 201222

October 26, 201223

Results Pop Up Window

October 26, 201224

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

Custom Output

• Produce a single report showing CMS

IPPS program data– CLABSI

– CAUTI

– SSI

October 26, 201226

October 26, 20122

7

Click on Output Options

under Analysis

October 26, 20122

8

October 26, 20122

9

Enter a name and

title for your report

Click Add Output Options

October 26, 20123

0

October 26, 201231

October 26, 201232

Publish allows other users at your

facility to use this output set

October 26, 201233

Advanced Output Options

• CMS-related reports

• See your facility’s data as they would be

submitted to CMS

October 26, 201234

October 26, 201235

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

Questions?

• Analysis questions– Elizabeth Pruitt

• epruitt@alqio.sdps.org

• 205-970-1600 Ext. 3514

• Help with NHSN– nhsn@cdc.gov

October 26, 20123

7