Standard AQ - California Pay Data

SB 1162 requires private employers with at least 100 employees to file a Payroll Employee Report for the prior calendar year, regardless of whether the employer files a federal EEO-1 report. This report was created based on specifications provided by California.

Click here to download the Spreadsheet

The report exports as an Excel Workbook. Ensure Save As Type = Workbook (*.xlsx).

On This Page
→ Report Description	→ Setup Required
→ Parameters	→ Report Fields
· Additional Required Setup: Supplier & Branch Properties	· Employee Detail = Yes
	· Employee Detail = No

Report Description

This report provides the data needed to comply with SB 1162.

California Pay Data Reporting | CRD

Setup Required

This AQ requires mapping to capture Column M for Job Category: https://avionteclassicsupport.zendesk.com/hc/en-us/articles/360045321534

Additional Required Setup: Supplier & Branch Properties

Name / Description	Location
NAICS Code*	Admin Tools > Employer > Supplier Property = OSHA NAICS Code
Major Activity*	Admin Tools > Employer > Branch > Branch Property = CA_EEO_PayData_Reporting_MajorActivity
Was a California Pay Data Report filed for this establishment last year?*	Admin Tools > Employer > Branch > Branch Property = CA_EEO_PayData_Reporting_CaliforniaFiledLastYear
Was an EEO-1 Report filed for this establishment last year?*	Admin Tools > Employer > Branch > Branch Property = CA_EEO_PayData_Reporting_ReportFiledLastYear
Is this establishment the employer's headquarters?*	Admin Tools > Employer > Branch > Branch Property = CA_EEO_PayData_Reporting_EmployersHeadquarter

Parameters

Parameter Name	Options	Description
Supplier	All Available Supplier List	Filters the supplier of the employee.
Branch	All Available Branch List	Filters the branch of the employee.
Date Type	Check Date, Accounting Period Date, Week Worked
Start Date		Pulls employees with payroll/checks within the snapshot period working under California worksites, or whose default branch address is in CA.
End Date
Transaction Type	All Available Taxable Transaction Type List	Filters the transaction type for transactions falling within the date range.
Ignore "Missing Info" Errors?	Yes or No	Yes — Only missing race, sex, and ethnicity are ignored; displays UU codes as required by CA. No — Displays errors and missing mapping data in the report.
Employee Detail	Yes or No	Yes — Displays the report per employee with their detail information. No — Displays the report per Branch, Job Category, Race/Ethnicity/Sex, and Pay Band.

Report Fields

Employee Detail = Yes

Field Name	Description	Note
Establishment Name	Employee's Branch
Address Line 1	Employee's Branch's Street 1
Address Line 2	Employee's Branch's Street 2
City	Employee's Branch's City
State	Employee's Branch's State
ZIP Code	Employee's Branch's Zip Code
NAICS Code	Value of the OSHA NAICS Code branch property
Major Activity	Value of the CA_EEO_PayData_Reporting_MajorActivity branch property
Employee ID	Employee's ID	Pulls employees with payroll/checks within the snapshot period working under California worksites, or whose default branch address is in CA.
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 with payroll at the Branch within the snapshot period.
Was a California Pay Data Report filed for this establishment last year?	Value of the CA_EEO_PayData_Reporting_CaliforniaFiledLastYear branch property
Was an EEO-1 Report filed for this establishment last year?	Value of the CA_EEO_PayData_Reporting_ReportFiledLastYear branch property
Is this establishment the employer's headquarters?	Value of the CA_EEO_PayData_Reporting_EmployersHeadquarter branch property
Job Category	Job Category. See the mapping.	https://avionteclassicsupport.zendesk.com/hc/en-us/articles/360045321534
Race*	Employee's race as reported for EEO purposes.
Race/Ethnicity/Sex	Race/Ethnicity/Gender Code. See the mapping.	The mapping is defined on the attached file.
Pay Band	Pay Band based on Taxable Gross for Medical employee wages for the year of the Start Date parameter. See the mapping.	The mapping is defined on the attached file.
Number of Employees	Total number of employees with payroll within the snapshot period by Branch, Job Category, Race/Ethnicity/Sex, and Pay Band.
Mean - Hourly Rate*	Calculated mean by Branch, Job Category, Race/Ethnicity/Sex, and Pay Band.
Median - Hourly Rate*	Calculated median by Branch, Job Category, Race/Ethnicity/Sex, and Pay Band.
Total Hours	Total hours worked by the employee for the year of the Start Date parameter.
Row-Level Clarifying Remarks	N/A

Employee Detail = No

Field Name	Description	Note
Establishment Name	Employee's Branch
Address Line 1	Branch's Street 1
Address Line 2	Branch's Street 2
City	Branch's City
State	Branch's State
ZIP Code	Branch's Zip Code
NAICS Code	Value of the OSHA NAICS Code branch property
Major Activity	Value of the CA_EEO_PayData_Reporting_MajorActivity branch property
Total Number of Employees at Establishment	Total number of employees with payroll at the Branch within the snapshot period.
Was a California Pay Data Report filed for this establishment last year?	Value of the CA_EEO_PayData_Reporting_CaliforniaFiledLastYear branch property
Was an EEO-1 Report filed for this establishment last year?	Value of the CA_EEO_PayData_Reporting_ReportFiledLastYear branch property
Is this establishment the employer's headquarters?	Value of the CA_EEO_PayData_Reporting_EmployersHeadquarter branch property
Job Category	Job Category. See the mapping.	https://avionteclassicsupport.zendesk.com/hc/en-us/articles/360045321534
Race*	Employee's race as reported for EEO purposes.
Race/Ethnicity/Sex	Race/Ethnicity/Gender Code. See the mapping.
Pay Band	Pay Band based on Taxable Gross for Medical employee wages for the year of the Start Date parameter. See the mapping.
Number of Employees	Total number of employees with payroll within the snapshot period by Branch, Job Category, Race/Ethnicity/Sex, and Pay Band.
Number of employees that do not work remotely*	Since remote workers are not tracked in Avionté, these fields will be blank. Manually add the information as needed.
Number of remote employees located within California*
Number of remote employees located outside California*
Total Hours	Total hours worked by the employee for the year of the Start Date parameter.
Row-Level Clarifying Remarks	N/A

Third-Party Link Disclaimer: These links are provided as a convenience and for informational purposes only; they do not constitute an endorsement or approval by the author of any 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 subsequent links. Contact the external site for answers to questions regarding its content.