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

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

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

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

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

STRING

Only if present in Employee Snapshot HRIS file, the first custom group defined there.

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

PreviousWork Items NextHow to export data to Cloud Storage Providers

Last updated 1 month ago