[Datamart-News] New OSPS Datamart table

[Datamart Support * DAS]

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/datamart-news/attachments/20190228/75d76dc0/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/datamart-news/attachments/20190228/75d76dc0/attachment.jpg>