[Datamart-News] New SFMS Datamart fields

[Datamart Support * DAS]

I am happy to announce we have a few new fields on the SFMS Datamart. The following new fields are the same fields that are currently on the 'GL Detail' table. We are now including the fields on the Accounting Event tables. Here is the breakdown:

Active Acct Event table:
'Rpt Appn Yr', 'Rpt Fiscal Yr', 'Rpt Fiscal Mm', 'Rpt Fiscal Mm Name'

All Acct Event table:
'Rpt Appn Yr', 'Rpt Fiscal Yr', 'Rpt Fiscal Mm', 'Rpt Fiscal Mm Name'

Archive Acct Event table:
'Rpt Appn Yr', 'Rpt Fiscal Yr', 'Rpt Fiscal Mm', 'Rpt Fiscal Mm Name'


Additional information and definitions of these fields are shown on the 'SFMS Datamart Tables' pdf on the Datamart website: (http://www.oregon.gov/DAS/EGS/FBS/Pages/datamart.aspx#SFMA_Datamart_Tables).

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst

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