<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:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:black;
font-weight:normal;
font-style:normal;}
.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" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Cambria",serif">Datamart Payroll partners,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Cambria",serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Cambria",serif">We have completed a work request that created a new table in the Datamart. The name of the table is the following:
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Cambria",serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Cambria",serif">OSPSPUSR.OSPS_LV_CLEARING_ACCOUNT_BALANCE<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Cambria",serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Cambria",serif">This table can be used to find any leave balances that were moved into the clearing account (P420) in OSPA. This data will not change as OSPA is no longer being updated, as of the end of December
2022. For most this will be a tool to help with employees who left state service prior to Workday going live in December 2022 or left state service in December 2022. If an employee returns, you can use this table to see if there are any leave balances that
would need to be restored, typically sick leave, as part of the re-hire process. In addition, for PERS purposes you can also see leave balances the employee had when they retired.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Cambria",serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Cambria",serif">Also, in OBIEE, you will see the new OSPS subject area: OSPS – Leave Clearing Account Balance.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Cambria",serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Cambria",serif;color:black">Thanks,<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:black">Aaron Wallace<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Sr. Datamart Business Analyst<o:p></o:p></span></p>
</div>
</div>
</body>
</html>