Employee Hire Date Dimension

Modified on Mon, 27 Jul at 9:08 PM

Calendar Summary

The Employee Hire Date Dimension expands the hire date stored with the Employee HR information. It is attached to the Employee HR Dimension rather than directly to a FACT table.

Calendar Type

Employee lifecycle date

Date Represents

Employee hire date

QuickBooks Source

Employee record

Model Relationship

Attached to Employee HR Dimension

Included Data Models

Operations: Payroll

QuickBooks Source

The hire date is stored on the employee record in QuickBooks.

QuickBooks employee hire date source

Available Fields

The following fields are included in the Employee Hire Date Dimension.

Display Order	Field Name
1	Hire Date
2	Hire Date Calendar Month Number
3	Hire Date Calendar Year Number
4	Hire Date Day Holiday Name
5	Hire Date Day is Holiday
6	Hire Date Day is Weekend Day
7	Hire Date Day is Working Day
8	Hire Date Day Number in Month
9	Hire Date Day Number in Quarter
10	Hire Date Day Number in Week
11	Hire Date Day Number in Year
12	Hire Date Day of Week
13	Hire Date Day of Week Abbr
14	Hire Date Formal Date
15	Hire Date Month Abbr
16	Hire Date Month Begin Date
17	Hire Date Month End Date
18	Hire Date Month Name
19	Hire Date Month Number
20	Hire Date Month Number in Quarter
21	Hire Date Month-Year
22	Hire Date Quarter (FQ)
23	Hire Date Quarter (Q)
24	Hire Date Quarter Begin Date
25	Hire Date Quarter End Date
26	Hire Date Quarter Number
27	Hire Date Quarter-Year (FQ)
28	Hire Date Quarter-Year (Q)
29	Hire Date Week Begin Date
30	Hire Date Week End Date
31	Hire Date Year (FY)
32	Hire Date Year (Y)
33	Hire Date Year Begin Date
34	Hire Date Year End Date
35	Hire Date Year Number