pres.collective_attendance_calendars

Schema: pres
English table: pres.collective_attendance_calendars
Italian original table: pres.tabcalen
Description: Defines company-wide or group-wide closures and collective absences, avoiding individual manual entries.

Overview

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

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Primary Key.
cac_calendar_id	cal_id	integer	NO		Internal unique identifier for the calendar entry.
tenant_id	tenant_id	integer	NO		Identifier of the related tenant.
cac_code	cod_calen	character(4)	NO	''::bpchar	Unique mnemonic code for the collective absence period.
cac_valid_from	cal_dalla_data	date	NO		Start date of the collective absence.
cac_valid_to	cal_alla_data	date	NO		End date of the collective absence.
cac_from_employee_number	cal_da_matricola	character(6)	NO	''::bpchar	Starting employee number for the target range.
cac_to_employee_number	cal_a_matricola	character(6)	NO	''::bpchar	Ending employee number for the target range.
cac_from_department_code	cal_da_rep	character(4)	NO	''::bpchar	Starting department code for the target range.
cac_to_department_code	cal_a_rep	character(4)	NO	''::bpchar	Code of cac to department code.
cac_from_job_title_code	cal_da_qual	character(4)	NO	''::bpchar	Code of cac from job title code.
cac_to_job_title_code	cal_a_qual	character(4)	NO	''::bpchar	Code of cac to job title code.
cac_description	cal_descrizione	character(40)	NO	''::bpchar	Description of cac description.
cac_justification_code	cal_cod_giust	character(4)	NO	''::bpchar	Justification code (e.g., FER) to be applied to all matching employees.
cac_justified_hours	cal_ore_giust	numeric(6,2)	NO	0	Number of hours to justify automatically.
cac_payroll_hours	cal_ore_paghe	numeric(6,2)	NO	0	Value of cac payroll hours.
cac_is_holiday	cal_festivo	boolean	NO	false	Flag indicating if the period should be treated as a public holiday.
cac_is_cancelled	cal_annullato	boolean	NO	false	Boolean flag for cac is cancelled.
cac_skip_validation_checks	cal_no_control	boolean	NO	false	Boolean flag for cac skip validation checks.
cac_validity_range	cal_periodo	daterange	YES	GENERATED: daterange(cac_valid_from, cac_valid_to, '[]'::text)	PostgreSQL daterange for period-based queries and overlap checks.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_cac_tenant	tenant_id	cloud.tenants	ten_internal_id	CASCADE	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_collective_attendance_calendars → id
• Unique: c_uk_cac_tenant_calendar_id → tenant_id, cac_calendar_id
• Unique: c_uk_cac_tenant_code → tenant_id, cac_code

Indexes

Name	Unique	Method	Columns / expression
idx_cac_tenant_calendar_id	NO	btree	tenant_id, cac_calendar_id
idx_cac_validity_range_gist	NO	gist	cac_validity_range

Navigation

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