Standard Canadian Report - PE Statutory Holiday Report_CA

Report Description

Like American holidays, some Canadian holidays, though recognized, do not garner paid days off. Along with federally recognized holidays, Canada also has provincial and territorial holidays.  Even though they're celebrated nationally, vacation is not paid for Valentine's Day, Mother's Day, St. Patrick's Day, Father's Day, or Halloween. 

Statutory holidays - which include New Year's Day, Good Friday (Easter), Canada Day, Labour Day and Christmas Day - are celebrated nationwide and are paid days off for employees.  Federally regulated employees also get Easter Monday, Victoria Day, Thanksgiving and Boxing Day off and it is common practice, however, not required, for non-federal employees to get these holidays off as well.

This report provides information about statutory holidays for employees in Prince Edward Island.

Parameters

Parameter Name	Options	Explanation
Branch	All branches available in the company.
Employee Name	Enter a specific employee's name or the "%" symbol which retrieves all employees qualifying for this report.
Start Date	Calendar date	The beginning date of the information period.
End Date	Calendar date	The ending date of the information period.
Date Type	Accounting Period Date, Week Worked Date	Based on the Holiday Date, the Date Type will show either the payroll info for that holiday's accounting period or that holiday's week.
Group By	Branch, None
Pay Codes	All, Reg, OT, DT, Bonus, etc.

Report Fields

Field Name	Explanation
Employee Name	The name of the employee receiving holiday pay
Employee ID	Employee’s unique ID
Days Wages Earned	The total number of days worked by the employee during the time period (30 days prior to the End Date parameter)
Days of Employment	The total number of days worked by the employee during the time period of the parameter
Wage Earned	The amount of pay earned by the employee in the last month
Average Daily Wage Per Day	The average amount of pay earned by the employee in a day during the time period (30 days prior to the End Date parameter)

Logic

If the total number of days worked by the employee during the time period (30 days prior to the End Date parameter) is greater than or equals to 15 and the total number of days worked by the employee during the time period of the parameter is greater than or equals to 30, *** is displayed.