National Healthcare Safety Network (NHSN) Procedures Upload CSV v8.5 2022

The report gathers a list of all procedures performed in the date of service range you provide and exports a list of pertinent information for reporting these procedures to the Centers for Disease Control and Prevention - National Healthcare Safety Network (NHSN). The intent of the report is to report patient safety procedure data.

This topic describes specifications for importing procedure data for NHSN Procedures Upload CSV version 8.5, 2020, and applies to AmkaiOffice versions 4.4 and later. Administrators should be sure to check roles and permissions for new features as well as new reports that are added to the system with the upgrade and provide access to the staff that will make use of this enhancement.

For complete information on the data field requirements and definitions, see the NHSN Manual, available here: http://www.cdc.gov/nhsn/acute-care-hospital/ssi/index.html.

Please contact our support team at 866-265-2434 for more information on running the NHSN data extract.

Note: This report is not a complete list of all the data elements needed to meet NHSN reporting requirements. It is necessary to edit the report output file to add the missing required data.

NHSN Report

The NHSN data extract can be found here in AmkaiOffice: Reports > CDM > NHSN Procedures upload.

This report will extract data elements required to send to the CDC for processing the NHSN Report. The system generates a CSV file that you can open and edit in Excel.

Criteria for including cases/procedures in the report

The report output file will include data elements extracted from cases documented in your AmkaiOffice database that meet all of the following criteria:

- Cases marked either Performed or Partially performed /Billable
- Cases that include a procedure code that is included in the NHSN approved list of codes
- Of those cases, only procedures documented in CDM > Operative > Performed Procedures table will be included

Excluded data

Any data that is not documented in AmkaiOffice is not included in the report output, including data that AmkaiOffice is not currently designed to collect, such as Height in inches. These unrecorded data elements are noted as such in the Data Elements table in this document.

You will need to add the missing information in the output file or add it directly in the NHSN program after the report is uploaded.

Report Output

The report is generated in a CSV file and can be edited in Microsoft Excel. If Excel is installed on your computer, the CSV file will automatically open in Excel for editing. Many of the report fields will be blank as indicated in the Data Elements table on this document. For any of those fields, you can enter data manually in the CSV file as needed.

You can only upload two procedures per case to NHSN even if there were more than two procedures entered for the case in AmkaiOffice. You will need to remove any additional procedure lines from the report output file before uploading.
The duration for each procedure line on the report is calculated as the total incision time in the CDM. If multiple procedures are being reported for a case, you will need to manually divide this total time between the reported procedures.
AmkaiOffice will default into select fields, including "Wound Class", "Scope", "Emergency", "Trauma", "Diabetes Mellitus" and type of KPRO/HPRO. You should evaluate these default values before uploading the report to NHSN, or edit them after the upload on the NHSN website.
The case name will display in the "Comments" field for better case identification/editing purposes.
If the Comments field contains a "±" character, the NHSN website will not accept the upload.
Remove any instances of this character in the Comments field before uploading the report.
Trigger codes have been updated to ICD-10 for cases with dates of service after 10/1/15.

Main Screen Parameters

Case Date

Select the From and Through dates to define the range of time from which to pull cases for the report.

Only cases that meet the requirements stated on page 4 of this document will be exported to the report.

Include Headers in File

Check this box to include header rows in the data file.

Closure

To exclude the closure type from the report, select (parameter not used). The other options for closure type are: Primary and Other.

Include Comments

If you check this box, the case name will display in the "Comments" field for better case identification/editing purposes. If the Comments field on the report output file contains a "±" character, the NHSN website will NOT accept the upload - you should remove any instances of this character in the Comments field before uploading.

Data Elements

Click herehere to view a table that shows the data elements included in the NHSN report. You can edit the report output to enter data in the fields that default as blank from AmkaiOffice.

