[Datamart-News] Datamart table update (payment control)

[Datamart Support * DAS]

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

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