CCF — Commuting
Yearly import covering the commuting habits of all employees across all company workspaces globally.
Import behavior: delete and reimport — existing data is permanently deleted before each new import.
FAQ
What happens to existing records on re-import?
The system permanently deletes all existing commuting data and replaces it with the new file.
Can I change column order or titles?
No.
How do I update existing records?
Export via Export file, edit rows, re-upload.
Can I record group commuting?
Yes. Each row can represent one employee (N° OF EMPLOYEES = 1) or a group of employees who commute the same distance by the same transport method (N° OF EMPLOYEES > 1).
Schema
| Column | Mandatory | Definition | Rule | Type | Example |
|---|---|---|---|---|---|
| COMMUTING ID | YES | Label for this commuting record | Spaces, - _ / | \ allowed · Uniqueness not validated | free text | rome-milan |
| WORKPLACE TYPE | NO | Type of workspace | Select from dropdown | single select | office |
| N. OF EMPLOYEES | YES | Number of employees in this commuting group | 1 ≤ x < 10,000 | numeric | 11 |
| AVG DISTANCE (one way) | YES | Average one-way distance from home to work (km) | 1 ≤ x < 10,000 | numeric | 14 |
| N. OF COMMUTED WORKING DAYS | YES | Average number of commuted working days per year | 1 ≤ x ≤ 365 | numeric | 255 |
| TRANSPORT METHOD | YES | Transport method used for commuting | Select from dropdown | single select | car |
| FUEL TYPE | YES if any car transport method | Fuel type of the car | Select from dropdown | single select | electric |
| EURO TYPE | YES if FUEL TYPE is diesel_low-sulfur | Euro emission class | Select from dropdown | single select | Euro 6 |
| TRANSPORT COUNTRY | YES if FUEL TYPE is electric | ISO country where the vehicle is registered | ISO 3166-1 alpha-2 | single select | IT |
Glossaries
WORKPLACE TYPE — 5 values: office · retail · showroom · warehouse · other
TRANSPORT METHOD — 14 values: tram · motorbike · bus · bus_electric · metro · bike · e-bike · e-scooter · car_small · car_medium · car_large · train · train_highspeed · walk
FUEL TYPE — 6 values: electric/petrol · natural_gas · diesel_low-sulfur · lpg · petrol_low-sulfur · electric
EURO TYPE — 4 values: euro_3 · euro_4 · euro_5 · euro_6
COUNTRY CODE — 249 ISO codes (see Supplier Registry — COUNTRY).
Cross-file dependencies
No cross-file dependencies. This file is self-contained.