[Datamart-News] Datamart field updates (new)

[Datamart Support * DAS]

Datamart users,

We have implemented the following changes with this past weekend's Datamart load:


1.     'Grant Phase' table - added the 'RTI' field

2.     'Recurring Tran' table

a.     Added the 'Index' field

b.    Added the 'PCA' field

c.     Added the 'effective begin date' field (titled 'Effect Beg Date')

d.    Added the 'effective end date' field (titled 'Effect End Date')

e.     Modified the 'RTI percent' field to be 5 decimals

Do not forget that if you have queries created prior to this update, which are using the 'Grant Phase' or 'Recurring Trans' tables, you will need to complete a 'Sync with Database' operation to view the new fields.

Please let me know if you have any questions.

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst

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