130 likes | 318 Views
The Query/View/Reporting System (QVR) Overall Plan for Incorporating IC-Specific Data. IC-Specific Data Committee April 23, 2002. Outline of Presentation. ECB System Priorities QVR System Priorities Features of the QVR system Plans for incorporating IC-specific data.
E N D
The Query/View/Reporting System(QVR)Overall Plan for IncorporatingIC-Specific Data IC-Specific Data Committee April 23, 2002
Outline of Presentation ECB System Priorities QVR System Priorities Features of the QVR system Plans for incorporating IC-specific data
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
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
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 The QVR Priorities and Enhancement Plans Completed Completed
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)
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
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)
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.
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 Reports—Second Phase
QVR—General Query Search Strategy Search Screen Basic Hit List Snapshot PI History Grant History Abstract Summary NGASub-Project Selected Records Download HTML Excel Spreadsheet Standard Reports
QVR—IC-Specific Data Search Strategy QVR Search Screen IMPAC Data IC-Specific Data Scientific indexing Budget data Other items (foreign PI, etc.) Snapshot PI History Grant History Abstract Summary NGASub-Project Basic Hit List Selected Records Download IMPAC Data IC-Specific Data HTML Excel Spreadsheet Standard Reports