Skip to main content

Create a query on public holidays included in entitlement

Create a query on public holidays included in entitlement.

J
Written by Joshua Shooter
Updated over a month ago

If users have public holidays included in their entitlement you can query on them to view what duration each day currently has.

To build a query on public holidays included in entitlements:

  1. Click Access Button image then click HR Admin.

  2. Click Queries then click the plus + icon.

  3. Click Holidays, then select the following fields:

    • Holiday Start Date

    • Holiday End Date

    • Holiday Type

    • Holiday Duration (Days)

    • Holiday Duration (Hours)

  4. Click Next, then select Holiday Type.

  5. Apply the filter to Equals as Public Holiday Inclusive.

  6. Click Next and name your query.

  7. Click Next then, click Export To.

For users who don't have the Entitlement Includes Public Holiday? option selected in their planner settings, public holidays don't affect their entitlement so they will not show in the query. You can check what template they are assigned to by creating a public holiday template query.

Did this answer your question?