---
title: "Employee Wellbeing Installation Instructions"
slug: "employee-wellbeing-installation-instructions"
updated: 2026-10-06T14:03:23Z
published: 2026-10-06T14:03:23Z
canonical: "documentation.lakesidesoftware.com/employee-wellbeing-installation-instructions"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.lakesidesoftware.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](/documentation/docs/employee-wellbeing-installation-instructions#import-kit).
2. [Create the Healthy Working View](/documentation/docs/employee-wellbeing-installation-instructions#healthy-working-view).
3. [Assign the Healthy Working View to the Employee Wellbeing Role](/documentation/docs/employee-wellbeing-installation-instructions#assign-the-healthy-working-view-to-the-employee-wellbeing-role).
4. [Assign the Employee Wellbeing Role to Relevant Configurations](/documentation/docs/employee-wellbeing-installation-instructions#employee-wellbeing-role).
5. [Configure the Security Role](/documentation/docs/employee-wellbeing-installation-instructions#security-role).

### Import the Kit

There are two ways to import the DEX Pack to SysTrack:

- Import the pack directly from the Kits page in SysTrack. See the [Import Online Kits](/documentation/docs/import-online-kits) guide for more information.
- Import a local file downloaded from the [DEX and Kit Downloads](/documentation/docs/dex-packs-dex-and-kit-downloads) page. Click the **Download Kit** link for the pack and follow the [Import Local Kits](/documentation/docs/import-local-kits) guide to finish the import.

### 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]
> **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](/documentation/docs/employee-wellbeing-installation-instructions#sfusersdaily-sql-query3), 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

```sql
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.