Labor by job

1-- core.toast_analytics.labor_by_job
2-- Labor hours and cost per job per day, with each job's cost as a share of the
3-- restaurant's net sales that day (Toast's labor cost percentage, by job).
4-- Grain: business date x restaurant x job.
5--
6-- Net sales come from Toast's daily labor report for the same restaurant and day,
7-- the figure Toast itself divides by. job_cost_pct_of_net_sales on each row sums
8-- across jobs to the restaurant's labor percentage for the day; over a longer
9-- period, sum total_cost and divide by the period's net sales instead.
10
11SELECT
12    j.business_date,
13    j.restaurant_id,
14    j.restaurant_name,
15    j.job_id,
16    j.job_title,
17    j.job_code,
18    j.regular_hours,
19    j.overtime_hours,
20    j.total_hours,
21    j.regular_cost,
22    j.overtime_cost,
23    j.total_cost,
24    l.net_sales                                    AS restaurant_net_sales,
25    SAFE_DIVIDE(j.total_cost, l.net_sales)         AS job_cost_pct_of_net_sales
26FROM {{staging.toast_analytics.labor_by_job}} j
27LEFT JOIN {{staging.toast_analytics.labor}} l USING (restaurant_id, business_date)