[Datamart-News] Workday hours (questions)

[Datamart Support * DAS]

Workday Payroll users (only),

We wanted to reach out and obtain your opinion on the below update (see Datamart news email below).

The recent update effected how the hours were displayed in the 'Workday - Time Calculated' subject area/table. Previously, it was 'run1 plus run2 equals a full month of hours; however, with the update, run2 has changed and currently contains the full month of hours, therefore no longer having run1 plus run2 equally a month.

Please briefly answer each question which relates to these changes and reply to 'Datamart.support at das.oregon.gov'.


  1.  Do you need to create reports that can split out run1 and run2 hours separately? Would this be helpful?

  2.  Since run2 includes all hourly data for the month, are you running reports with only run2 'Rpt Effective date'?

  3.  Have you used the OBIEE repository report file called 'Workday Time Calculated'? (Yes/No). If yes, has it provided the info you need?

  4.  Are there other Workday reports that could be helpful that are not currently in the OBIEE repository (please describe in detail)?

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst

From: Datamart-News <datamart-news-bounces at omls.oregon.gov> On Behalf Of WALLACE Aaron * DAS via Datamart-News
Sent: Tuesday, June 27, 2023 3:05 PM
To: datamart-news at omls.oregon.gov
Subject: [Datamart-News] Workday hours (update)

Workday Datamart users,

It has come to our attention that the Workday hours were not loading to the Datamart as expected. The Workday team has worked to improve the coding and fixed the way 'hours' are loaded. My tech support has now reloaded all the hour information back to the beginning of Workday payroll.

You will now find the run1 information to include hours through the specific monthly 'Rpt Effective Date' and the run2 data will display all hours through the end of the month, which includes run1. Therefore, you will want to filter to only run2 data once it has loaded.

We are currently working with the Workday team to determine if this will be the way we load hours going forward.

Thanks for your patience and understanding,
Aaron Wallace
Sr. Datamart Business Analyst

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20230914/ba7cceb3/attachment.html>