> ## Documentation Index > Fetch the complete documentation index at: https://developers.techwolf.ai/llms.txt > Use this file to discover all available pages before exploring further. # 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](/integrations/datasource-integrations/non-standard-datasource-integrations/jobs) and [Courses](/integrations/datasource-integrations/non-standard-datasource-integrations/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](/integrations/datasource-integrations/datasources-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](/integrations/datasource-integrations/non-standard-datasource-integrations/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. 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 | | 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 | | 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. | 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 | | 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 | | 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 | | 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 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 | | 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 | | 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 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 | | 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 | | 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. | 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 | | This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.