{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":5498,"path":"customer-service-management/activity-timer-log-components.md","title":"Activity timer log components","bundle":null,"doc_type":null,"release":"australia","body":"\n# Activity timer log components\n\nThe activity timer log feature is available with the Activity Timer Reporting application. This application adds user tables, user roles, UIB page properties, a script include, and a scheduled job.\n\n## Tables\n\nThe activity timer log feature adds the following tables.\n\n|Table|Description|\n|-----|-----------|\n|Time Entry \\[sn\\_at\\_time\\_entry\\]|Records the time that an agent spends working on case and interaction records. Each start and stop transaction has a time associated with it.|\n|Time Entry Aggregated \\[sn\\_at\\_time\\_entry\\_aggregated\\]|Aggregates the data stored in the Time Entry table. This aggregation records the time spent per case, agent, and record type.|\n\n|Field|Description|\n|-----|-----------|\n|Attributes|Attributes for the entry, such as the record state and short description.|\n|Record|The record type and number. For example, Case: CS0001008.|\n|Session|The session ID.|\n|Source|The record page that the agent was using in CRM Workspace.|\n|Table|The table that stores the record in the **Record** field.|\n|Timer running|The start and stop times for the entry.|\n|Timestamp|The timestamp for the start and stop times.|\n|Transaction|The transaction ID for a start/stop pair.|\n|User|The name or role of the user who worked on a record.|\n\n\n
\n\nField\n\n\n\nDescription\n\n
\n\nUser\n\n\n\nThe name or role of the user who worked on a record. This is a reference to the sys\\_user table.\n\n
\n\nRecord\n\n\n\nRecord number.\n\n
\n\nRecord Type\n\n\n\nRecord type, such as case or interaction.\n\n
\n\nShort Description\n\n\n\nShort description of the record.\n\n
\n\nStart Time\n\n\n\nTime that the agent started working on the record.\n\n
\n\nEnd Time\n\n\n\nTime that the agent stopped working on the record.\n\n
\n\nTotal Time Logged\n\n\n\nTotal time that the user spent working on the record, displayed in the following format:- In seconds for durations under a minute\n- In minutes for durations of one hour or less\n- In hours and minutes for durations of more than one hour\n\n
**Note:** Data in the Time Entry Aggregated table is automatically deleted 31 days after it is created.\n\n## User roles\n\nThe activity timer log feature adds the following user roles:\n\n- sn\\_at.admin\n- sn\\_at.agent\n\n## Script include\n\nThe `TimeTrackerAggregator` script include:\n\n- Runs every 24 hours and records all the transactions from the Timer Entries table.\n- Is invoked by the `Activity Timer Reporting Aggregator` scheduled job.\n- For each record, calculates the time between each start and stop on the record.\n\n## Scheduled job\n\nThe **Activity Timer Reporting Aggregator** scheduled job runs once every 24 hours and generates a report. It creates an aggregation of the records stored in the Time Entry table and stores this data in the Time Entry Aggregated table. The aggregated data is displayed in the agent's My Timelog list view.\n\n## Page properties\n\nThe activity timer log feature adds the following UI Builder page properties:\n\n\n
\n\nProperty\n\n\n\nDescription\n\n
\n\n**activity\\_timer**\n\n\n\nEnables the activity timer component in the workspace.- True: Activity timer is active.\n- False: Activity timer is inactive.\n\n
\n\n**activity\\_timer\\_custom\\_tables**\n\n\n\nSpecifies custom tables for the activity timer log feature.\n\n
\n\n**activity\\_timer\\_case\\_type\\_exclusion**\n\n\n\nSpecifies case types excluded from the activity timer log feature.\n\n
"}}