Multiple Schedules Per Day Report

This report identifies employees who have multiple schedules on the same day, excluding benefit schedules. It helps identify potential scheduling conflicts or employees working multiple shifts in a single day.

Parameters

No explicit parameters are defined in the script. The report analyzes all available schedule data.

Data Components

The report consists of 1 main data section:

1. Multiple Schedule Detection - Identifies employees with more than one schedule per day

Output Format

The output shows employees who have multiple schedules on the same day:

Technical Implementation

The script uses:

• Schedule type filtering (excludes benefit schedules)
• GROUP BY operations to count schedules per employee per day
• HAVING clauses to filter for employees with multiple schedules
• Date-based grouping to identify same-day conflicts

Schedule Types Excluded

• Benefit schedules (vacation, sick time, etc.)
• Other non-work schedule types that shouldn't count as conflicts

Use Cases

• Identifying potential scheduling conflicts
• Finding employees working multiple shifts per day
• Quality control for schedule creation
• Compliance checking for labor regulations
• Detecting data entry errors in scheduling

T-SQL

SET NOCOUNT ON
SET ANSI_WARNINGS OFF

Declare @MIN DATE, @MAX DATE

SET @MIN={mindate}
SET @MAX={maxdate}
/*
SET @MIN='10/31/2021'
SET @MAX='11/6/2021'
*/

Select E.lastname+', '+E.Firstname, e.IDNUM, S.Schdate, COUNT(*) Count

From EMPLOYEES e, SCHEDULES s
where e.FILEKEY=s.FILEKEY and SCHTYPE!=2 and s.SCHDATE between @min and @max
Group BY e.LASTNAME,e.FIRSTNAME,e.idnum,s.SCHDATE Having Count(*)>1
order by 1,3

Content Inventory

• Doc File: content/docs/reports/schedule/multiple_schedules_per_day.mdx
• SQL Script: SQL/reports/schedule/schedule_hours_by_day_name_of_week.sql