OSPS E-News ~ FW: New OSPS Datamart table

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

New OSPS Datamart Table.

See below for the e-News from the Datamart team for details.

Thanks,

Matthew Riley, CPA
OSPS Application Analyst
DAS | Oregon Statewide Payroll Services
(503) 373-0254 - direct
(503) 378-3518 - fax
http://oregon.gov/DAS/Financial/payroll/Pages/index.aspx

From: Datamart-News [mailto:datamart-news-bounces at listsmart.osl.state.or.us] On Behalf Of Datamart Support * DAS
Sent: Thursday, February 28, 2019 11:57 AM
To: datamart-news at listsmart.osl.state.or.us
Subject: [Datamart-News] New OSPS Datamart table

We have migrated a new OSPS Datamart table to Production. Please feel free to check it out and let us know if any issues arise.

The new table is called: OSPS_Retirement

The 'OSPS Retirement' table was created to provide historical data for various OSPA fields not contained on other OSPS Datamart tables, specifically the 'Final Check Issued Date', 'Final Check Period End Date' and the 'Retirement Date' from the P010 screen in OSPA.

It includes the following fields:
Agency Number
Employee Name
Employee Number
Final Check Issued Date (from the P010 screen in OSPA)
Final Check Period End Date (from the P010 screen in OSPA)
Load Date
Retirement Date (from the P010 screen in OSPA)


Sample Hyperion query:

[cid:image001.png at 01D4CDC9.46F503D0]

Thanks,
Aaron Wallace

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/osps-news/attachments/20190228/bafc1062/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 75765 bytes
Desc: image002.jpg
URL: <https://omls.oregon.gov/pipermail/osps-news/attachments/20190228/bafc1062/attachment.jpg>