The table contains detailed data about tasks/activities (actions — not visits, vacations, sick leaves, etc.) of users in the CRM system. It is used to analyze task execution, duration, activity types, statuses, and employee workload in Power BI.
| Field Name | Description |
|---|---|
act_action_type_id | Task type identifier, linked to the reference table crm_tasktype_csv |
act_country | Country where the task was performed |
act_date close | Task completion date in the format dd/mm/yyyy hh:mm:ss |
act_date create | Task creation date in the format dd/mm/yyyy hh:mm:ss |
act_date start | Task start date in the format dd/mm/yyyy hh:mm:ss |
act_datefrom | Task start date in the format dd.mm.yyyy |
act_datefrom_key | Date key in the format of day, month, and year for period aggregations |
act_dayweek | Name of the day of the week |
act_duration | Task duration in minutes |
act_ID | Unique sequential task number in the system (action) |
act_name | Task name (cleaned from service symbols) |
act_status | Task status (e.g., completed, planned, canceled) |
act_status_flag | Task closure flag (1 = closed, 0 = open) |
act_task_in_day | Average number of tasks per day (default 15) |
act_type | Name of the visit type |
act_user_id | User identifier, linked to the table crm_user_dictionary_csv |
act_workday | Workday (1 = yes, 0 = weekend) |
Duration h | Task duration in minutes (maximum 480 min = 8 hours) |
key_action | Special key composed of concatenated act_datefrom_key and act_user_id strings |