Variable	Requirement	Values	Notes/Where the value is found in AmkaiOffice
patID	Required	AmkaiOffice automatically supplies the correct header entries.	When the Include Headers checkbox is selected in report parameters, AO includes column headers in the report.
gender	Required	Patient’s account number	Demographics > Account > Account Number
dob	Required	M – Male F – Female O – Other (If blank, will populate as O.)	Demographics > Identification > Gender
medicareID	Required	Patient’s date of birth	Demographics > Identification > Date of Birth
procCode	Optional	Medicare insurance ID	Demographics > Insurance Policy > ID.
procCPTCode	Required in order for AmkaiOffice to pull in the NHSN procedure code. Optional for reporting purposes.	CPT code must be a valid code as listed in the NHSN Operative Procedures Category list	CDM > Operative > Performed Procedure 1 > ICD-Proc 1
procDate	Required	Patient’s schedule date of service	CDM > Operative > Begin Date
procDurationHr	Required	Length of the procedure in hours	CDM > Operative> Incision> Start time / End time duration minutes
procDurationMin	Required	Length of the procedure in minutes	CDM > Operative> Incision> Start time / End time duration minutes
swClass	Required	C – Clean CC – Clean Contaminated CO – Contaminated D – Dirty/Infected U – Unknown (“Unknown” is only available for procedures performed in 2013 and earlier) Note: The following procedure codes can NOT have a “clean” designation for wound class: APPY, BILI, CHOL, COLO, REC, SB, VHYS.	System will default “C” for types: o BRST o FX o HER o HPRO o HYST o KPRO System will default “CC” for the types: o CHOL o COLO
asa	Required if Outpatient = N	Patient’s classification for anesthesia (Physical Status Modifier) 1 - Normally healthy patient 2 - Patient with mild systemic disease 3 - Patient with severe systemic disease, not incapacitating 4 - Patient with incapacitating systemic disease, constant threat to life 5 - Moribund patient < 24 hr life expectancy	CDM > Anesthesia > Physical Status Modifier Field will be blank if no data entered
scope	Required	Was a scope required for the procedure? Y – Yes N – No	Defaults all cases to N. If needed, change to Y manually on the report output.
surgeonCode	Optional	Surgeon’s last name. Max length 20 characters.	CDM > Operative > Performed Procedure > Rendering Provider (Last name)
anesthesia	Required	Y – Yes N – No	CDM > Anesthesia > Anesthesia Type o Y (Yes) § If the type of anesthesia description or quick code contains “General” or “Gen” o N (No) § If type of anesthesia description or quick code do not contain “General” or “Gen”
htFeet	Optional for import; 2013 procedures and earlier: used only when procedure code is CSEC ALL 2014 procedures and later: required for complete in- plan record		Field will be blank for all cases as AO does not record this information.
htInches	Optional for import; 2013 procedures and earlier: used only when procedure code is CSEC ALL 2014 procedures and later: required for complete in- plan record		Field will be blank for all cases as AO does not record this information.
htMetric	Optional for import; 2013 procedures and earlier: used only when procedure code is CSEC ALL 2014 procedures and later: required for complete in- plan record		Field will be blank for all cases as AO does not record this data.
wtEnglish	Optional for import; 2013 procedures and earlier: used only when procedure code is CSEC ALL 2014 procedures and later: required for complete in- plan record		Field will be blank for all cases as AO does not record this data.
wtMetric	Optional for import; 2013 procedures and earlier: used only when procedure code is CSEC ALL 2014 procedures and later: required for complete in- plan record		Field will be blank for all cases as AO does not record this data.
diabetes	2013 procedures and earlier: required if procedure code is FUSN or RFUSN 2014 procedures and later: required for ALL procedures	Does the patient have Diabetes mellitus? Y – Yes N – No	Field will be blank for all cases as AO does not record this data.
	Required if procedure code is HPRO or KPRO	TOT – Total HEMI- Hemi RES- Resurfacing (HPRO only)	System defaults to “TOT” for HPRO and KRPO.
comment	Optional	Alphanumeric field length = 15 characters. · Numeric field length decimal (12,3) · Date field = mm/dd/yyyy
custom1 - custom14	Custom fields 1-14		Format and order according to custom field set up and sort order, per procedure code: Alphanumeric field length = 15 character Numeric field length decimal(12,3) 999999999.999 Date field = mm/dd/yyyy
custom15 - custom50	Custom fields 15-50		Format and order according to custom field set up and sort order, per procedure code: Alphanumeric field length = 15 character Numeric field length decimal(12,3) 999999999.999 Date field = mm/dd/yyyy

NSHN Procedure Codes and Associated ICD-CM-/CPT Codes

Click herehere to view a table showing these codes.

Legacy Code

Operative Procedure

Description

CPT Codes

AAA

Abdominal aorta surgery

Abdominal Aortic Aneurysm Repair - Resection of abdominal aorta with anastomosis or replacement

33875

33877

