V2 Dataset Dictionaries

NEMSIS Version 2.2.1 Data Dictionary

The NEMSIS NHTSA Version 2.2.1 DataDictionary provides over 400 definitions that can be implemented by an EMS system. National data elements are defined that should be collected for the National EMS Database, but additional data elements should be considered for use at the state and local levels depending on each state or local EMS system's need.

NEMSIS Version 2.2.1 Data Dictionary

Version 2.2.1 Data Entry Navigation Logic Document
A copy of a guide for using the NHTSA NEMSIS Version 2.2.1 dataset entitled “Data Entry Navigation Logic Document” as recommended by the EMS Performance Improvement Center (EMSPIC) is available for public use. The EMSPIC was an essential partner with the NEMSIS TAC for the development of the NEMSIS NHTSA Version 2.1.1 dataset, offering experience and best practice recommendations on the use and documentation of the dataset by EMS professionals. The EMSPIC provided this document as an example for software developers.
The navigation logic document describes how each of the NHTSA NEMSIS Version 2.2.1 data elements can be presented to an EMS software user in the most efficient way while improving data quality and validity.

The EMSPIC developed this document based on years of experience in developing EMS data entry tools and data analysis systems.

If you have any suggestions on how to make this document better, please forward them to Karen Jacobson at the NEMSIS TAC or Jeff Robertson at the EMSPIC for consideration. The EMSPIC maintains this document on the EMSPIC website (www.EMSPIC.org) for everyone’s use.

Version 2 – Demographic & EMS Dataset Schema
An EMS Dataset is a subset of information describing a complete EMS event. It includes information that is considered important from an EMS system, EMS personnel, and an EMS patient’s perspective. The data elements within the EMS dataset provide documentation of the system performance and clinical care.

EMS Database Script Files
The EMS Database scripts are designed to be executed from within a database management tool such as MS Query Analyzer or TOAD. The script will first create a database called “NEMSIS,” and then it will add the tables required to support the EMS XSD.

Once all of the tables have been added, the script adds in the Primary keys for each table and then establishes the foreign key relationships between the different tables. The database structure has been tested against the XSD’s and was used to import sample data.

Demographic Database Scripts
The DEMOGRAPHIC Database scripts are designed to be executed from within a database management tool, such as MS Query Analyzer or TOAD. The script will first create a database called “DEMOGRAPHIC,” and then it will add the tables required to support the DEMOGRAPHIC XSD.

Once all of the tables have been added, the script adds in the Primary keys for each table and then establishes the foreign key relationships between the different tables. To maintain the validity of data, the “DEMOGRAPHIC” database is more stringent than its corresponding XSD’s. Users of the “DEMOGRAPHIC” scripts should keep this in mind while using the database structure created by the scripts.

NEMSIS Lookup Table Script
The NEMSIS LOOKUP TABLE script is only designed for MS SQL SERVER. The script is in standard ANSI SQL and should run on the other platforms with minor modifications. This script will create a table under the “NEMSIS” database for the Look-up values and then insert all of the values contained in the data dictionary