[Datamart-News] Datamart table update (SFMS)

[Datamart Support * DAS]

Hello Everyone-

Four new items have been added to the Datamart!

Thanks go to Terry Polston for her description of the first three:

1. Report Request (91 profile) -
                Find all reports requested for your agency or for a specific user
Reduce duplicate report requests
Find report requests that are used infrequently (yearly or biennially)
Find reports that are requested continually that are no longer useful
Review the status code of requested reports

2. Report Distribution (95 profile)
                Identify the distribution type for reports requested on the 91 profile
                Review default distribution requests
                Review the status code of report distribution requests
It is very useful to use the Report Request table and the Report Distribution table together to get a comprehensive look at your agency reporting for both control and requestable reports.

3. In addition, the Last Process Date field has been added to the Fund_D23 table. This additional field will allow you to search for D23 funds that have been added or changed in a date range or a specific date.

And last but not least, one I personally hope users might find helpful:

4. Recurring Trans (550 profile)
                See your splits
                See your recurrences
                Note: invoice descriptions were scrubbed in line with agency requests to protect sensitive information

Enjoy!

-Michael

Michael Makelacy, CPA
Statewide Financial Management Services Manager
DAS | Enterprise Goods and Services | Financial Business Systems
503-373-0734 | http://oregon.gov/DAS/EGS/FBS/SFMS/
Data Classification:  Level 2 - Limited
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20140618/8cf837cd/attachment.html>