[Datamart-News] Datamart table update (reminder)

[Datamart Support * DAS]

Just a friendly reminder that the January 08; 'go live' date is fast approaching and you need to make sure to update any processes that relate to the below change.

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: Tuesday, December 12, 2017 9:54 AM
To: datamart-news at listsmart.osl.state.or.us
Subject: [Datamart-News] Datamart table update

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

The SFMS Datamart 'Agency code' tables (1, 2, & 3) will be updated with new fields the evening of January 05, 2018 and the new data will be available for view Monday, January 08, 2018.

These tables mirror the D26, D27, & D36 screens in RSTARS.

The updated 'Agency Code 1' fields are as follows:

*         Agency

*         Agency Code 1

*         Status Code

*         Last Proc Date Agy Cd 1

*         Eff Beg Date Agy Cd 1

*         Eff End Date Agy Cd 1

*         Agency Code 1 Ttl

*         Udate No

*         Fiscal year

*         Load Date Agy Cd 1

The updated 'Agency Code 2' fields are as follows:

*         Agency

*         Agency Code 2

*         Status Code

*         Last Proc Date Agy Cd 2

*         Eff Beg Date Agy Cd 2

*         Eff End Date Agy Cd 2

*         Agency Code 2 Ttl

*         Udate No

*         Fiscal year

*         Load Date Agy Cd 2

The updated 'Agency Code 3' fields are as follows:

*         Agency

*         Agency Code 3

*         Status Code

*         Last Proc Date Agy Cd 3

*         Eff Beg Date Agy Cd 3

*         Eff End Date Agy Cd 3

*         Agency Code 3 Ttl

*         Udate No

*         Fiscal year

*         Load Date Agy Cd 3

*         Treasury Fund

Please make sure you prepare for this update. Once the update is complete, the new fields will become available to use even on previously created queries; however, a 'Sync with Database' operation must be complete.

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst

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