[Datamart-News] SFMA D48 - Grant Object (changes)

Tue Jul 11 11:32:38 PDT 2023

SFMS Datamart users,

Along with the normal Datamart load on the weekend of August 19, 2023, we will be making a change to the 'D48 Grant Object' Profile table.

If you access the Datamart with an ODBC connection and use the D48 Grant Object Profile, you will want to review the query to determine if this change affects you.

Please note - OBIEE users are not affected by this change.

The unique key to the D48 Grant object profile (SFMSPUSR.GRANT_OBJ) will be changing from the following columns:
AGENCY
GRANT_OBJ
GRANT_NO
FISCAL_YEAR

To the following columns:
AGENCY
GRANT_OBJ
FISCAL_YEAR
COMPT_OBJ_FROM
COMPT_OBJ_TO
AGY_OBJ_FROM
AGY_OBJ_TO

Joins in your query between the accounting event tables and the D48 Grant Object table will be affected by this change.
Please let us 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/20230711/8a300161/attachment.html>