Effective Payroll Date Dimension

Modified on Mon, 27 Jul at 8:56 PM

Calendar Summary

The Effective Payroll Date Dimension organizes payroll activity by the date used to place posting transactions in the correct calendar-year compliance period.

Calendar Type

Payroll reporting date

Date Represents

Effective payroll date

QuickBooks Sources

Four posting transaction types

Primary Use

Calendar-year payroll compliance

Included Data Models

Operations: Payroll

QuickBooks Source

The effective payroll date comes from the following QuickBooks payroll posting transactions.

Source Transactions

Paycheck
Payroll YTD Adjustments
Liability Adjustments
Payroll Liability Check

Source Examples

QuickBooks Effective Payroll Date source transaction

Available Fields

The following fields are included in the Effective Payroll Date Dimension.

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