Employee Wellbeing Installation Instructions

Prerequisites

• Minimum Version: Requires SysTrack 11.8 or later.

Notes

• After this DEX Pack is installed, it may take up to 24 hours for data to appear.

• If you update or reinstall this DEX Pack, you must reassign any Views created below to the SF_Employee Wellbeing Role.

Installation Steps

To install this DEX Pack, complete the following steps:

1. Import the Kit.

2. Create the Healthy Working View.

3. Assign the Healthy Working View to the Employee Wellbeing Role.

4. Assign the Employee Wellbeing Role to Relevant Configurations.

5. Configure the Security Role.

Import the Kit

Create the Healthy Working View

The Healthy Working Dashboard requires you to make a View for the SF_Employee Wellbeing Role.

To create the new View:

1. Navigate to Configure > Views.

2. Click the padlock icon in the upper-right to enable editing.

3. Click the plus icon to add a new View.

4. Fill in the Settings as follows:

   1. View Name: SF_USERSDAILY

   2. Expires in: 30 Days

   3. Existing Category: Custom

      NOTE: If the existing Category does not contain Custom, create a new category for Custom in the New Category text box.

   4. When Expired: Append Data

   5. Do NOT check When overdue by 1 day(s).

   6. Set the Refresh drop-downs to Daily, Inside, 24x7, and Every Day.

   7. Copy the SF_USERSDAILY SQL Query, and paste it into the box under SQL Selection > Generic.

   8. Click Test SQL. A Success message should appear at the top of the screen. If the test is not successful, the query may have been copied incorrectly.

5. Click Create View at the top-right.

SF_USERSDAILY SQL Query

SELECT
	WGUID,
	GETUTCDATE() AS VWTIME,
	UNAME,
	DOTY,
	ACTIVE_TIME,
	SUM_BREAK_TIME,
	MAX_BREAK_TIME
FROM (
	SELECT
		T0.WGUID,
		GETUTCDATE() AS VWTIME,
		S0.STRVALUE AS UNAME,
		DATEADD(D,DATEDIFF(D,0,T0.WTIME),0) AS DOTY,
		COUNT(*) * 10 AS ACTIVE_TIME,
		SUM(CASE WHEN DATEDIFF(N,PREVIOUS_TIME,WTIME) BETWEEN 15 AND 180 THEN DATEDIFF(N,PREVIOUS_TIME,WTIME) ELSE 0 END) AS SUM_BREAK_TIME,
		MAX(CASE WHEN DATEDIFF(N,PREVIOUS_TIME,WTIME) BETWEEN 15 AND 180 THEN DATEDIFF(N,PREVIOUS_TIME,WTIME) ELSE 0 END) AS MAX_BREAK_TIME
	FROM (
		SELECT
			T0.WGUID,
			T0.WTIME,
			T0.ACCOUNT_ID,
			MAX(T1.WTIME) AS PREVIOUS_TIME
		FROM (
			SELECT
				T0.WGUID,
				T0.WTIME,
				T0.ACCOUNT_ID
			FROM SASYSUSERS AS T0
			INNER JOIN (
				SELECT ACCOUNT_ID
				FROM SAAPP
				WHERE SYSACCOUNT = 0
				GROUP BY ACCOUNT_ID
				HAVING SUM(FOCUS_TIME) > 0
			) AS T1 ON T0.ACCOUNT_ID = T1.ACCOUNT_ID
			WHERE
				WTYPE = 1
				AND WUSAGE = 3
		) AS T0
		LEFT JOIN (
			SELECT
				T0.WTIME,
				T0.ACCOUNT_ID
			FROM SASYSUSERS AS T0
			INNER JOIN (
				SELECT ACCOUNT_ID
				FROM SAAPP
				WHERE SYSACCOUNT = 0
				GROUP BY ACCOUNT_ID
				HAVING SUM(FOCUS_TIME) > 0
			) AS T1 ON T0.ACCOUNT_ID = T1.ACCOUNT_ID
			WHERE
				WTYPE = 1
				AND WUSAGE = 3
		) AS T1 ON T0.WTIME > T1.WTIME AND T0.ACCOUNT_ID = T1.ACCOUNT_ID
		GROUP BY
			T0.WGUID,
			T0.WTIME,
			T0.ACCOUNT_ID
	) AS T0
	INNER JOIN SASTRUSER AS S0 ON T0.ACCOUNT_ID = S0.STRINGID
	GROUP BY
		T0.WGUID,
		S0.STRVALUE,
		DATEADD(D,DATEDIFF(D,0,T0.WTIME),0)
) AS T0
WHERE
	DATEDIFF(D, DOTY, <LASTREFRESHTIME>) <= 0
	AND DATEDIFF(D, DOTY, GETUTCDATE()) > 0

Assign the Healthy Working View to the Employee Wellbeing Role

To assign the new View:

1. Navigate to Configure > Roles.

2. Use the drop-down at the top to select the SF_Employee Wellbeing Role.

3. Click Views, then check the box next to SF_USERSDAILY.

4. Click Save Changes at the top-right.

After this View is assigned, Screen Time data will be collected each day. It will take 30 days before the data in this Dashboard is fully populated.

Assign the Employee Wellbeing Role to Relevant Configurations

The Employee Wellbeing DEX Pack requires you to assign the SF_Employee Wellbeing Role to the relevant Configurations:

1. Navigate to Configure > Configurations.

2. Click the padlock icon in the upper-right to enable editing.

3. Use the drop-down at the top to select a relevant Configuration, or create a new Configuration.

4. Assign the SF_Employee Wellbeing Role to the Configuration by dragging it from Available Roles to Assigned Roles

5. Click Save Changes at the top-right.

6. Repeat this process for any other relevant Configurations.

Configure the Security Role

Due to the sensitive nature of the data in this DEX Pack, only specific users can view it. By default, the Employee Wellbeing Security Role is applied. With this Security Role, only users with Dashboard Builder access can view this DEX Pack.

To edit the users who can view this DEX Pack:

1. Open Dashboard Builder.

2. Click the key icon in the top-left.

3. Click Employee Wellbeing Security Role.

4. Use the Role Membership pane to add or remove users as needed. You can add individual users or dynamic groups of users.