Badge Data

Prerequisites:

• as this data will be linked by EMPLOYEE_ID, you MUST also provide HRIS data to map EMPLOYEE_ID to individuals by email in your organization

Suggested filename: badge_data_YYYYMMDD.csv

Worklytics can import badge swipe data, to parse swipe records as work events and gain insights into physical office usage. Each row is parsed as a single badge swipe event.

If you have multiple physical buildings (or other space gated by swipe entry), you can provide an identifying string for each swipe event. With each swipe event, you can also provide a string identifying the individual's assigned building. The identifying strings used for BUILDING_ID and BUILDING_ASSIGNED must be consistent.

Header Name	Required	Type	Description
EMPLOYEE_ID	Yes	STRING	Id of individual in org's HR schema
SWIPE_DATE	Yes	DATETIME	Date and time the employee entered/exited the location, UTC
BUILDING_ID	No	STRING	The building this employee accessed
BUILDING_ASSIGNED	No	STRING	The building where this employee is assigned

Badge data import example

EMPLOYEE_ID,SWIPE_DATE,BUILDING_ID,BUILDING_ASSIGNED
E-001,2021-10-07T09:01:23.000Z,BOSTON 1,HQ NYC
E-002,2021-10-07T08:55:31.000Z,BOSTON 1,BOSTON 1
E-003,2021-10-07T09:02:46.000Z,BOSTON 2,BOSTON 1
E-002,2021-10-07T12:15:25.000Z,BOSTON 1,BOSTON 1
E-002,2021-10-07T12:45:57.000Z,BOSTON 1,BOSTON 1
E-003,2021-10-07T16:49:16.000Z,BOSTON 2,BOSTON 1
E-001,2021-10-07T17:14:43.000Z,BOSTON 1,HQ NYC
E-002,2021-10-07T18:01:05.000Z,BOSTON 1,BOSTON 1