How do I extract my payroll data for pay data reporting?

You need to extract your hours, earnings, and total annual weeks worked info to the pay data report when:

  • You aren't an Oracle Cloud Global Payroll customer

  • You don't yet have payroll balances for the full calendar year

Otherwise, you can skip these steps.
  1. Extract the hours, earnings, and total annual weeks worked info from your third-party or legacy payroll application.

    Refer to the California Pay Data Reporting Portal User Guide for guidelines on what hours and earnings must be reported.

    For further info, see the DFEH website.

    Be sure to sum by person to their primary assignment (or the legacy application's equivalent).

  2. Perform any necessary configuration of these files to make them suitable for upload to the storage tables.

For further info, see Loading US Data Using HCM Data Loader (2558276.1) on My Oracle Support. This document includes a sample upload file to help you get started.