[Datamart-News] Agy Obj table update

[Datamart Support * DAS]

On 5/19/17, at 2pm, we will be updating the 'Agy Obj' table within the SFMS Datamart. This process should only take a few minutes. Once complete, the 'Agy Obj' table will contain the following additional fields:


*         Agy Obj Ind

*         Agy Obj Type

*         Eff Beg Date Ao

*         Eff End Date Ao

*         Last Proc Date Ao

These new fields mirror the D11 screen in RSTARS.

Please make sure to complete a 'Sync with Database' operation on any previously created query, which uses the 'Agy Obj' table. This will allow the new fields to populate.

To complete a 'Sync with Database', 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/20170517/964271dd/attachment.html>