When you request a data export for a staff member in Famly, you'll receive a ZIP file containing CSV files and a media/ folder with photos and documents. This article explains what each file contains so you can find and understand the information you need.
Before You Open the Files
A few things to know upfront:
Each CSV file covers one area of Famly: the staff profile, attendance, qualifications, leave, and so on. The filename tells you what's inside.
Files are numbered (e.g. 003famly_daycare_employee...). The number is just the export order; it doesn't mean anything, and it can change between exports. The same file may have a different number in a different staff member's export, or in a later export for the same person. What matters is the name after the number.
Empty files are normal. If a feature hasn't been used for a staff member, the file will still appear but with no data rows, just column headers.
Deleted records are included. Records removed from Famly's interface still appear in the export. Look for columns called deletedAt, deletedat, or active to identify them.
ID columns are internal references. Long strings of letters and numbers (UUIDs) are used to link records between files; they're not meant to be human-readable.
*By columns contain login IDs, not names. Columns like createdBy or deletedBy store an internal ID for the person who made a change, not their actual name.
No sensitive identity data. Unlike the child export, the staff export does not include national ID numbers, Social Security numbers, bank details, salary, or national insurance numbers. Pay-related time data (hours/minutes for payroll) is included. See the Approved hours section.
Leave request notes are not included. The free-text note a staff member adds to a leave request is stored separately and is not part of this export.
What's in the Export
The files are grouped below by area. Jump to the section you need:
Staff Profile
These files contain the staff member's core information and their connections to children and other records.
Staff profile
File: famly_daycare_employee_domain_model_employee.csv
The main staff record — the most important file in the export. Everything else links back to the employeeId found here.
Column | What it means |
employeeId | The staff member's unique ID in Famly |
siteId | Which nursery they belong to |
groupId | Their primary room or group |
loginId | Their internal Famly account identifier |
firstname / middlename / lastname | Their name |
birthday | Date of birth |
Email address | |
phone | Phone number |
street / zip / city / state | Home address |
extrainfo | Any freeform notes on the profile |
startdate | Employment start date |
enddate | Employment end date (blank if still employed) |
status | Employment or account status |
holidayallowance | Holiday allowance |
employeeWorkDayHours | Standard working-day length in hours (used in leave calculations) |
customemployeeid | A custom reference or payroll-style ID set by the nursery |
anonymized | Whether this record has been GDPR-anonymised |
createdtime / lastUpdatedAt | When the profile was created and last updated |
deletedtime | If the record was soft-deleted |
Emergency contacts
File: famly_daycare_employee_domain_model_relation.csv
The staff member's emergency contacts and next of kin.
Column | What it means |
relationId | Unique ID for this contact |
employeeId | Which staff member they're linked to |
firstname / middlename / lastname | Their name |
status | Relationship to the staff member — e.g. "Spouse", "Parent" |
Their email address | |
phone / workphone / homephone | Contact numbers |
createdat / deletedat | Timestamps |
Access and roles
File: famly_security2_domain_model_roleassignment.csv
Which access roles have been granted to the staff member — for example, manager access or room-level permissions.
Column | What it means |
roleAssignmentId | Unique ID |
loginId | Who was granted access |
roleId | Which role |
targetid | What the role applies to |
logincreatedaspartofassignment | Whether their Famly login was created at the same time |
createdat / deletedat / lastUpdatedAt | Timestamps |
createdby / deletedby | Who made the changes |
Profile photo
File: famly_core_image_domain_model_profileimage.csv
Metadata for the staff member's profile photo. The actual image is in media/profile-images/.
Column | What it means |
imageId | Unique ID (matches the filename in media/profile-images/) |
imagefor | What the photo is for |
id | The staff member's ID |
objecturloriginal | Storage URL of the photo |
active | Whether it's the current active photo |
createdtime / deletedat | Timestamps |
Key worker assignments
File: famly_daycare_child_domain_model_keyworkerrelation.csv
Records of which children this staff member is or was a key worker for.
Column | What it means |
keyWorkerRelationId | Unique ID |
childId | Which child they're key worker for |
employeeId | The staff member |
status | Whether they're the primary key worker |
validFrom / validTo | The period they held this role |
createdAt / deletedAt / lastUpdatedAt | Timestamps |
Custom tags
File: famly_daycare_tag_domain_model_tagassignment.csv
Custom nursery-created tags applied to the staff member.
Column | What it means |
tagAssignmentId | Unique ID |
tagId | Which tag was applied |
assignmenttype | "EMPLOYEE" for staff records |
assignmentid | The staff member's ID |
deletedat / lastUpdatedAt | Timestamps |
Status periods
File: famly_daycare_status_domain_model_statusregistration.csv
Periods during which the staff member is in a configured status — for example, on a probationary period or a specific employment status.
Column | What it means |
statusRegistrationId | Unique ID |
statusConfigId | Which status this is |
siteId | Which nursery |
employeeId | The staff member |
startedAt / endedAt | When the status started and ended |
startedBy / endedBy | Who started and ended it |
active | Whether still active |
createdAt / createdBy | When and who created it |
deletedAt / deletedBy | If deleted |
There is also a legacy status file called famly_daycare_status_domain_model_status.csv. This covers older-format status records. Key columns: statusid, targetid (the staff member), statustype, starttime, endtime, deletedtime.
Event replies
File: famly_daycare_event_domain_model_eventreply.csv
Whether the staff member responded to a calendar event — for example, a staff meeting or training day.
Column | What it means |
eventReplyId | Unique ID |
eventId | Which event |
repliertype | "EMPLOYEE" for staff replies |
replierid | The staff member's ID |
nochildren / noadults | Numbers indicated in the reply |
body | Any message left with the reply |
repliedat / deletedat | Timestamps |
inviteat / invitedat | When the invite was scheduled and sent |
Accident records
These link the staff member to accident and medication records they were involved in:
famly_daycare_accident_domain_model_staff_present.csv — records the staff member was present at an accident. Columns: reportId, employeeId.
famly_daycare_accident_domain_model_witnesses.csv — records the staff member witnessed an accident. Columns: reportId, employeeId.
medication_administered_witness.csv — records the staff member witnessed a medication being given to a child. Columns: administeredMedicationId, employeeId.
💡 Famly only supports accident reports for children. These files record the staff member's involvement in a child's accident, not an accident involving the staff member themselves.
Other profile files
foreign_data_mapping.csv — if the staff member's data is synced with an external system (e.g. a payroll or SSO platform), this maps Famly's ID to the external system's ID. Key columns: employee (the Famly ID), foreignId, foreignSystem.
famly_security_domain_model_assignpasswordtoken.csv — this file will always be empty. Password setup tokens are never exported.
Employment and HR
These files cover qualifications, working hours, leave entitlements, and payroll-related records.
Qualifications
File: staff_qualification_assignment.csv
One row per qualification recorded against the staff member — first aid certificates, DBS checks, degrees, and so on. Certificate documents and images are in media/files/ and media/images/.
Column | What it means |
assignmentId | Unique ID |
employeeId | Which staff member |
staffQualificationId | The qualification type or definition |
title | Freeform title or label |
qualificationDate | Date the qualification was obtained |
expirationDate | Expiry date (used to drive renewal reminders) |
certificateNo | Certificate or reference number |
note | Any freeform note |
level | Numeric level or grade |
createdBy / createdAt | When and who created the record |
deletedBy / deletedAt | If deleted |
staff_qualification_assignment_file.csv — links qualifications to attached documents. Columns: assignmentId, fileId.
staff_qualification_assignment_image.csv — links qualifications to attached images. Columns: assignmentId, imageId.
There is also a simpler qualification file called qualification_type_assignment.csv, which records which qualification types the staff member holds (e.g. "Paediatric First Aid", "Safeguarding"), with validity dates but without certificate details. Key columns: qualificationTypeAssignmentId, employeeId, qualificationTypeId, validFrom, validTo.
Contracted hours
File: employee_contracted_hours.csv
Time-bounded records of the staff member's contracted working hours.
Column | What it means |
contractedHoursId | Unique ID |
employeeId | Which staff member |
hours / minutes | Contracted hours and minutes |
period | The period measured over — e.g. weekly |
validFrom / validTo | When this arrangement was in effect |
createdBy / createdAt | When and who created it |
deletedBy / deletedAt | If deleted |
Work availability
File: employee_work_availability.csv
The staff member's weekly availability pattern — start and end times for each day of the week, time-bounded.
Column | What it means |
workAvailabilityId | Unique ID |
employeeId | Which staff member |
startMon / endMon … startSun / endSun | Availability start and end for each day (14 columns, Mon–Sun) |
validFrom / validTo | When this availability was in effect |
createdBy / createdAt | When and who created it |
deletedBy / deletedAt | If deleted |
Bank hours (TOIL)
File: employee_bank_hours.csv
Banked time — overtime or time off in lieu (TOIL) — stored in minutes.
Column | What it means |
bankHoursId | Unique ID |
employeeId | Which staff member |
minutes | Banked time in minutes |
validFrom / validTo | When this applies |
createdBy / createdAt | When and who created it |
deletedBy / deletedAt | If deleted |
Leave day hours
File: employee_leave_day_hours.csv
How many hours one leave day is worth for this staff member — used to convert between leave days and hours.
Column | What it means |
leaveDayHoursId | Unique ID |
employeeId | Which staff member |
hours / minutes | How long one leave day is |
validFrom / validTo | When this applies |
createdBy / createdAt | When and who created it |
deletedBy / deletedAt | If deleted |
Holiday entitlement
File: employee_holiday_entitlement.csv
The staff member's total holiday entitlement in minutes, time-bounded.
Column | What it means |
holidayEntitlementId | Unique ID |
employeeId | Which staff member |
minutes | Total holiday entitlement in minutes |
validFrom / validTo | When this entitlement applies |
createdBy / createdAt | When and who created it |
deletedBy / deletedAt | If deleted |
Leave balance
File: staff_leave_balance.csv
The staff member's current remaining leave balance per leave type.
Column | What it means |
staffLeaveBalanceId | Unique ID |
employeeId | Which staff member |
leaveType | Which type of leave this balance is for |
balance | Remaining balance |
lastModifiedAt | When it was last updated |
Leave entries
File: famly_daycare_leave_domain_model_employeeleave.csv
Individual leave or absence entries — one row per leave day or part-day.
Column | What it means |
employeeLeaveId | Unique ID |
employeeId | Which staff member |
siteId | Which nursery |
day | The day of leave |
leavetype | Type of leave — e.g. holiday, sickness |
reason | Freeform reason |
leavesubtypeid | Leave sub-type (if configured) |
startTime / endTime | Start and end for part-day leave |
hours | Hours of leave taken that day |
employeeWorkDay | Work-day length at the time (used for calculations) |
createdAt / deletedat | Timestamps |
Leave requests
File: staff_leave_request.csv
Formal leave requests submitted by the staff member.
💡 The free-text note added to a leave request is stored separately and does not appear anywhere in this export.
Column | What it means |
staffLeaveRequestId | Unique ID |
employeeId | Which staff member |
from / to | First and last day of the requested leave |
leaveType | Type of leave |
leavesubtypeid | Leave sub-type (if configured) |
startTime / endTime | Start and end times for part-day or hourly leave |
hours | Hours requested (for hourly leave) |
isPaid | Whether the leave is paid |
updatedBy / updatedAt | Who last updated it and when |
deletedAt | If deleted |
Approved hours
File: approved_staffhours.csv
The finalised, approved hours for the staff member per pay period — the record used for payroll.
Column | What it means |
approvedStaffHoursId | Unique ID |
employeeId | Which staff member |
siteId | Which nursery |
period | The pay period |
recordKind | The category of this record |
basePayMinutes | Base paid time in minutes |
overtimePayMinutes | Overtime paid time in minutes |
timeOffInLieuMinutes | TOIL accrued in minutes |
createdAt / createdBy | When and who created it |
deletedAt / deletedBy | If deleted |
approved_staffhours_details.csv — breaks overtime down by sub-type. Key columns: approvedStaffHoursId, overtimePayMinutes, overtimeSubTypeName, overtimeSubTypeCode.
Hours change history
File: employee_contracted_hours_change.csv
A log of every time the staff member's working arrangement was changed. Each row records that a change happened and links to the before and after versions of each setting. It doesn't store the values directly.
Column | What it means |
contractedHoursChangeId | Unique ID for this change event |
employeeId | Which staff member |
previousWorkAvailabilityId / newWorkAvailabilityId | Work availability before and after |
previousContractedHoursId / newContractedHoursId | Contracted hours before and after |
previousBankHoursId / newBankHoursId | Bank hours before and after |
previousLeaveDayHoursId / newLeaveDayHoursId | Leave day hours before and after |
previousHolidayEntitlementId / newHolidayEntitlementId | Holiday entitlement before and after |
previousApprovedStaffHoursId / newApprovedStaffHoursId | Approved hours before and after |
createdBy / createdAt | Who made the change and when |
Scheduling and Rotas
Famly has two rota models — the staff_rotas_* family and the newer staff_schedule_* family. Both are exported, and depending on which model your nursery uses, some of these files may be empty. There is also an older Shift Planner model (shiftplanner_shift).
Rota schedule (classic model)
File: staff_rotas_schedule.csv
A recurring rota pattern assigned to the staff member.
Column | What it means |
staffRotasScheduleId | Unique ID |
employeeId | Which staff member |
startDate / endDate | When the pattern applies |
repeatType | How it repeats — e.g. weekly |
createdAt / deletedAt | Timestamps |
Daily shifts (classic model)
File: staff_rotas_daily_schedule.csv
A specific shift on a particular day within a rota schedule.
Column | What it means |
staffRotasDailyScheduleId | Unique ID |
staffRotasScheduleId | Which rota schedule this belongs to |
startDate | The day the shift falls on |
startTime / endTime | Shift start and end times |
groupId | Which room or group |
staff_break_scheduled.csv — planned breaks within a daily shift. Columns: breakTimeMinutes, staffRotasDailyScheduleId.
staff_rotas_schedule_exception.csv — dates on which a recurring rota was overridden or skipped. Columns: exceptionDate, staffRotasScheduleId, staffRotasDailyScheduleId.
Scheduled days (newer model)
File: staff_schedule_day.csv
A scheduled working day in the newer rota model.
Column | What it means |
staffScheduleDayId | Unique ID |
staffRotasScheduleId | Which parent schedule |
initialDate | The first applicable date |
breakMinutes | Total break time for this day |
Time slots (newer model)
File: staff_schedule_time_slot.csv
A working time block within a scheduled day; each day can have multiple blocks in different rooms.
Column | What it means |
staffScheduleTimeSlotId | Unique ID |
staffScheduleDayId | Which day this belongs to |
startTime / endTime | Start and end of this block |
groupId | Which room or group |
Shift planner (older model)
File: shiftplanner_shift.csv
Shifts from the older Shift Planner feature. This file may be empty if your nursery uses the newer rota models.
Column | What it means |
shiftId | Unique ID |
employeeId | Which staff member |
startTime / endTime | Shift start and end |
breakMin | Break length in minutes |
state | Whether the shift is a draft or published |
groupId | Which room or group |
tagId | A work tag or role label on the shift |
recurrenceId | If part of a recurring series |
managerNoteId | A linked manager note |
createdAt / createdBy | When and who created it |
updatedAt / updatedBy | Last update |
deletedAt / deletedBy | If deleted |
Attendance and Check-ins (Sign-ins)
Check-ins
File: famly_daycare_checkin_domain_model_employeecheckin.csv
The staff member's clock-in and clock-out records.
Column | What it means |
employeeCheckInId | Unique ID |
employeeId | Which staff member |
siteId | Which nursery |
groupId | Which room they checked into |
checkintime | When they clocked in |
checkouttime | When they clocked out (blank if not yet checked out) |
estimatedcheckouttime | Expected check-out time |
checkinloginid / checkoutloginid | Who performed the check-in and check-out |
autocheckedout | Whether the system automatically checked them out |
deletedat | If this record was deleted |
Other attendance files
employee_checkin_work_tag.csv — work or activity tags applied to a check-in. Columns: employeeCheckInId, tagId.
employee_checkin_manager_note.csv — links a manager note to a check-in. Columns: employeeCheckInId, noteId.
checkin_statement_employeecheckin.csv — links a sign-in statement or signature to a check-in. Columns: statementId, employeeCheckinId.
Manager Notes and Newsfeed
Manager notes
File: manager_note.csv
Freeform notes written by a manager about the staff member — typically linked to check-in records.
Column | What it means |
noteId | Unique ID |
note | The note content |
createdBy / createdAt | Who wrote it and when |
updatedBy / updatedAt | Last edit details |
deletedBy / deletedAt | If deleted |
News feed items
File: famly_feed_domain_model_feeditem.csv
Items in the staff member's Famly news feed. The content of each item lives in the referenced record — this file lists what appeared in their feed and whether they saw it.
Column | What it means |
feedItemId | Unique ID |
originatorid | What the item is about |
loginId | Whose feed it appears in |
seen | Whether they've seen it |
createddate / expireddate / enableddate / deleteddate | Timestamps |
Bookmarks
File: famly_feed_domain_model_bookmark.csv
Records of the staff member saving a news feed item.
Column | What it means |
bookmarkId | Unique ID |
loginId | Who bookmarked it |
feedItemId | Which item |
createdAt / deletedAt | Timestamps |
famly_feed_domain_model_feeditemrolefilter.csv — controls which audience a feed item is shown to. Columns: feedItemRoleFilterId, feedItemId, siteSetId.
Photos and Files
The media/ folder in the ZIP contains the actual image and document files referenced in the CSVs. The CSV files below act as an index — use them to identify which file in media/ belongs to which record.
There are no videos in a staff export — only profile photos and qualification attachments.
Images
File: famly_core_image_domain_model_image.csv Folder: media/images/
Images attached to qualification records. Files are named <imageId>-<originalfilename>.
Column | What it means |
imageId | Unique ID (matches the filename in media/images/) |
imagefor | What the image is attached to |
id | ID of the owning record |
objecturloriginal | Storage URL of the full-size image |
objecturlsmall / objecturlbig | Resized versions |
width / height | Dimensions in pixels |
filesize | File size in bytes |
mime | File type — e.g. image/jpeg |
filename | Original filename |
createdat / deletedat | Timestamps |
Documents and files
File: famly_core_file_domain_model_file.csv Folder: media/files/
Documents attached to qualification records — for example, certificate PDFs. Files are named <fileId>-<originalfilename>.
Column | What it means |
fileId | Unique ID (matches the filename in media/files/) |
filename | Original filename |
filesize | File size in bytes |
objecturl | Storage URL |
createdBy | Who uploaded it |
createdat / deletedat | Timestamps |
Profile photos
Folder: media/profile-images/
The staff member's profile photo. See famly_core_image_domain_model_profileimage.csv in the Staff profile section for the metadata. Files are named <imageId>.<extension>.