Activity timer log components

The 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.

Tables

The activity timer log feature adds the following tables.

Table Description 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. 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. Field Description Attributes Attributes for the entry, such as the record state and short description. Record The record type and number. For example, Case: CS0001008. Session The session ID. Source The record page that the agent was using in CRM Workspace. Table The table that stores the record in the Record field. Timer running The start and stop times for the entry. Timestamp The timestamp for the start and stop times. Transaction The transaction ID for a start/stop pair. User The name or role of the user who worked on a record.

<table id=“table_u5g_d2y_z3c”><thead><tr><th>

Field

</th><th>

Description

</th></tr></thead><tbody><tr><td>

User

</td><td>

The name or role of the user who worked on a record. This is a reference to the sys_user table.

</td></tr><tr><td>

Record

</td><td>

Record number.

</td></tr><tr><td>

Record Type

</td><td>

Record type, such as case or interaction.

</td></tr><tr><td>

Short Description

</td><td>

Short description of the record.

</td></tr><tr><td>

Start Time

</td><td>

Time that the agent started working on the record.

</td></tr><tr><td>

End Time

</td><td>

Time that the agent stopped working on the record.

</td></tr><tr><td>

Total Time Logged

</td><td>

Total time that the user spent working on the record, displayed in the following format:- In seconds for durations under a minute - In minutes for durations of one hour or less - In hours and minutes for durations of more than one hour

</td></tr></tbody> </table>Note: Data in the Time Entry Aggregated table is automatically deleted 31 days after it is created.

User roles

The activity timer log feature adds the following user roles:

• sn_at.admin

• sn_at.agent

Script include

The TimeTrackerAggregator script include:

• Runs every 24 hours and records all the transactions from the Timer Entries table.

• Is invoked by the Activity Timer Reporting Aggregator scheduled job.

• For each record, calculates the time between each start and stop on the record.

Scheduled job

The 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.

Page properties

The activity timer log feature adds the following UI Builder page properties:

Property Description **activity\_timer** Enables the activity timer component in the workspace.- True: Activity timer is active. - False: Activity timer is inactive. **activity\_timer\_custom\_tables** Specifies custom tables for the activity timer log feature. **activity\_timer\_case\_type\_exclusion** Specifies case types excluded from the activity timer log feature.