Dates and Calendar Dimensions:
Document Based Dimensions:
List Based Dimensions:
Don't let anybody tell you that payroll information is not available from the Intuit Software Development Kit - it is. However getting at is not easy, or conventional.
All of the detail payroll check data is available, and about 95% of all employee fields are available.
However, there are some things that, because they are not available, makes things a little harder to get. View this guide on the Payroll Item Dimension: https://clearify.com/wiki/view/3326/payroll-item
This analytic uses the extended Employee HR Dimension which contains SSN, and employment information, which is suited to data imports, and larger payroll analysis.
QQube has - by far - the most comprehensive payroll and employee information of any data extraction or reporting product - and that includes QuickBooks Custom Reporting, and Advanced Reporting.
Is their no available link between vl_Employee and vl_EmployeeHR ?
okay, I discovered that LinkForEmployeeHRID=LinkForEmployeeID
The difference between the two, is that the "HR" has extended employee information that is only available under the QQubeFinancials DSN, and not the lesser permission QQubeUser DSN
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/216/payroll