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 |
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 APPY, BILI, CHOL, COLO, REC, SB, |
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 |
Patient’s classification for anesthesia (Physical Status Modifier)
1 - Normally healthy patient |
CDM > Anesthesia > Physical Status Modifier Field will be blank if no data entered
|
|
scope |
Required |
Was a scope required for the procedure?
Y – Yes |
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 |
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 |
|
Field will be blank for all cases as AO does not record this information. |
|
htInches |
Optional for |
|
Field will be blank for all cases as AO does not record this information. |
|
htMetric |
Optional for import; |
|
Field will be blank for all cases as AO does not record this data. |
|
wtEnglish |
Optional for import; |
|
Field will be blank for all cases as AO does not record this data. |
|
wtMetric |
Optional for |
|
Field will be blank for all cases as AO does not record this data. |
|
diabetes |
2013 procedures and earlier: |
Does the patient have Diabetes mellitus?
Y – Yes |
Field will be blank for all cases as AO does not record this data. |
|
|
Required if |
TOT – Total |
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 |
|
FX |
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 |
|
SB |
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 |