Skip to main content
J. J. Keller Support Center

Employment Data for OSHA Reports

 

The Employment Data page provides annual employment calculations for all locations that are required to complete your OSHA Form 300A. From the Safety Management Suite dashboard, click the down arrow next to Incidents on the left-hand side. Then, select Employment Data.

 clipboard_e06f701703323ff431a7d2c11520ad438.png

There are a few ways to add employment data:

1. Locate the desired location and year to review. Click the "three dots" and select Add Data.

clipboard_e72e4bf31c3c5fe35c69c1afc5e1e537f.png
 

2. Locate the desired location and year to review. Click the "three dots" and select View. Then, click + Add Employment Data.

clipboard_ea5385727847c0737bb98545ca90f5152.pngclipboard_e17a4fcc508b26a1bf4f9f478c4595b2b.png

 

3. Locate the desired location and year to review. Click the "three dots" and select View. Scroll to the Months section and click the "three dots" next to the month you want to add data for. Click Edit. (This option would only be available if data for January has at least been entered. The months don't appear in the table until data has been entered.)

clipboard_ea5385727847c0737bb98545ca90f5152.pngclipboard_e7ce5eb084b530afc3e10ba39cb6c9bba.png


Next, you will enter employment data. To ensure monthly reporting is accurate, you must enter data for each month.
(If no data has been entered yet, this initial "Add New" record will start with January by default.)

 

Enter in the required fields, number of full-time employees for the monthtotal hours worked by all employees, and peak employee count. Additionally, if applicable, you can choose to switch the toggle on (YES) to "Apply this month's employment info to all months", or leave it toggled off (NO) to edit each month individually. Once information is entered, click Save, or Save and Edit Next Month to move on to enter the next month's data.

clipboard_edc467dc94865dea20711fdafcec2fa14.png

Once saved, you can view the data entered for the location + year. In the example below, you can see that 2024 still has a few months that have not had any data entered.

clipboard_ea8b6f1232925b8b4127b811a37d46a3f.png

 

Importing Employment Data by Year or Month

 

By Year

Navigate to the Import/Export Center. This is located under the drop-down next to your initials.

clipboard_e331af904375371a0652341128d77be1f.png

 

In the Record Type dropdown, select Employment Data Yearly.

clipboard_eb4b05e81e8b17e33d370a4034b20e8c0.png

In the Import or Export dropdown, select Import.

  1. Download and open the Import Template.
  2. Complete the Template and save the file to your computer as a .csv file.
    -Note: Location Name will need to match the exact Location name in SMS
    -Note: Peak Employees should be a single number. Not a range of Values (1-19, 20-259)
    -The import process will also update existing records, so make sure all of your data is input correctly.
  3. Click Choose File and select the .csv file from your device. 
  4. Click Import. (The Import button will not display until you upload your .csv file.)

clipboard_ed516d620cb2e766d5ba9ddd294ff093d.png

clipboard_e249d95a0428ecc879b29f8def130bb59.png

Import Template Instructions - Yearly

DATA FIELD REQUIRED? MAX CHARACTERS INSTRUCTIONS/FORMATTING
Location  Name Yes 256 Must be an existing Location Name
Annual Average Employees Yes -- Number of full-time employees, numeric
Hours Worked By Employees Yes -- Total hours worked, numeric
Peak Employees Yes -- Max employees for the month, numeric
Year Yes 4 YYYY

 

 

By Month

If you have a location that did not have employees at it for the full year and need to enter "0" for the first couple of months, using the Import Center will be the best option for you.

 

In the Record Type dropdown, select Employment Data Monthly.

clipboard_ec1abecb55f0d8a63dd04d291b9ccce46.png

In the Import or Export dropdown, select Import.

  1. Download the Import Template.
  2. Complete the Template and save the file to your computer as a .csv file.
    -This is where you can enter 0 for any months needed that didn't have employees at the location
    -Location Name will have to match the exact Location name in SMS
    -Peak Employees should be a single number. Not a range of Values (ie. 1-19, 20-259)
    -
    The import process will also update existing records, so be sure all of your data is input correctly.
  3. Click Choose File and select the .csv file from your device. 
  4. Click Import. (The Import button will not display until you upload your .csv file.)

clipboard_ea90f5427ff89f625500bd2b074ff7db4.png

clipboard_e249d95a0428ecc879b29f8def130bb59.png

Import Template Instructions - Monthly

DATA FIELD REQUIRED? MAX CHARACTERS INSTRUCTIONS/FORMATTING
Location  Name Yes 256 Must be an existing Location Name
Month Yes 2 1-12
Full Time Employees Yes -- Number of full time employees, numeric
Total Hours Worked Yes -- Total hours worked, numeric
Peak Employees Yes -- Max employees for the month, numeric
Year Yes 4 YYYY

 

View Imported Data

To view the uploaded data, go to Incidents > Employment Data.

clipboard_ebb6f381d240d7f5a955c92090727ddc0.png

Locate the desired location + year to review. Click the "three dots" and select View.

clipboard_efbd2f1245caa702c3e6dc2bf0a30d263.png

You will now see any data that has been entered/submitted for that specific location and year.

clipboard_e5deccd30a824be3d64fbc6a97eaf4f9a.png

 
  • Was this article helpful?