34830

34831

34832

35081

35082

35091

35092

35102

35103

AMP

Limb amputation surgery

Limb Amputation - Total or partial amputation or disarticulation of the upper or lower limbs, including digits

11752

23900

23920

24900

24920

24930

24931

25900

25905

25909

25920

25922

25924

25927

25929

25931

26235

26236

26551

26910

26951

26952

27290

27295

27590

27591

27592

27598

27880

27881

27882

27884

27886

27888

27889

28124

28126

28160

28800

28805

28810

28820

28825

APPY

Appendix surgery

Appendix Surgery - Operation of appendix

44900

44950

44955

44960

44970

44979

AVSD

Surgery for dialysis

Shunt for dialysis - Arteriovenostomy for renal dialysis

36800

36810

36815

36818

36819

36820

36821

36825

36830

36832

36833

36838

BILI

Bile duct, liver or pancreatic surgery

Bile duct, liver or pancreatic surgery - Excision of bile ducts or operative procedures on the biliary tract, liver or pancreas (does not include operations on gall bladder only)

0585T

0586T

47010

47015

47100

47120

47122

47125

47130

47140

47141

47142

47300

47350

47360

47361

47362

47370

47371

47379

47380

47381

47400

47420

47425

47460

47560

47561

47700

47701

47711

47712

47715

47760

47765

47780

47785

47800

47802

47900

48000

48001

48020

48100

48105

48120

48140

48145

48146

48148

48150

48152

48153

48154

48155

48160

48500

48510

48520

48540

48545

48548

BRST

Breast Surgery

Excision of lesion or tissue of breast including radical, modified, or quadrant resection, lumpectomy, incisional biopsy, or mammoplasty

11970

19101

19105

19110

19112

19120

19125

19126

19300

19301

19302

19303

19305

19306

19307

19316

19318

19324

19325

19328

19330

19340

19342

19350

19355

19357

19361

19364

19366

19367

19368

19369

19370

19371

19380

CARD

Cardiac Surgery

Procedures on the heart; includes valves or septum; does not include coronary artery bypass graft, surgery on vessels, heart transplantation, or pacemaker implantation

32658

32659

32661

33020

33025

33030

33031

33050

33120

33130

33250

33251

33254

33255

33256

33257

33258

33259

33261

33265

33266

33300

33305

33310

33315

33365

33366

33400

33401

33403

33404

33405

33406

33410

33411

33412

33413

33414

33415

33416

33417

33420

33422

33425

33426

33427

33430

33440

33460

33463

33464

33465

33468

33470

33471

33474

33475

33476

33478

33496

33542

33545

33548

33600

33602

33608

33610

33611

33612

33615

33617

33619

33641

33645

33647

33660

33665

33670

33675

33676

33677

33681

33684

33688

33692

33694

33697

33702

33710

33720

33722

33732

33735

33736

33737

33770

33774

33776

33780

33782

33783

33786

33813

33814

33920

0051T

0052T

0053T

CBGB

Coronary artery bypass graft with BOTH chest and donor site incisions

Chest procedure to perform direct revascularization of the heart; includes obtaining suitable vein from donor site for grafting

33510

33511

33512

33513

33514

33516

CBGC

Coronary artery bypass graft with chest incision only

Chest procedure to perform direct revascularization of the heart; includes obtaining suitable vein from donor site for grafting

33533

33534

33535

33536

CEA

Carotid endarterectom

Endarterectomy on vessels of head and neck (includes carotid artery and jugular vein)

35301

35390

CHOL

Gallbladder surgery

Cholecystectomy and cholecystotomy

47480

47562

47563

47564

47570

47600

47605

47610

47612

47620

47720

47721

47740

47741

COLO

Colon surgery

Incision, resection, or anastomosis of the large intestine; includes large-to-small and small-to-large bowel anastomosis; see REC for rectal operations

44025

44110

44111

44137

44139

44140

44141

44143

44144

44145

44146

44147

44150

44151

44155

44156

44157

44158

44160

44188

44204

44205

44206

44207

44208

44210

44211

44212

44213

44227

44320

44322

44340

44345

44346

44604

44605

44620

44625

44626

CRAN

Craniotomy

Excision, repair or exploration of the brain or meninges; does not include taps or punctures

0169T

61105

61107

61108

61120

61140

61150

61151

61154

61156

61210

61250

61253

61304

61305

61312

