[Datamart-News] Datamart table update

[Datamart Support * DAS]

Datamart users,
I want to let you know of two work requests that will be implemented the weekend of October 19.

1.     The following fields from the 'Gaap Fund' table will be added into the 'D23 Fund' table.

a.     Gaap Fund Type

b.     Gaap Fund Status Code


2.     The following fields from the 'ORBITS Rpt Level' table will be added into the 'Program Code' table.

a.     Cross Ref No Format

b.     Cross Ref Sys Gen No

c.      Cross Reference Descr

d.     Cross Reference Level

e.     Enabled Flag

f.      Suspense Flag
To clarify, the 'Gaap Fund' and 'ORBITS Rpt Level' tables will still be separate tables within the Datamart; however, fields listed above will also be added into the other tables.
Both of these updates will help with the behind the scenes of the new OBIEE application.

Please review all your internal processes that may be affected.

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20190919/f4539e81/attachment.html>