<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 12 (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:Tahoma;
panose-1:2 11 6 4 3 5 4 4 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.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Arial","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Times New Roman","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="font-family:"Times New Roman","serif";color:#1F497D">Good afternoon,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif";color:#1F497D">We wanted to share the information below on recent payroll Datamart updates/changes. Please follow the instructions to sync up these changes with your Datamart .oce.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif";color:#1F497D">Thank you,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif";color:#1F497D">Sandy
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman","serif";color:#1F497D">Sandy Ridderbusch, Oregon Statewide Payroll Services - (503) 373-0198<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman","serif";color:#1F497D">Visit Our Online Resource Center:
<a href="http://oregon.gov/DAS/EGS/FBS/OSPS/"><span style="color:#1F497D">http://oregon.gov/DAS/EGS/FBS/OSPS/</span></a></span><span style="color:#1F497D"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Datamart-News [mailto:datamart-news-bounces@listsmart.osl.state.or.us]
<b>On Behalf Of </b>Datamart Support * DAS<br>
<b>Sent:</b> Wednesday, May 28, 2014 9:13 AM<br>
<b>To:</b> datamart-news@listsmart.osl.state.or.us<br>
<b>Subject:</b> [Datamart-News] Datamart update (OSPS)<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">I wanted to pass along a few nice updates within the OSPS Datamart, which updated last night.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoListParagraph" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.75in;text-indent:-.25in">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">1-</span><span style="font-size:7.0pt;font-family:"Times New Roman","serif"">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">We have altered the ‘Auth Number’ field within the ‘OSPS Js Lab Adj’ Datamart tables to show as ‘Authno’. This alteration creates a consistency with the other tables/systems in the Datamart.
This change does not affect the data within this column; however, users <b><i><u>must</u></i></b> complete a ‘<i>Sync with Database</i>’ operation for the changes to take effect on queries created before this date.<o:p></o:p></span></p>
<p class="MsoListParagraph" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.75in;text-indent:-.25in">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">2-</span><span style="font-size:7.0pt;font-family:"Times New Roman","serif"">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Added a new field called ‘Authno’ to the OSPS_LABOR_COST tables.<o:p></o:p></span></p>
<p class="MsoListParagraph" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.75in;text-indent:-.25in">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">3-</span><span style="font-size:7.0pt;font-family:"Times New Roman","serif"">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Added a new field called ‘Authno’ to the OSPS_LV_ACCRUAL tables.<o:p></o:p></span></p>
<p class="MsoListParagraph" style="margin-left:.75in;text-indent:-.25in"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">4-</span><span style="font-size:7.0pt;font-family:"Times New Roman","serif"">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Added a new field called ‘Routing Num’ to the OSPS_DED tables.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Items two through four will be populated with data starting with the load on
<b>June 10</b>, which is for the ‘May’ Pay Period End run. The three new columns will show blank data for months prior to this date.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Note: To complete a ‘<i>Sync with Database</i>’ operation, you click on the ‘query’ section, then select the ‘DataModel’ menu and finally select ‘Sync with Database’ (if you
are not logged into the Datamart, it will request you log into an oce). <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Please let me know if you have any questions.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Aaron Wallace<o:p></o:p></span></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Sr. Datamart Business Analyst<o:p></o:p></span></i></p>
</div>
</body>
</html>