March 4, 2002 [Number 222]     Printable version (469k PDF)

Index

Previous Story

Next Story

Keeping Up With the NIH Data Warehouse

There must be a reason why over 2,900 of your fellow employees are using the NIH Data Warehouse to assist with their daily work. Perhaps because Data Warehouse (DW) provides useful and timely information, or because we listen to your needs, we are constantly adding to the information DW offers. A collaborative effort between the DW staff and the NIH community, the NIH Data Warehouse is designed to meet your reporting and analysis needs.

A few of the recent enhancements made to the NIH business areas are in the Travel, Budget and Finance, and Human Resources business areas.

DWQuery Tool for Travel

Have you ever needed to report

• Foreign Travel taken by employees and contract staff to meet Congressional mandates? or
• annual leave days taken by employees while on travel?

Have you been asked questions concerning sponsored travel or concerning reimbursement for sponsored travel? Answers to many more questions are now available to you in the Travel area of DW.

In addition, the following information has recently been added to the Travel area:

• pay approved date, traveler's title, order release for payment date
• additional travel costs information
• leave information while on Travel
• seven new sponsored travel reports

DWQuery Tool for Budget and Finance

Wouldn’t it be nice if you could compare current-year money against prior years or obtain a complete history of payments made against specific orders?

• DW allows you to report your financial activity for the current and five past years. You can easily run comparisons of obligations by fiscal year, CAN and even object class code. This information is updated nightly—like most DW information.
• You can now access payment information for the past ten years. This new payment history feature can be used to answer disputes with vendors or to track payments against specific orders or contracts.

Human Resources

How easy is it for you to pull together demographic and cost information on civilian, Commissioned Corps, IRTA, and visiting fellows? This type of information is easily accessible with a click of a button—via two handy decision support tools, DWQuery and DWAnalyze.

• DWQuery—presents information in a traditional report format, offering NIH defined standard reports and user created ad hoc reports.
• DWAnalyze—provides a dynamic analysis format that allows the user to select data combinations and levels of detail.
• Workforce Demographics—contains information that is often needed to supervise and analyze the following types of personnel matters:
• tenure tracking
• forward planning for attrition or within-grade-increases
• analysis of salary bands for both FTE and non-FTE staff
• evaluation of workforce diversity

Workforce demographics also gives you other valuable reports:

• head counts by grade, series and salary range
• all personnel eligible for a within-grade increase or retirement within a specified date range
• individual employee information including last promotion date, current grade and step, education level, and organization code
• staff diversity

Please visit our DW Web site for more than access. The DW Web page contains a wealth of information—the online registration, technical support and news, as well as links to other NIH systems. You can also view and register for upcoming CIT training classes on DW.