61313

61314

61315

61320

61321

61322

61323

61330

61332

61333

61340

61343

61345

61458

61460

61480

61510

61512

61514

61516

61518

61519

61520

61521

61522

61524

61526

61530

61531

61533

61534

61535

61536

61537

61538

61539

61540

61541

61543

61544

61545

61546

61548

61566

61567

61570

61571

61575

61576

61580

61581

61582

61583

61584

61585

61586

61590

61591

61592

61595

61598

61600

61601

61605

61606

61607

61608

61610

61612

61615

61616

61618

61619

61680

61682

61684

61686

61690

61692

61697

61698

61700

61702

61703

61705

61708

61710

61711

61720

61735

61750

61751

61760

61770

61850

61860

61863

61867

61870

61875

61880

61886

61888

62000

62005

62010

62100

62120

62121

62161

62163

62164

62165

CSEC

Cesarean section

Obstetrical delivery by cesarean section

59100

59510

59514

59515

59618

59620

59622

59857

FUSN

Spinal fusion or refusion

Immobilization of spinal column

0195T

0196T

22532

22533

22548

22551

22554

22556

22558

22586

22590

22595

22600

22610

22612

22630

22633

22800

22802

22804

22808

22810

22812

27280

Open Reduction of Fracture

Open reduction of fracture or dislocation of long bones with our without internal or external fixation; does not include placement of joint prosthesis

23615

23616

23630

23670

23680

24515

24516

24545

24546

24575

24579

24586

24587

24635

24665

24666

24685

25337

25515

25525

25526

25545

25574

25575

25607

25608

25609

25652

27177

27178

27179

27181

27244

27245

27248

27254

27269

27506

27507

27511

27513

27514

27519

27535

27536

27540

27758

27759

27766

27769

27784

27792

27814

27822

27823

27826

27827

27828

27829

GAST

Gastric Surgery

Incision or excision of stomach; includes subtotal or total gastrectomy; does not include vagotomy or fundoplication

43117

43118

43121

43122

43280

43320

43325

43327

43328

43360

43500

43501

43502

43520

43605

43610

43611

43620

43621

43622

43631

43632

43633

43634

43640

43641

43644

43645

43770

43771

43772

43773

43774

43775

43800

43810

43820

43825

43840

43842

43843

43845

43846

43847

43848

43850

43855

43860

43865

43870

43880

43886

43887

43888

HER

Herniorrhaphy

Repair of inguinal, femoral, umbilical, or anterior abdominal wall hernia; does not include repair of diaphragmatic or hiatal hernia or hernias at other body sites

11008

49491

49492

49495

49496

49500

49501

49505

49507

49520

49521

49525

49550

49553

49555

49557

49560

49561

49565

49566

49570

49572

49580

49582

49585

49587

49590

49600

49605

49606

49610

49611

49650

49651

49652

49653

49654

49655

49656

49657

49659

HPRO

Hip prosthesis

Arthroplasty of hip

27125

27130

27132

27134

27137

27138

27236

HTP

Heart transplant

Transplantation of heart

33935

33945

HYST

Abdominal hysterectomy

Abdominal hysterectomy; includes that by laparoscope

58150

58152

58180

58200

58210

58240

58541

58542

58543

58544

58548

58550

58552

58553

58554

58570

58571

58572

58573

58951

58953

58954

58956

59525

KPRO

Knee prosthesis

Arthroplasty of knee

27438

27440

27441

27442

27443

27445

27446

27447

27486

27487

KTP

Kidney transplant

Transplantation of kidney

50340

50360

50365

50380

LAM

Laminectomy

Exploration or decompression of spinal cord through excision or incision into vertebral structures

0171T

0202T

0219T

0220T

0221T

22220

22222

22224

22856

22857

22861

22862

62287

62351

62380

63001

63003

63005

63011

63012

63015

63016

63017

63020

63030

63035

63040

63042

63045

63046

63047

63048

63050

63051

63055

63056

63064

63075

63077

63081

63082

63085

63086

63087

63088

63090

63265

63266

63267

63268

63270

63271

63091

63101

63250

63251

63252

63272

63273

63275

63276

63277

63278

63280

63281

63282

63283

63285

63286

63287

63290

63709

63740

63102

63103

63170

63172

63173

63180

63182

63185

63190

63191

63194

63195

63196

63197

63198

63199

63200

LTP

Liver transplant

