[Datamart-News] Datamart: Added D13 fields to D31 (GL Acct) profile

[Datamart Support * DAS]

Datamart users,

We had a request to update the Datamart with various fields that would help with Financial Statement items. We are happy to announce the request is complete and added to production.

Below are the details of the fields that were added from the RSTARS screen D13 (GAAP GL Account Category Profile) to the GL Acct (D31) Profile table.

Tables Affected/columns:
SFMSPUSR.GL_ACCT
GAAP_GL_ACCT_CAT
GAAP_GL_ACCT_CAT_ACFR_TYPE_IND
GAAP_GL_ACCT_CAT_TITLE
GAAP_GL_ACCT_CAT_STATUS

OBIEE Subject areas Affected:
  Active Acct Event
  All Acct Event
  Arch All acct event
  Budget Actuals
  GL Acct
 Arch GL Detail
  GL Detail
  YE GL Detail
  Arch GL Summary
  GL Summary
  YE GL Summary
  Recurring Tran
  YE Active Acct Event

OBIEE column names:
D31 Gaap Gl Acct Cat
D31 Gaap Gl Acct Cat Acfr Type Ind
D31 Gaap Gl Acct Cat Title
D31 Gaap Gl Acct Cat Status


If you have any questions, please contact Datamart.support at das.oregon.gov.
Thanks,
Aaron Wallace
Sr. Datamart Business Analyst
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20250902/bc82c030/attachment.html>