Employees

Employees datasource specification

This page describes the file-based datasource specification for syncing Employees into TechWolf when no standardized connector (such as Workday or SAP SuccessFactors) is available. It covers the Employee baseline, the organisational structure, and every skill-relevant signal attached to an Employee: learning, work history, certifications, education, feedback, projects, tickets, performance, Skill notes, resumes, and merge requests. It defines the files TechWolf expects, the fields within each file, and which fields are required.

Use this specification when a customer exports Employee data from any source system to flat files. The Employee Baseline file is required and establishes each Employee; every other file on this page references it through employee_id.

Two files link out to other entities: the Employee Baseline points to a Job through assigned_position, and Learning History points to a Course through course_id. The Jobs and Courses specifications must be synced as well for those links to resolve.

For the broader picture of how file-based integrations work and how they compare to API-based connectors, see Key concepts.

The delivery flow over SFTP and S3, the file locations, and how to read the field tables below are described in Technical data flow.

Most files on this page use an external_id as their primary key. Share the identifier from the source system where one exists. Where it does not, leave the field empty and TechWolf generates an identifier for the record.

Employee Baseline

The baseline Employee file. Required. Establishes the existence of each Employee; every other file on this page references it.

File on S3: .../file_based/TechWolf_Employee_Information/TechWolf_Employee_Information_[yyyy][MM][dd]_[HH][mm][ss].csv

TechWolf field	Required	Key	Max chars	Notes
employee_id	Required	Primary key	100	External ID of the file. ID of the Employee.
assigned_position	Recommended	Foreign key	100	The Employee’s current Job. Points to job_id in Job Information.
organisational_unit_id	Recommended	Foreign key	100	Points to organisational_unit_id in Organisational Information.
active	Recommended		n/a

Organisational Information

The supervisory organisation structure. Highly recommended.

File on S3: .../file_based/TechWolf_Supervisory_Organization/TechWolf_Supervisory_Organization_[yyyy][MM][dd]_[HH][mm][ss].csv

TechWolf field	Required	Key	Max chars	Notes
organisational_unit_id	Required	Primary key	100	External ID of the file.
organisational_unit_name	Required		100
organisational_unit_active	Recommended		n/a
parent_organisational_unit_id	Recommended	Foreign key	100	Points to the organisational_unit_id of the parent unit.
parent_organisational_unit_name	Recommended		100

Learning History

Courses an Employee has completed. Highly recommended.

File on S3: .../file_based/TechWolf_Learning_History/TechWolf_Learning_History_[yyyy][MM][dd]_[HH][mm][ss].csv

TechWolf field	Required	Key	Max chars	Notes
external_id	Recommended	Primary key	100	Share the ID from the source system if you have one. If it is not provided, TechWolf generates one.
employee_id	Required	Foreign key	100	Points to employee_id in Employee Baseline.
course_id	Required	Foreign key	100	Points to course_id in Course Information.
timestamp	Recommended		n/a	Defaults to the current date if empty.

Internal Work History

The Employee’s history of internal Jobs. Highly recommended. Should include the current assigned position and its start date.

File on S3: .../file_based/TechWolf_Internal_Work_History/TechWolf_Internal_Work_History_[yyyy][MM][dd]_[HH][mm][ss].csv

TechWolf field	Required	Key	Max chars	Notes
external_id	Recommended	Primary key	100	Share the ID from the source system if you have one. If it is not provided, TechWolf generates one.
employee_id	Required	Foreign key	100	Points to employee_id in Employee Baseline.
job_id	Required	Foreign key	100	Points to job_id in Job Information.
start_date	Recommended		n/a	Also used as the timestamp.
end_date	Recommended		n/a

External Work History

The Employee’s work experience outside the organisation. Highly recommended.

File on S3: .../file_based/TechWolf_External_Work_History/TechWolf_External_Work_History_[yyyy][MM][dd]_[HH][mm][ss].csv

TechWolf field	Required	Key	Max chars	Notes
external_id	Recommended	Primary key	100	Share the ID from the source system if you have one. If it is not provided, TechWolf generates one.
employee_id	Required	Foreign key	100	Points to employee_id in Employee Baseline.
job_title	Required		256	Title and description cannot both be empty.
job_description	Recommended		No limit
company	Recommended		256
start_date	Recommended		n/a
end_date	Recommended		n/a

Certification History

Certifications held by the Employee. Recommended.

File on S3: .../file_based/TechWolf_Certification/TechWolf_Certification_[yyyy][MM][dd]_[HH][mm][ss].csv

TechWolf field	Required	Key	Max chars	Notes
external_id	Recommended	Primary key	100	Share the ID from the source system if you have one. If it is not provided, TechWolf generates one.
employee_id	Required	Foreign key	100	Points to employee_id in Employee Baseline.
certification_name	Required		255	Name and description cannot both be empty.
certificate_description	Required		No limit
timestamp	Recommended		n/a

Education History

The Employee’s formal education. Recommended.

