[Datamart-News] OSPS repository file: Time and Leave Balances

[Datamart Support * DAS]

OSPS Datamart users (only),

Thank you for your response to the previous Datamart News below.

After some research, it has been determined that the Repository file 'Time and Leave Balances' has a flaw in the first query entitled 'timesheet/day', which cannot be fixed, due to the current structure of the OSPS Datamart. Therefore, I have eliminated the query along with the two related pivots from the file. However, the second query within the file works great and should continue to be used in the future, as it is a good research tool. The Repository is now updated with the new file.

If you have any questions, please feel free to ask.

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst


From: Datamart-News [mailto:datamart-news-bounces at listsmart.osl.state.or.us] On Behalf Of Datamart Support * DAS
Sent: Monday, April 06, 2015 2:36 PM
To: datamart-news at listsmart.osl.state.or.us
Subject: [Datamart-News] OSPS repository file: Time and Leave Balances

OSPS Datamart users,

There is a Repository file entitled 'Time and Leave Balances', which I have been conducting some research.

To help continue my research I would like to take a poll. I need to know if you actually use this file and if so, what do you use it for?

Thanks very much for your help,

Aaron Wallace
Sr. Datamart Business Analyst

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20150409/27da64b6/attachment.html>