The Labor Activity view is the labor activity record for R365. It contains actual and scheduled shift details, pay rates, hours worked, wages earned, and tip information per employee, job, and location.
Labor Activity Columns
Column Name | Data Type | Description |
|---|---|---|
id | UUID | Unique identifier for the labor activity record. |
tenant_id | integer | Customer's account identifier within the R365 platform. |
labor_type | string | Indicates whether this record represents actual worked labor or a scheduled shift. Possible values: actual, scheduled. |
employee_id | UUID | Unique identifier for the employee associated with this labor activity. |
business_date | date | The operating day for which this labor activity is recorded, based on the restaurant's business calendar. |
date_worked | date | The actual calendar date on which the work was performed. |
dss_id | UUID | Reference to the Daily Sales Summary record associated with this actual labor entry. Not applicable for scheduled labor. |
legal_entity_id | UUID | Unique identifier for the legal entity (business unit) associated with this labor activity. |
legal_entity_name | string | Display name of the legal entity (business unit) associated with this labor activity. |
location_id | UUID | Unique identifier for the restaurant location where this labor activity was recorded. |
location_name | string | Display name of the restaurant location where this labor activity was recorded. |
department_name | string | Name of the department or job title classification associated with this labor record. |
job_code | string | Short code identifying the job role or position for this labor activity. |
job_title | string | Full title of the job role or position for this labor activity. |
start_time | timestamp | Date and time when the shift or scheduled period began. |
end_time | timestamp | Date and time when the shift or scheduled period ended. |
regular_rate | number | Standard hourly pay rate for this employee and job role. |
overtime_rate | number | Overtime hourly pay rate for this employee and job role. |
double_rate | number | Double overtime hourly pay rate. Null when double overtime does not apply to this labor record. |
regular_hours | number | Number of regular (non-overtime) hours worked or scheduled during this shift. |
overtime_hours | number | Number of overtime hours worked or scheduled during this shift. |
double_hours | number | Number of double overtime hours worked or scheduled. Null when double overtime does not apply. |
regular_amount | number | Total regular wage amount earned for this shift, calculated as regular hours multiplied by the regular rate. |
overtime_amount | number | Total overtime wage amount earned for this shift, calculated as overtime hours multiplied by the overtime rate. |
double_amount | number | Total double overtime wage amount earned for this shift. Null when double overtime does not apply. |
total_pay | number | Total wages earned for this shift, including regular pay, overtime, double overtime, and applicable penalty amounts. |
penalty_name | string | Name of the labor compliance penalty applied to this record, if any (e.g., Break, Split Shift, Clopening). |
penalty_amount | number | Monetary amount of the labor compliance penalty applied to this record, if any. |
credit_tips | number | Credit card tip amount received during this shift. Null for scheduled labor records. |
declared_tips | number | Cash tip amount declared by the employee for this shift. Null for scheduled labor records. |
total_tips | number | Total tip amount (credit card plus declared cash tips) for this shift. Null for scheduled labor records. |