Standard AQ - Get Missing SOC Data

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 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/

On This Page
→ Current State Requirements	→ Report Description
→ Resolving Issues on the Report	→ Parameters
→ Report Fields

Current State Requirements

The following states require SOC codes for SUTA reporting:

• Alaska: Requires SOC codes
• Indiana: Requires SOC codes
• Louisiana: Requires SOC codes
• South Carolina: Requires SOC codes (effective since Q1 2024) — requires a detailed SOC code; major, minor, and broad category codes are not accepted
• Washington: Requires SOC codes (effective since Q4 2022) — requires a detailed SOC code; major, minor, and broad category codes are not accepted
• West Virginia: Requires SOC codes

For Washington state specifically, please refer to 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
• For Washington (WA) and South Carolina (SC), also identifies Skill Codes assigned a major, minor, or broad category SOC code — these states require a detailed SOC code and will not accept broader classifications
• 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)

Note: For WA and SC, if the AQ returns Skill Codes with a missing or non-detailed SOC code, the following errors appear in the results section:

• Missing Code. WA will not accept major, minor, or broad category from the SOC code list.
• Invalid Code. WA will not accept major, minor, or broad category from the SOC code list.
• Missing Code. SC will not accept major, minor, or broad category from the SOC code list.
• Invalid Code. SC will not accept major, minor, or broad category from the SOC code list.

Update affected Skill Codes with a detailed SOC code before running your state SUI filing reports.

Resolving Issues on the Report

1. Click on the Admin Tools button

   

2. Click on Skill Code

   
3. Search for the Skill Code
   • It's easier to search by SkillCodeID
4. Go to the SOC LookUp section
5. Choose the desired option; the code that most closely identifies the job title. For Washington (WA) and South Carolina (SC), you must select a Detailed SOC code — major, minor, and broad category codes are not accepted by these states.
6. 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.