Payroll

Fact table	Description	Source table
Employee Payment	Provides summary payment information such as Gross and Net pay or Taxable amounts. Check Date or Pay Period End Date can be used as Analyze by Date.	EmployeePayment
Employee Payment Deduction Detail	Provides information on Employee and Employer paid deductions. Check Date or Pay Period End date can be used as Analyze by Date.	EmployeePaymentDeductionDetail
Employee Time Record	Provides detailed Time record data. In addition to the Time Record Date, Check Date or Pay Period Date Range Begin and End date can be used as Analyze by Date in order to report on time record data alongside deductions and payment data.	EmployeeTimeRecord
Process - Payroll Register Items	Created for closed payment register dashboard based on Employee Payment, Employee Time Record, Employee Payment Deduction Details.	EmployeeTimeRecord, EmployeePayment, EmployeePaymentDeductionDetails

Employee Payment

Provides summary payment information such as Gross and Net pay or Taxable amounts. Check Date or Pay Period End Date can be used as Analyze by Date.

EmployeePayment

Employee Payment Deduction Detail

Provides information on Employee and Employer paid deductions. Check Date or Pay Period End date can be used as Analyze by Date.

EmployeePaymentDeductionDetail

Employee Time Record

Provides detailed Time record data. In addition to the Time Record Date, Check Date or Pay Period Date Range Begin and End date can be used as Analyze by Date in order to report on time record data alongside deductions and payment data.

EmployeeTimeRecord

Process - Payroll Register Items

Created for closed payment register dashboard based on Employee Payment, Employee Time Record, Employee Payment Deduction Details.

EmployeeTimeRecord, EmployeePayment, EmployeePaymentDeductionDetails