`pres.employee_leave_balances_today`

Schema: pres
English table: pres.employee_leave_balances_today
Italian original table: pres.ferie_today
Description: Real-time leave and vacation balances, aggregating residues from past years and current year accruals.

Overview

Columns: 25
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		Identifier of the related record.
`elbt_id`	`ft_id`	`integer`	NO		Identifier of the related elbt.
`tenant_id`	`tenant_id`	`integer`	NO		Identifier of the related tenant.
`elbt_employment_id`	`ft_rap_id`	`integer`	NO		Identifier of the related elbt employment.
`elbt_reference_date`	`ft_data`	`date`	NO		Date associated with elbt reference date.
`elbt_leave_type`	`ft_type`	`character(3)`	NO		Value of elbt leave type.
`elbt_uom`	`ft_udm`	`character(1)`	NO		Value of elbt uom.
`elbt_residue_old_years`	`ft_resid_ant`	`numeric(7,2)`	YES	`0`	Value of elbt residue old years.
`elbt_used_old_years`	`ft_goduto_ant`	`numeric(7,2)`	YES	`0`	Value of elbt used old years.
`elbt_available_old_years`	`ft_disponibile_ant`	`numeric(7,2)`	YES	`0`	Value of elbt available old years.
`elbt_residue_prev_year`	`ft_resid_ap`	`numeric(7,0)`	YES	`0`	Value of elbt residue prev year.
`elbt_paid_out_prev_year`	`ft_liquid_ap`	`numeric(7,2)`	YES	`0`	Value of elbt paid out prev year.
`elbt_used_prev_year`	`ft_goduto_ap`	`numeric(7,2)`	YES	`0`	Value of elbt used prev year.
`elbt_available_prev_year`	`ft_disponibile_ap`	`numeric(7,2)`	YES	`0`	Value of elbt available prev year.
`elbt_accrued_current`	`ft_maturato`	`numeric(7,2)`	YES	`0`	Value of elbt accrued current.
`elbt_accrued_accruals`	`ft_maturato_ratei`	`numeric(7,2)`	YES	`0`	Value of elbt accrued accruals.
`elbt_accrual_count`	`ft_ratei`	`smallint`	YES	`0`	Number of accrual months (ratei) processed so far in the year.
`elbt_used_current`	`ft_goduto`	`numeric(7,2)`	YES	`0`	Value of elbt used current.
`elbt_paid_out_current`	`ft_liquidato`	`numeric(7,2)`	YES	`0`	Value of elbt paid out current.
`elbt_booked_future`	`ft_impegnato`	`numeric(7,2)`	YES	`0`	Hours/Days already requested and approved for future dates.
`elbt_net_available`	`ft_disponibile`	`numeric(7,2)`	YES	`0`	Value of elbt net available.
`ft_disponibile_ratei`	`ft_disponibile_ratei`	`numeric(7,2)`	YES	`0`	Value of ft disponibile ratei.
`elbt_total_available`	`ft_disponibile_totale`	`numeric(7,2)`	YES	`0`	Value of elbt total available.
`ft_disponibile_totale_ratei`	`ft_disponibile_totale_ratei`	`numeric(7,2)`	YES	`0`	Value of ft disponibile totale ratei.
`elbt_target_usage`	`ft_goduto_obbiettivo`	`numeric(7,2)`	YES	`0`	Value of elbt target usage.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
`fk_elbt_tenant`	`tenant_id`	`cloud.tenants`	`ten_internal_id`	CASCADE	CASCADE
`fk_ferie_today_ft_rap_id_to_rapporti`	`tenant_id, elbt_employment_id`	`hr.employment_relationships`	`tenant_id, er_id`	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

Primary key: pk_employee_leave_balances_today → id
Unique: c_uk_elbt_id_tenant → tenant_id, elbt_id

Indexes

Name	Unique	Method	Columns / expression
`idx_elbt_lookup_composite`	NO	`btree`	`tenant_id, elbt_employment_id, elbt_reference_date, elbt_leave_type`

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

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​