What fields are on the Leave Data Report in Tilt?

Quick answer

The Leave Data Report is a CSV export that gives HR users detailed information about every leave in Tilt — employee info, leave dates, status, FMLA usage, and more. Use this field reference to understand what each column shows.

Who this applies to / Prerequisites

You are an HR user at a Tilt customer.
You have at least one leave of absence entered into Tilt.
You've downloaded the Leave Data Report. See How do I download leave data from Tilt as an HR user?

Field reference

Field	What it shows
Employee ID	The employee ID your company shares with Tilt.
First Name	Employee's legal first name.
Last Name	Employee's legal last name.
Email	Employee's email. Functions as Tilt's unique identifier for the employee.
Leave Start Date	When the leave is expected to start.
Leave End Date	When the leave is expected to end.
Time Off Start Date	For continuous leaves: the leave start date. For intermittent leaves or leaves taken in chunks: the start date for a specific portion of time.
Time Off End Date	For continuous leaves: the leave end date. For intermittent leaves or leaves taken in chunks: the end date for a specific portion of time.
Hours	The leave hours the employee has, calculated based on the Time Off Start Date and Time Off End Date.
Time Off ID	The unique ID Tilt generates for a recorded chunk of time off within a leave.
Hire Date	The hire date of the employee.
Job Title	The employee's job title.
Salary	The employee's current salary.
Salary Period	The employee's salary period.
Hourly?	Whether Tilt records show the employee is hourly. Returns TRUE or FALSE.
Hourly Rate	The hourly pay rate of the employee. Optional but recommended — your Leave Specialist needs it to accurately calculate pay for hourly employees.
Country	The country where the employee lives.
State of Residence	The state where the employee lives.
Physical Work Location	The state where the employee physically works.
Working City	The city where the employee physically works.
Manager First Name	The first name of the employee's primary manager.
Manager Last Name	The last name of the employee's primary manager.
Managers	The full list of managers associated with the employee.
HR Submitter	The name of the HR person who submitted the HR portion of the leave form.
Tilt LSM	The name of the Leave Specialist assigned to the leave. (The column header currently reads "Tilt LSM." The role is now called Leave Specialist.)
Leave Type	The type of leave. One of: PARENTAL, MEDICAL, CAREGIVING, MILITARY, OTHER.
Leave Type Other	Additional details describing an OTHER leave.
Parental Role	For parental leaves, notes the parent's role. Values apply only when the Leave Type is PARENTAL.
Leave Schedule	The type of schedule the leave is categorized as. One of: INTERMITTENT, CONTINUOUS.
Leave Status	The current status of the leave. One of: WAITING ON EMPLOYEE, WAITING ON HR, UNDER REVIEW, ACTIVE, DENIED BY HR.
Leave Stage	The current stage of the leave. One of: PRE-LEAVE, ON LEAVE, RETURNED.
FMLA	Whether the leave is covered under FMLA. One of: YES, NO, NULL (has not been determined yet).
ADA	Whether the leave is ADA. Returns TRUE or FALSE.
Canada EI	Whether the leave is eligible for Canada Employment Insurance. Returns TRUE or FALSE.
Total Scheduled FMLA Time in Leave	Shows how much FMLA time the employee is taking in this leave.
Total FMLA Used	Shows how much FMLA time the employee has used across all leaves.
Remaining FMLA Balance	Shows the remaining balance of FMLA for the tracking period.
Leave Notice	If applicable, shows notifications about the leave. Returns a comma-separated list of any that apply: Employee leave form is overdue, Med cert is overdue, Employee's leave has started, Employee's leave has ended. NULL if there are no alerts.
Created at	Date the leave was created.
Updated at	Date the leave was last updated.
Leave ID	The unique ID Tilt generates for a leave of absence.
Leave Time Status	(only visible if this feature is enabled for your company) See What do the Leave Time Status and Leave Time Status Notes columns mean on the Leave Export?
Leave Time Status Notes	(only visible if this feature is enabled for your company) See What do the Leave Time Status and Leave Time Status Notes columns mean on the Leave Export?

What if it doesn't work

If a field is empty on a row, that data hasn't been entered for that leave yet. For example, Hourly Rate is optional and may be blank.
If you see NULL in a field, that data point either doesn't apply or hasn't been determined yet (like FMLA before designation).
If your report is missing the Leave Time Status and Leave Time Status Notes columns, this is a controlled feature that isn't enabled for every Tilt customer by default. Contact your Customer Success Manager to ask about getting them enabled.

Limits and exceptions

The Leave Data Report reflects the current state of your leaves at the time of export. Re-export to see the most current data.
The report shows all active leaves by default. To see archived leaves, use the View Archived toggle before exporting. See How do I download leave data from Tilt as an HR user?
Some fields are optional on the leave survey (like Hourly Rate). Missing values mean the field was left blank rather than filled in with zero.
The Tilt LSM column shows the assigned Leave Specialist. The column header still reads "LSM" — a legacy label that will be updated in a future release.