1 / 72

Enhancing QVR: Advanced Query, View, and Reporting Features

Explore the new features of the Query/View/Reports System (QVR) presentation to the eRA Project Team meeting on March 27, 2001. Learn how to access, query, view, and report data conveniently on NIH projects using the web-based QVR system.

rpatrick
Download Presentation

Enhancing QVR: Advanced Query, View, and Reporting Features

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. New Featuresof theQuery/View/Reports System(QVR) Presentation to eRA Project Team Meeting March 27, 2001

  2. The Query/View/Reports SystemWhat is it? The QVR is a web-based system for conveniently access information on NIH projects. Extramural Staff Resource It provides a utility for extramural staff to QUERY the IMPAC II database, VIEW data from the database and produce REPORTS.

  3. The Electronic Council Book-Query/View/Report Partnership ECB-QVR Steering Committee Thorsten Fjellstedt, Chairperson Representatives from most ICs Center for Information Technology Pete Morton Tom Mason Don Tiedemann Office of Extramural Research Jim Cain Tim Twomey

  4. ECB-QVR Steering CommitteeRepresentatives from all ICs are welcome Thorsten Fjellstedt, NIEHS, Chairperson Carol Martin, NHGRI Jackie Sanders, NIMH Linda Robbins, NIMH Ruth Choi, NIMH Steve Hausman, NIAMS Penny Colbert, NICHD Beth Paterson, NIDDK Delores Lee, NCRR Jim Seach, NCI Greg Fischetti, NCI Terry Jones, NIAID Richard Fisher, NEI Paul Jordan, NIEHS Robbin Barr, NIA Karin Bashir, NIA Anne Conners, NIAMS Peter Soltys, NINDS Gahan Breithaupt, NINDS Anthony Coelho, OD/OER Jim Tucker, OD/OER Carlos Caban, OER Carla Flora, OD/OER Tim Twomey, OD/OER Pete Morton, CIT Tom Mason, CIT Don Tiedemann, CIT

  5. Relationship of NIH ECB, QVR, ECB CAM and IRDB NIH Staff Grant Info QVR and ECB Staff Version AXD Data IMPAC II IRDB (QVR/ECB Tables) ECB Administrator Module (CAM) Grant Info Council AXD Data ECB Council Version AXD Data ECB Web Servers Data in (write) Council Members Data out (read only)

  6. Query/View/Reporting System (QVR) Logon Screen

  7. QVR Search Screen Screen navigation items

  8. QVR Search Screen Select IC ========= One or many

  9. QVR Search Screen Select Project Status Awarded Cancelled NRFC Pending Pending Award Pending Council Pending IRG Terminated To be Paid Unknown Withdrawn

  10. QVR Search Screen Selection options: Fiscal Year Council Round or Budget Period

  11. QVR Search Screen-PI/Institution Select

  12. QVR Search Screen-PI/Institution Note: Selection options allow for partial names

  13. QVR Search Screen Select

  14. QVR Search Screen-Review/Program Review group and Special Emphasis Panel information

  15. QVR Search Screen-Review/Program Score Range Clears default percentiles and priority scores

  16. QVR Search Screen-Review/Program Summary Statement Release Since Select for report of all applications without summary statements

  17. QVR Search Screen-Review/Program Program Class Codes Individual data elements Allows for search on multiple Program Class Codes

  18. QVR Search Screen-Review/Program Name of Project Officer or Program Official Requires only “partial” name

  19. QVR Search Screen-Review/Program Enter funds without punctuation Search on direct costs in ANY year that meet the criterion selected

  20. QVR Search Screen-Application ID Select

  21. QVR Search Screen-Activity Codes Select any activity code or group of activity codes Activity codes may be INCLUDED in or EXCLUDED from a search

  22. QVR Search Screen-Primary/Dual Note: Selection options

  23. QVR Search Screen-Grant Number Note: User ONLY needs to fill in the boxes necessary to find the application or grant

  24. QVR Search Screen-RFA Number Enter RFA/PA number as DK00-003

  25. QVR Search Screen-Budget Select

  26. QVR Search Screen-Budget Enter range of funds Note: Options

  27. QVR Search Screen-Budget Search on single or multiple CANs

  28. QVR Search Screen-Text Search Select

  29. QVR Search Screen-Text Search Enter text string such as “endocrine disruptors”

  30. QVR Search Screen-Text Search Boolean logic operators

  31. QVR Search Screen-Text Search Options to search in summary statement, project title or both

  32. QVR Search Screen-Special Selects Select

  33. QVR Search Screen-Special Selects You may either include or exclude the “special select” parameters. This feature allows the user to combine searches on the “special select” parameters.

  34. QVR Search Screen-Sort Options Sort option is an “ordered Pick List.” The order of the items picked will dictate the sort order.

  35. QVR Search Screen-Output Options Several output options are available to meet the users needs. The number of pages in a report can be set. 50 pages is the default

  36. Downloadable Data Elements in QVR SystemMarch 7, 2001

  37. Example Search using the QVR • All SBIR/STTR grants awarded in Fiscal Year 2000 • Sort by mechanism • Within mechanism sort by PI name

  38. Example Search using the QVR Select IC Select “Awarded” Select “Fiscal Year”

  39. Example Search using the QVR Select

  40. Example Search using the QVR Select “Clear Scores”

  41. Example Search using the QVR Select “Activity Codes”

  42. Example Search using the QVR SBIR/STTR “Activity Codes”

  43. Example Search using the QVR Select to eliminate item

  44. Example Search using the QVR Select to add items

  45. Example Search using the QVR Select Select “Output” format

  46. QVR--Basic Output Select

  47. QVR--Snapshot

  48. QVR--Basic Output Select

  49. QVR--Summary Statement

  50. QVR--Basic Output Select

More Related