[Datamart-News] FW: SEFA Repository Reports Update

[WALLACE Aaron * DAS]

Just a reminder, SARS is in charge of the SEFA files in the OBIEE repository. All changes/updates will go through them.

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst

From: Acfr-contacts-news <acfr-contacts-news-bounces at omls.oregon.gov> On Behalf Of HAMILTON Robert W * DAS
Sent: Friday, August 4, 2023 2:09 PM
To: acfr-contacts-news at omls.oregon.gov
Subject: Re: [ACFR-contacts-news] SEFA Repository Reports Update

Hello ACFR Contacts,

I'm happy to share the following updates on the SEFA Repository Reports:


  1.  The SEFA Express reports (i.e., non-YE) have been updated to exclude Appropriated Funds that begin with 3 from Grant Types 01, 02, 05, and 06. They now only report Appropriated Funds that begin with 6. I know this was causing challenges for agencies, particularly those with matching requirements.
  2.  Like the SEFA Express reports shared earlier, the SEFA Express - YE reports now include the comptroller objects listed below for GASB Statement Nos. 87, 94, and 96.
  3.  The Expenditure Reports for both the SEFA Express and SEFA Express - YE have been updated to fix what was reported in the Direct Award Expenditures column. Previously, it was reporting Direct Award Expenditures plus Indirect Award Expenditures.

If agencies review the SEFA Repository Reports today, both the non-YE and YE reports will reflect these changes, even though underlying data remains from the last refresh cycle.


While we will continue to monitor this on Monday with the refreshed data, we believe this addresses the concerns raised by agencies with the SEFA Repository Reports. Thank you again to those agencies that shared their concerns with us.

Please reach out if there are any questions.

Rob

From: Acfr-contacts-news <acfr-contacts-news-bounces at omls.oregon.gov> On Behalf Of HAMILTON Robert W * DAS
Sent: Wednesday, July 26, 2023 12:55 PM
To: acfr-contacts-news at omls.oregon.gov
Subject: [ACFR-contacts-news] SEFA Repository Reports Update

Hello ACFR Contacts,

I'm writing to share a couple updates on the SEFA Repository Reports; one I'm happy to share while the other I'm not.

I'll start with the problematic update. We've become aware of issues with the YE SEFA Repository Reports. In short, they're not currently pulling data correctly. While we're working through the issues and determining how to correct, please only use the non-YE SEFA Repository Reports for accurate year-to-date information. Unfortunately, that means that refreshed data will only be available on Mondays until we're able to get this resolved. I am sorry that the YE SEFA Repository Reports are not working correctly, and any resulting problems this is causing agencies. Know we are working to get this resolved as quickly as we can; once I have something, I'll send around an update.

Pivoting to the update that I'm happy to share, the following comptroller objects have been successfully added to the SEFA Express and SEFA Subrecipient Expenditures Repositories, each of which relate to recently implemented standards, GASB Statement Nos. 87, 94, and 96:

4376
VARIABLE SUBSCRIPTION-BASED IT PAYMENTS
GASB 96
4377
OTHER SUBSCRIPTION-BASED IT PAYMENTS
GASB 96
4802
PAYMENTS ON SHORT-TERM LEASES
GASB 87
4803
VARIABLE LEASE PAYMENTS
GASB 87
4804
OTHER LEASE PAYMENTS
GASB 87
4805
VARIABLE PPP PAYMENTS
GASB 94
4806
OTHER PPP PAYMENTS
GASB 94
7000
LEASE PMT FOR EQUIP AND MACHINERY
GASB 87
7001
LEASE PMT FOR MOTOR VEHICLES
GASB 87
7002
LEASE PMT FOR DATA PROCESS HARDWARE
GASB 87
7003
LEASE PMT FOR TUNNELS & BRIDGES
GASB 87
7004
LEASE PMT FOR AIRPORTS
GASB 87
7005
LEASE PMT FOR DOCKS,DIKES & DAMS
GASB 87
7006
LEASE PMT FOR LAND
GASB 87
7007
LEASE PMT FOR BUILDINGS
GASB 87
7008
LEASE PMT FOR OTHER ASSETS
GASB 87
7009
PRINCIPAL PMT FOR SUBSCRIPTION IT ASSETS
GASB 96
7010
PRINCIPAL PMT FOR PPP ASSETS
GASB 94
7401
INTEREST-LEASED ASSETS
GASB 87
7402
INTEREST PMT FOR SUBSCRIPTION IT ASSETS
GASB 96
7403
INTEREST PMT FOR PPP ASSETS
GASB 94

If you have any questions, please reach out to your SARS analyst.

Rob

Robert W. Hamilton, CPA
Statewide Accounting and Reporting Services Manager
Chief Financial Office
Department of Administrative Services
Cell: (971) 719-3031
http://www.oregon.gov/DAS/financial/acctng

Data Classification: Level 1 - Published

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