new features of the query/view/reports system (qvr) presentation to era project team meeting march...

New Featuresof the

Query/View/Reports System(QVR)

Presentation to eRA Project Team Meeting

March 27, 2001

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

Office of Extramural ResearchOffice of Extramural ResearchJim CainJim Cain

Tim TwomeyTim Twomey

Center for Information TechnologyCenter for Information TechnologyPete MortonPete MortonTom MasonTom Mason

Don Tiedemann

ECB-QVR Steering CommitteeECB-QVR Steering CommitteeThorsten Fjellstedt, ChairpersonThorsten Fjellstedt, ChairpersonRepresentatives from most ICsRepresentatives from most ICs

Carol Martin, NHGRICarol Martin, NHGRIJackie Sanders, NIMHJackie Sanders, NIMHLinda Robbins, NIMHLinda Robbins, NIMH

Ruth Choi, NIMHRuth Choi, NIMHSteve Hausman, NIAMSSteve Hausman, NIAMSPenny Colbert, NICHDPenny Colbert, NICHDBeth Paterson, NIDDKBeth Paterson, NIDDK

Delores Lee, NCRRDelores Lee, NCRRJim Seach, NCIJim Seach, NCI

Greg Fischetti, NCIGreg Fischetti, NCITerry Jones, NIAIDTerry Jones, NIAIDRichard Fisher, NEIRichard Fisher, NEIPaul Jordan, NIEHSPaul Jordan, NIEHS

ECB-QVR Steering CommitteeECB-QVR Steering Committee Representatives from all ICs are welcomeRepresentatives from all ICs are welcome

Robbin Barr, NIARobbin Barr, NIAKarin Bashir, NIAKarin Bashir, NIA

Anne Conners, NIAMSAnne Conners, NIAMSPeter Soltys, NINDSPeter Soltys, NINDS

Gahan Breithaupt, NINDSGahan Breithaupt, NINDSAnthony Coelho, OD/OERAnthony Coelho, OD/OER

Jim Tucker, OD/OERJim Tucker, OD/OERCarlos Caban, OERCarlos Caban, OER

Carla Flora, OD/OERCarla Flora, OD/OERTim Twomey, OD/OERTim Twomey, OD/OER

Pete Morton, CITPete Morton, CITTom Mason, CITTom Mason, CIT

Don Tiedemann, CITDon Tiedemann, CIT

Thorsten Fjellstedt, NIEHS,Thorsten Fjellstedt, NIEHS, ChairpersonChairperson

IMPAC II

IRDB

(QVR/ECB

Tables)

QVR and ECB

Staff Version

ECB

Council Version

ECB Administrator

Module (CAM)

Council Members

NIH Staff

AX

D D

ata

AX

D D

ata

Grant Info

Council AXD Data

Grant Info

Relationship of NIH ECB, QVR, ECB CAM and IRDB

ECB Web Servers

Data in (write)

Data out (read only)

Query/View/Reporting System (QVR) Logon Screen

QVR Search Screen

Screennavigation

items

QVR Search Screen

Select IC=========One or many

QVR Search Screen

SelectProject Status

AwardedCancelled

NRFCPending

Pending AwardPending Council

Pending IRGTerminatedTo be PaidUnknown

Withdrawn

QVR Search Screen

Selection options:Fiscal Year

Council Roundor

Budget Period

QVR Search Screen-PI/Institution

Select

QVR Search Screen-PI/Institution

Note:Selection options

allow for partial names

QVR Search Screen

Select

QVR Search Screen-Review/Program

Review groupand

Special Emphasis Panelinformation

QVR Search Screen-Review/Program

Clears defaultpercentiles

andpriority scores

Score Range

QVR Search Screen-Review/Program

Select for reportof all applications

withoutsummary statements

Summary Statement Release Since

QVR Search Screen-Review/Program

Allows for searchon multiple

Program Class Codes

Program Class CodesIndividual data elements

QVR Search Screen-Review/Program

Requires only “partial” name

Name of Project Officer

orProgram Official

QVR Search Screen-Review/Program

Enter fundswithout

punctuation

Search on directcosts in ANY year

that meet the criterion selected

QVR Search Screen-Application ID

Select

QVR Search Screen-Activity Codes

Select anyactivity codeor group of

activity codes

Activity codesmay be

INCLUDED inor

EXCLUDED from a search

QVR Search Screen-Primary/Dual

Note:Selection options

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

EnterRFA/PA number

asDK00-003

QVR Search Screen-Budget

Select

QVR Search Screen-Budget

Enter rangeof funds

Note:Options

QVR Search Screen-Budget

Search on single or

multiple CANs

QVR Search Screen-Text Search

Select

QVR Search Screen-Text Search

Enter text string such as “endocrine disruptors”

QVR Search Screen-Text Search

Boolean logic operators

QVR Search Screen-Text Search

Options to search in summary statement, project title or both

QVR Search Screen-Special Selects

Select

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

Sort optionis an

“ordered Pick List.”The order of

