[Datamart-News] New SFMS field (complete)

[WALLACE Aaron * DAS]

The 'Agency Code 1' (also known as 'Facility') field is now added to the three GL Summary tables in the Datamart.

We will be adding the field to OBIEE on Jan 15 and it should be ready for use on Jan 18, since Monday, Jan 17 is a holiday.

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst

From: Datamart-News <datamart-news-bounces at omls.oregon.gov> On Behalf Of WALLACE Aaron * DAS via Datamart-News
Sent: Tuesday, December 7, 2021 12:32 PM
To: datamart-news at omls.oregon.gov
Subject: Re: [Datamart-News] New SFMS field

The Datamart team has been receiving some questions surrounding the new 'facility' field that will be added to the Datamart in Jan 2022. Here are some additional clarification details.

To clarify, the 'Facility' field refers to the SFMS 'Agency Code 1' field. It is not a new field within SFMS, but it was not previously included in the Datamart 'GL Summary', 'Archived GL Summary' and 'YE GL Summary' tables.

Due to the confusion, we have decided to use the field name 'Agency Code 1'. These changes will occur until the dates displayed below.

Thanks for your understanding,
Aaron Wallace
Sr. Datamart Business Analyst

From: Datamart-News <datamart-news-bounces at omls.oregon.gov<mailto:datamart-news-bounces at omls.oregon.gov>> On Behalf Of WALLACE Aaron * DAS via Datamart-News
Sent: Monday, December 6, 2021 12:04 PM
To: datamart-news at omls.oregon.gov<mailto:datamart-news at omls.oregon.gov>
Subject: [Datamart-News] New SFMS field

A new field, called 'Facility', was recently added to SFMS. It will also be added to the Datamart on the following tables: GL Summary, Archived GL Summary and YE GL Summary.

The Datamart update will take place on Jan 8, 2022. Please make sure to update any processes that may be effected.

One week following the Datamart update, the OB1 change will occur. Therefore, on Jan 15, the new field will be added into OB1, on the 'SFMS - GL Summary', 'SFMS - Archived GL Summary' and 'SFMS - YE GL Summary' subject area.

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst

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