<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)">
<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;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Arial","sans-serif";
color:#44546A;}
.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">Forwarded on behalf of the Datamart Team:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">I want to thank those few brave users who sent in their Hyperion files. I was able to review, update, and load these files to the ‘Repository’. I highly recommend you check them out.<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">New File list: <o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><b><i><span style="color:black">OSPS – XREF96</span></i></b><span style="color:#1F497D"> – This is a representation of the XREF96 – Cost Distribution report. It’s a report that shows how payroll costs are allocated
to the different object codes.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><b><i><span style="color:black">OSPS -Time And Leave Balances</span></i></b><span style="color:#1F497D"> – This is an upgrade and replacement to the previous ‘OSPS - Monthly Timesheet’ Repository file. There are
two queries within the file and they provide a timesheet by employee, as well as, leave balance information for a pay period.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><b><i><span style="color:black">OSPS - FMLA/OFLA Hrs Used
</span></i></b><span style="color:#1F497D">– This is an upgrade and replacement to the previous ‘OSPS - Payroll FMLA’ Repository file. This file returns FMLA/OFLA hours used within a 12-month rolling period.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><b><i><span style="color:black">OSPS - VOE</span></i></b><span style="color:#1F497D"> – This file provides a salary breakdown for ‘Verification of Employment’ requests. The file’s two queries provide a full view
of the Datamart.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><b><i><span style="color:black">OSPS - OSHA 300</span></i></b><span style="color:#1F497D"> – This file is used to provide counts to HR for annual OSHA report.</span><b><i><span style="color:black"><o:p></o:p></span></i></b></p>
<p class="MsoNormal" style="text-indent:.5in"><b><i><span style="color:black">OSPS - LAR Report</span></i></b><span style="color:#1F497D"> – This file, if run monthly, will provide ‘Leave Accrual Report’ data for managers in a spreadsheet format.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><b><i><span style="color:black">OSPS - PERS LWOP Report</span></i></b><span style="color:#1F497D"> – This file provides what hours are used and how much money is paid for a month when PERS requests salary breakdowns.<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">As you may have noticed, I only received queries from OSPS users. However, I would love to see more files come in, especially from
<i>RSTARS</i> users. <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">Please send in any queries/files you think could help. Even if you are not 100% sure they are the best queries, I am willing to work on them for you and make sure they are of the highest standards. Together we
can create a great product for many users to enjoy.<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">If you have any suggestions for improvement to the current Repository reports, please let me know by emailing ‘Datamart.Support@state.or.us’.<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 for all your submissions,<o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">Aaron Wallace<o:p></o:p></span></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">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 [<a href="mailto:datamart-news-bounces@listsmart.osl.state.or.us">mailto:datamart-news-bounces@listsmart.osl.state.or.us</a>]
<b>On Behalf Of </b>Datamart Support<br>
<b>Sent:</b> Tuesday, November 12, 2013 3:00 PM<br>
<b>To:</b> <a href="mailto:datamart-news@listsmart.osl.state.or.us">datamart-news@listsmart.osl.state.or.us</a><br>
<b>Subject:</b> [Datamart-News] Call for new Repository files<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The Datamart team is always on the lookout for new queries, which we could share on a statewide level. We are able to share files by using the ‘Repository’(Instructions:
<a href="http://cms.oregon.egov.com/DAS/EGS/FBS/Pages/datamart.aspx#Reports_Repository">
http://cms.oregon.egov.com/DAS/EGS/FBS/Pages/datamart.aspx#Reports_Repository</a>), which all Datamart users have access. However, we are unable to provide you with new reports unless experts, such as yourselves, send us these files.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am asking for any and all queries that we might be able to share on a statewide level. We are looking for files that pull ‘Cash balances’, ‘Accounts Receivables’, ‘Accounts Payable’, Grants, Budget, Payroll, or other. We will accept anything
that is not currently on the ‘Repository’.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Currently, on the ‘Repository’, we have 35+ files ready for your use. However, I want to really increase that number but again I cannot do that without your help.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am willing to work with you to put these files on the ‘Repository’, so that many people can benefit from your expertise. Please go out to the ‘Repository’ and view what we currently have, then send in any queries that could expand our
topics. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks for your help,<o:p></o:p></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>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>