<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;}
/* 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:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle19
{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;}
/* List Definitions */
@list l0
{mso-list-id:1101147808;
mso-list-template-ids:-83201114;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level4
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level7
{mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1
{mso-list-id:1211767813;
mso-list-template-ids:1295025780;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></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:black">Thank you for your patience with this process. The Datamart is back up; however, we will be taking it down at 5pm today to resolve the ‘Invoice No’ field load issue.
<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">I will let you know if all loaded ok tomorrow. Thanks again for your patience.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<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>
<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> Tuesday, April 17, 2018 4:23 PM<br>
<b>To:</b> datamart-news@listsmart.osl.state.or.us<br>
<b>Subject:</b> [Datamart-News] 2018 SFMS Datamart Archive<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:black">Datamart Users,<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">To go along with the SFMS archive (shown below), the Datamart will also be archiving.
<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">On the evening of May 4, 2018, the SFMS Datamart will start the archive process. Currently, the SFMS information goes back to FY2009; however, after the archive process is complete (ending May 7), the Datamart
will contain data back to FY2013. <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">If your agency desires to keep the data that will be archived, please make plans to download the information to your internal networks. After this process, it will no longer be available through the Datamart.
<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">We plan to have the <b>SFMS Datamart down on May 7</b> and coming back up on
<b>May 8</b> (Tuesday). I will continue to send information over the news list and let you know as soon as the Datamart is up and running again.
<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">The OSPS Datamart will continue to be up and running, during the event.<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 for your patience.<o:p></o:p></span></p>
<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>
<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> SFMS-News [<a href="mailto:sfms-news-bounces@listsmart.osl.state.or.us">mailto:sfms-news-bounces@listsmart.osl.state.or.us</a>]
<b>On Behalf Of </b>PARK Alan * DAS<br>
<b>Sent:</b> Monday, April 16, 2018 1:41 PM<br>
<b>To:</b> Sfms-News@Listsmart. Osl. State. or. Us (<a href="mailto:sfms-news@listsmart.osl.state.or.us">sfms-news@listsmart.osl.state.or.us</a>) <<a href="mailto:sfms-news@listsmart.osl.state.or.us">sfms-news@listsmart.osl.state.or.us</a>><br>
<b>Subject:</b> [SFMS-News] 2018 Production Region Financial Archive<o:p></o:p></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">Hello everyone,<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">SFMA will be unavailable for transaction processing from Saturday May 5<sup>th</sup> through Monday, May 7<sup>th</sup>. This is to allow time to process the annual Financial
Archive for 2018. Because no warrants or SFMS ACHs can be entered during this time, we wanted to alert you well in advance so you can have your necessary payments done by Friday, May 4<sup>th.</sup>. More information on the potential impact of this is outlined
in details below.<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"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif">2018 Financial Archive Project<o:p></o:p></span></b></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">Our objective for this year’s Financial Archive project is to archive financial data, up to and including June 31, 2014<span style="color:blue">
</span>(Month 13). We will retain appropriate Capital Construction records consistent with the logic described under the Capital Construction section below. Our logic has been to maintain required information on SFMA, and provide historical data on the Datamart.<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">We will run the archive programs following the batch cycle on Friday, May 4<sup>th</sup>. SFMA will not be available for transaction entry through Monday, May 7<sup>th</sup>.
A delay in the normal ACH processing will only occur if we are unable to run a batch cycle on Monday, May 7<sup>th</sup>. If there is a delay in the batch cycle, SFMS will send additional information for making emergency payments. Some examples of the normal
processing times for ACH transactions are shown below:<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>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="margin-left:30.2pt;border-collapse:collapse">
<tbody>
<tr>
<td width="175" valign="top" style="width:131.4pt;border:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">ACH Written Date<o:p></o:p></span></p>
</td>
<td width="150" valign="top" style="width:112.4pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">Clearance Date<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="175" valign="top" style="width:131.4pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">Wednesday, May 2, 2018<o:p></o:p></span></p>
</td>
<td width="150" valign="top" style="width:112.4pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">Friday, May 4, 2018<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="175" valign="top" style="width:131.4pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">Thursday, May 3, 2018<o:p></o:p></span></p>
</td>
<td width="150" valign="top" style="width:112.4pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">Monday, May 7, 2018<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="175" valign="top" style="width:131.4pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">Friday, May 4, 2018<o:p></o:p></span></p>
</td>
<td width="150" valign="top" style="width:112.4pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">Tuesday, May 8, 2018<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<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">Any agency interface files received after the batch cycle on Friday, May 4<sup>th</sup> will be held until the financial archive verification is complete. We will also hold
any Treasury redemption, post and account files. No transactions will post until the archive has been verified. The IT file (530 screen) will be closed.<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">We will be monitoring the archive’s progress, and will send out an update Monday, May 7<sup>th</sup>. If we can bring the system up sooner than Tuesday, May 8<sup>th</sup>,
we will send the notice out on SFMS News.<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"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif">SFMA On-Line Screens<o:p></o:p></span></b></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">The following screens will be altered to read “NO RECORD FOUND OR FINANCIAL DATA ARCHIVED AS OF 06/31/2014 (MONTH 13)”:<o:p></o:p></span></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNormal" style="mso-list:l0 level1 lfo3"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">61 Agency Budget Financial Inquiry<o:p></o:p></span></li><li class="MsoNormal" style="mso-list:l0 level1 lfo3"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">62 Appropriation Financial Inquiry<o:p></o:p></span></li><li class="MsoNormal" style="mso-list:l0 level1 lfo3"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">63 Cash Control Financial Inquiry<o:p></o:p></span></li><li class="MsoNormal" style="mso-list:l0 level1 lfo3"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">66 Grant Financial Inquiry<o:p></o:p></span></li><li class="MsoNormal" style="mso-list:l0 level1 lfo3"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">69 Agency/Fund Record Inquiry<o:p></o:p></span></li><li class="MsoNormal" style="mso-list:l0 level1 lfo3"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">80 Project Financial Inquiry<o:p></o:p></span></li><li class="MsoNormal" style="mso-list:l0 level1 lfo3"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">86 Document Transaction Inquiry<o:p></o:p></span></li></ul>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif">SFMA Reports<o:p></o:p></span></b></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">No reports, other than for Capital Construction, are available for the archived period; therefore, SFMA reports are not affected by the archive project.<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"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Capital Construction<o:p></o:p></span></b></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">We will archive Capital Construction data consistent with our last archive in 2017. Capital Construction is determined by the Appropriated Fund. (If the third digit of the
Appropriated Fund is a “2,” it is Capital Construction.)<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>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="margin-left:9.9pt;border-collapse:collapse">
<tbody>
<tr>
<td width="130" valign="top" style="width:97.7pt;border:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">Appropriated Fund<o:p></o:p></span></p>
</td>
<td width="228" valign="top" style="width:171.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">Title<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="130" valign="top" style="width:97.7pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">3020<o:p></o:p></span></p>
</td>
<td width="228" valign="top" style="width:171.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">Other Funds Capital Construction<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="130" valign="top" style="width:97.7pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">4020<o:p></o:p></span></p>
</td>
<td width="228" valign="top" style="width:171.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">Lottery Funds Capital Construction<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="130" valign="top" style="width:97.7pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">6020<o:p></o:p></span></p>
</td>
<td width="228" valign="top" style="width:171.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">Federal Funds Capital Construction<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="130" valign="top" style="width:97.7pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">8020<o:p></o:p></span></p>
</td>
<td width="228" valign="top" style="width:171.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif">General Fund Capital Construction
<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<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">We have set up a profile for each agency that has Capital Construction based on the Effective End Date of the oldest CC appropriation. Please keep in mind that only one profile
was set up for each Capital Construction agency. The profile indicates the agency number, the first AY to retain and the range of FY’s to retain. All subsequent Capital Construction data will be retained. The list of Capital Construction profiles was sent
on SFMS News on March 6, 2018.<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">The Financial Tables are listed below with the archive requirements:<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"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Accounting Event (AE)<o:p></o:p></span></u></b></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">No Accounting Event records will be archived.<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"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Inactive Accounting Event (IAE)<o:p></o:p></span></u></b></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">We will archive FY 14 and prior, retaining Capital Construction data consistent with the logic described above.
<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"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Agency Fund<o:p></o:p></span></u></b></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">We will archive FY14. No Capital Construction data is retained. (This is not considered a critical financial table.)<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"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Allotment (Agency Budget)<o:p></o:p></span></u></b></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">We will archive FY 14 and prior, retaining Capital Construction data consistent with the logic described above.<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"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Appropriation<o:p></o:p></span></u></b></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">We will archive FY 14 and prior, retaining Capital Construction data consistent with the logic described above.<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"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Cash Control<o:p></o:p></span></u></b></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">We will archive FY14. No Capital Construction data is retained. (This is a critical table for the current transaction and loses its value as a historical record.)<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"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">General Ledger<o:p></o:p></span></u></b></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">We will archive FY 14 and prior, retaining Capital Construction data consistent with the logic described above.<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"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Summary General Ledger<o:p></o:p></span></u></b></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">We will archive FY 14 and prior, retaining Capital Construction data consistent with the logic described above.<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"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Summary General Ledger Document (used for drilldown purposes)<o:p></o:p></span></u></b></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">We will archive FY 14 and prior, retaining Capital Construction data consistent with the logic described above.<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"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Document Financial<o:p></o:p></span></u></b></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">Only closed Document Financial records with a zero balance and a close date of FY 14 and prior will be archived. Documents that meet the archive criteria are removed up through
the current fiscal year.<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">Capital Construction data will be retained on the Document Financial table. The identification of Capital Construction data via Appropriated Fund or D23 Fund is not available
on this table; therefore, we match the data on the AE and IAE to the identified fields on the Document Financial table. Fields used for the match include Department, Document Number (including suffix), Current Document Number (including suffix) and Reference
Document Number (including suffix).<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"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Document Summary (used for drilldown purposes)<o:p></o:p></span></u></b></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">We will archive FY 14 and prior, less Capital Construction data, for the Document Summary Allotment and Appropriation tables (Allotment – 61 screen, Appropriation – 62 screen).
The Capital Construction data is generated using the same table created for the Document Financial. If a document number contains both Retained Capital Construction and non-Capital Construction or Capital Construction to archive suffixes, the document number
will remain on the Document Summary screen. If a document was entered during FY 15, but the Effective Date was FY 14, the document number will remain on the Document Summary screen. In both scenarios there will not be further drill down on the archived document
suffix.<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"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Grant, Project and Contract<o:p></o:p></span></u></b></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">We will archive FY14. No Capital Construction data is retained. This information can be acquired by the AE or IAE record. Additionally, Fiscal Year 13 and Fiscal Year 14 records
for these tables are included in the Datamart when querying the Archived Datamart tables listed below:<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>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td width="276" valign="top" style="width:188.7pt;border:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">“Archived” Datamart tables<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="276" valign="top" style="width:188.7pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">SFMSARCH.ARCH_GRANT_FINANCIAL<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="276" valign="top" style="width:188.7pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">SFMSARCH.ARCH_PROJECT_FINANCIAL<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="276" valign="top" style="width:188.7pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">SFMSARCH.ARCH_CONTRACT_FINANCIAL<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Financial Archive Testing and Verification<o:p></o:p></span></b></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">SFMS staff is responsible for the archiving of data. We have done substantial testing and believe all requirements have been met. However, some of the tables can only be viewed
online to determine the accuracy of the archive. Although we have spent a lot of time and effort on the project, we are unable to specifically review the millions of online transactions and requestable reports. The majority of our work is done using logical
samples. Please let us know as soon as possible if you find any inconsistencies in your data after the archive is run.<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">It is our intention to have an effective, efficient and affordable system while allowing agency needs to be met. We are hopeful we have met these goals from the agencies’ perspective.<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">Thank you.</span><span style="font-size:12.0pt;font-family:"Arial",sans-serif"><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">Alan<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"><b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:navy">Alan C. Park</span></b><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:navy">Senior SFMS Analyst<br>
DAS – Financial Business Systems</span><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:navy">Statewide Financial Management Services
</span><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:navy">Phone 503-373-0262<br>
</span><a href="http://oregon.gov/DAS/Financial/AcctgSys/Pages/Index.aspx"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:blue">http://oregon.gov/DAS/Financial/AcctgSys/Pages/Index.aspx</span></a><span style="font-size:12.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black">Data Classification: Level 2 - Limited</span><o:p></o:p></p>
</div>
</body>
</html>