<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:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal;
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="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:black">The below OSPS biennial date change project was a success. All the OSPS Datamart tables have been updated for the new biennium.<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 addition, a new field called ‘<b><i>Overtime Pay Ind</i></b>’ has been added to the ‘<b><i>OSPS Js Lab Adj</i></b>’ Datamart tables. This field will only contain data in the latest biennium; however, the field
will be shown in all ‘OSPS Js Lab Adj’ tables. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="color:black">The OSPA’s reference manual (see payroll website) has some detailed information about the Overtime column from the PTB2 screen. The PTB2 screen is the benefit package table. It lists
the different pay codes available in a benefit package.<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="color:black">OT Pay Indicator (under T on reference manual):<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="color:black">Used to calculate the FLSA regular rate of pay for the calculation of overtime.<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="color:black">Possible values include:<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="color:black">B = FLSA subject dollars and hours<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="color:black">D = FLSA subject dollars<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="color:black">N = neither dollars nor hours are FLSA subject<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="color:black">O = FLSA subject hours, paid at recalculated overtime rate<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">P = Paid according to the O/T MLT or the RATE UNIT rate on the PTB2 screen<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,<o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Aaron Wallace<o:p></o:p></span></p>
<p class="MsoNormal"><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>
</div>
</div>
<p class="MsoNormal"><span style="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-bounces@listsmart.osl.state.or.us [mailto:datamart-news-bounces@listsmart.osl.state.or.us]
<b>On Behalf Of </b>Datamart Support<br>
<b>Sent:</b> Tuesday, July 02, 2013 1:12 PM<br>
<b>To:</b> datamart-news@listsmart.osl.state.or.us<br>
<b>Subject:</b> [Datamart-News] OPSA Datamart data update (Biennium related)<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Due to the biennium change, the Datamart team will update the OSPA Datamart to keep the tables up-to-date with the appropriate range of data.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">The following shows the current date range and the soon to be updated date range:
<br>
<u><br>
Current OSPA Datamart tables:</u><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""><br>
Blank - 7/1/11 to 6/30/13<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">_B - 7/1/09 to 6/30/13<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">_PB - 7/1/09 to 6/30/11<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">_PP - 7/1/05 to 6/30/09<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><u><span style="font-family:"Arial","sans-serif"">Updated OSPA Datamart tables:<o:p></o:p></span></u></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Blank - 7/1/13 to 6/30/15<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">_B - 7/1/11 to 6/30/15<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">_PB - 7/1/11 to 6/30/13<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">_PP - 7/1/07 to 6/30/11<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">This change will take effect with the July 2013 OSPA Datamart load, which occurs on
<b><i>August 13, 2013</i></b>. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">We have provided you with almost a month and a half to download OSPA data from 7/1/05 – 6/30/07 and save to your agency’s network, if so desired, because after August 13, 2013 this data will
no longer be available on the Datamart.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Thanks,<o:p></o:p></span></p>
<div>
<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>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Department of Administrative Services<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial","sans-serif"">Data Classification: Level 1 - Published<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>