`pres.shift_flexibility_rules`

Schema: pres
English table: pres.shift_flexibility_rules
Italian original table: pres.orari_flex
Description: Extension table for shifts defining flexibility windows and mandatory presence slots.

Overview

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

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
`id`	`id`	`integer`	NO		Primary Key.
`sfr_flex_id`	`oraf_id`	`integer`	NO		Internal flexibility configuration identifier.
`tenant_id`	`tenant_id`	`integer`	NO		Tenant identifier for data isolation.
`sfr_is_enabled`	`oraf_enabled`	`boolean`	YES	`false`	Flag to activate the flexibility rules for the shift.
`sfr_shift_id`	`oraf_ora_id`	`integer`	YES	`0`	Reference to the parent shift definition.
`sfr_mandatory_start_p1`	`oraf_t1_ob`	`numeric(4,0)`	YES	`0`	Start time of the mandatory presence window for period 1 (HHMM).
`sfr_mandatory_end_p1`	`oraf_t2_ob`	`numeric(4,0)`	YES	`0`	End time of the mandatory presence window for period 1 (HHMM).
`sfr_mandatory_start_p2`	`oraf_t3_ob`	`numeric(4,0)`	YES	`0`	Start time of the mandatory presence window for period 2 (HHMM).
`sfr_mandatory_end_p2`	`oraf_t4_ob`	`numeric(4,0)`	YES	`0`	End time of the mandatory presence window for period 2 (HHMM).
`sfr_min_ordinary_minutes`	`oraf_min_ordin`	`numeric(3,0)`	YES	`0`	Minimum minutes to be considered as an ordinary workday.
`sfr_max_ordinary_minutes`	`oraf_max_ordin`	`numeric(3,0)`	YES	`0`	Maximum minutes to be considered as an ordinary workday.
`sfr_is_flexibility_enabled`	`oraf_flex_enabled`	`boolean`	YES	`false`	General toggle for flexibility management.
`sfr_flex_justification_code_1`	`oraf_flex_caus1`	`character varying(4)`	YES	`''::character varying`	Primary justification code used for flexible time entries.
`sfr_flex_justification_code_2`	`oraf_flex_caus2`	`character varying(4)`	YES	`''::character varying`	Secondary justification code used for flexible time entries.
`sfr_enable_flex_anomaly_check`	`oraf_flex_ana`	`boolean`	YES	`false`	If true, triggers anomalies when flexibility limits are exceeded.
`sfr_max_flex_minutes`	`oraf_flex_minuti`	`numeric(4,0)`	YES	`0`	Maximum allowed minutes for flexible entry/exit.
`sfr_absence_calculation_mode`	`oraf_modo_assenza`	`numeric(1,0)`	YES	`0`	Logic for calculating absence hours (e.g., based on theoretical vs mandatory).
`sfr_slot_type_control_mode`	`oraf_ctrl_tipo_fascia`	`numeric(1,0)`	NO	`1`	Control mode for time slot classification (Standard, Special, etc.).
`sfr_mandatory_from_first_punch`	`oraf_obb_dalla_prima`	`boolean`	NO	`false`	If true, the mandatory window is calculated relative to the first actual punch of the day.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
`fk_sfr_shift_definitions`	`tenant_id, sfr_shift_id`	`pres.shift_definitions`	`tenant_id, shd_id`	CASCADE	CASCADE
`fk_sfr_tenant`	`tenant_id`	`cloud.tenants`	`ten_internal_id`	CASCADE	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

Primary key: pk_shift_flexibility_rules → id
Unique: c_uk_sfr_tenant_flex_id → tenant_id, sfr_flex_id
Unique: c_uk_sfr_tenant_shift_id → tenant_id, sfr_shift_id

Indexes

Name	Unique	Method	Columns / expression
`idx_orari_flex_tenant_ora`	NO	`btree`	`tenant_id, sfr_shift_id`

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

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​