pres.attendance_reasons

Schema: pres
English table: pres.attendance_reasons
Italian original table: pres.tabgiu
Description: Master table for all attendance and absence reason codes (Justifications).

Overview

• Columns: 62
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 13
• Indexes: 1

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Identifier of the related record.
ar_reason_id	giu_id	integer	NO		Unique internal identifier for the attendance reason.
tenant_id	tenant_id	integer	NO		Identifier of the related tenant.
ar_code	cod_giu	character(4)	NO	''::bpchar	Mnemonic code (e.g., FER, MAL, STR). High-level identifier.
ar_description	giu_descrizione	character(40)	NO	''::bpchar	Full description of the reason.
ar_payroll_code_active	giu_paghe_att	character(4)	NO	''::bpchar	Export code for current payroll processing.
ar_payroll_code_historical	giu_paghe_pre	character(4)	NO	''::bpchar	Export code used for retroactive payroll adjustments.
ar_math_sign	giu_segno	character(1)	NO	''::bpchar	Algebraic sign (+/-) determining if the value adds to or subtracts from balances.
ar_is_compensable	giu_compensabile	boolean	NO	false	Whether the time can be used for time-off-in-lieu (banca ore).
ar_is_paid	giu_retribuito	boolean	NO	false	If the time associated is remunerated.
ar_is_regular_work	giu_ordinarie	boolean	NO	false	Flag for standard worked hours.
ar_is_absence	giu_assenza	boolean	NO	false	Flag identifying the reason as an absence (vacation, sickness, etc.).
ar_is_overtime	giu_straordinario	boolean	NO	false	Flag for overtime hours.
ar_is_premium	giu_maggiorazione	boolean	NO	false	Indicates if this is a shift premium or shift allowance (maggiorazione).
giu_proporzionale	giu_proporzionale	boolean	NO	false	Boolean flag for giu proporzionale.
ar_short_name	giu_abbreviazione	character(3)	NO	''::bpchar	3-character abbreviation for compact grid displays.
giu_utile_per_comp	giu_utile_per_comp	boolean	NO	false	Boolean flag for giu utile per comp.
ar_calculation_percentage	giu_percentuale	numeric(7,2)	NO	0	Multiplier percentage for the value (e.g., 150.00 for 50% overtime).
ar_calculate_days	giu_calc_giorni	boolean	NO	false	Boolean flag for ar calculate days.
giu_asscomp	giu_asscomp	boolean	NO	false	Boolean flag for giu asscomp.
ar_allow_overtime_calculation	giu_calc_strao	boolean	NO	false	Time associated with ar allow overtime calculation.
giu_prop_pres	giu_prop_pres	boolean	NO	false	Boolean flag for giu prop pres.
giu_supplementari	giu_supplementari	boolean	NO	false	Boolean flag for giu supplementari.
giu_zero	giu_zero	boolean	NO	false	Boolean flag for giu zero.
giu_rapido	giu_rapido	boolean	NO	false	Boolean flag for giu rapido.
giu_default	giu_default	numeric(2,0)	NO	0	Value of giu default.
giu_giorni	giu_giorni	character(8)	NO	''::bpchar	Value of giu giorni.
giu_prop_timb	giu_prop_timb	boolean	NO	false	Boolean flag for giu prop timb.
ar_is_hidden	giu_nascosto	boolean	NO	false	Boolean flag for ar is hidden.
giu_prop_tim_tolleranza	giu_prop_tim_tolleranza	numeric(2,0)	YES	0	Value of giu prop tim tolleranza.
giu_convers_giorni	giu_convers_giorni	numeric(1,0)	YES	0	Value of giu convers giorni.
ar_is_clocking_derived	giu_bollato	boolean	YES	false	If true, the reason is generated by a physical clock-in/out event.
giu_non_estendere	giu_non_estendere	boolean	NO	false	Boolean flag for giu non estendere.
giu_no_controllo_fasce	giu_no_controllo_fasce	boolean	NO	false	Boolean flag for giu no controllo fasce.
ar_rounding_minutes	giu_arrotondamento	numeric(2,0)	NO	0	Rounding rule in minutes applied to the total duration.
ar_internal_notes	giu_note	text	NO	''::text	Value of ar internal notes.
ar_web_portal_notes	giu_web_note	text	NO	''::text	Value of ar web portal notes.
ar_linked_counter_id	giu_cnt_collegato	integer	NO	0	ID of the counter (acd_counter_id) automatically updated by this reason.
ar_subtract_break_time	giu_sottrai_pausa	boolean	NO	true	If true, the automatic break deduction is applied to this reason.
giu_rigido	giu_rigido	boolean	NO	false	Boolean flag for giu rigido.
giu_rigido_arrot_prec	giu_rigido_arrot_prec	numeric(2,0)	NO	0	Value of giu rigido arrot prec.
giu_rigido_arrot_succ	giu_rigido_arrot_succ	numeric(2,0)	NO	0	Value of giu rigido arrot succ.
giu_pag_arrotonda	giu_pag_arrotonda	numeric(1,0)	YES	0	Value of giu pag arrotonda.
giu_pag_arrotonda_valore	giu_pag_arrotonda_valore	numeric(2,0)	YES	0	Value of giu pag arrotonda valore.
giu_prop_min	giu_prop_min	integer	YES	0	Value of giu prop min.
giu_prop_max	giu_prop_max	integer	YES	999	Value of giu prop max.
ar_daily_limit_hours	giu_limite_giorno	numeric(6,2)	YES	0	Maximum hours allowed per day for this reason.
ar_weekly_limit_hours	giu_limite_settimana	numeric(6,2)	YES	0	Value of ar weekly limit hours.
ar_monthly_limit_hours	giu_limite_mese	numeric(6,2)	YES	0	Value of ar monthly limit hours.
ar_yearly_limit_hours	giu_limite_anno	numeric(6,2)	YES	0	Value of ar yearly limit hours.
ar_limits_enabled	giu_abilita_limiti	boolean	YES	false	Boolean flag for ar limits enabled.
ar_is_prevailing_reason	giu_prevalente	boolean	YES	false	Boolean flag for ar is prevailing reason.
giu_timb_pausa	giu_timb_pausa	boolean	YES	false	Boolean flag for giu timb pausa.
giu_valore_minimo	giu_valore_minimo	integer	YES	0	Value of giu valore minimo.
giu_gest_minimo	giu_gest_minimo	numeric(1,0)	YES	0	Value of giu gest minimo.
giu_cal_assenze	giu_cal_assenze	numeric(1,0)	YES	0	Value of giu cal assenze.
ar_ui_color	giu_colore	character varying(10)	YES	''::character varying	HEX or CSS color code for UI/Calendar representation.
giu_no_fer	giu_no_fer	boolean	YES	false	Boolean flag for giu no fer.
giu_no_par	giu_no_par	boolean	YES	false	Boolean flag for giu no par.
giu_no_ro	giu_no_ro	boolean	YES	false	Boolean flag for giu no ro.
giu_no_fes	giu_no_fes	boolean	YES	false	Boolean flag for giu no fes.
_deleted	_deleted	boolean	YES	false	Flag indicating whether the record is soft-deleted.

