Skip to Main Content
Return to Navigation

PeopleSoft Workforce Analytics Process Flow

This section lists the steps to set up workforce analytic applications:

  1. Import internal source data to OWS tables using Extract, Transform, and Load (ETL).

  2. Review data warehouse tables that are delivered with the system.

  3. Design and set up workforce-related trees.

  4. Perform workforce-related dimension and tree node mapping.

  5. Use ETL to load the OWE tables.

  6. Review and edit data for D00s and R00s.

  7. Review and modify the flat file definitions, data warehouse tables, and delivered ETL jobs for external survey data.

    The remaining steps from here to the end of this list apply to HCM Warehouse and Workforce Rewards. External survey data is currently not incorporated into Workforce Planning.

  8. Run the ETL jobs to populate the survey data warehouse tables and the survey mapping definition tables.

  9. Review and edit the data in the survey data warehouse tables.

  10. Complete survey mapping definition pages prior to running a Load ETL batch.

  11. Review the survey mappings.

  12. Run the next set of ETL jobs as needed.