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.