<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:National2;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:black">OBIEE Workday users:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">There has been a lot of concern and confusion around the new Workday information. One of the main topics is ‘How best to pull and filter the data’. I wanted to assure you that DAS FBS is hard at work to help users
with this issue. We have multiple teams working on creating some helpful reports in OBIEE. Once complete, I plan to load them to the OBIEE repository.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">We do not have an estimated completion date; however, I assure you we are working hard to help all users with this information.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">We will keep you posted on any updates or changes as soon as it is available.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">Thanks for your patience and understanding,<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:black">Aaron Wallace<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Sr. Datamart Business Analyst<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Datamart-News <datamart-news-bounces@omls.oregon.gov>
<b>On Behalf Of </b>WALLACE Aaron * DAS via Datamart-News<br>
<b>Sent:</b> Thursday, January 19, 2023 12:42 PM<br>
<b>To:</b> datamart-news@omls.oregon.gov<br>
<b>Subject:</b> [Datamart-News] Workday Payroll Datamart Tables/Queries<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:black">Payroll/Workday users,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">We wanted to clarify how Workday Payroll Datamart data is stored compared to OSPA Datamart data. In addition, how to filter effectively so that you are able to compare Workday data with SFMS data.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">Per the Workday (WD) team, the new system does not process pay the same way that OSPA did in regards to pay period dates associated with Run 1 and Run 2. Unlike OSPA, which closed the pay period after Run 2, the
pay period in WD is closes after Run 1, so the December period closed when WD payroll ran December Run 1 on December 28<sup>th</sup>. Any adjustments made to the December pay period after that closed date are then considered “retro” entries and are processed
in the open pay period; in this case January. Therefore, if it is Dec Run 2, it is a “retro” to the December pay period and the data comes over to SFMA with a 01/31/#### pay period date, but may still have a 12/31/#### effective date. Take note, there will
be a “retro period” assigned to those entries that will reflect December dates though, with one caveat.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">The way that retro-active entries are processed in WD, for instance adding OT that wasn’t paid on the December pay period, will show as results for the January pay period, with a December retro period, but the
incremental employer taxes will be calculated in January and will never have the retro period associated with it. <b>WD does not calculate taxes retroactively</b>. Those data rows will have a January pay period and a blank retro period.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">In order to isolate Run 1 and Run 2 data, the key is going to be to filter by the ‘report effective date’. This is the date the data was loaded into OBIEE. All the results from the mid-January effective date (1/11/23)
would be for corrections to December, or for January pay for a term employee (typical Run 1 fair). Since December is closed, WD can’t calculate results with a regular period end date of 12/31, it just doesn’t work that way. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">Again, with some exceptions, if users’ filter by the ‘report effective date’, it will match SFMS, since WD generates the Datamart reports and the SFMA reports using the same completion dates from WD. Also, now
that WD is loading two times a month, users can filter by the ‘report effective date’ to see all the data that was loaded for a specific run. You are able to verify the two runs, during a month, on the Workday or Datamart calendars, on the respective websites.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="color:black">If you have additional questions about WD data, please contact WD support.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Aaron Wallace<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Sr Datamart Business Analyst</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>