[Datamart-News] FW: Agy Obj table update (revision)

[Datamart Support * DAS]

Due to unforeseen circumstances, we will move the update date to June 8 at 2pm.

Please make sure to prepare for this update to the 'Agy Obj' table.

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: Wednesday, May 17, 2017 8:58 AM
To: datamart-news at listsmart.osl.state.or.us
Subject: [Datamart-News] Agy Obj table update

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/25d8c2ad/attachment.html>