Basic Principles
From the data stored for work shift planning, you can add to a query:
- Planned and published shifts regardless of how they were created
- Combinations of shifts, for example:
- Total planned work for Fri–Sat, Sat–Sun, and Sun–Mon combinations
- Work scheduled on public holidays
- Data related to rest-time monitoring, such as:
- Various shift types (only if shift calendars are in use)
- e.g. how many evening→morning shift combinations occurred
- If you’re not using shift calendars (traditional mode), no shift types exist and this data can’t be obtained
- Various shift types (only if shift calendars are in use)
Note: Extracted shift durations do not account for assumed meal breaks from roster planning. For example, a planned 8 h shift with an automatic 30 min break still appears as 8 h, not 7 h 30 min.
Available Fields
- Person’s shift-calendar code and name
- Person’s leave-calendar code and name
- Shifts planned and published via roster planning and shift calendars (start and end date/time)
- For each planned and published shift:
- Planned event type (code)
- Abbreviation (from the shift calendar)
- Additional shift-type information
- Public shift information (cannot extract shift-group public info)
- You can search within this public info for specific characters or substrings (e.g. a keyword)
Can not be added to a query
- Shift-calendar contents (schemas)
- Leave-calendar contents (schemas)
- Shift requirements
- Tasks
- Competencies
- Shift-group planning data
- Shift-group public information
- Detailed shift-planning notes