OSPS E-News ~ FW: OSPS Datamart (upcoming changes)

[Announcements from OSPS to the users of the Oregon State Payroll Application]

Good morning,

The change indicated in the eNews below was implemented last night without any issues.  You may build new queries using updated tables.  If you have any saved queries you will need to remove the extension in order for it to process.

The repository queries will be updated next week.

Thank you,

Geri Greeno-Sanders
OSPS Senior System Analyst
DAS/EGS/FBS/Oregon Statewide Payroll Services
(503) 373-0259 – direct
(503) 378-3518 – fax
geri.l.greeno-sanders at oregon.gov<mailto:geri.l.greeno-sanders at oregon.gov>
www.oregon.gov/DAS/Financial/payroll/Pages/index.aspx<http://www.oregon.gov/DAS/Financial/payroll/Pages/index.aspx>

-----Original Message-----
From: Datamart Support * DAS [mailto:Datamart.Support at oregon.gov];
Sent: 8/3/2017 4:23:51 PM
To: datamart-news at listsmart.osl.state.or.us<mailto:datamart-news at listsmart.osl.state.or.us> [mailto:datamart-news at listsmart.osl.state.or.us];
Subject: [Datamart-News] OSPS Datamart (upcoming changes)

It has been determined that there is no longer a need to cut up the OSPS Datamart tables into four separate views. In the best interest of the user as well as the Datamart, we will be eliminating the three extra file extension views (_B, _PB, and _PP) within OSPS.

Going forward, there will be only one OSPS Datamart table for each view of the OSPS data and will contain no extension. The data in each table (listed below) will contain the full information of the OSPS Datamart.

Updated OSPS table names (starting Aug 11, 2017 – July payroll load):

OSPS_Ded – 07/01/11 to 06/30/19

OSPS_Js_Lab_Adj – 07/01/11 to 06/30/19

OSPS_Labor_Cost – 07/01/11 to 06/30/19

OSPS_Lv_Accrual – 07/01/11 to 06/30/19

OSPS_Net_Pay – 07/01/11 to 06/30/19

OSPS_Work_Sched – (will not change)

It will be important to update your queries that are using the old file extensions (_B, _PB, and _PP). These queries must be updated to point to the OSPS table with no file extension. Make sure to go into the properties of the table (double click on the top of the table) and alter the ‘physical name’ to contain no extension.

With this change, it has become more important to make sure each OSPS query has at least two filters. One is ‘Agency’ and the other is a time period such as ‘Pay Period End’, ‘Pay Proc Date’, etc. These two filters will allow your query to run at its’ optimal level.

The move to the new view of the OSPS Datamart will occur with the transition of the biennial date change on Aug 11, 2017.

Please email Datamart Support, if you have any questions.

Aaron Wallace

Sr. Datamart Business Analyst


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/osps-news/attachments/20170811/dc2e7bd3/attachment.html>