6 Working with RMW Reports

The RMW application provides you predefined queries to generate reports of various activities in the Environment and Material modules. The output of reports is based on predefined template and is rendered in Excel, PDF, XML, and HTML formats.

The application stores all the reports that you generate. You can view them on-screen, or export them to be stored in your system.

6.1 Generating Reports

You can generate reports for various activities performed in the Environment and Material modules of the RMW application.

To generate a report:

1. In the Left Navigation menu, open Reports drawer.

2. Click Material Not Used Report under Reporting > Material. Enter values in mandatory fields.

3. Click Lookup icon to search and select desired values. Enter values in the optional fields.

4. Click Generate Report.

5. Click OK.

Note: The system records a report request even if you do not complete fields marked mandatory.

A Report appears in the Manage Reports page with the request ID along with a confirmation message

6.2 Managing Reports

The RMW application stores all the reports that you generate. You can view these reports on-screen or export them to be saved on your system. For complete details on how to export the reports, refer to Exporting Records. You can access generated reports from Manage.

To view a report:

1. In the Left Navigation pane, open the Reports drawer.

2. In Reporting, click Manage.

3. In the Report Request page, select the desired parameters and click Search.

4. In the Results in Report Request, click on the attachment icon of a desired report. File download popup shows up with Open, Save and Cancel buttons.

You can save the report only in Excel format.

To delete a report:

1. Search and select the report you wish to delete.

2. Click Delete.

6.3 Environment Reports

The following Environment report can be generated in the RMW application:

Name

Description

SARA 311/312 Report

SARA 311/312 is Section 311 or 312 of Environmental Protection Agency's Superfund Amendments Reauthorization Act. Section 311 requires that hazardous chemicals with Material Safety Data Sheet as prescribed by Occupational Safety and Health Administration (OSHA) be stored in specific environments. A list of such chemicals must be submitted to the concerned authorities. Section 312 requires that the emergency and hazardous chemical inventory form, called Tier II form, is submitted annually. Tier II forms provide the following information for each substance: The chemical name or the common name as indicated on the MSDS. An estimate (in ranges) of the maximum amount of the chemical present at any time during the preceding calendar year and the average daily amount. A brief description of the hazards and manner of storage of the chemical. The location of the chemical at the facility. An indication of whether the owner elects to withhold location information from disclosure to the public. The SARA 311/312 report uses information from RMW Daily Material Inventory. It includes storage details of the chemical. This report lists out all material inventory for the site/location for a given time period.

6.4 Material Reports

The following Material reports can be generated in the RMW application:

Name	Description
Restock Report	Provides details of all materials in the Material Inventory at the selected site where the Quantity Available is less than the Inventory Restock Level. Material Manager uses this report to take decision on restocking of the inventory.
The Material Not Used Report	Used for tracking all the material lots that were not used since a specified date. This report helps the Material Managers to know the materials that are not being used and hence can be freed up from the inventory.
Material Dispensing and Adjustment Report	Provides details of all inventory adjustment transactions, such as dispenses and corrections for each Lot or Container. You have to specify the Lot ID.
Lots without Dispensing Activity Report	Provides details of all the lots that remained without dispensing activity during a specified date range.
Containers without Dispensing Activity Report	Provides the details of all the Containers that remained without dispensing activity during a specified date range.
Daily Inventory Report	Provides the balances of the specified Materials or all the materials in the inventory on a given day. Material field is mandatory.
Daily Inventory by CAS/TPQ Report	Provides the balances of Materials by their CAS (Chemical Abstract Service) and Threshold Planning Quantity.