Help with Queries
- Select query parameters
- Select report variables
- Make another query
- Troubleshoot a query
- Contact Us
How to select query parameters
The default selection for variables is All, except for Treatment Year, which defaults to the most current year of data available. Running a query without selecting parameters other than the defaults will produce an estimate that is the total of all injury cases for all workers for the most recent data year. Selecting specific parameters will produce an estimate for a narrower subset. For example, selecting Sex = Female will return the number of female workers, and selecting Event = 24* Pedestrian vehicular incident will return the number of cases in which pedestrians were injured by vehicles. Selecting Event = 111* Intentional injury by other person and Source = 5771 Robber will produce the number of assaults by robbers.
To select specific query parameters:
- Click on the button in any of the query parameter boxes located under "Step 1: Select query parameters" to display available parameters.
- Select parameters by clicking on your choices. In the Time Period section, you can select only one Treatment Year per query, but you may choose multiple months or quarters in Treatment Month(s) by holding the Shift key while clicking on the first and last items of a continuous sequence, or by holding the Ctrl key while clicking on individual parameters to select non-adjacent items. Do the same to select multiple parameters in Demographics and Nature of Injury. To select multiple parameters in Incident Characteristics, click to check the boxes that apply.
How to select Incident Characteristics parameters
The BLS Occupational Injury and Illness Classification System (OIICS) for Event, Source, and Secondary Source is arranged by general divisions of single-digit codes that narrow into more specific categories with two-, three-, and four-digit codes. Aggregate categories, which are identified by asterisks after the code digits (such as 2* or 63*), include all subcategories and individual codes listed below the aggregate category.
Data years 1998-2011 use OIICS v1.01, and data years 2012 and onward use v. 2.01. The query system defaults to the use of the appropriate OIICS version based on the year of data selected for analysis. There is a break in series between the versions, and users should not compare Event, Source, and Secondary Source results between years that use different versions (e.g., 2011 and 2012).
To view the OIICS code tree
- Click on the button to display the OIICS code tree.
- Click on the button to expand the tree to see more detailed code branches.
- Click on the button to hide the more detailed branches. Previously expanded branches automatically collapse when a new branch expands.
- Click on the button to see a detailed list of all codes selected.
To search for a specific code
- Open the Search function by clicking on the button in the upper right of the code tree window.
- To search by keyword, enter a word or text string into the Search box to find specific codes within the tree that contain the same words or text. To search by code, enter the code number.
- Matches appear in a clickable list below the Search box. Click on an item to move to that section of the tree.
To select a category or individual code
- Click on an open box to select a category or an individual code. A hash indicates a category that is partially or fully selected. An indicates an individually selected code.
To undo selections
- Click on the button to undo an individual code selection.
- Click on the button to undo all selections on that particular code branch.
To view a selected code or codes
- Click on the button to display the specific code or codes selected for your query.
- To modify your selections, click on the button to return to the code tree window.
To collapse the code tree
- Click on the button to close branches displaying code categories and individual codes.
How to select report variables
Use the "Step 2: Select Report Variables" section pull-down lists to produce a table of estimates for each subcategory within a parameter. You may select up to two categories by using Row Variable (1-Major Group) and Row Variable (2-Minor Group). The results table will have a row for each estimate by subcategory and a final row with the query total.
How to make another query
There are three options for navigating back to the query page from the results page:
- Click on the button. This will preserve your most recent query parameters when you return to the query page.
- Click on the button. Depending on your browser setup, your previous parameter selections may or may not be retained.
- Use the Back button on your web browser. Depending on your browser setup, your previous parameter selections may or may not be retained.
How to troubleshoot a query
Problem: Not all subcategories are displayed when specifying variables using the Select Report Variables (e.g., you selected the variable Sex, but your results only list males).
- You probably restricted results by choosing an individual parameter such as Sex = Male and then used Row Variables = Sex in the current query or a previous query (variables selected in the Select Report Variable section do not override selected individual parameters that restrict the query). Check all query parameters selected.
- Subcategories with a value of zero are not displayed. Your query may have returned no results.
Problem: You received a "Timeout" instead of a results table.
- The query system may have been experiencing heavy traffic. Try the query again now or at another time of day.
How to contact us
If you have questions about Work-RISQS, or if you wish to inquire about a query you are unable to run using Work-RISQS, please contact: