Standard AQ - Get Missing SOC Data

Updated May 06, 2025 16:13

Overview

The Missing SOC Report Advanced Query (AQ) identifies Job Titles that are missing Standard Occupational Classification (SOC) codes, which are required for SUTA reporting in several states.

The Standard Occupational Classification (SOC) system is a federal statistical standard used by federal agencies to classify workers into occupational categories to collect, calculate, or disseminate data.

For information on the SOC and a list of the codes, please visit the BLS website: https://www.bls.gov/soc/

Current State Requirements

Alaska: Requires SOC codes
Indiana: Requires SOC codes
Louisiana: Requires SOC codes
South Carolina: Requires SOC codes (effective since Q1 2024)
Washington: Requires SOC codes (effective since Q4 2022)
West Virginia: Requires SOC codes

For Washington state specifically, please refer to this article for more information: ESDWAGOV - About SOC (external content - State of Washington)

Report Description

The Missing SOC Report AQ:

- Shows a list of all Skill Codes that don't have the Occupational Code associated with them
- Includes all states that require SOC codes: AK, IN, LA, SC, WA, and WV
- Produces a Greenshades file for WA SUI (implemented on 10/13/2022)
- SOC = Standard Occupational Classification

(click the image to open a larger view in a new tab)

Resolving issues on the Report

Click on the Admin Tools button
Click on Skill Code
Search for the Skill Code
- It's easier to search by SkillCodeID
Go to the SOC LookUp section
Choose the desired option; the code that most closely identifies the job title
Click Save

Parameters

Parameter Name	Options	Description
Search Type	Missing Job Title, Occ. Code or Either	Choose the type of search. If Missing Occ. Code is selected, the system checks for the following states: AK, IN, LA, SC, WA, and WV.
Date Type	Active Assignment, Week Worked, Check Date	Choose the Date Type from the available set of options
Start Date	Start Date	Pulls the records starting from the date based on the selected value for the Date Type parameter
End Date	End Date	Pulls the records Ending on the date based on the selected value for the Date Type parameter
State	All, AK, IN, LA, SC, WA, and WV (multi-select)	Selecting 'All' will select all the states (AK, IN, LA, SC, WA, and WV)

Report Fields

Missing Job Title

Field Name	Description
Supplier	Name of the Supplier
Branch	Order's Branch
Customer ID	Pulls Customer ID from the order
CustomerName	The name of the customer
DepartmentName	The specific department in which the order was placed
StaffingOrderID	Unique number assigned to the order
State	State Code
Select	Checkbox to select individual results

Missing Occ. Code

Field Name	Description
Supplier	Name of the Supplier
ConfigSkillCodeID	Unique number assigned to the Skill Code
CategoryName	The specific Category the Skill Code is in
SkillCode	The name of the Skill Code
Description	Description of the Skill Code
State	State Code
Select	Checkbox to select individual results

Missing Either

Field Name	Description
Supplier	Name of the Supplier
Branch	Order's Branch
CustomerID	Pulls Customer ID from the order
CustomerName	The name of the customer
DepartmentName	The specific department in which the order was placed
StaffingOrderID	Unique number assigned to the order
ConfigSkillCodeID	Unique number assigned to the Skill Code
CategoryName	The specific Category the Skill Code is in
SkillCode	The name of the Skill Code
Description	Description of the Skill Code
State	State Code
Select	Checkbox to select individual results

3rd party link Disclaimer: These links are being provided as a convenience and for informational purposes only; they do not constitute an endorsement or approval by [The author] of any of the products, services, or opinions of the corporation, organization, or individual. [The author] bears no responsibility for the accuracy, legality, or content of the external site or for that of subsequent links. Contact the external site for answers to questions regarding its content.