api_time_registrations

Description

The api_time_registrations table exposes individual time registration entries, including hours, values, and related metadata.

Fields

Field Name	Type	Description
time_registration_id	Integer	Unique identifier for the time registration
employee_id	Integer	Identifier of the employee who made the registration
invoice_id	Integer	Identifier of the invoice (if the registration has been invoiced)
correction_creator_id	Integer	Identifier of the employee who created the correction
project_service_id	Integer	Identifier of the project service
project_id	Integer	Identifier of the project
project_assignment_id	Integer	Identifier of the project assignment
item_type_id	Integer	Identifier of the item type (hour type)
week_number	Integer	Week number of the registration
date	Date	Date of the time registration
start_time	DateTime	The start datetime of the registration
end_time	DateTime	The end datetime of the registration
correction_date	Date	Date when the correction was made (if applicable)
description	String	Description or note for the time entry
external_url	String	External URL reference (e.g., link to external system)
invoice_method	String	Method used for invoicing this registration
correction_reason	String	Reason for the correction (if applicable)
category	String	Category of the registration (e.g., direct, indirect, leave)
hour_type	String	Name of the hour type
hourly_tariff	Numeric	The hourly declarable rate of the registration
declarable_tariff_hourly	Numeric	Declarable hourly tariff rate
hourly_cost_price	Numeric	Hourly cost price for this registration
is_project_billable	Numeric	Flag indicating if the project is billable (1=yes, 0=no)
is_declarable_service	Numeric	Flag indicating if the service is declarable (1=yes, 0=no)
registered_hours	Numeric	Hours registered for this individual time registration
correction_value	Numeric	Monetary value of time correction for this registration
correction_amount	Numeric	Amount of time correction in hours for this registration
total_declarable	Numeric	Declarable value for this registration
registered_leave_hours	Numeric	Leave hours for this registration
registered_absence_hours	Numeric	Absence hours for this registration
registered_direct_hours	Numeric	Direct project hours for this registration
registered_direct_value	Numeric	Monetary value of direct hours for this registration
registered_indirect_hours	Numeric	Indirect hours for this registration
registered_direct_declarable_hours	Numeric	Direct declarable hours for this registration
registered_direct_declarable_value	Numeric	Monetary value of direct declarable hours for this registration
registered_direct_declarable_hours_with_corrections	Numeric	Direct declarable hours including corrections for this registration
total_registered_cost_price	Numeric	Total cost price of registered hours for this registration
registered_direct_declarable_value_with_corrections	Numeric	Declarable value including corrections for this registration
invoiceable_value	Numeric	Value that can still be invoiced for this registration
invoiced_value	Numeric	Value that has already been invoiced for this registration
result	Numeric	Result for this registration (declarable value minus cost price)
result_pct	Numeric	Result percentage for this registration
last_updated_at	DateTime	Timestamp of the last update

Related Tables

• api_employees - Employee details via employee_id
• api_projects - Project details via project_id
• api_project_services - Service details via project_service_id
• api_project_assignments - Assignment details via project_assignment_id
• api_item_types - Item type details via item_type_id
• api_invoices - Invoice details via invoice_id