[Datamart-News] New Datamart Table (YE Acctg Event)

[WALLACE Aaron * SCD SARS]

The Datamart team is continually working to provide all Datamart users with the best possible information. Therefore, I am pleased to announce another important improvement within the Datamart.



A new table called 'YE Accounting Event' has been created in the Datamart.



This table contains the lowest level of detail (transactions, etc) and is a mirror image of the other Accounting event tables; however, it will only contain one year of data, which currently is Fiscal Year 2012.



This table will update only 3 times during month 13 (July 25, Aug 1 and Aug 8). It will update in the evening of these dates and be available for view the following day (Thursday).



This table was created, per agency request, to help with year-end reporting.



If you plan to use this new table, please be sure to update your current queries accordingly.



Thanks and enjoy,



Aaron Wallace

Sr. Datamart Business Analyst

Department of Administrative Services

Data Classification: Level 1 - Published



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