`hr.employment_pay_accumulators`

Schema: hr
English table: hr.employment_pay_accumulators
Italian original table: hr.retribuzioni_progressivi
Description: Year-to-date (YTD) payroll accumulators for each employment relationship, used for tax brackets and contribution thresholds.

Overview

Columns: 28
Primary key: id
Outgoing foreign keys: 2
Incoming foreign keys: 0
Indexes: 5

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
`id`	`id`	`integer`	NO		Surrogate primary key.
`epa_id`	`retrprog_id`	`integer`	NO		Business identifier for the accumulator record.
`epa_employment_relationship_id`	`retrprog_rap_id`	`integer`	NO		Identifier of the related epa employment relationship record.
`epa_month`	`retrprog_month`	`integer`	NO		Reference month for the accumulated values.
`epa_year`	`retrprog_year`	`integer`	NO		Reference year for the accumulated values.
`epa_value_1`	`retrprog_v1`	`numeric(10,2)`	NO		Accumulated value 1 (YTD), meaning depends on payroll engine mapping.
`epa_value_2`	`retrprog_v2`	`numeric(10,2)`	NO		Accumulated value 2 (YTD), meaning depends on payroll engine mapping.
`epa_value_3`	`retrprog_v3`	`numeric(10,2)`	NO		Accumulated value 3 (YTD), meaning depends on payroll engine mapping.
`epa_value_4`	`retrprog_v4`	`numeric(10,2)`	NO		Accumulated value 4 (YTD), meaning depends on payroll engine mapping.
`epa_value_5`	`retrprog_v5`	`numeric(10,2)`	NO		Accumulated value 5 (YTD), meaning depends on payroll engine mapping.
`epa_value_6`	`retrprog_v6`	`numeric(10,2)`	NO		Accumulated value 6 (YTD), meaning depends on payroll engine mapping.
`epa_value_7`	`retrprog_v7`	`numeric(10,2)`	NO		Accumulated value 7 (YTD), meaning depends on payroll engine mapping.
`epa_value_8`	`retrprog_v8`	`numeric(10,2)`	NO		Accumulated value 8 (YTD), meaning depends on payroll engine mapping.
`epa_value_9`	`retrprog_v9`	`numeric(10,2)`	NO		Accumulated value 9 (YTD), meaning depends on payroll engine mapping.
`epa_value_10`	`retrprog_v10`	`numeric(10,2)`	NO		Accumulated value 10 (YTD), meaning depends on payroll engine mapping.
`epa_value_11`	`retrprog_v11`	`numeric(10,2)`	NO		Accumulated value 11 (YTD), meaning depends on payroll engine mapping.
`epa_value_12`	`retrprog_v12`	`numeric(10,2)`	NO		Accumulated value 12 (YTD), meaning depends on payroll engine mapping.
`epa_value_13`	`retrprog_v13`	`numeric(10,2)`	NO		Accumulated value 13 (YTD), meaning depends on payroll engine mapping.
`epa_value_14`	`retrprog_v14`	`numeric(10,2)`	NO		Accumulated value 14 (YTD), meaning depends on payroll engine mapping.
`epa_value_15`	`retrprog_v15`	`numeric(10,2)`	NO		Accumulated value 15 (YTD), meaning depends on payroll engine mapping.
`epa_value_16`	`retrprog_v16`	`numeric(10,2)`	NO		Accumulated value 16 (YTD), meaning depends on payroll engine mapping.
`epa_value_17`	`retrprog_v17`	`numeric(10,2)`	NO		Accumulated value 17 (YTD), meaning depends on payroll engine mapping.
`epa_value_18`	`retrprog_v18`	`numeric(10,2)`	NO		Accumulated value 18 (YTD), meaning depends on payroll engine mapping.
`epa_value_19`	`retrprog_v19`	`numeric(10,2)`	NO		Accumulated value 19 (YTD), meaning depends on payroll engine mapping.
`epa_value_20`	`retrprog_v20`	`numeric(10,2)`	NO		Accumulated value 20 (YTD), meaning depends on payroll engine mapping.
`tenant_id`	`tenant_id`	`integer`	YES		Tenant identifier for data isolation.
`colcustom`	`colcustom`	`jsonb`	YES	`'{}'::jsonb`	JSON payload containing additional attributes.
`_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_epa_employment_relationship`	`epa_employment_relationship_id, tenant_id`	`hr.employment_relationships`	`er_id, tenant_id`	RESTRICT	CASCADE
`fk_epa_tenant`	`tenant_id`	`cloud.tenants`	`ten_internal_id`	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

Primary key: pk_epa1 → id
Unique: uk_epa_id_tenant1 → epa_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
`idx_epa_emp_rel_period_tenant`	NO	`btree`	`tenant_id, epa_employment_relationship_id, epa_month, epa_year) WHERE (_deleted = false`
`idx_epa_emp_rel_tenant`	NO	`btree`	`tenant_id, epa_employment_relationship_id) WHERE (_deleted = false`
`idx_epa_id_tenant1`	NO	`btree`	`tenant_id, epa_id) WHERE (_deleted = false`
`idx_epa_period_tenant`	NO	`btree`	`tenant_id, epa_month, epa_year) WHERE (_deleted = false`
`idx_epa_tenant1`	NO	`btree`	`tenant_id`

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

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​