the items picked will dictate

the sort order.

QVR Search Screen-Output Options

Several output options are available to meet

the users needs.

The number ofpages in a report

can be set.50 pages is the default

Downloadable Data Elements in QVR System

March 7, 2001AIDs RelatedActivityAlterations CostAnimal Subject ConcernsAppl Status CodeAppl Status DescripAppl Status Group CodeAppl Status Group DescripBudget End DateBudget Start DateCanChildren ConcernsCommitted Dollars AllYearsCommitted Dollars Yr 1Consulting CostCouncilCouncil RecDirect CostEquipment CostFYFellow Stip Yr 1Fellow Stipends All YearsForeign GrantFull Study SectionGender ConcernsHuman Subject Concerns

ICIRGIRG Dollars All YearsIRG Dollars Yr 1IRG RecommIndirect CostInst CityInst CountryInst StateInst Zip CodeInstitutionIntent To PayMajor Component CodeMajor Component NameMinority ConcernsOrganization TypePCCPI AddressPI EmailPI FaxPI NamePI PhonePercentilePhase 3 TrialsPostdocs All YearsPostdocs FTTPPostdocs Yr 1

Predocs All YearsPredocs FTTPPredocs Yr 1Prev Direct CostPrev PercentilePrev Priority ScorePriorityProject End DateProject NumberProject Start DateProject TitleRFA/PA NumberRequested Dollars All YearsRequested Dollars Yr 1Serial NumStateStatusSupport Years AwdSupport Years RecSupport Years ReqTotal CostTrainees All YearsTrainees Yr 1TypeUnobligated Bal

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 QVR

Select IC

Select “Awarded”

Select “Fiscal Year”

Example Search using the QVR

Select

Example Search using the QVR

Select “Clear Scores”

Example Search using the QVR

Select “Activity Codes”

Example Search using the QVR

SBIR/STTR“Activity Codes”

Example Search using the QVR

Select toeliminate item

Example Search using the QVR

Select toadd items

Example Search using the QVR

Select“Output” format

Select

QVR--Basic Output

Select

QVR--Snapshot

QVR--Basic Output

Select

QVR--Summary Statement

QVR--Basic Output

Select

QVR--Custom Download

Select

QVR--Custom Download

Select items

QVR--Custom Download as HTML

Select

QVR--Custom Download as HTML

QVR--Custom Download into Excel

Select

QVR--Custom Download into Excel

Select

QVR--Custom Download into Excel

Enter File NameSelect

QVR--Custom Download into ExcelOpen Excel and Open file

Building and Saving a Query

Select Council rounds

Building and Saving a Query

Select mechanisms

Select sort order

Select “Primary Projects Only”

Building and Saving a Query

Select

Note: If no summary statementexists there will not be a check box.

Building and Saving a Query

Fill in Query Nameand

Query Description

Building and Saving a Query

Select

Building and Saving a Query

Retrieving a Saved Query

Select

Retrieving a Saved Query

Note: Query Description

This deletesthe query

from your list

Click hereto

select query

Saving List of Items for Download

Enter Title

Select

Retrieving List of Items for Download

Select

Retrieving List of Items for Download

Select

The ECB, QVR and CAM Priorities and Enhancement Plans

Launch Basic QVR System (FY 2001)Launch Basic QVR System (FY 2001)

Access funded projectsAccess funded projectsGrant snapshotGrant snapshot

Save queriesSave queriesNew version of hit listsNew version of hit lists

Summary statement download as PDF and Zip fileSummary statement download as PDF and Zip file

Update Council Version of ECB (FY 2001)Update Council Version of ECB (FY 2001)

Save queriesSave queriesNew version of hit listsNew version of hit lists

Summary statement download as PDF and Zip fileSummary statement download as PDF and Zip file

The ECB, QVR and CAM Priorities and Enhancement Plans

(Continued - 1)Add Enhancement to Staff ECB and QVR Add Enhancement to Staff ECB and QVR

systems (FY 2001, 2002, 2003)systems (FY 2001, 2002, 2003)

Pre-formatted reportsPre-formatted reportsShared queriesShared queriesAd-hoc queriesAd-hoc queries

Access application imageAccess application imageAccess publication dataAccess publication data

Access joint funding dataAccess joint funding dataAdd-on systems to include IC specific requirementsAdd-on systems to include IC specific requirements

Access IC specific dataAccess IC specific dataConvenience enhancementsConvenience enhancements

The ECB, QVR and CAM Priorities and Enhancement Plans

(Continued - 2)Redesign Council Administration ModuleRedesign Council Administration Module

(FY 2001, 2002)(FY 2001, 2002)

Early council concurrenceEarly council concurrenceEnhancements to assignment noduleEnhancements to assignment nodule

Redesign approval moduleRedesign approval modulePerformance improvementsPerformance improvementsExpand reporting optionsExpand reporting options

Import council member data from IMPAC systemImport council member data from IMPAC systemIntegrate functionality of council sweep into CAMIntegrate functionality of council sweep into CAM