New features of the query view reports system qvr
Download
1 / 72

New Features of the Query/View/Reports System (QVR) - PowerPoint PPT Presentation


  • 421 Views
  • Uploaded on

New Features of the Query/View/Reports System (QVR) . Presentation to eRA Project Team Meeting March 27, 2001. The Query/View/Reports System What is it?. The QVR is a web-based system for conveniently access information on NIH projects. Extramural Staff Resource.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'New Features of the Query/View/Reports System (QVR)' - emily


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
New features of the query view reports system qvr l.jpg

New Featuresof theQuery/View/Reports System(QVR)

Presentation to eRA Project Team Meeting

March 27, 2001


The query view reports system what is it l.jpg

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.


The electronic council book query view report partnership l.jpg

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


Ecb qvr steering committee representatives from all ics are welcome l.jpg

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


Slide5 l.jpg

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)



Qvr search screen l.jpg
QVR Search Screen

Screen

navigation

items


Qvr search screen8 l.jpg
QVR Search Screen

Select IC

=========

One or many


Qvr search screen9 l.jpg
QVR Search Screen

Select

Project Status

Awarded

Cancelled

NRFC

Pending

Pending Award

Pending Council

Pending IRG

Terminated

To be Paid

Unknown

Withdrawn


Qvr search screen10 l.jpg
QVR Search Screen

Selection options:

Fiscal Year

Council Round

or

Budget Period



Qvr search screen pi institution12 l.jpg
QVR Search Screen-PI/Institution

Note:

Selection options

allow for

partial names



Qvr search screen review program l.jpg
QVR Search Screen-Review/Program

Review group

and

Special Emphasis Panel

information


Qvr search screen review program15 l.jpg
QVR Search Screen-Review/Program

Score Range

Clears default

percentiles

and

priority scores


Qvr search screen review program16 l.jpg
QVR Search Screen-Review/Program

Summary Statement

Release Since

Select for report

of all applications

without

summary statements


Qvr search screen review program17 l.jpg
QVR Search Screen-Review/Program

Program Class Codes

Individual data elements

Allows for search

on multiple

Program Class Codes


Qvr search screen review program18 l.jpg
QVR Search Screen-Review/Program

Name of

Project Officer

or

Program Official

Requires only

“partial” name


Qvr search screen review program19 l.jpg
QVR Search Screen-Review/Program

Enter funds

without

punctuation

Search on direct

costs in ANY year

that meet the

criterion selected



Qvr search screen activity codes l.jpg
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


Qvr search screen primary dual l.jpg
QVR Search Screen-Primary/Dual

Note:

Selection options


Qvr search screen grant number l.jpg
QVR Search Screen-Grant Number

Note:

User ONLY needs to

fill in the boxes

necessary to find

the application

or grant


Qvr search screen rfa number l.jpg
QVR Search Screen-RFA Number

Enter

RFA/PA number

as

DK00-003



Qvr search screen budget26 l.jpg
QVR Search Screen-Budget

Enter range

of funds

Note:

Options


Qvr search screen budget27 l.jpg
QVR Search Screen-Budget

Search on

single or

multiple CANs



Qvr search screen text search29 l.jpg
QVR Search Screen-Text Search

Enter text string such as

“endocrine disruptors”


Qvr search screen text search30 l.jpg
QVR Search Screen-Text Search

Boolean logic operators


Qvr search screen text search31 l.jpg
QVR Search Screen-Text Search

Options to search in

summary statement,

project title or both



Qvr search screen special selects33 l.jpg
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.


Qvr search screen sort options l.jpg
QVR Search Screen-Sort Options

Sort option

is an

“ordered Pick List.”

The order of

the items picked

will dictate

the sort order.


Qvr search screen output options l.jpg
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


Downloadable data elements in qvr system march 7 2001 l.jpg
Downloadable Data Elements in QVR SystemMarch 7, 2001


Example search using the qvr l.jpg
Example Search using the QVR

  • All SBIR/STTR grants awarded in Fiscal Year 2000

  • Sort by mechanism

  • Within mechanism sort by PI name


Example search using the qvr38 l.jpg
Example Search using the QVR

Select IC

Select “Awarded”

Select “Fiscal Year”



Example search using the qvr40 l.jpg
Example Search using the QVR

Select “Clear Scores”


Example search using the qvr41 l.jpg
Example Search using the QVR

Select “Activity Codes”


Example search using the qvr42 l.jpg
Example Search using the QVR

SBIR/STTR

“Activity Codes”


Example search using the qvr43 l.jpg
Example Search using the QVR

Select to

eliminate item


Example search using the qvr44 l.jpg
Example Search using the QVR

Select to

add items


Example search using the qvr45 l.jpg
Example Search using the QVR

Select

Select

“Output” format








Qvr custom download52 l.jpg
QVR--Custom Download

Select items






Qvr custom download into excel57 l.jpg
QVR--Custom Download into Excel

Select

Enter File Name


Qvr custom download into excel open excel and open file l.jpg
QVR--Custom Download into ExcelOpen Excel and Open file


Building and saving a query l.jpg
Building and Saving a Query

Select Council rounds


Building and saving a query60 l.jpg
Building and Saving a Query

Select mechanisms

Select

“Primary Projects Only”

Select sort order


Building and saving a query61 l.jpg
Building and Saving a Query

Select

Note: If no summary statement

exists there will not be a check box.


Building and saving a query62 l.jpg
Building and Saving a Query

Fill in Query Name

and

Query Description





Retrieving a saved query66 l.jpg
Retrieving a Saved Query

Note: Query Description

Click here

to

select query

This deletes

the query

from your list





The ecb qvr and cam priorities and enhancement plans l.jpg

The ECB, QVR and CAM Priorities and Enhancement Plans

Update Council Version of ECB (FY 2001)

Save queries

New version of hit lists

Summary statement download as PDF and Zip file

Launch Basic QVR System (FY 2001)

Access funded projects

Grant snapshot

Save queries

New version of hit lists

Summary statement download as PDF and Zip file


The ecb qvr and cam priorities and enhancement plans continued 1 l.jpg

The ECB, QVR and CAM Priorities and Enhancement Plans(Continued - 1)

Add Enhancement to Staff ECB and QVR systems (FY 2001, 2002, 2003)

Pre-formatted reports

Shared queries

Ad-hoc queries

Access application image

Access publication data

Access joint funding data

Add-on systems to include IC specific requirements

Access IC specific data

Convenience enhancements


The ecb qvr and cam priorities and enhancement plans continued 2 l.jpg

The ECB, QVR and CAM Priorities and Enhancement Plans(Continued - 2)

Redesign Council Administration Module

(FY 2001, 2002)

Early council concurrence

Enhancements to assignment nodule

Redesign approval module

Performance improvements

Expand reporting options

Import council member data from IMPAC system

Integrate functionality of council sweep into CAM