[Datamart-News] Updated Invoice Description field

[Datamart Support]

Datamart users:



In two weeks, on February 23, 2013, the SFMS team will migrate the programming changes to expand the Description field on several RSTARS screens.



Due to this change, the Datamart team will also update and expand the "Invoice Description" field, from 30 to 40 characters, on the following Datamart tables:



*         All_Acct_Event

*         Active_Acct_Event

*         Arch_All_Acct_Event

*         YE_Active_Acct_Event



After the migration is complete, if a user has an existing query that uses these tables, they will need to review and update their files.



NOTE: If using Hyperion the user will need to re-sync their queries. To accomplish this task: Open the existing file in Hyperion, click on the query section, select the 'DataModel' menu, select 'Sync with Database', it will request that you log into the Datamart with an oce. Once logged in, the 'Sync with Database' process will commence.



NOTE: Please forward this notice to your local IT department if your agency uses any of these tables to load into local applications as they may need to review and/or update their automated load processes.



Please, let us know if you have additional questions.



Thanks,



Aaron Wallace

Sr. Datamart Business Analyst

Department of Administrative Services

Data Classification: Level 1 - Published



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