<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:"Book Antiqua";
panose-1:2 4 6 2 5 3 5 3 3 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;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Arial",sans-serif;
color:black;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Arial",sans-serif;
color:black;}
span.EmailStyle20
{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">New OSPS Datamart Table.<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">See below for the e-News from the Datamart team for details.<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">Thanks,<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:"Book Antiqua",serif;color:#1F497D">Matthew Riley, CPA<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:12.0pt;font-family:"Book Antiqua",serif;color:#A6A6A6">OSPS Application Analyst<o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-size:12.0pt;font-family:"Book Antiqua",serif;color:#A6A6A6">DAS | Oregon Statewide Payroll Services<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Book Antiqua",serif;color:#1F497D">(503) 373-0254 – direct<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Book Antiqua",serif;color:#1F497D">(503) 378-3518 – fax<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.0pt;font-family:"Times New Roman",serif;color:#BFBFBF"><a href="http://oregon.gov/DAS/Financial/payroll/Pages/index.aspx"><span style="font-size:11.0pt;color:#BFBFBF;text-decoration:none">http://oregon.gov/DAS/Financial/payroll/Pages/index.aspx</span></a></span><span style="font-family:"Times New Roman",serif;color:#BFBFBF"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><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 [mailto:datamart-news-bounces@listsmart.osl.state.or.us]
<b>On Behalf Of </b>Datamart Support * DAS<br>
<b>Sent:</b> Thursday, February 28, 2019 11:57 AM<br>
<b>To:</b> datamart-news@listsmart.osl.state.or.us<br>
<b>Subject:</b> [Datamart-News] New OSPS Datamart table<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We have migrated a new OSPS Datamart table to Production. Please feel free to check it out and let us know if any issues arise.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The new table is called: OSPS_Retirement<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The ‘OSPS Retirement’ table was created to provide historical data for various OSPA fields not contained on other OSPS Datamart tables, specifically the ‘Final Check Issued Date’, ‘Final Check Period End Date’ and the ‘Retirement Date’
from the P010 screen in OSPA.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">It includes the following fields:<o:p></o:p></p>
<p class="MsoNormal">Agency Number<o:p></o:p></p>
<p class="MsoNormal">Employee Name<o:p></o:p></p>
<p class="MsoNormal">Employee Number<o:p></o:p></p>
<p class="MsoNormal">Final Check Issued Date (from the P010 screen in OSPA)<o:p></o:p></p>
<p class="MsoNormal">Final Check Period End Date (from the P010 screen in OSPA)<o:p></o:p></p>
<p class="MsoNormal">Load Date<o:p></o:p></p>
<p class="MsoNormal">Retirement Date (from the P010 screen in OSPA)<o:p></o:p></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:black">Sample Hyperion query:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><img border="0" width="1053" height="726" id="Picture_x0020_1" src="cid:image002.jpg@01D4CF5C.B3B56F20" alt="cid:image001.png@01D4CDC9.46F503D0"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal">Aaron Wallace<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>