api_employee_timesheet

⚠️ 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.

This table provides employee timesheet data from Simplicate.

Description

The api_employee_timesheet table exposes aggregated timesheet data per employee per day, including productivity metrics, hours breakdown, and targets.

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