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.

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

 

 

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