Relationships

Outgoing foreign keys

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

Referenced by

From table	Foreign key	Source columns	Target columns
pres.attendance_reason_cascades	fk_arc_child_reason	tenant_id, arc_child_reason_code	tenant_id, ar_code
pres.attendance_reason_cascades	fk_arc_parent_reason	tenant_id, arc_parent_reason_code	tenant_id, ar_code
pres.clocking_reason_mappings	fk_crm_justification	tenant_id, crm_target_justification_code	tenant_id, ar_code
pres.custom_calculations	fk_cca_reason_type	tenant_id, cca_reason_code	tenant_id, ar_code
pres.daily_attendance_justifications	fk_daj_reason_definition	tenant_id, daj_reason_code	tenant_id, ar_code
pres.holiday_calendar	fk_hol_reason_type	tenant_id, hol_reason_code	tenant_id, ar_code
pres.leave_transformation_rules	fk_ltr_source_reason	tenant_id, ltr_source_reason_code	tenant_id, ar_code
pres.leave_transformation_rules	fk_ltr_target_reason	tenant_id, ltr_target_reason_code	tenant_id, ar_code
pres.long_term_absences	fk_lta_reason_definition	tenant_id, lta_reason_code	tenant_id, ar_code
pres.monthly_justification_aggregates	fk_mja_reason_definition	tenant_id, mja_reason_code	tenant_id, ar_code
pres.overtime_and_premium_rules	fk_opr_target_attendance_reason	tenant_id, opr_target_reason_code	tenant_id, ar_code
pres.payroll_additional_reasons	fk_par_reason_type	tenant_id, par_reason_code	tenant_id, ar_code
pres.weekly_justification_aggregates	fk_wja_reason_definition	tenant_id, wja_reason_code	tenant_id, ar_code

Constraints

• Primary key: pk_attendance_reasons → id
• Unique: c_uk_ar_tenant_code → tenant_id, ar_code
• Unique: c_uk_ar_tenant_reason_id → tenant_id, ar_reason_id

Indexes

Name	Unique	Method	Columns / expression
idx_ar_tenant_active	NO	btree	tenant_id) WHERE (_deleted = false

Navigation

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