National Institute of Dental and Craniofacial Research

1
National Institute of Dental and Craniofacial
Research
DOCRS
May 2001

• Dental, Oral, Craniofacial Reporting System
  (DOCRS)

Mary Ann Williamson Office of Information
Technology NIDCR
2
Overview

• IMPAC II Extension
• Allows flexible querying and reporting of IMPAC
  II data

DOCRS
May 2001
3
Requirements and Specifications

• Grew out of NIDCR Strategic Planning Process
• Trans-NIDCR Workgroup participated in all phases
• Meets Division of Extramural Research needs as
  well as other NIDCR organizational units

DOCRS
May 2001
4
Technical Features

• Database back-end is Oracle 8.1.6
• Daily data refresh
• Client front-end is MSAccess2000
• Application resides on client PC
• Client application updates are distributed
  automatically to all users

DOCRS
May 2001
5
Security

• User logon is required
• Three role types ensure appropriate access to
  data and application

DOCRS
May 2001
6
Some Key Features

• Query flexibility
• Output flexibility

DOCRS
May 2001
7
Query Flexibility

• Specific IC or all of NIH
• Funded and pending applications from one screen
• Pre-defined aggregates simplify querying
• User can create report heading
• Query can be saved for future use

DOCRS
May 2001
8
Output Flexibility

• Up to 3 sort levels
• Default hitlist contains significant data
  elements
• Hitlist displays record count and sum of funded
  amounts
• Can export query results to Word and Excel
• Other output options include mailing labels and
  e-mail

DOCRS
May 2001
9
Hitlist Options

• Dynamically sort on any field displayed
• Select records from Hitlist to copy/paste into
  other application, or to sum funded amounts
• View Detail Report for individual record
• View Summary Statement, Abstract, or Notice of
  Grant Award in Word

DOCRS
May 2001
10
Current Phase

• Maintenance phase
• Minimal changes will respond to environment, make
  corrections, or add any critical elements
• Next planned feature is standard reporting module
• NIDCR will monitor IMPACII applications before
  undertaking any significant new development

DOCRS
May 2001
11
(No Transcript)
12
(No Transcript)