Rostered hours report extract

Use the Rostered Hours extract to export a CSV file of worker appointment data — covering both shifts and sessions — for a selected date range. This provides information on workers' rostered hours, taking into consideration unpaid breaks and sleepovers. The export can then be opened in tools like Microsoft Excel, Google Sheets, or Apple Numbers for reporting and analysis.

Required packages and permissions

Available with: Lumary WFM 2.13 and later

Supported in: Lumary DC

Permission: Lumary - Scheduling permission set

Before you begin

• The maximum date range for a single extract is 3 months. If you need data beyond 3 months, run separate extracts.
• Large date ranges and appointments can extend the extract and file generation time.
• The date and time values in the export are based on the rostered worker's user time zone.
• When shifts are enabled, session hours that fall within a shift are not counted separately — only the shift's total hours are used.

To generate and export the rostered hours report:

1. Click on the App Launcher icon (nine dots on the top left hand side of the screen), search for extracts and click on the Lumary Extracts link.
2. Select Rostered Hours in the Extract Type picklist field.

This will load a new form. The following table explains the purpose of the fields. Mandatory fields are marked with an asterisk.

Field	Purpose
*Start Date	The starting date range of worker appointments that the report will include.
*End Date	The ending date range of worker appointments that the report will include.

3. Click Create Extract. You will receive an email when the extract is ready.

4. Click the link in the email or click Refresh List for the created extract to appear when ready, and click the Extract ID (e.g. EXT-000153).
5. Click Generate File. You will receive an email when the CSV file is ready.
6. Click the link in the email or refresh the page for the file to appear when generated.
7. Under the Files related list, click the generated file (e.g. Rostered Hours - 1/1/2026 - 31/1/2026.csv).
8. Click Download.

This will download the rostered hours CSV file. The following table explains the fields in the report. Unpaid time includes unpaid breaks and sleepovers.

Field	Purpose
Worker	The worker's name that was rostered to the session.
Session Type	The type of session that was rostered.
Status	The status of the worker appointment.
Site Name	The site that the session is located at (if it was located at a site).
Scheduled Start	The scheduled start date/time of the worker appointment.
Scheduled End	The scheduled end date/time of the worker appointment.
Scheduled Hours	The duration of hours scheduled, excluding unpaid time.
Finalised Start Date	The finalised start date/time of the worker appointment.
Finalised End Date	The finalised end date/time of the worker appointment.
Finalised Hours	The duration of hours finalised, excluding unpaid time.
Approved	Whether the worker appointment is approved.
Scheduled Unpaid Activities	The scheduled unpaid activities.
Scheduled Unpaid Hours	The duration of hours scheduled that are unpaid.
Finalised Unpaid Activities	The unpaid activities that are finalised.
Finalised Unpaid Hours	The duration of hours finalised that are unpaid.

Back to top