--- title: "CA Pay Data Report for Employee" slug: "ca-pay-data-report-for-employee" updated: 2026-04-24T10:54:21Z published: 2026-04-24T10:54:21Z canonical: "zenoplesupport.aqore.com/ca-pay-data-report-for-employee" --- > ## Documentation Index > Fetch the complete documentation index at: https://zenoplesupport.aqore.com/llms.txt > Use this file to discover all available pages before exploring further. # CA Pay Data Report for Employee #### Overview California's Pay Data Reporting law (SB 973 / SB 1162) requires covered employers to submit annual pay equity data to the California Civil Rights Department (CRD). The CA Pay Data (Employee) report is a compliance report that organizes your employee payroll data in the exact format required for that submission. The report groups employees by establishment, job category, race/ethnicity/sex, pay band, exemption status, and employment type, and calculates required metrics such as mean and median hourly rates, total annual hours worked, and remote vs. on-site employee counts. #### Who This Applies To Organizations with employees who work in California and are subject to CA SB 1162 pay data reporting requirements. #### How to Access Navigate to **Reports** and search for **CA Pay Data (Employee)**. #### Report Parameters | **Parameter** | **Description** | **Required** | | --- | --- | --- | | Reporting Year | The calendar year for which pay data is being reported (e.g., 2024) | Yes | | Accounting Period From | The start date of the pay period range to include within the reporting year | Yes | | Accounting Period To | The end date of the pay period range to include within the reporting year | Yes | | Company | Filter results to one or more companies. Defaults to all companies the user has access to | No | | Office | Filter results to one or more offices. Defaults to all offices (child filter of Company) | No | | State | Filter results to a specific state. Defaults to all states | No | #### Report Columns | **Column** | **Description** | **Logic / Notes** | | --- | --- | --- | | Establishment Name | The name of the employer's establishment or worksite location | Sourced from the office establishment record | | Address Line 1 | First line of the establishment's street address | | | Address Line 2 | Second line of the establishment's street address | Blank if not applicable | | City | City where the establishment is located | | | State | State where the establishment is located | | | Zip Code | ZIP code of the establishment | | | NAICS Code | North American Industry Classification System code identifying the establishment's industry | Assigned through the organization's custom field settings | | Major Activity | A plain-language description of the establishment's primary business activity | | | Total Number of CA Payroll Employees at Est | Total count of distinct employees at this establishment during the reporting year | Counts unique individuals — not headcount per pay period | | Was Prior Year CA Report Filed? | Indicates whether a CA Pay Data report was submitted to the CRD for the previous year | "Yes" or "No" | | Is this Est the Employer's Headquarters? | Indicates whether this establishment is the employer's main headquarters location | "Yes" if the establishment address matches the job site address on record; "No" otherwise | | Job Category | The EEO-1 job category assigned to the employees in this group | E.g., Executive/Senior Officials, Professionals, Technicians, Sales Workers, Administrative Support, Craft Workers, Operatives, Laborers & Helpers, Service Workers | | Race/Ethnicity/Sex | Coded combination of the employee group's race/ethnicity and gender, formatted per CA Pay Data reporting standards | **H10/H20** = Hispanic or Latino Male/Female; **W10/W20** = White (Non-Hispanic) Male/Female; **B10/B20** = Black or African American Male/Female; **A10/A20** = Asian Male/Female; **A30/A40** = Native Hawaiian or Pacific Islander Male/Female; **A50/A60** = Two or More Races Male/Female; **A70** = additional Asian/Pacific Islander variant; **D10–D70** = Non-Binary variants matching the same ethnic categories in the same order; **U10/U20** = Unknown, Other, or Do Not Wish to Answer Male/Female; **UU** = fallback when both race and gender cannot be resolved | | Pay Band | The California-defined annual pay band range this employee group falls into | Salary ranges defined by the CA Civil Rights Department | | Exemption Status | Whether employees in this group are classified as Exempt or Non-Exempt under the Fair Labor Standards Act (FLSA) | | | Employment Type | The employment classification for this group | "Full-Time", "Part-Time", or "Intermittent". Note: employees classified internally as "Seasonal" are automatically reported as "Intermittent" to comply with CA reporting requirements | | Total CA Employees in This Employee Group | The total number of employees in this specific reporting group (same establishment + job category + race/sex + pay band + exemption + employment type) | Calculated as: Remote employees within CA + Worksite employees + Remote employees outside CA | | Total Annual Hours Worked | Total payroll hours worked by this employee group during the reporting year | Aggregated from payroll transaction records within the selected accounting period range | | Total Annual Weeks Worked | Total number of distinct pay periods during which this employee group received pay in the reporting year | Counted as unique accounting period IDs from payroll transaction records | | Mean Hourly Rate | The average hourly pay rate across all employees in this group | Calculated from individual pay rate records for all employees in the group | | Median Hourly Rate | The middle-value hourly pay rate within this group | The midpoint of all hourly pay rates in the group when sorted from lowest to highest | | Number of Remote CA Employees Located Within CA | Count of employees who work remotely and whose home address is also in California | Remote workers whose assigned job site state is CA and whose home/resident address state is also CA | | Number of CA Employees That Do Not Work Remotely | Count of employees who physically report to a worksite | Employees who are assigned to and work at a physical job site location | | Number of Remote CA Employees Located Outside CA | Count of employees who are assigned to a CA job site but work remotely from outside California | Remote workers whose assigned job site state is CA but whose home/resident address state is not CA | | Row Level Clarifying Remarks | Optional free-text field for any additional explanations or clarifications about the data in this row | Left blank by default; can be filled in manually before the report is submitted to the CRD |