Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2025-04-04
Example: Configure Statutory Holiday Pay for Provinces (CAN)

Example: Configure Statutory Holiday Pay for Provinces (CAN)

This example illustrates 1 way to configure a statutory holiday earning to calculate all provinces for Canadian workers.
Sonia the payroll administrator needs to configure statutory holiday earnings for all the provinces. She uses Workday-owned statutory holiday values.
  • Create holiday time blocks for workers.
  • Specify employee period eligibility for holiday time worked.
  • Configure time calculation rules that govern worker statutory holiday payout.
  • Create an instance set comparison calculation for all provinces using the payroll tax authority worktags.
  • Create a
    Canada Statutory Holiday
     time calculation tag.
Security: These domains in the Core Payroll functional area:
  • Set Up: Payroll (Calculations - Generic)
  • Set Up: Payroll (Calculations - Payroll Specific)
  1. Access the
    Create Related Calculation
     task and enter these settings:
    Option Description
    Name
    CAN Statutory Holiday - Hours Worked
    Code
    STAT_HOL_HRWK
    Category
    Payroll
    Value > Currency Related
    Select
  2. Access the
    Create Related Calculation
     task and enter these settings:
    Option Description
    Name
    CAN Statutory Holiday - Days Worked
    Code
    STAT_HOL_DYSWK
    Category
    Payroll
    Value > Currency Related
    Select
  3. Access the
    Create Related Calculation
     task and enter these settings:
    Option Description
    Name
    CAN Statutory Holiday - Time-Based Earnings
    Code
    STAT_HOL_TB
    Category
    Payroll
    Value > Currency Related
    Select
  4. Access the
    Create Related Calculation
     task and enter these settings:
    Option Description
    Name
    CAN Statutory Holiday - Non-Time Based Earnings
    Code
    STAT_HOL_NTB
    Category
    Payroll
    Value > Currency Related
    Select
  5. Access the
    Create Related Calculation
     task and enter these settings:
    Option Description
    Name
    CAN Statutory Holiday - Total Earnings
    Code
    STAT_HOL_TOTERN
    Category
    Payroll
    Value > Currency Related
    Select
  6. Access the
    Create Related Calculation
     task and enter these settings:
    Option Description
    Name
    CAN Statutory Holiday - EI Hours
    Code
    STAT_HOL_EIHRS
    Category
    Payroll
    Value > Currency Related
    Select
  7. Access the
    Create Related Calculation
     task and enter these settings:
    Option Description
    Name
    CAN Statutory Holiday - Prior Period Holiday Pay
    Code
    STAT_HOL_PPHP
    Category
    Payroll
    Value > Currency Related
    Select
  8. Access the
    Create Aggregate Calculation
     task and enter these settings:
    Option Description
    Name
    CAN Statutory Holiday Total Earnings Function - Sum
    Function
    Sum
    Operand
    RCs for Prior SH, Non-Time Based Earnings and Time Based Earnings.
  9. Access the
    Create Arithmetic Calculation
     task and enter these settings:
    Option Description
    Name
    CAN Statutory Holiday Hours Worked / CAN Statutory Holiday Days Worked
    Category
    Payroll
    1st Operand
    CAN Statutory Holiday - Hours Worked
    Operator
    Divide
    2nd Operand
    CAN Statutory Holiday - Days Worked
    Rounding
    Round down to nearest 0.01
  10. Access the
    Create Arithmetic Calculation
     task and enter these settings:
    Option Description
    Name
    CAN Statutory Holiday Total Earnings / CAN Statutory Holiday Days Worked
    Category
    Payroll
    1st Operand
    CAN Statutory Holiday - Total Earnings
    Operator
    Divide
    2nd Operand
    CAN Statutory Holiday - Days Worked
  11. Access the
    Create Arithmetic Calculation
     task and enter these settings:
    Option Description
    Name
    CAN Statutory Holiday Total Earnings / 20
    Category
    Payroll
    1st Operand
    CAN Statutory Holiday - Total Earnings
    Operator
    Divide
    2nd Operand
    20
  12. Access the
    Create Arithmetic Calculation
     task and enter these settings:
    Option Description
    Name
    CAN Statutory Holiday Total Earnings * 0.1
    Category
    Payroll
    1st Operand
    CAN Statutory Holiday - Total Earnings
    Operator
    Multiply
    2nd Operand
    0.1
  13. Access the
    Create Conditional Calculation
     task and enter these settings:
    Option Description
    Name
    CAN Statutory Holiday Pay Calculation
    Category
    Payroll
  14. Add 13 rows to the
    Conditional Calculations
     grid and enter these settings:
    Order
    Condition
    Result
    A
    Payroll Tax Authority Worktags for Current Calculation = Alberta
    CAN Statutory Holiday Total Earnings / CAN Statutory Holiday Days Worked
    B
    Payroll Tax Authority Worktags for Current Calculation = British Columbia
    CAN Statutory Holiday Total Earnings / CAN Statutory Holiday Days Worked
    C
    Payroll Tax Authority Worktags for Current Calculation = Manitoba
    CAN Statutory Holiday Total Earnings / 20
    D
    Payroll Tax Authority Worktags for Current Calculation = New Brunswick
    CAN Statutory Holiday Total Earnings / CAN Statutory Holiday Days Worked
    E
    Payroll Tax Authority Worktags for Current Calculation = Newfoundland and Labrador
    CAN Statutory Holiday Total Earnings / CAN Statutory Holiday Days Worked
    F
    Payroll Tax Authority Worktags for Current Calculation = Northwest Territories
    CAN Statutory Holiday Total Earnings / CAN Statutory Holiday Days Worked
    g
    Payroll Tax Authority Worktags for Current Calculation = Nova Scotia
    CAN Statutory Holiday Total Earnings / CAN Statutory Holiday Days Worked
    h
    Payroll Tax Authority Worktags for Current Calculation = Nunavut
    CAN Statutory Holiday Total Earnings / CAN Statutory Holiday Days Worked
    I
    Payroll Tax Authority Worktags for Current Calculation = Ontario
    CAN Statutory Holiday Total Earnings / 20
    J
    Payroll Tax Authority Worktags for Current Calculation = Prince Edward Island
    CAN Statutory Holiday Total Earnings / CAN Statutory Holiday Days Worked
    K
    Payroll Tax Authority Worktags for Current Calculation = Quebec
    CAN Statutory Holiday Total Earnings / 20
    L
    Payroll Tax Authority Worktags for Current Calculation = Saskatchewan
    CAN Statutory Holiday Total Earnings / 20
    M
    Payroll Tax Authority Worktags for Current Calculation = Yukon
    CAN Statutory Holiday Total Earnings * 0.1
  15. Enter zero as the
    Default Response
    .
  16. Access the
    Create Earning
     task and enter these settings:
    Option Description
    Name
    Statutory Holiday Pay [CAN]
    Code
    CAN_STAT_HOLIDAY
    Country
    Canada
  17. Enter these settings on the
    Effective Dated
     tab:
    Option Description
    Effective Date
    Today
    Worker Eligibility
    Row 1:
    • Timesheet: Approved Hours for Earning < > 0
    Calculation
    CAN Statutory Holiday Pay Calculation
    Override Frequency
    Hourly
    Calculation Proration
    None of the above
    Do Not Recalculate During Retro
    Select.
    Workday doesn't support retro for Statutory Holiday Pay.
  18. Enter these settings in the
    Related Calculations
     grid:
    Related Calculation
    Groups
    Override Calculation
    Do Not Store / Do Not Store if Zero
    Display Current / Current and Balances
    Do Not Apply Percentage Splits / Apply Percentage Splits
    CAN Statutory Holiday - Hours Worked
    CAN Statutory Holiday: Hours Worked
    None of the above
    Current and Balances
    None of the above
    CAN Statutory Holiday - Days Worked
    CAN Statutory Holiday: Days Worked
    None of the above
    Current and Balances
    None of the above
    CAN Statutory Holiday - Time Based Earnings
    Statutory Holiday Total Time Based Earnings
    None of the above
    Current and Balances
    None of the above
    CAN Statutory Holiday - Non Time Based Earnings
    CAN Statutory Holiday Non Time Based Earnings
    None of the above
    Current and Balances
    None of the above
    CAN Statutory Holiday - Total Earnings
    CAN Statutory Holiday Total Earnings
    None of the above
    Current and Balances
    None of the above
    CAN Statutory Holiday EI Hours
    EI Hours [CAN]
    CAN Statutory Holiday Hours Worked / CAN Statutory Holiday Days Worked
    None of the above
    Current and Balances
    None of the above
    CAN Statutory Holiday - Prior Period Holiday Pay
    Statutory Holidays Paid in Lookback Period
    None of the above
    Current and Balances
    None of the above
  19. Enter
    Hourly Pay
     as the
    Compensation Element
    .
  20. Enter
    Canada Statutory Holiday
     in the
    Time Calculation Tags
     grid.
    The
    Time Calculation Tag
     used on the earning must match the tag used on the
    Create Statutory Holiday Configuration
     task and used as the
    Statutory Holiday Calculation Tag
    .
  21. Enter these settings on the
    Non-Effective Dated
     tab:
    Option Description
    Groups
    Adds to Gross [CAN USA]
    CNESST Taxable [CAN]
    BCEHT Taxable [CAN]
    CPP Taxable [CAN]
    EI Taxable [CAN]
    Income Taxable (Withhold Taxes) [CAN]
    Manitoba Health Taxable [CAN]
    Newfoundland and Labrador Health Taxable [CAN]
    Northwest Territories Payroll Tax Taxable [CAN]
    Nunavut Payroll Tax Taxable [CAN]
    ONEHT Taxable [CAN]
    QHSF Taxable [CAN]
    QPIP Taxable [CAN]
    QPP Taxable (Withhold Taxes) [CAN]
    Quebec Taxable (Withhold Taxes) [CAN]
    Statutory Holiday Pay Earning [CAN]
    Withholding Order (All): Periodic Earnings and Lump Sum Earnings Canada [CAN]
    WSDRF Taxable [CAN]
    ROE
    Allocation Reporting Period
     >
    Period Paid
    Allocation Reporting Period for Hours
     >
    Period Paid
    Allocation Reporting Period Retro
     >
    Period Paid
    Allocation Reporting Period for Retro Hours
     >
    Period Paid
Statutory Holiday Pay now resolves for each province when you process payroll.