`pres.long_term_absences`

Schema: pres
English table: pres.long_term_absences
Italian original table: pres.giustif
Description: Source table for multi-day absence events. Used to generate daily justification records.

Overview

Columns: 21
Primary key: id
Outgoing foreign keys: 4
Incoming foreign keys: 0
Indexes: 3

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
`id`	`id`	`integer`	NO		Identifier of the related record.
`lta_id`	`arg_id`	`integer`	NO		Unique identifier for the long-term absence request.
`tenant_id`	`tenant_id`	`integer`	NO		Identifier of the related tenant.
`lta_employment_id`	`arg_rap_id`	`integer`	NO	`0`	Reference to the employee employment contract.
`lta_start_date`	`arg_dalla_data`	`date`	NO		Start date of the absence event.
`lta_end_date`	`arg_alla_data`	`date`	NO		End date of the absence event.
`lta_reason_code`	`cod_giu`	`character(4)`	NO	`''::bpchar`	Reason code (e.g., MATERNITY, SICKNESS, VACATION).
`lta_daily_hours`	`arg_oregius`	`numeric(6,2)`	NO	`0`	Daily hours to be justified (if 0, uses theoretical schedule).
`lta_source`	`arg_provenienza`	`character(2)`	NO	`''::bpchar`	Value of lta source.
`lta_is_automatic`	`arg_automatico`	`boolean`	NO	`false`	Boolean flag for lta is automatic.
`lta_is_cancelled`	`arg_annullato`	`boolean`	NO	`false`	Boolean flag for lta is cancelled.
`lta_start_time_int`	`arg_dalle_ore`	`numeric(4,0)`	NO	`0`	Time associated with lta start time int.
`lta_end_time_int`	`arg_alle_ore`	`numeric(4,0)`	NO	`0`	Time associated with lta end time int.
`lta_week_days_pattern`	`arg_giorni`	`character(8)`	NO	`''::bpchar`	Binary string (7 chars) indicating active weekdays (e.g., 1111100 for Mon-Fri).
`lta_excluded_dates_json`	`arg_cauescl`	`text`	NO	`''::text`	Date associated with lta excluded dates json.
`lta_workflow_doc_id`	`arg_mwe_doc_id`	`integer`	NO	`0`	Identifier of the related lta workflow doc.
`lta_document_id`	`arg_doc_id`	`integer`	YES	`0`	Identifier of the related lta document.
`lta_hr_notes`	`arg_note_hr`	`text`	YES		Internal notes entered by the HR department.
`lta_employee_notes`	`arg_note_dip`	`text`	YES		Notes or justifications entered by the employee.
`lta_parent_event_id`	`arg_giuma_id`	`integer`	YES		Identifier of the related lta parent event.
`lta_validity_range`	`arg_periodo`	`daterange`	YES	GENERATED: `daterange(lta_start_date, lta_end_date, '[]'::text)`	Native daterange for optimized overlap and exclusion queries.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
`fk_giustif_arg_doc_id_to_documenti`	`tenant_id, lta_document_id`	`hr.documents`	`tenant_id, doc_id`	RESTRICT	CASCADE
`fk_giustif_arg_rap_id_to_rapporti`	`tenant_id, lta_employment_id`	`hr.employment_relationships`	`tenant_id, er_id`	RESTRICT	CASCADE
`fk_lta_reason_definition`	`tenant_id, lta_reason_code`	`pres.attendance_reasons`	`tenant_id, ar_code`	CASCADE	RESTRICT
`fk_lta_tenant`	`tenant_id`	`cloud.tenants`	`ten_internal_id`	CASCADE	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

Primary key: pk_long_term_absences → id
Unique: c_uk_lta_id_tenant → tenant_id, lta_id

Indexes

Name	Unique	Method	Columns / expression
`idx_giustif_arg_doc_id`	NO	`btree`	`tenant_id, lta_document_id`
`idx_lta_employment_reason_lookup`	NO	`btree`	`tenant_id, lta_employment_id, lta_reason_code`
`idx_lta_range_gist`	NO	`gist`	`lta_validity_range`

Back to main index
[Back to pres index]../)

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​