resource_day_summaries_v1
Represents resources’ time spent against various activities summarized per day.
| Column | Data type | Description |
|---|---|---|
| id | VARCHAR(32) | The unique identifier of the resource utilization per day. |
| resource_id | NUMBER(38,0) | The identifier of the resource. |
| resource | VARCHAR(100) | The full name of the resource. |
| resource_group | VARCHAR(100) | The name of the group that this resource belongs to. |
| shift_duration_in_minutes | NUMBER(38,2) | The duration of the resource shift in minutes. |
| shift_duration_in_hours | NUMBER(38,2) | The duration of the resource shift in hours. |
| driving_duration_in_minutes | NUMBER(38,2) | The duration of the resource driving in minutes. |
| driving_duration_in_hours | NUMBER(38,2) | The duration of the resource driving in hours. |
| driving_duration_within_wh_in_minutes | NUMBER(38,2) | The duration of the resource driving within working hours (shift) in minutes. |
| driving_duration_within_wh_in_hours | NUMBER(38,2) | The duration of the resource driving within working hours (shift) in hours. |
| driving_duration_outside_wh_in_minutes | NUMBER(38,2) | The duration of the resource driving outside working hours (shift) in minutes. |
| driving_duration_outside_wh_in_hours | NUMBER(38,2) | The duration of the resource driving outside working hours (shift) in hours. |
| job_duration_in_minutes | NUMBER(38,2) | The duration of the resource working on jobs in minutes. |
| job_duration_in_hours | NUMBER(38,2) | The duration of the resource working on jobs in hours. |
| job_duration_within_wh_in_minutes | NUMBER(38,2) | The duration of the resource working on jobs within working hours (shift) in minutes. |
| job_duration_within_wh_in_hours | NUMBER(38,2) | The duration of the resource working on jobs within working hours (shift) in hours. |
| job_duration_outside_wh_in_minutes | NUMBER(38,2) | The duration of the resource working on jobs outside working hours (shift) in minutes. |
| job_duration_outside_wh_in_hours | NUMBER(38,2) | The duration of the resource working on jobs outside working hours (shift) in hours. |
| job_duration_in_minutes_as_resource | NUMBER(38,2) | The duration of the resource working on jobs as the main resource in minutes. |
| job_duration_in_hours_as_resource | NUMBER(38,2) | The duration of the resource working on jobs as the main resource in hours. |
| job_duration_within_wh_in_minutes_as_resource | NUMBER(38,2) | The duration of the resource working on jobs as the main resource within working hours (shift) in minutes. |
| job_duration_within_wh_in_hours_as_resource | NUMBER(38,2) | The duration of the resource working on jobs as the main resource within working hours (shift) in hours. |
| job_duration_outside_wh_in_minutes_as_resource | NUMBER(38,2) | The duration of the resource working on jobs as the main resource outside working hours (shift) in minutes. |
| job_duration_outside_wh_in_hours_as_resource | NUMBER(38,2) | The duration of the resource working on jobs as the main resource outside working hours (shift) in hours. |
| job_duration_in_minutes_as_assistant | NUMBER(38,2) | The duration of the resource working on jobs as an assistant in minutes. |
| job_duration_in_hours_as_assistant | NUMBER(38,2) | The duration of the resource working on jobs as an assistant in hours. |
| job_duration_within_wh_in_minutes_as_assistant | NUMBER(38,2) | The duration of the resource working on jobs as an assistant within working hours (shift) in minutes. |
| job_duration_within_wh_in_hours_as_assistant | NUMBER(38,2) | The duration of the resource working on jobs as an assistant within working hours (shift) in hours. |
| job_duration_outside_wh_in_minutes_as_assistant | NUMBER(38,2) | The duration of the resource working on jobs as an assistant outside working hours (shift) in minutes. |
| job_duration_outside_wh_in_hours_as_assistant | NUMBER(38,2) | The duration of the resource working on jobs as an assistant outside working hours (shift) in hours. |
| driving_and_job_duration_in_minutes | NUMBER(38,2) | The duration of the resource driving and working on jobs in minutes. |
| driving_and_job_duration_in_hours | NUMBER(38,2) | The duration of the resource driving and working on jobs in hours. |
| driving_and_job_duration_within_wh_in_minutes | NUMBER(38,2) | The duration of the resource driving and working on jobs within working hours (shift) in minutes. |
| driving_and_job_duration_within_wh_in_hours | NUMBER(38,2) | The duration of the resource driving and working on jobs within working hours (shift) in hours. |
| driving_and_job_duration_outside_wh_in_minutes | NUMBER(38,2) | The duration of the resource driving and working on jobs outside working hours (shift) in minutes. |
| driving_and_job_duration_outside_wh_in_hours | NUMBER(38,2) | The duration of the resource driving and working on jobs outside working hours (shift) in hours. |
| absence_duration_in_minutes | NUMBER(38,2) | The duration of the resource actual absence during the shift in minutes. |
| absence_duration_in_hours | NUMBER(38,2) | The duration of the resource actual absence during the shift in hours. |
| planned_absence_duration_in_minutes | NUMBER(38,2) | The duration of the resource planned absence during the shift in minutes. |
| planned_absence_duration_in_hours | NUMBER(38,2) | The duration of the resource planned absence during the shift in hours. |
| unallocated_duration_in_minutes | NUMBER(38,2) | The duration of the resource unallocated time (i.e. time not spent on driving, job or absence) during the shift, in minutes. |
| unallocated_duration_in_hours | NUMBER(38,2) | The duration of the resource unallocated time (i.e. time not spent on driving, job or absence) during the shift, in hours. |
| availability_duration_in_minutes | NUMBER(38,2) | The duration of the resource availability in minutes after excluding absence duration. |
| availability_duration_in_hours | NUMBER(38,2) | The duration of the resource availability in hours after excluding absence duration. |
| date | DATE | The date of resource utilization summary. |
| date_year | NUMBER(4,0) | The year of the 'date' column. |
| date_month | NUMBER(2,0) | The month of the 'date' column. |
| date_day | NUMBER(2,0) | The day of the 'date' column. |
| date_week | NUMBER(2,0) | The week of the year of the 'date' column. |
| date_day_of_the_week | NUMBER(2,0) | The day of the week of the 'date' column. |
| date_week_commencing_date | DATE | The week commencing date of the 'date' column. |
| time_zone | VARCHAR(80) | The time zone of the resource. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the resource day record was last refreshed. |