Employee (HR) Dimension

Modified on Mon, 27 Jul at 11:38 PM

Employee HR Summary

The QQube Employee HR Dimension contains the complete employee record available from QuickBooks, including sensitive personal, employment, payroll, sick-time, and vacation information.

Dimension Type

Restricted QuickBooks list dimension

Employee Represents

An employee record with HR and payroll details

QuickBooks Source

Employee List and employee payroll information

Primary Use

Payroll and administrative employee analysis

Included Data Models

Operations: Payroll

QuickBooks Source

The fields are derived from the Employee List and employee payroll information in QuickBooks.

Unlike the standard Employee Dimension, this dimension includes all available employee fields, including Social Security number, demographic information, employment dates, emergency contacts, payroll settings, sick hours, and vacation hours.

Source Example

QuickBooks employee information source for the Employee HR Dimension

Administrative access required

This dimension contains sensitive employee and payroll information. It is intended only for the Payroll data model and users with the required administrative permissions.

Available Fields

Display Order	Field Name
1	Employee Active
2	Employee Is SalesRep
3	Employee SalesRep Initial
4	Employee Class
5	Employee Name
6	Employee Salutation
7	Employee First Name
8	Employee Middle Name
9	Employee Last Name
10	Employee SSN
11	Employee Gender
12	Employee Birth Date
13	Employee is US Citizen
14	Employee Ethnicity
15	Employee is Disabled
16	Employee Disability Description
17	Employee I-9 Form is On File
18	Employee I-9 Form Work Authorization Expiration Date
19	Employee is US Veteran
20	Employee Employee Status
21	Employee Address Line 1
22	Employee Address Line 2
23	Employee Address Line 3
24	Employee Address Line 4
25	Employee Address City
26	Employee Address State
27	Employee Address Postal Code
28	Employee Address Country
29	Employee Primary Phone
30	Employee Alt Phone
31	Employee Work Phone
32	Employee Fax
33	Employee Alt Fax
34	Employee Cell Phone
35	Employee Alt Cell Phone
36	Employee Email
37	Employee Alt Email 1
38	Employee Alt Email 2
39	Employee CC Email
40	Employee LinkedIn
41	Employee Facebook
42	Employee Twitter
43	Employee Skype ID
44	Employee Web Site
45	Employee URL 1
46	Employee URL 2
47	Employee URL 3
48	Employee URL 4
49	Employee Other 1
50	Employee Other 2
51	Employee Other 3
52	Employee Emergency Primary Contact
53	Employee Emergency Primary Contact Phone
54	Employee Emergency Primary Contact Relation
55	Employee Emergency Secondary Contact
56	Employee Emergency Secondary Contact Phone
57	Employee Emergency Secondary Contact Relation
58	Employee Hire Date
59	Employee Original Hire Date
60	Employee Adjusted Service Date
61	Employee Release Date
62	Employee Type
63	Employee Full/Part Time
64	Employee Exempt Status
65	Employee is Key Employee
66	Employee Job Title
67	Employee Job Supervisor
68	Employee Job Department
69	Employee Job Description
70	Employee Target Bonus
71	Employee Notes
72	Employee Account Number
73	Employee Billing Rate Name
74	Employee Custom Field 01
75	Employee Custom Field 02
76	Employee Custom Field 03
77	Employee Custom Field 04
78	Employee Custom Field 05
79	Employee Custom Field 06
80	Employee Custom Field 07
81	Employee Custom Field 08
82	Employee Custom Field 09
83	Employee Custom Field 10
84	Employee Custom Field 11
85	Employee Custom Field 12
86	Employee Uses Time Data to Create Paychecks
87	Employee Pay Period
88	Employee Sick Hours Accrual Period
89	Employee Sick Hours Accrual Start Date
90	Employee Sick Hours Reset Each Year
91	Employee Sick Hours Maximum Hours
92	Employee Sick Hours Accrued
93	Employee Sick Hours Used
94	Employee Sick Hours Available
95	Employee Vacation Hours Accrual Period
96	Employee Vacation Hours Accrual Start Date
97	Employee Vacation Hours Reset Each Year
98	Employee Vacation Hours Maximum Hours
99	Employee Vacation Hours Accrued
100	Employee Vacation Hours Used
101	Employee Vacation Hours Available