[Datamart-News] Datamart back up (Successful 2014 Financial Archive)

Tue Apr 8 07:44:50 PDT 2014

The Datamart is now back up and running. Thank you again for your patience during the archive process.

Aaron Wallace
Sr. Datamart Business Analyst

From: SFMS-News [mailto:sfms-news-bounces at listsmart.osl.state.or.us] On Behalf Of MAKELACY Michael * EGS
Sent: Monday, April 07, 2014 3:11 PM
To: 'sfms-news at listsmart.osl.state.or.us'
Subject: [SFMS-News] Successful 2014 Financial Archive

Hello Everyone-

SFMS is pleased to announce the successful completion of the 2014 financial archive.  Many thanks to those who made this process possible.

Agencies:  Thank you for your understanding, patience and willingness to plan ahead.  We appreciate your support.

Enterprise Technology Services and Publishing and Distribution:  Thank you for your coordination and teamwork, instrumental to performing the archive without significant technical problems.

SFMS Staff:  Thank you for your hard work, dedication and teamwork to help bring up the system so quickly.

The 12 financial tables that were archived housed 493,640,740 rows of financial data.  This year we successfully archived 85,785,836 rows (17%).  Since the beginning of this project in 2002, we have archived a total of about 830 million rows.  This means that, if we were not archiving data, we would have more than 1.2 billion rows of financial data on these 12 tables.  After the archive, they now house 408 million rows of data.

The only financial table we intentionally did not archive is the Accounting Event.  This table is not included because we routinely move transactions from the Accounting Event table to the Inactive Accounting Event table, and from there they are included in the financial archive.

SFMA will have a batch cycle tonight.  This means that you are welcome to send in your interfaces and we will process them tonight, as well as any transactions entered online this afternoon.  The SFMA Datamart is being updated now, and we expect it to be available tomorrow morning.

Thanks again!

-Michael

Michael Makelacy, CPA
Statewide Financial Management Services Manager
DAS | Enterprise Goods and Services | Financial Business Systems
503-373-0734 | http://oregon.gov/DAS/EGS/FBS/SFMS/
Data Classification:  Level 2 - Limited

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20140408/737a66e5/attachment.html>