DWQuery—New Look to the Web Pages
In an ongoing effort to update the Data Warehouse, we have extended the Data Town Web interface to every business area under DWQuery. This consistency in design ensures a seamless transition throughout the DW web site and makes the system easier to use.
In addition, new links have been added to the DWQuery Web pages:
| o |
DW Data Currency |
lists all business areas with the date last updated |
| o |
DW News |
includes articles on new applications, important issues, training, and system updates |
| o |
About Business Area |
describes the data sources, tables, and reports for that particular business area |
| o |
Useful Information |
explains how to save user created queries, submit user created queries and export query results |
| o |
List of DWQuery Reports |
lists all of the NIH-defined reports for each business area, gives a description of each report, and links to a preview image of each report |
Government Purchase Card Reconciliation—Enhancements
The DW purchase card reconciliation application has been improved. This tool offers the ability to move back and forth between the ADB Web and the NIH Data Warehouse to view purchase log and bank transactions information. As soon as a user updates a log item on the ADB, the updated information can immediately be viewed on the Data Warehouse using the purchase card reconciliation application.
The following improvements and new features make this reporting and analysis tool even easier to use:
| o |
column headers remain visible on the screen when the data is scrolled |
| o |
the bank transaction month is now consistent with the ADB’s bank review cycle |
| o |
transaction links are in a more prominent location (on the left side of the screen) |
| o |
new information links include a glossary of terms, information page about the data, and helpful hints on using the purchase card application |
New Areas Under Development
•
Human Resources Business Area—"Fellowship Payment" Coming Soon
The "Fellowship Payment" activity is in the final development stages and will be available for use in the near future. This activity offers the same information that is contained in the FPSII system. Fellowship payment provides a wide variety of information about fellows at NIH including the following:
| o |
obligations |
includes insurance and stipend amounts for new awards, renewals and transfers |
| o |
monthly pay information |
displays a history of each fellow’s monthly payment |
| o |
stipend changes |
includes specialty allowances, and a list of stipend periods for each fellow |
| o |
fellow movement tracking |
includes transfers from one node to another, transfers within the same IC, transfers from one IC to another, program type changes, terminated awards, and renewed awards |
o |
demographic information |
displays information on non-U.S. permanent residents, citizenship status, and work location |
| o |
administrative reports |
lists all fellows for a specific approving official, sponsor, and certifying official |
•
Technology Transfer Business Area—Being Developed
The new business area in development for Technology Transfer information will provide comprehensive reports on inventions, inventors, licenses, patents, work orders, and work order invoices. This reporting and analysis tool will be particularly useful for technology development coordinators, budget officers, and other managers. They will be able to identify relationships between inventions and inventors, inventions and licenses, inventions and patents, and patent prosecution costs. Technology Transfer will contain one year of current data and up to 10 years of historical data from the invention tracking system (ITS). The following report categories will be included:
| o |
invention |
provides reports about inventors, invention title, and licenses or patents that are associated with an invention |
| o |
patent |
includes information about patent status and unlicensed patents |
| o |
license agreements |
displays the status of signed license agreements and the associated inventions |
| o |
search |
allows the user to view information based on E-number, case number, patent number, invention title, and research type |
| o |
work order invoice |
offers detail information about patent |
More Information
Additional information on the Data Warehouse enhancements mentioned above, or any future plans and releases, is available on the Data Warehouse Web page—use the link to "DW News." If you have any questions or concerns, please call TASC at (301) 594-6248.
