<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;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle18
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.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:955528544;
mso-list-type:hybrid;
mso-list-template-ids:-1374758628 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
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;}
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="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Datamart users,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We are moving forward with our Social Security Number (SSN) algorithm conversion project. The SSN’s within the SFMA system have now been converted to algorithm’s, so it is time to load this information into the Datamart.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Along with this weekend’s load, we will convert the SSN’s to algorithm’s within the Datamart. This will affect the ‘Accounting Event’ tables, as well as, the ‘Payment Control’ table.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Additional details from SFMS are described in the below email.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks and have a great day!<o:p></o:p></p>
<div>
<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"">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"><span style="color:#1F497D">____________________________<o:p></o:p></span></p>
<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""> sfms-news-bounces@listsmart.osl.state.or.us [mailto:sfms-news-bounces@listsmart.osl.state.or.us]
<b>On Behalf Of </b>PARK Alan * SCD SFMS<br>
<b>Sent:</b> Tuesday, September 04, 2012 10:40 AM<br>
<b>To:</b> sfms-news@listsmart.osl.state.or.us<br>
<b>Subject:</b> [SFMS-News] Social Security Numbers in SFMA<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Good morning everyone,<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 process of masking the Social Security Numbers (SSN) that were used as vendor numbers in SFMA has been a long, multi-step process. We are preparing for the next step on Saturday, September
8, 2012, after SFMA closes for the day.<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"">SFMA programmers will convert SSN vendor numbers to their “algorithm” number in the R*STARS and ADPICS financial tables. After the vendor number conversion occurred on October 17, 2011, new
transactions were posted to the financial tables using the “algorithm” number. However, all the transactions posted prior to October 17, 2011 still have the SSN vendor number on the financial tables. SFMS will verify that the conversion occurred as expected.
There should be no downtime for agencies.<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"">There are 17 ADPICS tables and eight R*STARS tables affected by this conversion.<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"">One major advantage of this conversion will be to streamline the process of querying on the R*STARS 85 screen (VENDOR TRANSACTION INQUIRY). Let’s look at an example using John Smith.<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"">John’s SSN is 123456789.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">John’s vendor number before the vendor algorithm conversion on 10/17/11 was 1123456789.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">John’s “algorithm” vendor number is 3678910004.<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"">John was paid on 10/11/11, 10/13/11 & 10/20/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"">In order to view all of John’s payments today, you would need to do two separate queries on the 85 screen:<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo2"><![if !supportLists]><span style="font-family:Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-family:"Arial","sans-serif"">Query #1 using John’s SSN vendor number<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo2"><![if !supportLists]><span style="font-family:Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-family:"Arial","sans-serif"">Query #2 using John’s algorithm vendor number<o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="551" style="width:413.5pt;margin-left:4.6pt;border-collapse:collapse">
<tbody>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border:solid windowtext 1.0pt;border-bottom:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black">S085 UC: 10 STATE OF OREGON 08/29/12 01:16 PM
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> LINK TO: VENDOR TRANSACTION INQUIRY PROD
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> PAGE 0001
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VEND NO/MC:
<span style="background:yellow;mso-highlight:yellow">1123456789</span> AGY: 100 DOC TYPE: VI INV#:
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VEND NAME: JOHN SMITH
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> REC TYPE: I APPR FUND: FUND: EFF DATE RANGE: 101011 TO 102111
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> <o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> DOC NO / SFX REF DOC/SFX INVOICE # TC PDT PMT- # DATE APPR DT
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> AP FUND FUND INDEX PCA AY COBJ AOBJ TRANS AMT R S
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VIW01103 001 2785566 DFP 0047072202 222 MA 122934803 101311 101311
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> 6400 6400 38100 31869 13 6950 8705 287.93
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VIW01104 001 2785574 DFP 0047091343 222 MA 122934803 101311 101311
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> 6400 6400 38100 31869 13 6950 8705 287.93
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VIW01101 001 2785624 DFP 0047093453 222 MA 122930753 101111 101111
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> 6400 6400 38100 31869 13 6950 8705 443.02
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VIW01102 001 2785678 DFP 0047132051 222 MA 122930753 101111 101111
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> 6400 6400 38100 31869 13 6950 8705 443.02
<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoListParagraph"><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="551" style="width:413.5pt;margin-left:4.6pt;border-collapse:collapse">
<tbody>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border:solid windowtext 1.0pt;border-bottom:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black">S085 UC: 10 STATE OF OREGON 08/29/12 01:26 PM
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> LINK TO: VENDOR TRANSACTION INQUIRY PROD
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> PAGE 0001
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VEND NO/MC:
<span style="background:yellow;mso-highlight:yellow">3678910004</span> AGY: 100 DOC TYPE: VI INV#:
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VEND NAME: JOHN SMITH
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> REC TYPE: I APPR FUND: FUND: EFF DATE RANGE: 101011 TO 102111
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> <o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> DOC NO / SFX REF DOC/SFX INVOICE # TC PDT PMT- # DATE APPR DT
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> AP FUND FUND INDEX PCA AY COBJ AOBJ TRANS AMT R S
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VIW01105 001 2784373 DFP 0047052015 222 MA 122943547 102011 102011
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> 6400 6400 38100 31869 13 6950 8703 650.00
<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<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"">After the conversion on Saturday, September 8, 2012, you will be able to see all five of John’s payments with just one query using his algorithm vendor number:<o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="551" style="width:413.5pt;margin-left:4.6pt;border-collapse:collapse">
<tbody>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border:solid windowtext 1.0pt;border-bottom:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black">S085 UC: 10 STATE OF OREGON 08/29/12 01:26 PM
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> LINK TO: VENDOR TRANSACTION INQUIRY PROD
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> PAGE 0001
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VEND NO/MC:
<span style="background:yellow;mso-highlight:yellow">3678910004</span> AGY: 100 DOC TYPE: VI INV#:
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VEND NAME: JOHN SMITH
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> REC TYPE: I APPR FUND: FUND: EFF DATE RANGE: 101011 TO 102111
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> <o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> DOC NO / SFX REF DOC/SFX INVOICE # TC PDT PMT- # DATE APPR DT
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> AP FUND FUND INDEX PCA AY COBJ AOBJ TRANS AMT R S
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VIW01105 001 2784373 DFP 0047052015 222 MA 122943547 102011 102011
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> 6400 6400 38100 31869 13 6950 8703 650.00
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VIW01103 001 2785566 DFP 0047072202 222 MA 122934803 101311 101311
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> 6400 6400 38100 31869 13 6950 8705 287.93
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VIW01104 001 2785574 DFP 0047091343 222 MA 122934803 101311 101311
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> 6400 6400 38100 31869 13 6950 8705 287.93
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VIW01101 001 2785624 DFP 0047093453 222 MA 122930753 101111 101111
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> 6400 6400 38100 31869 13 6950 8705 443.02
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> VIW01102 001 2785678 DFP 0047132051 222 MA 122930753 101111 101111
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="551" nowrap="" valign="bottom" style="width:413.5pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:black"> 6400 6400 38100 31869 13 6950 8705 443.02
<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<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"">Following the conversion of the vendor numbers in the financial tables, the next step in this process will be to run our Vendor Purge program. At this point, we have not established a date
to run the Vendor Purge in Production, but we will communicate that once it has been determined.<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"">Please let me know if you have any questions regarding the changes to take place this coming Saturday in Production.<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"">Thank you.<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-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://www.das.state.or.us/DAS/EGS/FBS/SFMS/Pages/index.aspx"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">http://www.das.state.or.us/DAS/EGS/FBS/SFMS/Pages/index.aspx</span></a><span style="font-family:"Arial","sans-serif""> </span><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><span style="font-size:12.0pt"> </span><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>