Standard AQ - California Laborer Contractor Report

Provide this report to your customers, they will determine if they need to submit the required information to California.

Senate Bill 1162 added the requirement that a private employer with 100 or more workers hired through labor contractors in the prior calendar year (with at least one worker based in California) must file a separate “Labor Contractor Employee Report” that covers workers hired through labor contractors in the prior calendar year (2022(This report was created based on the specifications found here- PDR Excel Templates | CRD (ca.gov) and is due on 5/10/2023.

 

Report Description

Provide this report to your customers, they will determine if they need to submit the required information to California.

Report will pull blank data, this is expected and no setup is required.

Was a California Pay Data Report filed for this establishment last year?  
Was an EEO-1 Report filed for this establishment last year?  
Is this establishment the employer's headquarters?  

 

Parameters

Parameter Name

Options

Description

Supplier  All Available Suppliers Filters the supplier of the employee.
Branch  All Available Branches Filters the branch of the employee.
Date Type Accounting Period Date, Week Worked Date, Check Date  
Start Date MM/DD/YYYY Pulls the employee that have payroll/checks within the snapshot period/date range working for the provided customer ID
End Date MM/DD/YYYY
Transaction Type All Available Taxable Transaction Types Ex) Regular, OT, DT, Salary, Bonus, Equipment, etc.
Ignore "Missing Info" Errors? Yes or No Yes - Only the missing race sex ethnicity will be ignored and display UU codes as required by CA.
No - Displays the Errors and Missing Mapping Data in the report.
Customer ID Free text field to enter Customer ID Filters the ID of Customer
Show Employee Detail Yes / No Yes - Displays the report per employee with their detail information.
No - Displays the report per Customer, Worksite, Job Category, Race/Ethnicity/Sex, and Pay Band.
Include Child Departments Yes / No Yes- Includes the customer passed in Customer ID parameter and its child customers/departments
No- Includes only the customer passed in Customer ID parameter but not its child customers/departments

 

 

Report Fields

 

Employee Detail = Yes

Field Name

Description

Note

Establishment Name Customer's Name  
Address Line 1 Customer's Worksite Street 1  
Address Line 2 Customer's Worksite Street 2  
City Customer's Worksite City  
State Customer's Worksite State  
ZIP Code Customer's Worksite Zip Code  
NAICS Code    
Major Activity Value of CA_EEO_PayData_Reporting_MajorActivity branch property  
Employee ID Employee's ID Pulls the employee that have payroll within the snapshot period/date range
Employee First Name Employee's First Name  
Employee Middle Name Employee's Middle Name  
Employee Last Name Employee's Last Name  
Total Number of Employees at Establishment Total Number of Employees having payroll at the Customer and Worksite Address within snapshot period
Was a California Pay Data Report filed for this establishment last year?  
Was an EEO-1 Report filed for this establishment last year?  
Is this establishment the employer's headquarters?  
Labor Contractor Transaction's Supplier Name  
Labor Contractor FEIN Transaction's Supplier FEIN  
Snapshot - Start Date Start Date from the parameter  
Snapshot - End Date End Date from the parameter  
Job Category Job Category. See the mapping

https://avionteclassicsupport.zendesk.com/hc/en-us/articles/360045321534

Race/Ethnicity/Sex

Race/Ethnicity/Gender Codes are as Follows:
A10 - Hispanic/Latino - Male
A20 - Hispanic/Latino - Female
A30 - Hispanic/Latino - Non-Binary
B10 - Non-Hispanic/Non-Latino - Male - White
B20 - Non-Hispanic/Non-Latino - Male - Black or African American
B30 - Non-Hispanic/Non-Latino - Male - Native Hawaiian or Other Pacific Islander
B40 - Non-Hispanic/Non-Latino - Male - Asian
B50 - Non-Hispanic/Non-Latino - Male - American Indian or Alaskan Native
B60 - Non-Hispanic/Non-Latino - Male - Two or more races
C10 - Non-Hispanic/Non-Latino - Female - White
C20 - Non-Hispanic/Non-Latino - Female - Black or African American
C30 - Non-Hispanic/Non-Latino - Female - Native Hawaiian or Other Pacific Islander
C40 - Non-Hispanic/Non-Latino - Female - Asian
C50 - Non-Hispanic/Non-Latino - Female - American Indian or Alaskan Native
C60 - Non-Hispanic/Non-Latino - Female - Two or more races
D10 - Non-Hispanic/Non-Latino - Non-Binary - White
D20 - Non-Hispanic/Non-Latino - Non-Binary - Black or African American
D30 - Non-Hispanic/Non-Latino - Non-Binary - Native Hawaiian or Other Pacific Islander
D40 - Non-Hispanic/Non-Latino - Non-Binary - Asian
D50 - Non-Hispanic/Non-Latino - Non-Binary - American Indian or Alaskan Native
D60 - Non-Hispanic/Non-Latino - Non-Binary - Two or more races
U10 - Unknown Race/Ethnicity,, Known Male
U20 - Unknown Race/Ethnicity, Known Female
U30 - Unknown Race/Ethnicty, Known Non-binary
UU - Unknown Race/Ethnicity, Unknown Sex

 

Pay Band Pay Band Category Codes are as Follows:
1: $19,239 and under
2: $19,240 - $24,959
3: $24,960 - $32,239
4: $32,240 - $41,079
5: $41,080 - $53,039
6: $53,040 - $68,119
7: $68,120 - $87,359
8: $87,360 - $112,319
9: $112,320 - $144,559
10: $144,560 - $186,159
11: $186,160 - $239,199
12: $239,200 and over
Pay Band as per their Taxable Gross for Medical employee Wages for the year of start date.  See the mapping.
Number of Employees Total Number of Employees having payroll within snapshot period by Customer, Worksite, Job Category, Race/Ethnicity/Sex, and Pay Band  
Mean - Hourly Rate* Calculated Mean as per Customer, Worksite, Job Category, Race/Ethnicity/Sex, and Pay Band
Median - Hourly Rate* Calculated Median as per Customer, Worksite, Job Category, Race/Ethnicity/Sex, and Pay Band
Total Hours Total Hours of work done by the employee for the transactions of the California worksite for the year of Start Date parameter  
Row-Level Clarifying Remarks N/A  

 

 

Employee Detail = No

Field Name

Description

Note

Establishment Name Customer's Name  
Address Line 1 Customer's Worksite Street 1  
Address Line 2 Customer's Worksite Street 2  
City Customer's Worksite City  
State Customer's Worksite State  
ZIP Code Customer's Worksite Zip Code  
NAICS Code    
Major Activity    
Total Number of Employees at Establishment Total Number of Employees having payroll at the Customer and Worksite Address within snapshot period
Was a California Pay Data Report filed for this establishment last year?  
Was an EEO-1 Report filed for this establishment last year?  
Is this establishment the employer's headquarters?  
Labor Contractor Transaction's Supplier Name  
Labor Contractor FEIN Transaction's Supplier FEIN  
Snapshot - Start Date Start Date from the parameter  
Snapshot - End Date End Date from the parameter  
Job Category Job Category. See the mapping https://avionteclassicsupport.zendesk.com/hc/en-us/articles/360045321534
Race/Ethnicity/Sex

Race/Ethnicity/Gender Codes are as Follows:
A10 - Hispanic/Latino - Male
A20 - Hispanic/Latino - Female
A30 - Hispanic/Latino - Non-Binary
B10 - Non-Hispanic/Non-Latino - Male - White
B20 - Non-Hispanic/Non-Latino - Male - Black or African American
B30 - Non-Hispanic/Non-Latino - Male - Native Hawaiian or Other Pacific Islander
B40 - Non-Hispanic/Non-Latino - Male - Asian
B50 - Non-Hispanic/Non-Latino - Male - American Indian or Alaskan Native
B60 - Non-Hispanic/Non-Latino - Male - Two or more races
C10 - Non-Hispanic/Non-Latino - Female - White
C20 - Non-Hispanic/Non-Latino - Female - Black or African American
C30 - Non-Hispanic/Non-Latino - Female - Native Hawaiian or Other Pacific Islander
C40 - Non-Hispanic/Non-Latino - Female - Asian
C50 - Non-Hispanic/Non-Latino - Female - American Indian or Alaskan Native
C60 - Non-Hispanic/Non-Latino - Female - Two or more races
D10 - Non-Hispanic/Non-Latino - Non-Binary - White
D20 - Non-Hispanic/Non-Latino - Non-Binary - Black or African American
D30 - Non-Hispanic/Non-Latino - Non-Binary - Native Hawaiian or Other Pacific Islander
D40 - Non-Hispanic/Non-Latino - Non-Binary - Asian
D50 - Non-Hispanic/Non-Latino - Non-Binary - American Indian or Alaskan Native
D60 - Non-Hispanic/Non-Latino - Non-Binary - Two or more races
U10 - Unknown Race/Ethnicity,, Known Male
U20 - Unknown Race/Ethnicity, Known Female
U30 - Unknown Race/Ethnicty, Known Non-binary
UU - Unknown Race/Ethnicity, Unknown Sex

 

Pay Band Pay Band Category Codes are as Follows:
1: $19,239 and under
2: $19,240 - $24,959
3: $24,960 - $32,239
4: $32,240 - $41,079
5: $41,080 - $53,039
6: $53,040 - $68,119
7: $68,120 - $87,359
8: $87,360 - $112,319
9: $112,320 - $144,559
10: $144,560 - $186,159
11: $186,160 - $239,199
12: $239,200 and over
Pay Band as per their Taxable Gross for Medical employee Wages for the year of start date.  See the mapping.
Number of Employees Total Number of Employees having payroll within snapshot period by Customer, Worksite, Job Category, Race/Ethnicity/Sex, and Pay Band  
Mean - Hourly Rate* Calculated Mean as per Customer, Worksite, Job Category, Race/Ethnicity/Sex, and Pay Band
Median - Hourly Rate* Calculated Median as per Customer, Worksite, Job Category, Race/Ethnicity/Sex, and Pay Band
Total Hours Total Hours of work done by the employee for the transactions of the California worksite for the year of Start Date parameter  
Row-Level Clarifying Remarks N/A  

 

 

3rd party link Disclaimer: These links are being provided as a convenience and for informational purposes only; they do not constitute an endorsement or an approval by [The author] of any of the products, services or opinions of the corporation or 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.

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share