Employee Release Date Dimension

Modified on Mon, 27 Jul at 9:09 PM

Calendar Summary

The Employee Release Date Dimension expands the release 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 release date

QuickBooks Source

Employee record

Model Relationship

Attached to Employee HR Dimension

Included Data Models

Operations: Payroll

QuickBooks Source

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

QuickBooks employee release date source

Available Fields

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

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