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 it, is not easy, or conventional.
All of the detail payroll check data is available, and about 95% of all employee fields are available.
See QuickBooks Data Availability in QQube
This data model uses the extended Employee HR Dimension which contains SSN, and employment information, which is suited to data imports, and larger payroll analysis.
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
Your session has expired. You are being logged out.