Modular Data Management

1
Modular Data Management

• Julio C. Silva, MD
• Research Director
• Department of Emergency Medicine
• Resurrection Medical Center

2
(No Transcript)
3
Existing Database

• Separate tables
• Not linked
• Previously formatted
• Different care locations

4
(No Transcript)
5
(No Transcript)
6
(No Transcript)
7
(No Transcript)
8
(No Transcript)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
Create New Unified Table

• Copy/pasted from old tables
• Linked
• Previously formatted
• Unified database

13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
(No Transcript)
32
(No Transcript)
33
(No Transcript)
34
Creating New Database

• Stand alone single table
• Different name
• Exportable

35
(No Transcript)
36
(No Transcript)
37
(No Transcript)
38
(No Transcript)
39
(No Transcript)
40
(No Transcript)
41
(No Transcript)
42
(No Transcript)
43
(No Transcript)
44
(No Transcript)
45
(No Transcript)
46
(No Transcript)
47
(No Transcript)
48
Creating A Data Entry Form

• Computer based
• Drop down selections
• Yes/No toggles
• Free form data entry

49
(No Transcript)
50
(No Transcript)
51
(No Transcript)
52
(No Transcript)
53
(No Transcript)
54
(No Transcript)
55
(No Transcript)
56
(No Transcript)
57
(No Transcript)
58
(No Transcript)
59
Reusable Modules

• Pre-hospital
• Demographics
• ED management
• Hospital course
• Outcome

60
Conclusions

• Field creation one time only
• Easy changes from master
• Easy data entry
• Easy import and export
• Formatted data analysis