Transplantation of liver

47135

47399

NECK

Neck surgery

Major excision or incision of the larynx and radical neck dissection; does not include thyroid and parathyroid operations

31300

31360

31365

31367

31368

31370

31375

31380

31382

31390

31395

31400

31420

31560

31561

31580

31584

31587

31590

31599

38308

38542

38720

38724

41135

41140

41145

41155

42420

42425

42426

69150

69155

NEPH

Kidney surgery

Resection or manipulation of the kidney with or without removal of related structures

50010

50020

50040

50045

50060

50065

50070

50075

50120

50125

50130

50135

50205

50220

50225

50230

50234

50236

50240

50250

50280

50290

50320

50400

50405

50541

50542

50543

50545

50546

50547

50548

50549

OVRY

Ovarian surgery

Operations on ovary and related structures

58660

58661

58662

58679

58720

58740

58800

58805

58820

58822

58825

58900

58920

58925

58940

58943

58950

58952

58970

PACE

Pacemaker Surgery

Insertion, manipulation or replacement of pacemaker

0571T

0572T

0573T

0574T

33202

33203

33206

33207

33208

33212

33213

33214

33215

33216

33217

33218

33220

33221

33222

33223

33224

33225

33226

33227

33228

33229

33230

33231

33233

33234

33235

33236

33237

33238

33240

33241

33243

33244

33249

33262

33263

33264

33270

33271

33272

33273

PRST

Prostate surgery

Suprapubic, retropubic, radical, or perineal excision of the prostate; does not include transurethral resection of the prostate

55705

55810

55812

55815

55821

55831

55840

55842

55845

55866

PVBY

Peripheral vascular bypass surgery

Bypass operations on peripheral arteries and veins

33889

35501

35506

35508

35509

35510

35511

35512

35515

35516

35518

35521

35522

35523

35525

35533

35556

35558

35566

35570

35571

35583

35585

35587

35616

35621

35623

35650

35654

35656

35661

35666

35671

35686

REC

Rectal surgery

Operations on rectum

45110

45111

45112

45113

45114

45116

45119

45120

45121

45126

45395

45397

45562

45563

57307

Small bowel surgery

Incision or resection of the small intestine; does not include small-to-large bowel anastomosis

43496

44010

44015

44020

44021

44120

44121

44125

44126

44127

44128

44130

44186

44187

44202

44203

44300

44310

44312

44314

44316

44602

44603

44615

44640

44650

44800

45136

SPLE

Spleen Surgery

Resection or manipulation of spleen

38100

38101

38102

38115

38120

38200

THOR

Thoracic surgery

Noncardiac, nonvascular thoracic surgery; includes pneumonectomy and hiatal hernia repair or diaphragmatic hernia repair (except through abdominal approach)

20101

21603

31770

31775

32096

32097

32100

32110

32120

32124

32140

32141

32151

32200

32215

32220

32225

32310

32320

32440

32442

32445

32480

32482

32484

32486

32488

32491

32501

32503

32504

32505

32506

32507

32540

32553

32607

32608

32609

32651

32652

32655

32662

32663

32666

32667

32668

32669

32670

32671

32672

32800

32815

32905

32906

32940

32960

39000

39010

39200

39220

39501

39545

39560

39561

64746

THYR

Thyroid and/or parathyroid surgery

Resection or manipulation of thyroid and/or parathyroid

60000

60200

60210

60212

60220

60225

60240

60252

60254

60260

60270

60271

60280

60281

60500

60502

60505

60512

VHYS

Vaginal Hysterectomy

Vaginal hysterectomy; includes that by laparoscope

51925

58260

58262

58263

58267

58270

58275

58280

58285

58290

58291

58292

58293

58294

VSHN

Ventricular shunt

Ventricular shunt operations, including revision and removal of shunt

62160

62180

62190

62192

62194

62200

62201

62220

62223

62225

62230

62256

62258

XLAP

Exploratory laparotomy

Abdominal operations not involving the gastrointestinal tract or biliary system; includes diaphragmatic hernia repair through abdominal approach

20102

35840

39503

39540

39541

43332

43333

44005

44180

44700

44820

44850

49000

49002

49010

49013

49014

49020

49040

49060

49203

49204

49205

49215

49220

49250

49255

49320

49321

49324

49325

49326

49402

49412

49419

49421

49425

49426

49900

49905

49906

58960