<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)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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:Aptos;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@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="#467886" vlink="#96607D" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-ligatures:none">SFMS Datamart users,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:none"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:none">I understand that quite a few users work over the weekend during this busy time of the year. We would like to clarify how the Datamart works during the weekend load process.
</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">First, the weekly Datamart extract occurs Friday evening after the online SFMS system closes and the nightly batch cycle completes. Next, there is an upload process that starts on Saturday evening/Sunday morning. It is safe to run queries
in the Datamart during Saturday from 7am to 6pm. Outside of this timeframe the SFMS Datamart may be down due to the load process. The upload process does not complete until Sunday morning, at varying times. Finally, the data is validated on Monday morning
at 7am. If you plan to run any queries on Sunday, you do so at your <i>own risk</i>. The data is not validated, so please be aware of that fact.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Datamart Calendar example: <span style="mso-ligatures:none">
<img width="210" height="79" style="width:2.1833in;height:.825in" id="Picture_x0020_2" src="cid:image001.png@01DAE972.2155B6E0"></span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Important note: During the ‘extract’ and ‘upload’ processes, the SFMS Datamart is down; however, Workday Payroll information is still available. In addition, no matter what program you use to query the Datamart, during this load time, you
will not obtain SFMS data.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">To clarify, if you process a query successfully, during the weekend, you will not have the most up-to-date SFMS information until the upload is complete. For example, running a query Saturday morning will obtain the previous loaded data
and not the current week’s extract. In addition, if you ran a query on Sunday, after the upload was complete, you will not know if there was a problem with the load process, so pulling the data is at your
<i>own risk</i>. I highly recommend that you do not pull new data until the load is verified Monday morning.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Please let me know if you have any questions.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks for your understanding,<o:p></o:p></p>
<p class="MsoNormal"><span style="mso-ligatures:none">Aaron Wallace<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:none">Sr. Datamart Business Analyst<o:p></o:p></span></p>
</div>
</body>
</html>