New features of the query view reports system qvr l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 72

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


  • 333 Views
  • Uploaded on
  • Presentation posted in: General

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.

Download Presentation

New Features of the Query/View/Reports System (QVR)

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)


Query view reporting system qvr logon screen l.jpg

Query/View/Reporting System (QVR) Logon Screen


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 institution l.jpg

QVR Search Screen-PI/Institution

Select


Qvr search screen pi institution12 l.jpg

QVR Search Screen-PI/Institution

Note:

Selection options

allow for

partial names


Qvr search screen13 l.jpg

QVR Search Screen

Select


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 application id l.jpg

QVR Search Screen-Application ID

Select


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 budget l.jpg

QVR Search Screen-Budget

Select


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 search l.jpg

QVR Search Screen-Text Search

Select


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 selects l.jpg

QVR Search Screen-Special Selects

Select


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 qvr39 l.jpg

Example Search using the QVR

Select


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 basic output l.jpg

QVR--Basic Output

Select


Qvr snapshot l.jpg

QVR--Snapshot


Qvr basic output48 l.jpg

QVR--Basic Output

Select


Qvr summary statement l.jpg

QVR--Summary Statement


Qvr basic output50 l.jpg

QVR--Basic Output

Select


Qvr custom download l.jpg

QVR--Custom Download

Select


Qvr custom download52 l.jpg

QVR--Custom Download

Select items


Qvr custom download as html l.jpg

QVR--Custom Download as HTML

Select


Qvr custom download as html54 l.jpg

QVR--Custom Download as HTML


Qvr custom download into excel l.jpg

QVR--Custom Download into Excel

Select


Qvr custom download into excel56 l.jpg

QVR--Custom Download into Excel

Select


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


Building and saving a query63 l.jpg

Building and Saving a Query

Select


Building and saving a query64 l.jpg

Building and Saving a Query


Retrieving a saved query l.jpg

Retrieving a Saved Query

Select


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


Saving list of items for download l.jpg

Saving List of Items for Download

Enter Title

Select


Retrieving list of items for download l.jpg

Retrieving List of Items for Download

Select


Retrieving list of items for download69 l.jpg

Retrieving List of Items for Download

Select


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


  • Login