---
title: "Daily Labor Retention Extract"
slug: "daily-retention-extract"
description: "Export employee punch data (clock-in/out, job, hire date, pay rate) by business day for daily pay processing."
updated: 2025-08-21T21:27:51Z
published: 2025-08-21T21:27:51Z
canonical: "docs.restaurant365.com/daily-retention-extract"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Daily Labor Retention Extract

The Daily Retention Extract is a file export that displays employee punch data for the selected day(s) for daily pay purposes.

---

## Navigation

The My Reports search bar can be used to search R365's entire catalog of reports.

1. Open the **Reports** app.
2. Navigate to **My Reports**.
3. Enter all or part of the report name in the **search bar**.
4. The **Results** tab will open with the list of search results.
5. From beneath the report name, click **Run** to run the report with the selected report view. -OR- Click **Customize** to adjust the report parameters and run the report.

![Overview of report options in Restaurant365 with highlighted run and customize buttons.](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/report.png)

---

## Report Parameters

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-K25RUFIL.png)

| Field | Description |
| --- | --- |
| Filter By | A list of all filter categories. Filter categories will vary based on the report. |
| Filter | A list of filter options determined by the 'Filter By' category selected. |
| Start | First date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for the data generated. The report then displays data for all dates within the date range, including the start and end dates. |
| End | Last date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for the data generated. The report then displays data for all dates within the date range, including the start and end dates. |
| Job Type | Filters the report to include only the jobs assigned to the selected job types. The default is All. |
| Job | Filters the report to include only the employees assigned to the selected jobs. Options selectable here are based on the Job Type selected in the parameter above. |
| Hash Employee ID | Indicates whether or not the employee ID will be hashed (obscured to be unidentifiable). When set to **Yes**, the Employee IDs will be hashed. When set to **No**, the Employee IDs will appear on the export. |
| Include Pay Rate | Indicates whether or not the pay rate will be included on the report. When set to **Yes**, an additional PAY_RATE column and its data will appear on the report. When set to **No**, the report will export without the PAY_RATE column. |

---

## Report Columns

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-2Z1I4S00.png)

| **j Field** | **Description** |
| --- | --- |
| **STORE_ID** | Location number. |
| **BUSINESS_DAY** | Date of the business day the punch occurred (aligned with daily sales summary (DSS) date). |
| **EMPLOYEE_ID** | Employee payroll ID. |
| **EMPLOYEE_ROLE** | Job name that the employee clocked in under for the given shift. |
| **HIRE_DATE** | Date the employee was hired. |
| **TERMINATION_DATE** | Date of employee termination. > [!NOTE] > This is not tracked in R365, and this column will be blank in the export. |
| **EMPLOYEE_CLOCK_ACTIVITY_ID** | ID of the R365 labor record. |
| **CLOCK_IN** | Punch in time of the labor record. |
| **CLOCK_OUT** | Punch out time of the labor record. |
| **SOURCE_OF_DATA** | R365 |
| **PAY_RATE** | Employee’s rate of pay. > This column will only appear when the **Include Pay Rate** parameter is set to **Yes**. |