hr.time_accounting_entries

Schema: hr
English table: hr.time_accounting_entries
Italian original table: hr.in_rendiconto_ore
Description: Detailed logs of time accounting, including hours worked per project, travel data, and GPS locations.

Overview

• Columns: 49
• Primary key: id
• Outgoing foreign keys: 2
• Incoming foreign keys: 0
• Indexes: 12

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
tae_id	rendcont_id	integer	NO		Identifier of the related tae record.
tae_employment_id	rendcont_rap_id	integer	NO		Identifier of the related tae employment record.
tae_project_id	rendcont_com_id	integer	YES		Identifier of the related tae project record.
tae_project_line_id	rendcont_coml_id	integer	YES		Identifier of the related tae project line record.
tae_project_activity_id	rendcont_comat_id	integer	NO		Identifier of the related tae project activity record.
tae_date	rendcont_data	date	NO		Date associated with the record.
tae_total_hours	rendcont_ore	integer	NO		Numeric value.
tae_is_travel	rendcont_viaggio	boolean	NO		Boolean flag.
tae_notes	rendcont_note	text	NO		Free-form notes.
tae_start_time	rendcont_dalle_ore	integer	NO		Start time in minutes/seconds from midnight (integer).
tae_end_time	rendcont_alle_ore	integer	NO		Numeric value.
tae_is_reimbursable_travel	rendcont_viaggio_darimb	boolean	NO		Boolean flag.
tae_has_work_report	rendcont_rapportino	boolean	NO		Boolean flag.
tae_expense_summary_id	rendcont_nsm_id	integer	NO		Reference to the monthly expense summary (NSM).
tae_is_driver	rendcont_conducente	boolean	NO		Boolean flag.
tae_vehicle_id	rendcont_anaauto_id	integer	NO		Identifier of the related tae vehicle record.
tae_has_allowance	rendcont_indennita	boolean	NO		Boolean flag.
tae_start_latitude	rendcont_lat_ini	numeric(12,8)	NO		Tae start latitude.
tae_start_longitude	rendcont_long_ini	numeric(12,8)	NO		Tae start longitude.
tae_end_latitude	rendcont_lat_fine	numeric(12,8)	NO		Tae end latitude.
tae_end_longitude	rendcont_long_fine	numeric(12,8)	NO		Tae end longitude.
tae_is_start_position_confirmed	rendcont_conf_pos_ini	boolean	NO		Boolean flag.
tae_start_address	rendcont_indirizzo_ini	text	NO		Text value.
tae_is_end_position_confirmed	rendcont_conf_pos_fine	boolean	NO		Boolean flag.
tae_end_address	rendcont_indirizzo_fine	text	NO		Text value.
tae_is_manually_edited	rendcont_modificato	boolean	NO		Boolean flag.
rendcont_custom1	rendcont_custom1	text	NO		Text value.
rendcont_custom2	rendcont_custom2	text	NO		Text value.
rendcont_custom3	rendcont_custom3	text	NO		Text value.
rendcont_custom4	rendcont_custom4	text	NO		Text value.
rendcont_custom5	rendcont_custom5	text	NO		Text value.
tae_kilometers	rendcont_km	integer	NO		Numeric value.
tae_customer_id	rendcont_incli_id	integer	YES		Identifier of the related tae customer record.
tae_customer_site_id	rendcont_inclise_id	integer	YES		Identifier of the related tae customer site record.
tae_start_clocking_id	rendcont_tim_id_inizio	integer	NO		Identifier of the related tae start clocking record.
tae_end_clocking_id	rendcont_tim_id_fine	integer	NO		Identifier of the related tae end clocking record.
tae_requires_verification	rendcont_da_verificare	boolean	NO		Boolean flag.
tae_start_clocking_point_id	rendcont_puntotim_ini	integer	NO		Identifier of the related tae start clocking point record.
tae_end_clocking_point_id	rendcont_puntotim_fine	integer	NO		Identifier of the related tae end clocking point record.
tae_is_start_point_confirmed	rendcont_conf_punto_ini	boolean	NO		Boolean flag.
tae_is_end_point_confirmed	rendcont_conf_punto_fine	boolean	NO		Boolean flag.
tae_ordinary_hours	rendcont_ore_ord	integer	NO		Numeric value.
tae_overtime_hours	rendcont_ore_strao	integer	NO		Numeric value.
tae_expiration_date	rendcont_data_scadenza	date	NO		Date associated with the record.
tae_visibility_code	tenant_id	numeric(1,0)	NO		0 if visible, other values indicate hidden or archived states.
tenant_id	colcustom	integer	YES		Tenant identifier for data isolation.
colcustom	_deleted	jsonb	YES	'{}'::jsonb	JSON payload containing additional attributes.
_deleted	rendcont_nascosto	boolean	YES	false	Flag indicating whether the record is soft-deleted.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_time_accounting_entries_employment	tae_employment_id, tenant_id	hr.employment_relationships	er_id, tenant_id	RESTRICT	CASCADE
fk_time_accounting_entries_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_time_accounting_entries → id
• Unique: uk_time_accounting_entries_id → tae_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_tae_customer_site_tenant	NO	btree	tenant_id, tae_customer_site_id) WHERE (_deleted = false
idx_tae_customer_tenant	NO	btree	tenant_id, tae_customer_id) WHERE (_deleted = false
idx_tae_date_tenant	NO	btree	tenant_id, tae_date) WHERE (_deleted = false
idx_tae_employment_tenant	NO	btree	tenant_id, tae_employment_id) WHERE (_deleted = false
idx_tae_expense_summary_tenant	NO	btree	tenant_id, tae_expense_summary_id) WHERE (_deleted = false
idx_tae_id_tenant	NO	btree	tenant_id, tae_id) WHERE (_deleted = false
idx_tae_project_activity_tenant	NO	btree	tenant_id, tae_project_activity_id) WHERE (_deleted = false
idx_tae_project_line_tenant	NO	btree	tenant_id, tae_project_line_id) WHERE (_deleted = false
idx_tae_project_tenant	NO	btree	tenant_id, tae_project_id) WHERE (_deleted = false
idx_tae_tenant	NO	btree	tenant_id
idx_tae_vehicle_tenant	NO	btree	tenant_id, tae_vehicle_id) WHERE (_deleted = false
idx_tae_visibility_date_tenant	NO	btree	tenant_id, tae_visibility_code, tae_date) WHERE ((_deleted = false) AND (tae_visibility_code = (0)::numeric)

Navigation

• Back to main index
• [Back to hr index]../)