`pres.leave_accrual_rules`

Schema: pres
English table: pres.leave_accrual_rules
Italian original table: pres.cnf_ferie
Description: Configuration table for leave and vacation accrual logic based on seniority, contract types, and job levels.

Overview

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

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
`id`	`id`	`integer`	NO		Identifier of the related record.
`lar_id`	`cfe_id`	`integer`	NO		Identifier of the related lar.
`tenant_id`	`tenant_id`	`integer`	NO		Identifier of the related tenant.
`fer_gg_inizio`	`fer_gg_inizio`	`numeric(2,0)`	NO	`0`	Value of fer gg inizio.
`fer_mm_inizio`	`fer_mm_inizio`	`numeric(2,0)`	NO	`0`	Value of fer mm inizio.
`par_gg_inizio`	`par_gg_inizio`	`numeric(2,0)`	NO	`0`	Value of par gg inizio.
`par_mm_inizio`	`par_mm_inizio`	`numeric(2,0)`	NO	`0`	Value of par mm inizio.
`ro_gg_inizio`	`ro_gg_inizio`	`numeric(2,0)`	NO	`0`	Value of ro gg inizio.
`ro_mm_inizio`	`ro_mm_inizio`	`numeric(2,0)`	NO	`0`	Value of ro mm inizio.
`fes_gg_inizio`	`fes_gg_inizio`	`numeric(2,0)`	NO	`0`	Value of fes gg inizio.
`fes_mm_inizio`	`fes_mm_inizio`	`numeric(2,0)`	NO	`0`	Value of fes mm inizio.
`fer_causali_god_ap`	`fer_causali_god_ap`	`character(20)`	NO	`''::bpchar`	Value of fer causali god ap.
`lar_vacation_usage_reasons_current_year`	`fer_causali_god_at`	`character(20)`	NO	`''::bpchar`	Value of lar vacation usage reasons current year.
`fer_causali_liq_ap`	`fer_causali_liq_ap`	`character(20)`	NO	`''::bpchar`	Value of fer causali liq ap.
`fer_causali_liq_at`	`fer_causali_liq_at`	`character(20)`	NO	`''::bpchar`	Value of fer causali liq at.
`par_causali_god_ap`	`par_causali_god_ap`	`character(20)`	NO	`''::bpchar`	Value of par causali god ap.
`lar_par_usage_reasons_current_year`	`par_causali_god_at`	`character(20)`	NO	`''::bpchar`	Value of lar par usage reasons current year.
`par_causali_liq_ap`	`par_causali_liq_ap`	`character(20)`	NO	`''::bpchar`	Value of par causali liq ap.
`par_causali_liq_at`	`par_causali_liq_at`	`character(20)`	NO	`''::bpchar`	Value of par causali liq at.
`ro_causali_god_ap`	`ro_causali_god_ap`	`character(20)`	NO	`''::bpchar`	Value of ro causali god ap.
`ro_causali_god_at`	`ro_causali_god_at`	`character(20)`	NO	`''::bpchar`	Value of ro causali god at.
`ro_causali_liq_ap`	`ro_causali_liq_ap`	`character(20)`	NO	`''::bpchar`	Value of ro causali liq ap.
`ro_causali_liq_at`	`ro_causali_liq_at`	`character(20)`	NO	`''::bpchar`	Value of ro causali liq at.
`fes_causali_god_ap`	`fes_causali_god_ap`	`character(20)`	NO	`''::bpchar`	Value of fes causali god ap.
`fes_causali_god_at`	`fes_causali_god_at`	`character(20)`	NO	`''::bpchar`	Value of fes causali god at.
`fes_causali_liq_ap`	`fes_causali_liq_ap`	`character(20)`	NO	`''::bpchar`	Value of fes causali liq ap.
`fes_causali_liq_at`	`fes_causali_liq_at`	`character(20)`	NO	`''::bpchar`	Value of fes causali liq at.
`lar_vacation_uom`	`fer_udm`	`character(1)`	NO	`''::bpchar`	Unit of Measure for vacation (G = Days, O = Hours).
`lar_par_uom`	`par_udm`	`character(1)`	NO	`''::bpchar`	Value of lar par uom.
`lar_rol_uom`	`ro_udm`	`character(1)`	NO	`''::bpchar`	Value of lar rol uom.
`lar_fes_uom`	`fes_udm`	`character(1)`	NO	`''::bpchar`	Value of lar fes uom.
`fer_god_prec_auto`	`fer_god_prec_auto`	`boolean`	NO	`false`	Boolean flag for fer god prec auto.
`par_god_prec_auto`	`par_god_prec_auto`	`boolean`	NO	`false`	Boolean flag for par god prec auto.
`ro_god_prec_auto`	`ro_god_prec_auto`	`boolean`	NO	`false`	Boolean flag for ro god prec auto.
`fes_god_prec_auto`	`fes_god_prec_auto`	`boolean`	NO	`false`	Boolean flag for fes god prec auto.
`script_maturato`	`script_maturato`	`character varying(100)`	YES	`''::character varying`	Value of script maturato.
`lar_vacation_accrual_tier1`	`fer_maturato_ft1`	`numeric(6,2)`	YES	`0`	Base monthly accrual value for the first seniority tier.
`lar_vacation_seniority_months_1`	`fer_anz_1`	`smallint`	YES	`0`	Value of lar vacation seniority months 1.
`fer_maturato_ft2`	`fer_maturato_ft2`	`numeric(6,2)`	YES	`0`	Value of fer maturato ft2.
`fer_anz_2`	`fer_anz_2`	`smallint`	YES	`0`	Value of fer anz 2.
`fer_maturato_ft3`	`fer_maturato_ft3`	`numeric(6,2)`	YES	`0`	Value of fer maturato ft3.
`fer_anz_3`	`fer_anz_3`	`smallint`	YES	`0`	Value of fer anz 3.
`lar_par_accrual_tier1`	`par_maturato_ft1`	`numeric(6,2)`	YES	`0`	Value of lar par accrual tier1.
`par_anz_1`	`par_anz_1`	`smallint`	YES	`0`	Value of par anz 1.
`par_maturato_ft2`	`par_maturato_ft2`	`numeric(6,2)`	YES	`0`	Value of par maturato ft2.
`par_anz_2`	`par_anz_2`	`smallint`	YES	`0`	Value of par anz 2.
`par_maturato_ft3`	`par_maturato_ft3`	`numeric(6,2)`	YES	`0`	Value of par maturato ft3.
`par_anz_3`	`par_anz_3`	`smallint`	YES	`0`	Value of par anz 3.
`lar_rol_accrual_tier1`	`ro_maturato_ft1`	`numeric(6,2)`	YES	`0`	Value of lar rol accrual tier1.
`ro_anz_1`	`ro_anz_1`	`smallint`	YES	`0`	Value of ro anz 1.
`ro_maturato_ft2`	`ro_maturato_ft2`	`numeric(6,2)`	YES	`0`	Value of ro maturato ft2.
`ro_anz_2`	`ro_anz_2`	`smallint`	YES	`0`	Value of ro anz 2.
`ro_maturato_ft3`	`ro_maturato_ft3`	`numeric(6,2)`	YES	`0`	Value of ro maturato ft3.
`ro_anz_3`	`ro_anz_3`	`smallint`	YES	`0`	Value of ro anz 3.
`fes_maturato_ft1`	`fes_maturato_ft1`	`numeric(6,2)`	YES	`0`	Value of fes maturato ft1.
`fes_anz_1`	`fes_anz_1`	`smallint`	YES	`0`	Value of fes anz 1.
`fes_maturato_ft2`	`fes_maturato_ft2`	`numeric(6,2)`	YES	`0`	Value of fes maturato ft2.
`fes_anz_2`	`fes_anz_2`	`smallint`	YES	`0`	Value of fes anz 2.
`fes_maturato_ft3`	`fes_maturato_ft3`	`numeric(6,2)`	YES	`0`	Value of fes maturato ft3.
`fes_anz_3`	`fes_anz_3`	`smallint`	YES	`0`	Value of fes anz 3.
`ore_sett_ft`	`ore_sett_ft`	`numeric(6,2)`	YES	`0`	Value of ore sett ft.
`fer_giorni_rateo`	`fer_giorni_rateo`	`smallint`	YES	`0`	Value of fer giorni rateo.
`par_giorni_rateo`	`par_giorni_rateo`	`smallint`	YES	`0`	Value of par giorni rateo.
`ro_giorni_rateo`	`ro_giorni_rateo`	`smallint`	YES	`0`	Value of ro giorni rateo.
`fes_giorni_rateo`	`fes_giorni_rateo`	`smallint`	YES	`0`	Value of fes giorni rateo.
`fer_causali_god_ant`	`fer_causali_god_ant`	`character(20)`	YES	`''::bpchar`	Value of fer causali god ant.
`par_causali_god_ant`	`par_causali_god_ant`	`character(20)`	YES	`''::bpchar`	Value of par causali god ant.
`ro_causali_god_ant`	`ro_causali_god_ant`	`character(20)`	YES	`''::bpchar`	Value of ro causali god ant.
`fes_causali_god_ant`	`fes_causali_god_ant`	`character(20)`	YES	`''::bpchar`	Value of fes causali god ant.
`giorni_sett_ft`	`giorni_sett_ft`	`smallint`	YES	`0`	Value of giorni sett ft.
`lar_vacation_desc`	`fer_descrizione`	`character varying(30)`	YES	`''::character varying`	Value of lar vacation desc.
`lar_par_desc`	`par_descrizione`	`character varying(30)`	YES	`''::character varying`	Value of lar par desc.
`lar_rol_desc`	`ro_descrizione`	`character varying(30)`	YES	`''::character varying`	Value of lar rol desc.
`lar_fes_desc`	`fes_descrizione`	`character varying(30)`	YES	`''::character varying`	Value of lar fes desc.
`lar_contract_id`	`cfe_con_id`	`integer`	YES	`0`	Identifier of the related lar contract.
`fer_anno`	`fer_anno`	`integer`	YES	`0`	Value of fer anno.
`cnf_desc_ant`	`cnf_desc_ant`	`character varying(30)`	NO	`''::character varying`	Value of cnf desc ant.
`cnf_desc_ap`	`cnf_desc_ap`	`character varying(30)`	NO	`''::character varying`	Value of cnf desc ap.
`cnf_desc_at`	`cnf_desc_at`	`character varying(30)`	NO	`''::character varying`	Value of cnf desc at.
`cnf_mesi_separati`	`cnf_mesi_separati`	`numeric(1,0)`	NO	`1`	Value of cnf mesi separati.
`cnf_nday_auto_saldi`	`cnf_nday_auto_saldi`	`numeric(3,0)`	NO	`60`	Value of cnf nday auto saldi.
`cnf_anni_prec_mode`	`cnf_anni_prec_mode`	`numeric(1,0)`	NO	`1`	Value of cnf anni prec mode.
`lar_valid_from`	`cnf_dal`	`date`	YES		Value of lar valid from.
`lar_valid_to`	`cnf_al`	`date`	YES		Value of lar valid to.
`lar_filter_job_title_pattern`	`cnf_conq_id`	`character varying(50)`	YES	`'*'::character varying`	Value of lar filter job title pattern.
`lar_filter_level_pattern`	`cnf_conl_id`	`character varying(50)`	YES	`'*'::character varying`	Value of lar filter level pattern.
`cnf_conm_id`	`cnf_conm_id`	`character varying(50)`	YES	`'*'::character varying`	Identifier of the related cnf conm.
`lar_filter_contract_type_pattern`	`cnf_tipt`	`character varying(50)`	YES	`'*'::character varying`	Pattern to match specific contract types for rule application.
`cnf_grp_id`	`cnf_grp_id`	`character varying(50)`	YES	`'*'::character varying`	Identifier of the related cnf grp.
`cnf_rap_id`	`cnf_rap_id`	`character varying(50)`	YES	`'*'::character varying`	Identifier of the related cnf rap.
`lar_priority_order`	`cnf_order`	`integer`	YES	`0`	Value of lar priority order.
`lar_vacation_rounding`	`fer_arrotonda`	`numeric(5,2)`	YES	`0`	Value of lar vacation rounding.
`par_arrotonda`	`par_arrotonda`	`numeric(5,2)`	YES	`0`	Value of par arrotonda.
`ro_arrotonda`	`ro_arrotonda`	`numeric(5,2)`	YES	`0`	Value of ro arrotonda.
`fes_arrotonda`	`fes_arrotonda`	`numeric(5,2)`	YES	`0`	Value of fes arrotonda.
`fer_campi_web`	`fer_campi_web`	`text`	YES		Value of fer campi web.
`par_campi_web`	`par_campi_web`	`text`	YES		Value of par campi web.
`ro_campi_web`	`ro_campi_web`	`text`	YES		Value of ro campi web.
`fes_campi_web`	`fes_campi_web`	`text`	YES		Value of fes campi web.

Relationships

Outgoing foreign keys

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

Referenced by

No incoming foreign keys found.

Constraints

Primary key: pk_leave_accrual_rules → id
Unique: c_uk_lar_id_tenant → tenant_id, lar_id

Indexes

Name	Unique	Method	Columns / expression
`idx_lar_contract_lookup`	NO	`btree`	`tenant_id, lar_contract_id`

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

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​