We use Invantive Cloud for one of our clients to extract data from Nmbrs. Unfortunately, we’re finding that information is missing in certain areas, or that information is difficult to access via the current connectors. For the most part, we’ve accepted that the data from Nmbrs is quite incomplete, but we still have a few requests and hopefully Invantive can help with these:
What we’d really like is simply a table containing all the leave records of employees, which also clearly states the leave type. The view seems suitable for this, but it requires two variables: employee ID and leave type ID. The employee keys can still be found via the Employee table, since that can be fully accessed, but I can’t access the leave types directly. So I don’t know the IDs, and therefore I don’t think I can build logic that simply retrieves all leave types for all employees via a join.
My question is: does a query exist that joins both the employee table and the leave types to achieve this? It’s really just about getting a complete view of this query:
select *
from Nmbrs.Employees.EmployeeLeaveBalancesByEmployeeLeaveType@nms
( :EmployeeId -- Numeric ID of employee. (number)
, :LeaveType -- One of 'Undefined', 'Type1', 'Type2', 'Type3', 'Type4'. (varchar2)
)
and this one:
select *
from Nmbrs.Employees.EmployeeLeavesV2ByEmployeeYearLeaveTypeLeaveUsageType@nms
( :EmployeeId -- Numeric ID of employee. (number)
, :LeaveType -- One of 'Undefined', 'Type1', 'Type2', 'Type3', 'Type4'. (varchar2)
, :Soort
, :Year -- Payroll year. (number)
)
Specific questions:
- Are there any views that already display this data which I might have overlooked?
- Can Invantive provide the query or create a view?
- If not, can Invantive offer hourly-based support to help realise this?
Thanks in advance
