Tableau Data Export

Disclaimer

Worklytics assumes no responsibility for Customer use or management of exported data. In particular, such data is no longer subject to our Privacy Policy, Terms of Service, or any applicable agreements between Worklytics and the Customer Organization.

By initiating or requesting a data export, Customer agrees to ensure that all subsequent usage, management, and retention of exported data by the Customer is consistent with all applicable laws, data protection regulations, and labor/employee/contractor agreements. Customer acknowledges that data exports may include Personally Identifiable Information (PII), which may impose particular data protection requirements on the data.

Additionally, data exports may include information that could be considered sensitive, confidential, or private. Please take care in your usage of the data to avoid inadvertent disclosures of such information. The simplest way to do this is to avoid exposing any non-aggregated data from the Items/Events dataset to end users (ie, humans), and in particular any text fields. Should you choose to expose data from that set to end users, we recommend that you endeavor to respect the privacy models of the underlying data sources.

TABLEAU DATA EXPORT SCHEMAS

DASHBOARD_WEEKLY_GROUP_AGGREGATES

NAME	TYPE	DESCRIPTION
week	DATE	isoweek, starts on Monday
idType	STRING	type of group (ORG or GROUP)
groupType	STRING	group sub type
groupName	STRING	group name
aggType	STRING	AVG/ SUM/ COUNT
key	STRING	metric key
value	FLOAT	metric value
sumValue	FLOAT	sum of all (precalculated value, usefulness depends on the aggregate)
avgByActiveEmployees	FLOAT	avg per active employee (precalculated, usefulness depends on the aggregate)
activeEmployees	INTEGER	active members on the week
totalMembers	INTEGER	total members on the week
worklyticsId	STRING	worklytics unique for the group id

DASHBOARD_SURVEY_DATA

NAME	TYPE	DESCRIPTION
employeeId	STRING	employee id as provided by customer
questionId	STRING	question id
questionLabel	STRING	question text
surveyDate	DATE	response date
surveyName	STRING	survey name for identification
value	INTEGER	question response value

DASHBOARD_SURVEY_DATA_INDIVIDUAL_AGGREGATES

NAME	TYPE	DESCRIPTION
employeeId	STRING	employee id as provided by customer
week	DATE	isoweek, starts on Monday
key	STRING	metric key
value	FLOAT	metric value

DASHBOARD_SURVEY_DATA_INDIVIDUAL_GROUPS

This schema is generated dynamically based on the groups provided by the customer. Fixed columns are:

• employeeId

• week

• active

The following table shows all possible columns, final customer export might differ.

NAME	TYPE	DESCRIPTION
employeeId	STRING	employee id as provided by customer
week	DATE	isoweek, starts on Monday
BUSINESS_UNIT	STRING	BUSINESS_UNIT group this person belonged to during the week, NULL if none
BUSINESS_SEGMENT	STRING	BUSINESS_SEGMENT group this person belonged to during the week, NULL if none
COST_CENTRE	STRING	COST_CENTRE group this person belonged to during the week, NULL if none
DEPARTMENT	STRING	DEPARTMENT group this person belonged to during the week, NULL if none
LEVEL	STRING	LEVEL group this person belonged to during the week, NULL if none
LINE_OF_BUSINESS	STRING	LINE_OF_BUSINESS group this person belonged to during the week, NULL if none
OFFICE	STRING	OFFICE group this person belonged to during the week, NULL if none
ROLE	STRING	ROLE group this person belonged to during the week, NULL if none
TEAM	STRING	TEAM group this person belonged to during the week, NULL if none
TERRITORY	STRING	TERRITORY group this person belonged to during the week, NULL if none
CUSTOM_GROUP_1	STRING	CUSTOM_GROUP_1 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_2	STRING	CUSTOM_GROUP_2 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_3	STRING	CUSTOM_GROUP_3 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_4	STRING	CUSTOM_GROUP_4 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_5	STRING	CUSTOM_GROUP_5 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_6	STRING	CUSTOM_GROUP_6 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_7	STRING	CUSTOM_GROUP_7 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_8	STRING	CUSTOM_GROUP_8 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_9	STRING	CUSTOM_GROUP_9 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_10	STRING	CUSTOM_GROUP_10 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_11	STRING	CUSTOM_GROUP_11 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_12	STRING	CUSTOM_GROUP_12 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_13	STRING	CUSTOM_GROUP_13 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_14	STRING	CUSTOM_GROUP_14 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_15	STRING	CUSTOM_GROUP_15 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_16	STRING	CUSTOM_GROUP_16 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_17	STRING	CUSTOM_GROUP_17 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_18	STRING	CUSTOM_GROUP_18 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_19	STRING	CUSTOM_GROUP_19 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_20	STRING	CUSTOM_GROUP_20 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_21	STRING	CUSTOM_GROUP_21 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_22	STRING	CUSTOM_GROUP_22 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_23	STRING	CUSTOM_GROUP_23 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_24	STRING	CUSTOM_GROUP_24 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_25	STRING	CUSTOM_GROUP_25 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_26	STRING	CUSTOM_GROUP_26 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_27	STRING	CUSTOM_GROUP_27 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_28	STRING	CUSTOM_GROUP_28 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_29	STRING	CUSTOM_GROUP_29 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_30	STRING	CUSTOM_GROUP_30 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_31	STRING	CUSTOM_GROUP_31 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_32	STRING	CUSTOM_GROUP_32 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_33	STRING	CUSTOM_GROUP_33 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_34	STRING	CUSTOM_GROUP_34 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_35	STRING	CUSTOM_GROUP_35 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_36	STRING	CUSTOM_GROUP_36 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_37	STRING	CUSTOM_GROUP_37 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_38	STRING	CUSTOM_GROUP_38 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_39	STRING	CUSTOM_GROUP_39 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_40	STRING	CUSTOM_GROUP_40 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_41	STRING	CUSTOM_GROUP_41 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_42	STRING	CUSTOM_GROUP_42 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_43	STRING	CUSTOM_GROUP_43 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_44	STRING	CUSTOM_GROUP_44 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_45	STRING	CUSTOM_GROUP_45 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_46	STRING	CUSTOM_GROUP_46 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_47	STRING	CUSTOM_GROUP_47 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_48	STRING	CUSTOM_GROUP_48 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_49	STRING	CUSTOM_GROUP_49 group this person belonged to during the week, NULL if none
CUSTOM_GROUP_50	STRING	CUSTOM_GROUP_50 group this person belonged to during the week, NULL if none
<any HRIS custom group defined 1>	STRING	Only if present in Employee Snapshot HRIS file, the first custom group defined there.
<any HRIS custom group defined ...>	STRING	Only if present in Employee Snapshot HRIS file, rest of custom groups defined there (one column per group)
	STRING	Only if present in Employee Snapshot HRIS file, the last custom group defined there.
ETHNICITY	STRING	ETHNICITY group this person belonged to during the week, NULL if none
GENDER	STRING	GENDER group this person belonged to during the week, NULL if none
GENERATION	STRING	GENERATION group this person belonged to during the week, NULL if none
MILITARY_STATUS	STRING	MILITARY_STATUS group this person belonged to during the week, NULL if none
active	BOOLEAN	if employee was considered active on the week