The Query/View/Reporting System (QVR) Overall Plan for Incorporating IC-Specific Data

1
The Query/View/Reporting System(QVR)Overall
Plan for IncorporatingIC-Specific Data

• IC-Specific Data Committee
• April 23, 2002

2
Outline of Presentation

• ECB System Priorities
• QVR System Priorities
• Features of the QVR system
• Plans for incorporating IC-specific data

3
The ECB Priorities and Enhancement Plans
Update Council Version of ECB (FY 2001) Save
queries/Save hit list New version of hit
lists Summary statement download as PDF and Zip
file
Redesign Council Administration Module (FY 2001,
2002) Early council concurrence Enhancements to
assignment module Redesign approval
module Performance improvements Expand reporting
options Import council member data from IMPAC
system Integrate functionality of council sweep
into CAM
4
The QVR Priorities and Enhancement Plans
Launch Basic QVR System (FY 2001) Access funded
projects Grant snapshot Notice of Grant
Award Save queries/Save hit list New version of
hit lists Summary statement download as PDF and
Zip file Download IMPAC II data to spread sheet
5
The QVR Priorities and Enhancement Plans
Enhancement to QVR systems (FY 2002 and 2003) PI
history Application history Shared
queries Pre-formatted reports (first
five) Pre-formatted reports (second
five) Sub-projects and Sub-project
abstracts Abstract and Summary Statement
first page Standard Report Additional search
features (Stem Cells, GM Specialist, etc.) Access
IC specific data On-line training tools Access
application image Access publication data Access
joint funding data
Completed
Completed
6
Relationship of NIH ECB, QVR, CAM and IRDB
NIH Staff
Grant Info
ECB/QVR Staff Version
IMPAC II IRDB (ECB Tables)
AXD Data
ECB Administrator Module (CAM)
Grant Info
Council AXD Data
ECB Council Version
AXD Data
ECB/QVR Web Servers
Data in (write)
Council Members
Data out (read only)
7
QVR Search Screen Output and Sort Options
Standard Hit List (Basic) One-line hit list
containing the application number, Links, PI
name and title Standard Hit List
(Detailed) Two-line hit list containing the items
above and RFA/PA, Council round, Priority
score/percentile score, IRG, IC-PCC and
institution Summary Hit List Same as above but
provides the Print Central, PDF download and ZIP
file download of groups of summary statement (See
next slide) Résumé Hit List Same as Standard
Hit List (Detailed) PLUS the Résumé and Summary
of Discussion (from the Summary
Statement) Reports Option A series of
pre-formatted reports in either Excel or MS
Word Custom Download Allows the user to search
the IMPAC II database and select data elements
for download into an Excel spreadsheet
8
Summary Statement Search Strategy
Search Screen
Summary Statement Hit List
Selected Summary Statements
Print Central
ZIP File
PDF
9
QVR Search ScreenOutput and Sort Options Links
Both the Standard Hit List (Basic) and the
Standard Hit List (Detailed) provide links
to Summary statement Snapshot PI
history Application history Notice of Grant Award
(NGA) Abstract (funded projects) Sub-project
abstract (funded projects) _______________________
_________________________________ To be added to
the QVR system soon Application image (PDF format
with bookmarks)
10
IC-Specific Data Query Logic
There will be more than one type of data that ICs
will want to capture. SCIENTIFIC INDEXING
DATA This is the primary group (including the
weighting factor) Boolean logic operators may be
utilized with scientific terms BUDGET DATA
Interim budget reductions/adjustments before
making an award A good model for the NIDA
system. OTHER DATA Data types such as what FIC
captures in their local database. This includes
the foreign PI on projects. 
11
IC-Specific Data Query Logic
The search strategy can be based on a combination
of IMPAC data and IC-specific data. Initiating a
search will result in a hit list similar to the
QVR Basic Hit List (Detailed) The user may
select particular records using the check
boxes. User may download IMPAC data and
IC-specific data in HTML or to a
spreadsheet User may select frozen data or
dynamic data where appropriate Standard
ReportsSecond Phase
12
QVRGeneral Query Search Strategy
Search Screen
Basic Hit List
Snapshot PI History Grant History Abstract Summar
y NGASub-Project
Selected Records
Download
HTML
Excel Spreadsheet
Standard Reports
13
QVRIC-Specific Data Search Strategy
Snapshot PI History Grant History Abstract Summar
y NGASub-Project
QVR Search Screen IMPAC Data IC-Specific
Data Scientific indexing Budget data Other items
(foreign PI, etc.)
Basic Hit List
Selected Records
Download IMPAC Data IC-Specific Data
HTML
Excel Spreadsheet
Standard Reports
14
THANK YOU