pres.shift_advanced_settings
Schema: pres
English table: pres.shift_advanced_settings
Italian original table: pres.orari_adv
Description: Advanced configuration for shifts, handling tolerances, rounding, and automatic period insertions.
Overview
- Columns: 39
- Primary key: id
- Outgoing foreign keys: 2
- Incoming foreign keys: 0
- Indexes: 0
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Primary Key. | |
sas_shift_id | ora_id | integer | NO | Unique identifier of the associated shift. | |
tenant_id | tenant_id | integer | NO | Tenant identifier for data isolation. | |
sas_shift_code | cod_ora | character(4) | NO | ''::bpchar | Reference code for the shift (max 4 chars). |
sas_is_enabled | ora_enabled | boolean | NO | false | Boolean flag to enable or disable these advanced settings. |
sas_flexibility_type | ora_tim_flex | numeric(1,0) | NO | 0 | Numeric flag for flexibility calculation logic (0=Fixed, 1=Flexible). |
sas_p1_start_time | ora_p1_dalle | numeric(4,0) | NO | 0 | Theoretical start time for the first period (Format: HHMM). |
sas_p1_end_time | ora_p1_alle | numeric(4,0) | NO | 0 | Theoretical end time for the first period (Format: HHMM). |
sas_p2_start_time | ora_p2_dalle | numeric(4,0) | NO | 0 | Theoretical start time for the second period (Format: HHMM). |
sas_p2_end_time | ora_p2_alle | numeric(4,0) | NO | 0 | Theoretical end time for the second period (Format: HHMM). |
sas_min_duration | ora_lung_min | numeric(4,0) | NO | 0 | Minimum required work duration for the shift (minutes). |
sas_max_duration | ora_lung_max | numeric(4,0) | NO | 0 | Maximum allowed work duration for the shift (minutes). |
sas_use_inbound_params | ora_parametri | boolean | NO | false | If true, applies entry tolerance and rounding parameters. |
sas_p1_early_tolerance | ora_p1_tolant | numeric(2,0) | NO | 0 | Minutes of tolerance for early arrival in period 1. |
sas_p1_late_tolerance | ora_p1_tolrit | numeric(2,0) | NO | 0 | Minutes of tolerance for late arrival in period 1. |
sas_p1_early_rounding | ora_p1_arrant | numeric(2,0) | NO | 0 | Rounding interval in minutes for early arrival in period 1. |
sas_p1_late_rounding | ora_p1_arrrit | numeric(2,0) | NO | 0 | Rounding interval in minutes for late arrival in period 1. |
sas_p2_early_tolerance | ora_p2_tolant | numeric(2,0) | NO | 0 | Minutes of tolerance for early arrival in period 2. |
sas_p2_late_tolerance | ora_p2_tolrit | numeric(2,0) | NO | 0 | Minutes of tolerance for late arrival in period 2. |
sas_p2_early_rounding | ora_p2_arrant | numeric(2,0) | NO | 0 | Rounding interval in minutes for early arrival in period 2. |
sas_p2_late_rounding | ora_p2_arrrit | numeric(2,0) | NO | 0 | Rounding interval in minutes for late arrival in period 2. |
sas_p1_inter_period_rounding | ora_inter_p1 | numeric(2,0) | NO | 0 | Rounding applied to intervals within period 1. |
sas_p2_inter_period_rounding | ora_inter_p2 | numeric(2,0) | NO | 0 | Rounding applied to intervals within period 2. |
sas_break_rounding | ora_arr_pausa | numeric(2,0) | NO | 0 | Rounding interval applied to lunch or mid-day breaks. |
sas_recover_overtime | ora_recupera_esubero | boolean | NO | false | Flag to allow automatic recovery of excess time worked. |
sas_ignore_lateness | ora_no_ritardi | boolean | NO | false | If true, system does not flag late arrivals as anomalies. |
sas_auto_insert_punch_time | ora_ins_timbra_orario | numeric(4,0) | NO | 0 | Fixed time used for automatic punch insertion (HHMM). |
sas_min_duration_tolerance | ora_tol_lung_min | numeric(3,0) | YES | 0 | Tolerance applied to the minimum shift duration. |
sas_max_duration_tolerance | ora_tol_lung_max | numeric(3,0) | YES | 0 | Tolerance applied to the maximum shift duration. |
sas_use_outbound_params | ora_parametri_out | boolean | YES | false | If true, applies exit tolerance and rounding parameters. |
sas_p1_auto_insert_duration | ora_p1_da_inserire | numeric(4,0) | YES | 0 | Duration to be automatically inserted for period 1 (HHMM). |
sas_p2_auto_insert_duration | ora_p2_da_inserire | numeric(4,0) | YES | 0 | Duration to be automatically inserted for period 2 (HHMM). |
sas_overtime_in_mandatory_slot | ora_esubero_in_fascia_obb | boolean | NO | false | If true, overtime is calculated even within mandatory presence windows. |
sas_prevent_day_overflow | ora_evita_sconfinamento | boolean | NO | false | If true, prevents calculations from crossing the midnight boundary incorrectly. |
sas_ignore_break | ora_ignora_pausa | boolean | NO | false | Flag to exclude break deduction from total hours. |
sas_auto_insert_justification | ora_insert_causale | boolean | YES | false | Enables automatic insertion of a justification code. |
sas_justification_code | ora_cod_cau | character(4) | YES | ''::bpchar | Reference code of the justification to be automatically inserted. |
sas_slot_type | ora_tipo_fascia | numeric(1,0) | YES | 0 | Category of the time slot for payroll aggregation purposes. |
sas_justification_fixed_value | ora_cau_valore_fisso | numeric(4,0) | YES | 0 | Fixed numeric value to assign to the automatic justification. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_sas_shift_definitions | tenant_id, sas_shift_code | pres.shift_definitions | tenant_id, shd_code | CASCADE | CASCADE |
fk_sas_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_shift_advanced_settings→id - Unique:
c_uk_sas_tenant_shift_code→tenant_id, sas_shift_code - Unique:
c_uk_sas_tenant_shift_id→tenant_id, sas_shift_id
Indexes
No indexes detected.
Navigation
- Back to main index
- [Back to
presindex]../)