⚠️ Important: Some fields in this table will be deprecated on Wednesday, January 7th, 2025. Please review the Deprecated Fields section below and migrate to the recommended alternatives.

Fields

Field Name	Type	Description
`timesheet_id`	Integer	Unique identifier for the timesheet record
`employee_id`	Integer	Identifier of the employee this timesheet belongs to
`date`	Date	Date of the timesheet record
`week_number`	Integer	Week number of the timesheet record
`raster_hours`	Numeric	The scheduled hours on the raster for this timesheet record
`registered_hours`	Numeric	Hours registered by the employee for this timesheet record
`registered_direct_hours`	Numeric	Hours registered on direct project work for this record
`registered_direct_value`	Numeric	Monetary value of direct hours for this record
`registered_direct_declarable_value_with_corrections`	Numeric	The declarable value (including corrections) for direct project hours for this record
`registered_direct_declarable_hours_with_corrections`	Numeric	Direct declarable hours including corrections for this record
`correction_value`	Numeric	Correction value for this record
`registered_direct_declarable_value`	Numeric	Declarable value for this record
`registered_leave_hours`	Numeric	Leave hours for this record
`registered_absence_hours`	Numeric	Absence hours for this record
`productivity_hours_day`	Numeric	Productivity hours per day for this record
`sum_total_direct_task_hours`	Numeric	Total direct task hours assigned for this record
`sum_total_value_direct_tasks`	Numeric	Total value of direct tasks assigned for this record
`sum_total_indirect_task_hours`	Numeric	Total indirect task hours assigned for this record
`sum_total_direct_task_value`	Numeric	Direct task value for this record
`average_productivity_target_pct`	Numeric	Average productivity target percentage for this record
`registered_hours_cost_price`	Numeric	The cost price (based on the cost price of the raster) of all the registered hours for this record
`raster_hours_cost_price`	Numeric	The cost price (based on the cost price of the raster) based on the number of hours on the raster for this record
`registered_direct_hours_cost_price`	Numeric	The cost price (based on the cost price of the raster) of all the registered direct hours for this record
`registered_leave_and_absence_hours`	Numeric	Combined leave and absence hours for this record
`net_raster_hours`	Numeric	The net available raster hours when leave hours are subtracted for this record
`net_raster_hours_minus_absence_hours`	Numeric	The net available raster hours when leave and absence hours are subtracted for this record
`available_hours`	Numeric	Available hours (raster hours minus registered hours) for this record
`remaining_hours`	Numeric	Remaining hours after subtracting leave, absence, and assigned hours for this record
`registered_direct_declarable_cost_price`	Numeric	Cost price of declarable direct hours for this record
`net_productivity_target_hours`	Numeric	The productivity target in hours corrected with leave and absence hours for this record
`net_productivity_target_hours_without_absence`	Numeric	The productivity target in hours corrected with leave hours for this record
`net_productivity_target_value`	Numeric	The target value based on the productivity target for this record
`net_productivity_target_value_without_absence`	Numeric	The target value based on the productivity target corrected with leave hours for this record
`pct_productivity`	Numeric	Time registered on direct project tasks compared to the net raster hours for this record
`pct_declarability`	Numeric	Declarable time registered on direct project tasks compared to the net raster hours for this record
`pct_total_direct_task_hours_vs_target_productive`	Numeric	Percentage of direct task hours compared to productivity target for this record
`productivity_target_hours_minus_direct_assignment_hours`	Numeric	The remaining direct task hours based on the productivity target corrected with leave hours for this record
`productivity_target_minus_assignment_hours`	Numeric	The remaining task hours based on the productivity target corrected with leave hours for this record
`net_productivity_target_value_without_absence_minus_sum_total_value_direct_tasks`	Numeric	Target value minus direct task value for this record
`pct_total_value_direct_tasks_vs_target_productive_value`	Numeric	Percentage of direct task value compared to target value for this record
`result_registered_value`	Numeric	The result of the registered direct declarable value with corrections minus the cost price of the registered hours for this record
`result_raster_value`	Numeric	The result of the raster declarable value with corrections minus the cost price of the raster for this record
`result_registered_value_pct`	Numeric	The result of the registered hours compared to the cost price of the registered hours for this record
`result_raster_value_pct`	Numeric	The result of the raster hours compared to the cost price of the raster for this record
`raster_hours_versus_registered_hours`	Numeric	The difference between the raster hours and the registered hours for this record
`raster_hours_versus_registered_hours_pct`	Numeric	The percentage of the difference between the raster hours and the registered hours for this record
`target_based_on_net_raster_hours`	Numeric	Target hours based on net raster hours for this record

Deprecated Fields

⚠️ Deprecation Notice: The following fields will be deprecated on Wednesday, January 7th, 2025. Please migrate to the recommended alternatives.

Deprecated Field	Type	Recommended Alternative
`key_timesheet_id`	Integer	`timesheet_id`
`key_employee_id`	Integer	`employee_id`
`date_value`	Date	`date`

Related Tables

api_employees - Employee details via employee_id

Insights: Number of Planned Tasks per Employee

Table api_time_registrations

Table api_project_assignments_facts

Table api_project_service_date_facts

Table api_project_service_costs

Table api_employee_timesheet

Fields

Deprecated Fields

Related Tables