api_employee_timesheet

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

Related Tables

• api_employees - Employee details via employee_id