[Datamart-News] Datamart SSN project update...
Datamart Support
datamart.support at state.or.us
Wed Sep 12 09:36:58 PDT 2012
Datamart users,
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.
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.
Additional details from SFMS are described in the below email.
Thanks and have a great day!
Aaron Wallace
Sr. Datamart Business Analyst
Department of Administrative Services
Data Classification: Level 1 - Published
____________________________
From: sfms-news-bounces at listsmart.osl.state.or.us [mailto:sfms-news-bounces at listsmart.osl.state.or.us] On Behalf Of PARK Alan * SCD SFMS
Sent: Tuesday, September 04, 2012 10:40 AM
To: sfms-news at listsmart.osl.state.or.us
Subject: [SFMS-News] Social Security Numbers in SFMA
Good morning everyone,
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.
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.
There are 17 ADPICS tables and eight R*STARS tables affected by this conversion.
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.
John's SSN is 123456789.
John's vendor number before the vendor algorithm conversion on 10/17/11 was 1123456789.
John's "algorithm" vendor number is 3678910004.
John was paid on 10/11/11, 10/13/11 & 10/20/11.
In order to view all of John's payments today, you would need to do two separate queries on the 85 screen:
* Query #1 using John's SSN vendor number
* Query #2 using John's algorithm vendor number
S085 UC: 10 STATE OF OREGON 08/29/12 01:16 PM
LINK TO: VENDOR TRANSACTION INQUIRY PROD
PAGE 0001
VEND NO/MC: 1123456789 AGY: 100 DOC TYPE: VI INV#:
VEND NAME: JOHN SMITH
REC TYPE: I APPR FUND: FUND: EFF DATE RANGE: 101011 TO 102111
DOC NO / SFX REF DOC/SFX INVOICE # TC PDT PMT- # DATE APPR DT
AP FUND FUND INDEX PCA AY COBJ AOBJ TRANS AMT R S
VIW01103 001 2785566 DFP 0047072202 222 MA 122934803 101311 101311
6400 6400 38100 31869 13 6950 8705 287.93
VIW01104 001 2785574 DFP 0047091343 222 MA 122934803 101311 101311
6400 6400 38100 31869 13 6950 8705 287.93
VIW01101 001 2785624 DFP 0047093453 222 MA 122930753 101111 101111
6400 6400 38100 31869 13 6950 8705 443.02
VIW01102 001 2785678 DFP 0047132051 222 MA 122930753 101111 101111
6400 6400 38100 31869 13 6950 8705 443.02
S085 UC: 10 STATE OF OREGON 08/29/12 01:26 PM
LINK TO: VENDOR TRANSACTION INQUIRY PROD
PAGE 0001
VEND NO/MC: 3678910004 AGY: 100 DOC TYPE: VI INV#:
VEND NAME: JOHN SMITH
REC TYPE: I APPR FUND: FUND: EFF DATE RANGE: 101011 TO 102111
DOC NO / SFX REF DOC/SFX INVOICE # TC PDT PMT- # DATE APPR DT
AP FUND FUND INDEX PCA AY COBJ AOBJ TRANS AMT R S
VIW01105 001 2784373 DFP 0047052015 222 MA 122943547 102011 102011
6400 6400 38100 31869 13 6950 8703 650.00
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:
S085 UC: 10 STATE OF OREGON 08/29/12 01:26 PM
LINK TO: VENDOR TRANSACTION INQUIRY PROD
PAGE 0001
VEND NO/MC: 3678910004 AGY: 100 DOC TYPE: VI INV#:
VEND NAME: JOHN SMITH
REC TYPE: I APPR FUND: FUND: EFF DATE RANGE: 101011 TO 102111
DOC NO / SFX REF DOC/SFX INVOICE # TC PDT PMT- # DATE APPR DT
AP FUND FUND INDEX PCA AY COBJ AOBJ TRANS AMT R S
VIW01105 001 2784373 DFP 0047052015 222 MA 122943547 102011 102011
6400 6400 38100 31869 13 6950 8703 650.00
VIW01103 001 2785566 DFP 0047072202 222 MA 122934803 101311 101311
6400 6400 38100 31869 13 6950 8705 287.93
VIW01104 001 2785574 DFP 0047091343 222 MA 122934803 101311 101311
6400 6400 38100 31869 13 6950 8705 287.93
VIW01101 001 2785624 DFP 0047093453 222 MA 122930753 101111 101111
6400 6400 38100 31869 13 6950 8705 443.02
VIW01102 001 2785678 DFP 0047132051 222 MA 122930753 101111 101111
6400 6400 38100 31869 13 6950 8705 443.02
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.
Please let me know if you have any questions regarding the changes to take place this coming Saturday in Production.
Thank you.
Alan
Alan C. Park
Senior SFMS Analyst
DAS - Financial Business Systems
Statewide Financial Management Services
Phone 503-373-0262
http://www.das.state.or.us/DAS/EGS/FBS/SFMS/Pages/index.aspx
Data Classification: Level 2 - Limited
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20120912/8e739c42/attachment.html>
More information about the Datamart-News
mailing list