1 / 14

Presentation to IC-Specific Data Committee June 26, 2002

The Query/View/Reporting System (QVR) Proposed Screens for Incorporating IC-Specific Data Functionality. Presentation to IC-Specific Data Committee June 26, 2002. Specific Steps Needed. Obtain a composite view of the “external” data needed by ICs for their business processes

kenda
Download Presentation

Presentation to IC-Specific Data Committee June 26, 2002

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. The Query/View/Reporting System(QVR)Proposed Screens for Incorporating IC-Specific Data Functionality Presentation to IC-Specific Data Committee June 26, 2002

  2. Specific Steps Needed • Obtain a composite view of the “external” data needed by ICs for their business processes • Identify the IMPAC II data extramural (OLTP and IRDB) that’s being downloaded by each IC and determine how it is used • Identify other data sources required

  3. Specific Steps Needed (Continued) • Determine the local (i.e., IC-specific) data needed by each IC for their extramural business processes • Identify grant coding/indexing data and techniques used by each IC • Identify other IC-specific data needed

  4. Overall Plan • Develop database structure for storage of IC-specific data • Upload IC-specific data for pilot test ICs into central database • Copy necessary IMPAC data into central database • Direct QVR functionality to access IC-Specific data for pilot test ICs • Expand system to other ICs • Develop data input functionality for IC requiring this capability

  5. The Goal IC #7 IC #8 IC #9 IC #10 IC #11 IC #n IC #1 IC #2 IC #3 IC #4 IC #5 IC #6 Institutes will continue using the eRA suite of applications as usual Only a single download to the Central database from the OLTP and IRDB will be needed eRA Suite of Applications (GM, ICO, Review, etc.) Selected IMPAC II Data Plus IC-specific Data Institutes will load data into a central database IMPAC II - OLTP IMPAC II - IRDB

  6. IC-Specific Data-Screen Options • Search Screens—Allow searches based on • IC-specific data • IMPAC II data • Frozen data or dynamic IMPAC data • Generate Reports • IC-specific data • IMPAC II data (Frozen data or dynamic IMPAC data)

  7. Mockup of IC-Specific Data Screens System would offer an IC-Specific Search Screen The screen would be customized to the needs of each IC or Office using the system The user could specify whether the search was to be conducted on current IMPAC data or FROZEN data The system would offer the full utility of the QVR system including data download to a spreadsheet and the Standard Reports

  8. Switch Screen Option Select

  9. Proposed IC-Specific Data Search Screen IC-Specific Data Search Example link_qvr.qvr_standard_detail_v link_qvr.qvr_download_v Select The system recognizes the Institute or Office the user is associated with and will display ONLY the IC-specific data associated with that Institute or Office

  10. IC-Specific Data Search Screen Screen navigation items Select IC-Specific Data

  11. IC-Specific Data Search Screen The system recognizes the Institute or Office the user is associated with and will display ONLY the IC-specific data associated with that Institute or Office IC-Specific Search Screen Panel No Yes Use Frozen Data Primary Search Term And Or and not Secondary Search Term “NIXXX” Specific Data Or “Office” Specific Data Scientific Indexing Terms Other Indexing Terms And Or and not

  12. System Design Parameters • The user could search on IC-specific data as well as IMPAC II data. • The user could generate reports based on IC-specific data as well as IMPAC II data • The user could define whether the reports would use Frozen data or Dynamic IMPAC II data

  13. Important findings so far • Each IC downloads a large number of data items from IMPAC II relating to their IC • Only a small subset of these data items need to be frozen

  14. THANK YOU

More Related