eRA Web Query Tool eRA Symposium April 30, 2003

1
eRA Web Query TooleRA Symposium April 30, 2003
Electronic Research Administration National
Institutes of Health
2
Plethora of eRA Query Toolsand Access Methods

• ICSTORe
• QuickView
• CRISP Plus
• IQR
• CRISP on the Web
• ICO

• QVR/ECB
• Ad Hoc Query
• IRDB Power Views
• BA-specific Query Screens

3
Plethora of eRA Query Tools

• Confusing for users too many choices!
• Users want features provided in newer tools to be
  reproduced in older tools
• Duplicative functionality inefficient use of
  resources
• Project decision to migrate from Client/Server to
  J2EE Architecture Migration Plan recommendation
• Desire to update improve appearance to a real
  Web UI
• Desire to provide same interface for some
  reporting functions to internal and external
  users

4
To retain the unique requirements of each
interface/access method while eliminating
unnecessary duplication
The Challenge
Electronic Research Administration National
Institutes of Health
5
The Solution eRA Reporting Tool
ConsolidationEliminating Redundancy and
Improving Usability

• IRDB
• Power Views
• QuickView
• Pre-Programmed Reports
• Materialized Views
• Ad Hoc Query
• CRISP Plus

Reporting tools access previous days data
real-time reporting available via IMPAC II
modules.
6
Web Query Tool

• Overview of Screens and Capabilities

7
Most frequently used query parameters For
category appear. To see more Query parameters for
same category, Click .
8
User can select individual Screens with different
categories Of query parameters, or Show All
Basic or Show All Expanded
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
Basic hit list
21
Each data element Will appear in Excel In
separate column
Expanded hit list w/links
22
Web Query Tool

• User Interface Details

23
(No Transcript)
24
Other person related demographic parameters to be
determined.
25
(No Transcript)
26

27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
(No Transcript)
32
(No Transcript)
33
Quick sort by column hdrs
34
Three level nested sort
35
Expanded hit list w/links
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)