Skip to main content
J. J. Keller Support Center

Employment Data

 

From the Safety Management Suite dashboard, click the down arrow next to Incidents on the left hand side.  In the expanded menu, click Employment Data.

clipboard_e8d3b418ccc97e3ac0e10658f972a9b95.png                                        clipboard_e35e58031deffb84354342b17e2d240a1.png

 

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

clipboard_e7aef193a9b8f68813dd52351948da035.png

clipboard_eef537737cac2770354e9848031110c97.png

 

Note: Use the filters and sorting options across the top of the table to narrow down specific locations, years, etc.

clipboard_e54cc6da9348efc955d0d51c883318154.png

 

Click the Add New button within the Data by Month box.
(If no data has been entered yet, this initial "Add New" record will start with January by default. To ensure monthly reporting is accurate, you must enter data for each month.)

clipboard_edd63cd82d0df2f1ea8cfdffbb0eed48d.png

 

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.

 

clipboard_ece74da33e612aedbe3738581182149f7.png

clipboard_ec303e2fee97373a20bf1a94a61cff834.png

 

Once information is entered, click Save, or Save and Edit Next Month to move on to enter the next month's data.

clipboard_e0a29ca61b81d4f842ec7d012ce2aa6a1.png


If you need to enter data specific to each month or must come back at a later time to enter data, navigate to the specific location/year again.

clipboard_e7aef193a9b8f68813dd52351948da035.pngclipboard_eef537737cac2770354e9848031110c97.png

 

Click Edit under the desired month.

clipboard_e8d23efe547fb74d8a21174a052571cf4.png

 

Complete the required fields and save the data.

clipboard_eed74bf52da5f53ec83980daec90f95ec.png

clipboard_e0a29ca61b81d4f842ec7d012ce2aa6a1.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_e7aef193a9b8f68813dd52351948da035.png

clipboard_eef537737cac2770354e9848031110c97.png

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

clipboard_e69858e774aa4597bd32db594109b7daf.png

 
  • Was this article helpful?