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
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
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
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.
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
Last updated