Transcript Retrieving and Analyzing Data Using the QVR System Scientific Program Staff

Retrieving and Analyzing
Data Using the QVR
System
Scientific Program Staff
2
QVR—Major Features
•
•
Extensive capabilities for searching and selecting
Grants and Grant applications
Extensive capabilities for generating standard reports
and downloading into Excel for custom reports
Added in the past year:
–
–
–
–
–
–
Person Search (NIH or Op/Div)
History Search (back to ~1970)
Link to PubMed (publications related to applicant or
grantee)
Budget Reports
Accommodations for NIH RoadMap
Extensive Training and online Tutorials
4
Usage of the QVR System
The number of Logons System to the QVR and the number
of searches has increased dramatically.
Currently 6,000–7,000 Queries/Drill-downs per workday!
Logons/Month (November)
Searches/Month
QVR LOGONS FOR NOVEMBER
QVR UTILIZATION--SEARCHES
60,000
25,000
60,000
50,000
20,000
15,000
Nov
10,000
10,000
SEARCHES PER MONTH (November)
Logons/Month
20,000
40,000
30,000
30,000
20,000
5,000
10,000
0
0
0
0
2001
2001
2002
2002
2003
YEARS
2003
2004
2004
2002
2002
2003
2003
YEAR
2004
2004
5
The QVR Principle:
The system must be
USER-FRIENDLY
and
USER-DEFINED
Search Capability of the QVR System
Logon QVR
(4)
QVR History
Search Screen
(5)
QVR Person
Search Screen
Allows for searches in
IMPAC data back to
1970
Standard Hitlist and
Record Count
Allows for searches
for all persons in the
in IMPAC database
(applicants/grantees/c
ommittees) for last 12
years.
(3)
QVR
(1)
(2)
(Original/New/Quick)
Search Screens
7
Program-Related Functions in
QVR
Search Capabilities
All Specific groups of projects can easily be identified via QVR .
•
Data is staged for QVR on a nightly basis from the IRDB, OLTP and
Central Accounting System (CAS). Users can search on a variety of
search criteria including: Centers, training, fellowships, RFAs/PAs,
council round, awarded status, Program Official name, etc.
Search Screen has specific
Program/Review Section
8
Program-Related Functions in
QVR
Select
9
Program-Related Functions in
QVR
10
Program-Related Functions in
QVR
Select
11
Program-Related Functions in
QVR
12
Program-Related Functions in
QVR
Search Capabilities
It has two “Public Queries" specifically designed to retrieve
projects relating to Scientific Programs.
eSNAP Available
Pending Review
Pending Council
Pending Award
A series of Population Tracking Reports
13
14
Search Capabilities
Select “Retrieve Query” then
“Public Query” to access
“Program” Public Queries
Functionality of the QVR System
Logon
QVR
Search
Screen
Enter
Search
Criteria
Enter
Output
Format
Basic Hit list Summary
Basic Hit list Hit list
(Detailed)
Print Central
PDF
Zip File
15
LINKS
Hit
List
Snapshot
PI/Grant History
Publication history
Abstract
Summary
NGA
Sub-Projects
Application image
Résumé Custom Standard
Hit list Download Reports
HTML
Excel®
Access®
Excel®
MS Word®
PivotTables®
“Program-Related” Functions in
QVR
Hitlist Features
The hitlist has a series of links:
•
Application snapshot, summary statement, abstract, NGA,
grant history, application image grant related publication and PI
publications.
Snapshot: The hitlists generated in QVR have a link to a Snapshot
of every record. For training grants the Snapshot has a section
that details the current appointees
(see next slides).
16
17
QVR Hitlist Features
Search Criteria
Select
Click to retrieve
application image
Click on envelope to
send email to PI.
Click on PI name to
retrieve PI
Information—
Committee
service
Publication history,
etc
Click on envelope to
send email to
Program Official
18
Snapshot Features
This is a
Grant Snapshot
of a T32.
This section lists
budget allocations
This section lists
all trainees on
the training grant
19
Program-Related Data Features
Custom Download Capabilities
The Custom Download allows the user to
download a variety of data items
Over 250 Downloadable Data Items
Abstract Text
Training/Fellowships—many data items.
NIH Staff Contacts
Application/Grant Data
20
Custom Download Capabilities
Select
Note:
Search
criteria
Custom Download Capabilities
User may download data
in HTML format,
to an Excel spreadsheet
or as a *.CSV file (Access)
Select
To view a full list
of the downloadable
data items click
on “Column Glossary”
These are a few of over
250
data items that may be
downloaded
21
22
Custom Download—HTML Format
Program-Related Standard Reports
QVR has 33 Standard Reports. Many of these specifically relate to
Scientific Programs.
The following slides illustrate how to access these Standard Reports
23
QVR Has 33 Standard Reports
The following slides
illustrate how to access
these Standard Reports
24
25
Standard Reports
Select
Standard Reports
26
Select
These are the
Standard Reports
that provide specific
Program-related
information
27
Standard Reports
Select
Note: Options to
customize
Standard Report
Review Meeting Information
Standard Reports—PivotTable
Note: PivotTable format
allows the user to easily
manipulate the data and
incorporate additional
data items
28
Review Meeting Information
Standard Reports—PivotTable
Note: PivotTable is
manipulated to provide
convenient summary table
29
Standard Reports
Grant Snapshot
Select
User may select any
combination of
snapshot sections
30
Standard Reports
Grant Snapshot
31
Standard Reports
Grant Snapshot
32
Note:
Training Information
33
Potential Areas where QVR
could be enhanced to meet the
needs of Scientific Programs
•
•
•
•
•
•
•
Additional Program-related items on search screen
Additional Public Queries useful to Program Officials
Additional Hitlist formats
Program-related items added to custom download
Creation of Public “Lists” of downloadable data items
Modification of existing Standard Reports
Additional Program-related Standard Reports
34
Development Process Used by
QVR Team
• QVR team will work with ePUG to develop concept for
additional information
• QVR team will develop prototype feature in close
collaboration with staff
• Prototype of feature will be quickly developed
• Prototype version of feature will be tested by
extramural staff
• Feature will be refined as needed in close collaboration
with staff
• New feature will be moved into production version of
QVR as soon as acceptable by staff
• Feature may be further refined even though it is in
production