Transcript Slide 1

Welcome to
Alexandria
Buffet lunch is available
Please to serve yourself when you arrive
What we will cover
• Composition of the NEMSIS Database
– Status of states
• Recommended State Dataset
• Data Submission Schedule
• NDX (National Data Exchange)
– Data profile report
• vendor and agency stratification
• New Frequency Reports
– Pediatric report
– Urbanicity report
What we will cover (con’t)
• OLAP Cubes
– National cube
– State cube
– Movie and paper tutorials
• Research Dataset
– Form and process for data release
– Release format
– Data users manual
• Discussion Items
– Many to many datasets
– Classification of medications
What we will cover (con’t)
• HL7 Update
– EMS Domain Analysis Model
– NEMSIS HL7 Charter
• Revision Process Update
– Closure of the compliance process
Current Composition
of the National EMS
Database
Current Composition (2007-2009)
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
Alabama
Florida
Hawaii
Iowa
Idaho
Maine
Minnesota
Missouri
North Carolina
North Dakota
635,409
563,655
23,912
200,145
6,991
139,194
476,400
133,217
2,094,004
67,346
Current Composition 2007-2009(con’t)
11.
12.
13.
14.
15.
16.
17.
Nebraska
New Hampshire
New Jersey
New Mexico
Nevada
Oklahoma
Utah
Total
86,329
113,807
86,199
17,454
38,139
1,922
110,560
4,794,684
The next Quarter
(23 Total)
•
•
•
•
•
•
South Carolina*
West Virginia*
Colorado*
Washington
Illinois
Alaska
(* have submitted data that has not yet been processed)
States Potentially Submitting in
2009 (36 Total)
•
•
•
•
•
•
Pennsylvania
California
Massachusetts
South Dakota
Wisconsin
Guam
•
•
•
•
•
•
•
Arkansas
Connecticut
Indiana
Virginia
Vermont
Oregon
Georgia
State Recommended Dataset
• Data Managers Council (DMC) deliverable
to NTHSA
• Purpose –
– Develop a suggested dataset for states who have
not yet identified what variables will be
included.
• Includes all the National Elements
• Other elements selected by consensus
State Dataset
Data Submission Schedule
• Processes to improve compliance
– Reminder e-mails from the message board
• 1 month, 2 weeks, due now, late notice
• Sent to state vendor and state data manager
– Hard date for “end of year” data
Data Submission Schedule
As of June 5, 2009
Enhancement to Data Profile
Report
• Current report
–
–
–
–
Submission Summary
Date range for submissions
Frequency tables
Violations of business logic
Enhancement to Data Profile
Report
• Available profile stratification by:
– Vendor
– Agency
Data Profile Report
New Frequency Reports
• Focus Groups with EMSC Representatives
– Quickly answer simple questions
– Tabular data
– Access to more complex tabular data
Frequency Reports
Use of OLAP Cubes
"Dimensional modeling gives us the ability to
visualize data. The ability to visualize
something as abstract as a set of data in a
concrete and tangible way is the secret of
understandability." Ralph Kimball, The
Data Warehouse Toolkit (1996, John
Wiley & Sons, Inc.)
National Data Cube
•
•
•
•
•
Public dataset
Generate and save tables
Build charts
Manipulate the format
Export Reports
National Data Cube
State Data Cube
• Only see your state’s data
• Limit of three passwords per state
– State EMS Official
– State EMS Data Manager
– State EMS Physician
• State’s responsibility to keep us
informed of staff changes
• After login….same as the National
Data Cube, except….
State Data Cube
Tutorials for Cube Services
• Tutorials are available as:
– Written pdf documents
– Adobe Flash presentations
Cube Tutorials
Break
Research Dataset
• Set for release July, 2009
– Release on a single DVD
• Includes 2008 data
–
–
–
–
–
Dynamic tables
Flat files
SAS files
SAS programming
DVD encryption at the data level
Research Dataset
NEMSIS Data Use Manual
• Set for release July, 2009
– Includes
• Terms of use policy
• Description of 3 datasets
• Computed and ancillary variables
• Edit flags
• Extended definition document
Data Users Manual
NEMSIS Terms of Use Policy
HL7 Update
• HL7 Project Acceptance
– Clinical Interoperability Council
• Emergency Care, Patient Care
– First phase complete
– Second phase complete August, 2009
NEMSIS HL7 Charter
6.
5.
4.
Formal SDO Submission
EMS Domain Analysis
Model
Synthesis
Project Specifications
3.
Identify
Project Specification/Standards
2.
Project Analysis Model (PAM)
1.
Scope
Initiate and Frame
•Messages
•Documents
•Templates
•Services
Complete EMAR Specific -PAM
All Classes, Attributes, Code and
Value Sets. Actors, Activity and
Work Flows
Narrative and UML for Each
Specification. Inventory of Value and
Code Sets
Identification of Known
Specifications and SMEs
Workgroup. SDO Pre-coordination
Initial UML Model
(Based on ER-EHR UML)
Static and Dynamic Components
Project Scope and Initiation Document
HL7 Update (cont.)
EMS Domain Analysis Model
A Sundry Discussion Items
• Many-to-many datasets
• Classification of medications
Revision Process Update
Draft NEMSIS Version 3