[Datamart-News] Datamart table updates (payment control, 28a, 28b)

[Datamart Support * DAS]

The 'Payment Control', 'TC28a' and 'TC28b' tables in the (SFMS) Datamart were successfully updated over the weekend.

Please enjoy these improved tables. If you have any questions about the tables, please don't hesitate to ask.

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, February 22, 2018 11:25 AM
To: datamart-news at listsmart.osl.state.or.us
Subject: [Datamart-News] Datamart table update (payment control)

We are always working to bring new fields to the Datamart and we have another great update for SFMS users.

The SFMS Datamart 'Payment Control' table will be updated with new fields and will be available for view Monday, March 05, 2018.

This table mirrors the 47 screen in RSTARS.

Update Notes:

-          The new datamart table will be called SFMSPUSR.PAYMENT_CONTROL. It will be loaded weekly and contain a complete view of the Datamart.

-          The existing SFMSARCH.PAYMENT_CONTROL table will no longer be available.

-          The 2 special views - SFMSPJUD.PAYMENT_CONTROL and SFMSPSEC.PAYMENT_CONTROL will also no longer be available.

-
Please make sure you prepare for this update. If you have any questions, please don't hesitate to ask.

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: Monday, February 12, 2018 9:02 AM
To: datamart-news at listsmart.osl.state.or.us
Subject: [Datamart-News] Datamart table update

The 'TC28A' and 'TC28B' SFMS Datamart tables are being updated. They will contain the complete range of fields based on the RSTARS system screens.

The 'go live' date for the tables to contain a complete range of fields will be March 5, 2018.

Once the update is complete, please make sure to change any older queries to contain the new fields. This can be done with a 'Sync with Database' operation. To complete a 'Sync with Database', you click on the query section, click on 'DataModel' menu, then select 'Sync with database'. If you are not logged into an oce, it will prompt you to log in. Once logged in, it will update the file, which normally only takes a few seconds.

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst

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