<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=utf-8">
<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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Arial",sans-serif;
font-variant:normal !important;
color:black;
text-transform:none;
font-weight:normal;
font-style:normal;
text-decoration:none none;
vertical-align:baseline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.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">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Good morning,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">The change indicated in the eNews below was implemented last night without any issues. You may build new queries using updated tables. If you have any saved queries you will need to remove the extension in
order for it to process.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">The repository queries will be updated next week.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Thank you, <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2F1444">Geri Greeno-Sanders<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2F1444">OSPS Senior System Analyst<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2F1444">DAS/EGS/FBS/Oregon Statewide Payroll Services<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2F1444">(503) 373-0259 – direct<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2F1444">(503) 378-3518 – fax
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#271137"><a href="mailto:geri.l.greeno-sanders@oregon.gov">geri.l.greeno-sanders@oregon.gov</a>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:#1F497D"><a href="http://www.oregon.gov/DAS/Financial/payroll/Pages/index.aspx">www.oregon.gov/DAS/Financial/payroll/Pages/index.aspx</a>
<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">-----Original Message-----<br>
<b>From:</b> Datamart Support * DAS [<a href="mailto:Datamart.Support@oregon.gov">mailto:Datamart.Support@oregon.gov</a>];
<br>
<b>Sent:</b> 8/3/2017 4:23:51 PM<br>
<b>To:</b> <a href="mailto:datamart-news@listsmart.osl.state.or.us">datamart-news@listsmart.osl.state.or.us</a> [<a href="mailto:datamart-news@listsmart.osl.state.or.us">mailto:datamart-news@listsmart.osl.state.or.us</a>];
<br>
<b>Subject:</b> [Datamart-News] OSPS Datamart (upcoming changes)<span style="font-size:12.0pt;font-family:"Times New Roman",serif"><o:p></o:p></span></p>
<div>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">It has been determined that there is no longer a need to cut up the OSPS Datamart tables into four separate views. In the best interest of the user as well as the Datamart, we will
be eliminating the three extra file extension views (_B, _PB, and _PP) within OSPS.
<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">Going forward, there will be only one OSPS Datamart table for each view of the OSPS data and will contain no extension. The data in each table (listed below) will contain the full
information of the OSPS Datamart. <o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">Updated OSPS table names (starting
<i>Aug 11, 2017</i> – July payroll load):<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">OSPS_Ded – 07/01/11 to 06/30/19<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">OSPS_Js_Lab_Adj – 07/01/11 to 06/30/19<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">OSPS_Labor_Cost – 07/01/11 to 06/30/19<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">OSPS_Lv_Accrual – 07/01/11 to 06/30/19<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">OSPS_Net_Pay – 07/01/11 to 06/30/19<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">OSPS_Work_Sched – (will not change)<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">It will be important to update your queries that are using the old file extensions (_B, _PB, and _PP). These queries must be updated to point to the OSPS table with no file extension.
Make sure to go into the properties of the table (double click on the top of the table) and alter the ‘physical name’ to contain no extension.
</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">With this change, it has become more important to make sure each OSPS query has
<i>at least two filters</i>. One is ‘Agency’ and the other is a time period such as ‘Pay Period End’, ‘Pay Proc Date’, etc. These two filters will allow your query to run at its’ optimal level.
<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">The move to the new view of the OSPS Datamart will occur with the transition of the biennial date change on
<b>Aug 11, 2017</b>. </span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">Please email Datamart Support, if you have any questions.
<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">Aaron Wallace<o:p></o:p></span></p>
<p><i><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">Sr. Datamart Business Analyst<o:p></o:p></span></i></p>
<p><o:p> </o:p></p>
</div>
</div>
</body>
</html>