new features of the query view reports system qvr
Download
Skip this Video
Download Presentation
New Features of the Query/View/Reports System (QVR)

Loading in 2 Seconds...

play fullscreen
1 / 72

New Features of the Query - PowerPoint PPT Presentation


  • 420 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' - 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

New Featuresof theQuery/View/Reports System(QVR)

Presentation to eRA Project Team Meeting

March 27, 2001

the query view reports system what is it

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

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

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

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
QVR Search Screen

Screen

navigation

items

qvr search screen8
QVR Search Screen

Select IC

=========

One or many

qvr search screen9
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
QVR Search Screen

Selection options:

Fiscal Year

Council Round

or

Budget Period

qvr search screen pi institution12
QVR Search Screen-PI/Institution

Note:

Selection options

allow for

partial names

qvr search screen review program
QVR Search Screen-Review/Program

Review group

and

Special Emphasis Panel

information

qvr search screen review program15
QVR Search Screen-Review/Program

Score Range

Clears default

percentiles

and

priority scores

qvr search screen review program16
QVR Search Screen-Review/Program

Summary Statement

Release Since

Select for report

of all applications

without

summary statements

qvr search screen review program17
QVR Search Screen-Review/Program

Program Class Codes

Individual data elements

Allows for search

on multiple

Program Class Codes

qvr search screen review program18
QVR Search Screen-Review/Program

Name of

Project Officer

or

Program Official

Requires only

“partial” name

qvr search screen review program19
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
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
QVR Search Screen-Primary/Dual

Note:

Selection options

qvr search screen grant number
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
QVR Search Screen-RFA Number

Enter

RFA/PA number

as

DK00-003

qvr search screen budget26
QVR Search Screen-Budget

Enter range

of funds

Note:

Options

qvr search screen budget27
QVR Search Screen-Budget

Search on

single or

multiple CANs

qvr search screen text search29
QVR Search Screen-Text Search

Enter text string such as

“endocrine disruptors”

qvr search screen text search30
QVR Search Screen-Text Search

Boolean logic operators

qvr search screen text search31
QVR Search Screen-Text Search

Options to search in

summary statement,

project title or both

qvr search screen special selects33
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
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
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

example search using the qvr
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
Example Search using the QVR

Select IC

Select “Awarded”

Select “Fiscal Year”

example search using the qvr40
Example Search using the QVR

Select “Clear Scores”

example search using the qvr41
Example Search using the QVR

Select “Activity Codes”

example search using the qvr42
Example Search using the QVR

SBIR/STTR

“Activity Codes”

example search using the qvr43
Example Search using the QVR

Select to

eliminate item

example search using the qvr45
Example Search using the QVR

Select

Select

“Output” format

qvr custom download into excel57
QVR--Custom Download into Excel

Select

Enter File Name

building and saving a query
Building and Saving a Query

Select Council rounds

building and saving a query60
Building and Saving a Query

Select mechanisms

Select

“Primary Projects Only”

Select sort order

building and saving a query61
Building and Saving a Query

Select

Note: If no summary statement

exists there will not be a check box.

building and saving a query62
Building and Saving a Query

Fill in Query Name

and

Query Description

retrieving a saved query66
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

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

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

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

ad