OSPS E-News ~ TS/SL Query

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

Payroll Partners,


Per request in the latest payroll forum, an OBIEE query has been built to pull data for TS and SL balances for employees. It can be found in OBIEE/ Shared Folders / Agencies / 107 / OSPS Unit:

[cid:image001.png at 01D8A32B.9730D230]

The query has a prompt for you to select which agency(ies) you're pulling the information for (shown below), and it will pull the data from the 063022 Leave Accrual run on 7/12/22. This query only pulls information for employees that have a balance in one, or both, of the types of leave. Further sorting will need to be done manually.

[cid:image002.png at 01D8A32B.9730D230]



Best Regards,

Vangie Barizo
System Analyst
Oregon Statewide Payroll Services



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/osps-news/attachments/20220729/66636191/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 56748 bytes
Desc: image001.png
URL: <https://omls.oregon.gov/pipermail/osps-news/attachments/20220729/66636191/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 14514 bytes
Desc: image002.png
URL: <https://omls.oregon.gov/pipermail/osps-news/attachments/20220729/66636191/attachment-0001.png>