resource_activities_v1
Represents resources’ time spent against various activities summarised per activity per day.
| Column | Data type | Description |
|---|---|---|
| id | VARCHAR(32) | The unique identifier of the resource activity. |
| resource_id | NUMBER(38,0) | The identifier of the resource. |
| resource | VARCHAR(100) | The resource name of the resource assigned for the job. |
| resource_group | VARCHAR(100) | The resource group of the job's resource. When the resource belongs to a different customer then the value is 'Collaboration'. |
| is_assistant | VARCHAR(3) | Indicates if the activity was performed by the resource as an assistant, for activities of type 'Job'. Possible values: 'Yes', 'No'. |
| type | VARCHAR(11) | The type of the resource activity. Possible values: 'Job', 'Driving', 'Absence', 'Unallocated'. 'Unallocated' represents time that is spent outside Job, Driving and Absence. |
| start_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the resource activity time slice start. |
| end_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the resource activity time slice end. |
| duration_in_minutes | NUMBER(38,2) | The duration of the resource activity of a type indicated in 'type' column in minutes. |
| duration_in_hours | NUMBER(38,2) | The duration of the resource activity of a type indicated in 'type' column in hours. |
| is_within_working_hours | VARCHAR(3) | Indicates if the activity was performed by the resource within working hours, for activities of type 'Job' or 'Driving'. Possible values: 'Yes', 'No'. |
| date | DATE | The date of the resource activity. |
| 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. |
| job_id | NUMBER(38,0) | The identifier of the job associated with 'Job' or 'Driving' resource activity. |
| job_reference | VARCHAR(88) | The reference of the job that is inputted as free text. |
| job_type | VARCHAR(200) | The type of the job. |
| job_category | VARCHAR(100) | The job's category name. |
| job_start_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the job start. |
| job_end_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the job end. |
| assistant_start_at | TIMESTAMP_TZ(9) | The timestamp with the time zone offset when the assistant initiates the job on their device. |
| assistant_end_at | TIMESTAMP_TZ(9) | The timestamp with the time zone offset when the assistant completes the job on their device. |
| contact | VARCHAR(256) | The name of the contact associated with the job. |
| parent_contact | VARCHAR(256) | The parent contact of the contact associated with the job. |
| contact_group | VARCHAR(100) | The contact group associated with the job. |
| absence_id | NUMBER(38,0) | The identifier of the absence associated with 'Absence' resource activity. |
| absence_start_at | TIMESTAMP_NTZ(9) | The timestamp of the planned absence start. |
| absence_end_at | TIMESTAMP_NTZ(9) | The timestamp of the planned absence end. |
| absence_type | VARCHAR(100) | The type of the resource absence as configured by the user in Administration panel. |
| number_of_days_off | NUMBER(3,1) | The number of days off for the planned absence. |
| is_paid | VARCHAR(3) | Indicates if the planned absence is paid. Possible values: 'Yes', 'No'. |
| _resource_deleted_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the resource record deletion. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the resource activity record was last refreshed. |