View EmployeeLeaveBalancesCurrent

Questions
, ,
1

The view Nmbrs.Views.EmployeeLeaveBalancesCurrent@nms shows the starting total and the current total.

We have (and I don’t know if this is company specific) two leave types:

  • ‘normal’ - the standard leave that everyone receives and
  • ‘special’ which has no minimum or maximum, and is approved by management each time; for example funerals etc.

The starting total is correct, however the current total subjects BOTH special leave and normal leave from the starting total instead of only the normal leave.

There is also no distinction in the resulting table from this column. Is this an issue with the view or something else?

2

This is not a known issue and given the definition of the view this is not expected to be a problem.

Maybe an alternative table or view provides help available at:

3

Thank you for your response. I made a typo in my original question; it should be SUBTRACTS, not subjects. To clarify:

If my starting leave balance is 200 hours and I use 10 hours special leave but 0 hours normal leave, my total should still be 200 hours. However, the view is showing 190 hours.

I think some of those tables would indeed provide what I need, but they don’t seem to be available in Power BI using the connector (I read that not everything is available with Power BI due to requiring parameters). For example:

  • EmployeeLeaveBalancesByEmployee: Nmbrs Medewerker Verlofsaldo
  • EmployeeLeaveBalancesByEmployeeLeaveType: Nmbrs Verlofsaldo per Werknemer en Verlofsoort
  • EmployeeLeavesV2ByEmployeeYearLeaveTypeLeaveUsageType: Nmbrs Verloven per Werknemer, Jaar, Verlofsoort en Verlofgebruikstype

Any ideas?

4

Thanks for clarification. It doesn’t ring a bell. Maybe another user or a consultant knows where to find this data.

5

This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution.

Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.

6

Dit topic is 3 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.