How do I generate the Regional Pay Data Report?

Use the Regional Pay Data Report to extract the California pay data from the storage table and consolidate it with the HR EEO-1 data for delivery to the DFEH.

Run this flow each year according to California's reporting requirements.

For further info, see Regional Pay Data Report for the US.

This flow creates the following reports for the California Pay Data Report.

Output report

How you use it

CSV upload file

This is the file you submit to the DFEH.

Audit report

This CSV file contains diagnostic info in pages organized by:

  • Number of Employees

  • Number of Hours

Use this file to reconcile employee counts by their race, ethnicity, sex, job category, pay band, and hours.

Exception report

This PDF file contains any errors captured during the flow run, such as missing ethnicity info, missing gender, and so on.

Employee detail report

This CSV file contains the regional pay data info, sorted by employee.

Use this file to confirm each employee’s pay data, including their total for hours and earnings.