Implementation Spreadsheets and Test Case Scenario Worksheets

Implementation Spreadsheets

Use the NMI Implementation Spreadsheets below to help facilitate a gap analysis for the chosen HL7 case notification message. These templates merge information from the message mapping guides, NMI HL7 Message Specification, and the PHIN Vocabulary Access and Distribution System (PHINVADS). Each implementation spreadsheet has an introduction tab with detailed guidance on how to use the spreadsheet.

• Arboviral Implementation Spreadsheet excel icon[691 KB, 3 Worksheets, 508]
• Babesiosis Implementation Spreadsheet and Instructions excel icon[717 KB, 4 Worksheets, 508]
• COVID-19 Implementation Spreadsheet and Instructions excel icon[717 KB, 4 Worksheets, 508]
• “COVID Lite” Implementation Spreadsheet and Instructions excel icon[720 KB, 4 Worksheets, 508] new
• Generic v2 Implementation Spreadsheet and Instructions excel icon[546 KB, 4 Worksheets, 508]
• Congenital Syphilis Implementation Spreadsheet and Instructions excel icon[634 KB, 4 Worksheets, 508] new
• FDD Implementation Spreadsheet and Instructions excel icon[641 KB, 4 Worksheets, 508]
• FDD EIP Implementation Spreadsheet and Instructions excel icon[666 KB, 4 Worksheets, 508]
• Healthcare-Associated Infections (HAI) Spreadsheet and Instructions excel icon[753 KB, 4 Worksheets, 508]
• Hepatitis Implementation Spreadsheet and Instructions excel icon[588 KB, 4 Worksheets, 508]
• Lab Template Implementation Spreadsheet and Instructions excel icon[517 KB, 4 Worksheets, 508]
• Lyme Implementation Spreadsheet and Instructions excel icon[621 KB, 4 Worksheets, 508]
• Malaria Implementation Spreadsheet and Instructions excel icon[721 KB, 4 Worksheets, 508]
• Mumps Implementation Spreadsheet and Instructions excel icon[565 KB, 4 Worksheets, 508]
• Pertussis Implementation Spreadsheet and Instructions excel icon[564 KB, 4 Worksheets, 508]
• RIBD Implementation Spreadsheet and Instructions excel icon[949 KB, 4 Worksheets, 508]
• STD Implementation Spreadsheet and Instructions excel icon[727 KB, 4 Worksheets, 508] new
• TB Implementation Spreadsheet and Instructions excel icon[734 KB, 4 Worksheets, 508]
• Trichinellosis Implementation Spreadsheet and Instructions excel icon[714 KB, 4 Worksheets, 508]
• Varicella Implementation Spreadsheet and Instructions excel icon[571 KB, 4 Worksheets, 508]

Test Case Scenario Worksheets

Create test messages associated with the below test case scenario worksheet for the chosen HL7 case notification message, indicating differences from the CDC example values in the worksheet.

• Arboviral Test Case Scenario Worksheet excel icon[63 KB, 3 Worksheets, 508]
• All Other Conditions Test Case Scenario Worksheet excel icon[1 MB, 16 Worksheets, 508]

Note: Newer message mapping guides (MMGs) will include the test scenario worksheet as part of the MMG workbook.