File on S3: .../file_based/TechWolf_Education/TechWolf_Education_[yyyy][MM][dd]_[HH][mm][ss].csv

TechWolf field	Required	Key	Max chars	Notes
external_id	Recommended	Primary key	100	Share the ID from the source system if you have one. If it is not provided, TechWolf generates one.
employee_id	Required	Foreign key	100	Points to employee_id in Employee Baseline.
degree_name	Required		No limit	Name and description cannot both be empty.
degree_description	Required		No limit
start_date	Recommended		n/a
end_date	Recommended		n/a	Also used as the timestamp.

Feedback

Feedback given to the Employee. Recommended.

File on S3: .../file_based/TechWolf_Feedback/TechWolf_Feedback_[yyyy][MM][dd]_[HH][mm][ss].csv

TechWolf field	Required	Key	Max chars	Notes
external_id	Recommended	Primary key	100	Share the ID from the source system if you have one. If it is not provided, TechWolf generates one.
employee_id	Required	Foreign key	100	Points to employee_id in Employee Baseline.
timestamp	Recommended		n/a
source	Recommended		No limit
description	Required		No limit

Project Data

Projects the Employee has worked on. Recommended.

File on S3: .../file_based/TechWolf_Project/TechWolf_Project_[yyyy][MM][dd]_[HH][mm][ss].csv

TechWolf field	Required	Key	Max chars	Notes
external_id	Recommended	Primary key	100	Share the ID from the source system if you have one. If it is not provided, TechWolf generates one.
employee_id	Required	Foreign key	100	Points to employee_id in Employee Baseline.
project_description	Required		10000
timestamp	Recommended		n/a

Ticket Data

Tickets the Employee has handled. Highly recommended.

File on S3: .../file_based/TechWolf_Ticket/TechWolf_Ticket_[yyyy][MM][dd]_[HH][mm][ss].csv

TechWolf field	Required	Key	Max chars	Notes
external_id	Recommended	Primary key	100	Share the ID from the source system if you have one. If it is not provided, TechWolf generates one.
employee_id	Required	Foreign key	100	Points to employee_id in Employee Baseline.
ticket_title	Required		1000
ticket_description	Required		50000
ticket_system	Recommended		100
ticket_status	Recommended		No limit
ticket_type	Recommended		1000
timestamp	Recommended		n/a

Performance Data

Performance records for the Employee. Recommended.

File on S3: .../file_based/TechWolf_Performance/TechWolf_Performance_[yyyy][MM][dd]_[HH][mm][ss].csv

TechWolf field	Required	Key	Max chars	Notes
external_id	Recommended	Primary key	100	Share the ID from the source system if you have one. If it is not provided, TechWolf generates one.
employee_id	Required	Foreign key	100	Points to employee_id in Employee Baseline.
title	Required		255
description	Required		No limit
status	Recommended		No limit	Only send entries perceived as relevant (e.g. “Completed”, “On Track”).
type	Recommended		No limit
timestamp	Recommended		n/a

Skill Notes

Free-text notes about an Employee’s Skills. Highly recommended (if available).

File on S3: .../file_based/TechWolf_Skill_Notes/TechWolf_Skill_Notes_[yyyy][MM][dd]_[HH][mm][ss].csv

TechWolf field	Required	Key	Max chars	Notes
external_id	Recommended	Primary key	100	Share the ID from the source system if you have one. If it is not provided, TechWolf generates one.
employee_id	Required	Foreign key	100	Points to employee_id in Employee Baseline.
description	Required		No limit

Resume

The Employee’s resume document. Recommended.

File on S3: .../file_based/TechWolf_Resume_Attachment/TechWolf_Resume_Attachment_[yyyy][MM][dd]_[HH][mm][ss].csv

TechWolf field	Required	Key	Max chars	Notes
external_id	Recommended	Primary key	100	Share the ID from the source system if you have one. If it is not provided, TechWolf generates one.
employee_id	Required	Foreign key	100	Points to employee_id in Employee Baseline.
mimeType	Required		n/a	Only application/pdf, application/msword, application/vnd.openxmlformats-officedocument.wordprocessingml.document, and text/plain are supported; other types are ignored.
base64Content	Required		No limit	The document encoded as a base64 string.

Merge Requests (Commit Messages)

Commit messages authored by the Employee. Recommended. Only commit messages linked to a merged merge request should be included.

File on S3: .../file_based/TechWolf_Merge_Request/TechWolf_Merge_Request_[yyyy][MM][dd]_[HH][mm][ss].csv

TechWolf field	Required	Key	Max chars	Notes
external_id	Recommended	Primary key	100	Share the ID from the source system if you have one. If it is not provided, TechWolf generates one.
employee_id	Required	Foreign key	100	Mapped to the Employee based on the author of the commit message.
merge_request_title	Required		500
merge_request_description	Required		250000
commit_message	Required		100000	Each row contains a single commit message.
status	Recommended		No limit
timestamp	Recommended		n/a