[Datamart-News] Datamart updates (as of 2/17/14)

[Datamart Support * DAS]

I wanted to pass along a few minor updates within the Datamart, which loaded this past weekend.


1-     We have updated the 'Position Num' field within the OSPS Datamart tables (Lv Accrual, Js Lab Adj and Labor Cost) to show as 'Posno'. This alteration creates a consistency with the other systems in the Datamart.



2-     Within the PICS and PPDB Datamart, we added a field called 'SFMS Agy', which is a 3 digit agency field. This helps create a consistency with other Datamart systems.

If you have queries built prior to this update, which use any of the tables listed above, you must complete a 'Sync with Database' operation for the changes to take affect.

To complete a 'Sync with Database' operation, you click on the 'query' section, then select the 'DataModel' menu and finally select 'Sync with Database' (if you are not logged into the Datamart, it will request you log into an oce).

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst


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