Standard AQ - California Pay Data

Requires a private employer of at least 100 employees to file a Payroll Employee Report regardless of whether the employer files a federal EEO-1 report for the prior calendar year (2022). This report was created based on the specifications provided by California.

• Click here to download the Spreadsheet

Report will export as an Excel Workbook - ensure Save As Type = Workbook (*.xlsx). 

Report Description

This report provides the necessary data 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 the employee that have payroll/checks within the snapshot period/date range working under worksites of CA states or if the employee has default branch's address in CA.
End Date
Transaction Type	All Available taxable Transaction Type List	Filters the transaction type of the transactions that fall under the date range passed.
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.
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 OSHA NAICS Code branch property
Major Activity	Value of CA_EEO_PayData_Reporting_MajorActivity branch property
Employee ID	Employee's ID	Pulls the employee that have payroll/checks within the snapshot period/date range working under worksites of CA states or if the employee has default branch's address 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 having payroll at the Branch within snapshot period
Was a California Pay Data Report filed for this establishment last year?	Value of CA_EEO_PayData_Reporting_CaliforniaFiledLastYear branch property
Was an EEO-1 Report filed for this establishment last year?	Value of CA_EEO_PayData_Reporting_ReportFiledLastYear branch property
Is this establishment the employer's headquarters?	Value of CA_EEO_PayData_Reporting_EmployersHeadquarter branch property
Job Category	Job Category. See the mapping	https://avionteclassicsupport.zendesk.com/hc/en-us/articles/360045321534
Race/Ethnicity/Sex	Race Ethnicity Gender Code. See the mapping	The mapping is defined on attached file
Pay Band	Pay Band as per their Taxable Gross for Medical employee Wages for the year of start date. See the mapping	The mapping is defined on attached file
Number of Employees	Total Number of Employees having payroll within snapshot period by Branch, Job Category, Race/Ethnicity/Sex, and Pay Band
Mean - Hourly Rate*	Calculated Mean as per Branch, Job Category, Race/Ethnicity/Sex, and Pay Band
Median - Hourly Rate*	Calculated Median as per Branch, Job Category, Race/Ethnicity/Sex, and Pay Band
Total Hours	Total Hours of work done by the employee for the year of start date
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 OSHA NAICS Code branch property
Major Activity	Value of CA_EEO_PayData_Reporting_MajorActivity branch property
Total Number of Employees at Establishment	Total Number of Employees having payroll at the Branch within snapshot period
Was a California Pay Data Report filed for this establishment last year?	Value of CA_EEO_PayData_Reporting_CaliforniaFiledLastYear branch property
Was an EEO-1 Report filed for this establishment last year?	Value of CA_EEO_PayData_Reporting_ReportFiledLastYear branch property
Is this establishment the employer's headquarters?	Value of CA_EEO_PayData_Reporting_EmployersHeadquarter branch property
Job Category	Job Category. See the mapping	https://avionteclassicsupport.zendesk.com/hc/en-us/articles/360045321534
Race/Ethnicity/Sex	Race Ethnicity Gender Code. See the mapping	The mapping is defined on attached file, not sure how we would mention here
Pay Band	Pay Band as per their Taxable Gross for Medical employee Wages for the year of start date. See the mapping	The mapping is defined on attached file, not sure how we would mention here
Number of Employees	Total Number of Employees having payroll within snapshot period by Branch, Job Category, Race/Ethnicity/Sex, and Pay Band
Number of employees that do not work remotely*	Since we don't track remote workers in Avionte, there will be no data in these fields. Therefore, we suggest manually adding the information as necessary.
Number of remote employees located within California*
Number of remote employees located outside California*
Total Hours	Total Hours of work done by the employee for the year of start date
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.