[Datamart-News] Datamart: D16 fields added to D10 profile

[Datamart Support * DAS]

Datamart users,

We had a request to update the Datamart with various fields that would help with year-end and the ACFR. We are happy to announce the request is complete and added to production.

The new fields are from the D16: GAAP CATEGORY PROFILE based on the D10: PROP GAAP CATEGORY and D10: GOVT GAAP CATEGORY. Below are the details of the fields that have been added to the Datamart within the 'Comptroller Object' profile table.

Tables affected:
SFMSPUSR.COMPT_OBJ

New column names:
GAAP_CAT_GOVT_TTL
GAAP_CAT_GOVT_STATUS
GOVT_GAAP_ACFR_TYPE
GOVT_ACFR_OPER_STMT

GAAP_CAT_PROP_TTL
GAAP_CAT_PROP_STATUS
PROP_ACFR_TYPE
PROP_ACFR_OPER_STMT

OBIEE subject areas affected:
Active Acct Event
Arch GL Detail
Arch All Acct Event
All Acct Event
YE Active Acct Event
Budget Actuals
Recurring Tran
Agy Obj
YE GL Detail
GL Detail
Comp Obj

OBIEE column name:
D10 Gaap Cat Govt Ttl
D10 Gaap Cat Govt Status
D10 Govt Gaap Acfr Type
D10 Govt Acfr Oper Stmt

D10 Gaap Cat Prop Ttl
D10 Gaap Cat Prop Status
D10 Prop Acfr Type
D10 Prop Acfr Oper Stmt

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/20250827/697d9a7c/attachment.html>