[Datamart-News] Datamart Level 4 Security Data Removal Project (follow up)

[Datamart Support * DAS]

Datamart users,

I wanted to follow up on my previous email about the level 4 security data changes in the Datamart. This information could touch a lot of various processes, so I want to make sure everyone is on the same page, when the change-over occurs on May 4, 2018.

Here is the main overview of the coding changes to the load process:

If the 'Vendor Number' field begins with '9', '7' or '4' the following information will no longer be loaded to the Datamart: Vendor Number, Vendor Address (1-4), Vendor City, Vendor State, & Vendor Zip Code. These changes will occur within the Accounting Event, Payment Control, Contract and Doc Financial tables.

Some agencies have provided very specific alterations/additions to the information above. This will help eliminate all level 4 data in the Datamart. If you believe your agency has some additional information, which needs to be disclosed or removed, please let us know.

In addition, due to level 4 data no longer being in the Datamart, it will allow us to remove 'special views'. Therefore, the following views will no longer be needed or available:
Owner

View name

SFMSP100

ACTIVE_ACCT_EVENT

SFMSP137

ACTIVE_ACCT_EVENT

SFMSP274

ACTIVE_ACCT_EVENT

SFMSP415

ACTIVE_ACCT_EVENT

SFMSP575

ACTIVE_ACCT_EVENT

SFMSPSTPOL

ACTIVE_ACCT_EVENT

SFMSPJUD

ACTIVE_ACCT_EVENT





SFMSP100

ALL_ACCT_EVENT

SFMSP137

ALL_ACCT_EVENT

SFMSP274

ALL_ACCT_EVENT

SFMSP415

ALL_ACCT_EVENT

SFMSP575

ALL_ACCT_EVENT

SFMSPSTPOL

ALL_ACCT_EVENT

SFMSPJUD

ALL_ACCT_EVENT





SFMSP100

ARCH_ALL_ACCT_EVENT

SFMSP137

ARCH_ALL_ACCT_EVENT

SFMSP274

ARCH_ALL_ACCT_EVENT

SFMSP415

ARCH_ALL_ACCT_EVENT

SFMSP575

ARCH_ALL_ACCT_EVENT

SFMSPSTPOL

ARCH_ALL_ACCT_EVENT

SFMSPJUDARC

ARCH_ALL_ACCT_EVENT





SFMSP100

YE_ACTIVE_ACCT_EVENT

SFMSP137

YE_ACTIVE_ACCT_EVENT

SFMSP274

YE_ACTIVE_ACCT_EVENT

SFMSP415

YE_ACTIVE_ACCT_EVENT

SFMSP575

YE_ACTIVE_ACCT_EVENT

SFMSPSTPOL

YE_ACTIVE_ACCT_EVENT

SFMSPJUD

YE_ACTIVE_ACCT_EVENT






If you have questions about the related views for your agency, please ask your agency security officer. All other questions, please send to Datamart.Support at oregon.gov<mailto:Datamart.Support at oregon.gov>.

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst

From: Datamart-News [mailto:datamart-news-bounces at listsmart.osl.state.or.us] On Behalf Of Datamart Support * DAS
Sent: Thursday, March 29, 2018 7:27 AM
To: datamart-news at listsmart.osl.state.or.us<mailto:datamart-news at listsmart.osl.state.or.us>
Subject: [Datamart-News] Level 4 security data removal project

It has come to our attention that the policies surrounding level 4 security (Statewide Asset Classification Policy http://www.oregon.gov/das/Policies/107-004-050.pdf) have become stricter and will start to require a lot more administration. Therefore, the Datamart Admin, along with agency help, have been hard at work reviewing all the level 4 security data within the Datamart. The current project was created to help remove all level 4 security data from the Datamart. This will help keep costs down, as well as, prevent massive changes to security access when using the Datamart.

The Datamart admin is well aware that some agencies still need to view the level 4 security data. If so desired, agencies can work with DAS SFMS to obtain a data extract and continue to view high security data directly from RSTARS.

Not all agencies have level 4 data; however, the main agencies that are affected have been alerted about the change and are working toward creating extracts, if desired. In addition, there is still a lot of time for any other agency to create such data extracts, as the removal of level 4 data will take place the evening of May 4, 2018. This will coincide with the Datamart archive process.

Thanks for your patience with this project and please feel free to ask any questions.

Thanks again,
Aaron Wallace
Sr. Datamart Business Analyst

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