pres.holiday_calendar

Schema: pres
English table: pres.holiday_calendar
Italian original table: pres.festivita
Description: Calendar of national and local holidays with rules for payroll calculation and work shifts.

Overview

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

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Identifier of the related record.
hol_id	fest_id	integer	NO		Identifier of the related hol.
tenant_id	tenant_id	integer	NO		Identifier of the related tenant.
hol_date	fest_data	date	NO		Date associated with hol date.
hol_description	fest_descrizione	character(40)	NO	''::bpchar	Description of hol description.
hol_is_observed_on_different_date	fest_spostata	boolean	NO	false	Date associated with hol is observed on different date.
hol_observed_date	fest_data_spostata	date	NO		The actual date the holiday is observed if different from the calendar date (e.g., bridge days).
hol_reason_code	fest_causale	character(4)	NO	''::bpchar	Code of hol reason code.
hol_calculation_mode	fest_modo	numeric(1,0)	NO	0	Value of hol calculation mode.
hol_value	fest_valore	numeric(8,2)	NO	0	Value of hol value.
hol_job_title_filter	fest_qualifica	character(4)	NO	''::bpchar	Value of hol job title filter.
hol_is_easter_related	fest_pasqua	boolean	NO	false	Boolean flag for hol is easter related.
hol_is_workable	fest_lavorabili	numeric(1,0)	NO	0	Value of hol is workable.
hol_worked_reason_code	fest_causale_lav	character(4)	NO	''::bpchar	Code of hol worked reason code.
hol_worked_calculation_mode	fest_modo_lav	numeric(1,0)	NO	0	Value of hol worked calculation mode.
hol_worked_value	fest_valore_lav	numeric(8,2)	NO	0	Value of hol worked value.
hol_work_site_pattern	fest_sede_lavoro	character varying(50)	YES	''::character varying	Filters holidays based on specific company locations (essential for Patron Saint days).
hol_is_patron_saint_day	fest_santo_patrono	numeric(1,0)	YES	0	Value of hol is patron saint day.
hol_standard_day_minutes	fest_day_value	numeric(6,2)	YES	480	Standard duration of the holiday in minutes (default 480 = 8h).

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_hol_reason_type	tenant_id, hol_reason_code	pres.attendance_reasons	tenant_id, ar_code	CASCADE	RESTRICT
fk_hol_tenant	tenant_id	cloud.tenants	ten_internal_id	CASCADE	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_holiday_calendar → id
• Unique: c_uk_hol_id_tenant → tenant_id, hol_id

Indexes

Name	Unique	Method	Columns / expression
idx_hol_date_lookup	NO	btree	tenant_id, hol_date
idx_hol_observed_date_lookup	NO	btree	tenant_id, hol_observed_date

Navigation

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