timesheet_activities_v1
Timesheet activities encompass both job-related and non-job related tasks that mobile workers can log in their timesheets. These activities are essential for efficient task management and maintaining accurate records of the tasks performed by mobile workers.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier of the timesheet activity. |
| name | VARCHAR(40) | The name or description of the activity that the mobile worker is logging in their timesheet. |
| start_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the activity started. |
| end_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the activity ended. |
| status | VARCHAR(8) | Indicates current status of the activity. Possible values: 'Unsigned', 'Signed', 'Queried', 'Rejected', 'Approved', 'Paid'. |
| status_updated_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the status of the activity was last updated. |
| status_triggered_by | VARCHAR(100) | The name of the person who triggered activity status update. |
| contact_name | VARCHAR(100) | The name of the contact associated with the activity. |
| contact_address | VARCHAR(200) | The address of the contact associated with the activity. |
| contact_geolocation_longitude | FLOAT | The geolocation longitude of the contact. This is the longitude of the centroid of the shape describing contact location on the map. |
| contact_geolocation_latitude | FLOAT | The geolocation latitude of the contact. This is the latitude of the centroid of the shape describing contact location on the map. |
| contact_geolocation | VARCHAR(64) | The geolocation latitude and longitude of the contact. |
| driving_duration_in_seconds | NUMBER(38,0) | The amount of time spent driving for a particular activity, measured in seconds. |
| driving_distance_km | NUMBER(7,2) | The distance of the driving associated with activity in km. |
| _owner_id | NUMBER(38,0) | The identifier of the owner of the activity. |
| _contact_id | NUMBER(38,0) | The identifier of the contact associated with the activity. |
| _resource_id | NUMBER(38,0) | The identifier of the resource associated with the activity. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the activity record was last refreshed. |